[CI][Ruby][Flight] flight-sql test fails on PRs with invalid SQL #47842
Description
Describe the bug, including details regarding any error messages, version, and platform.
The ARM64 macOS 14 GLib & Ruby job seems to be failing consistently on PRs with invalid SQL on two flight SQL tests:
+ ruby test/run-test.rb
===============================================================================
Error: test_success(TestFlightSQLClient::#execute_update):
Arrow::Error::Invalid: [flight-sql-client][execute-update]: Invalid: [flight-sql-server][do-put-command-statement-update]: garrow - error - quark(4): invalid SQL
/Users/runner/work/arrow/arrow/c_glib/test/helper/flight-sql-server.rb:45:in `virtual_do_do_put_command_statement_update'
. gRPC client debug context: UNKNOWN:Error received from peer ipv4:127.0.0.1:49481 {grpc_message:"[flight-sql-server][do-put-command-statement-update]: garrow - error - quark(4): invalid SQL\n /Users/runner/work/arrow/arrow/c_glib/test/helper/flight-sql-server.rb:45:in `virtual_do_do_put_command_statement_update\'\n", grpc_status:3}. Client context: OK
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:583:in `execute_update'
/Users/runner/work/arrow/arrow/c_glib/test/flight-sql/test-client.rb:62:in `test_success'
59: sub_test_case("#execute_update") do
60: def test_success
61: insert_sql = "INSERT INTO page_view_table VALUES (100, true)"
=> 62: n_changed_records = @sql_client.execute_update(insert_sql)
63: assert_equal(1, n_changed_records)
64: end
65:
Error: Arrow::Error::Invalid: [flight-sql-client][execute-update]: Invalid: [flight-sql-server][do-put-command-statement-update]: garrow - error - quark(4): invalid SQL
/Users/runner/work/arrow/arrow/c_glib/test/helper/flight-sql-server.rb:45:in `virtual_do_do_put_command_statement_update'
. gRPC client debug context: UNKNOWN:Error received from peer ipv4:127.0.0.1:49481 {grpc_message:"[flight-sql-server][do-put-command-statement-update]: garrow - error - quark(4): invalid SQL\n /Users/runner/work/arrow/arrow/c_glib/test/helper/flight-sql-server.rb:45:in `virtual_do_do_put_command_statement_update\'\n", grpc_status:3}. Client context: OK
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:583:in `execute_update'
/Users/runner/work/arrow/arrow/c_glib/test/flight-sql/test-client.rb:62:in `test_success'
/Users/runner/work/arrow/arrow/cpp/src/gandiva/cache.cc:58: Creating gandiva cache with capacity of 5000
===============================================================================
===============================================================================
Error: test_success(TestFlightSQLClient::#prepare):
Arrow::Error::Invalid: [flight-sql-client][prepare]: Invalid: [flight-sql-server][create-prepared-statement]: garrow - error - quark(4): invalid SQL
/Users/runner/work/arrow/arrow/c_glib/test/helper/flight-sql-server.rb:52:in `virtual_do_create_prepared_statement'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:583:in `prepare'
/Users/runner/work/arrow/arrow/c_glib/test/flight-sql/test-client.rb:76:in `test_success'
73: sub_test_case("#prepare") do
74: def test_success
75: insert_sql = "INSERT INTO page_view_table VALUES (?, true)"
=> 76: statement = @sql_client.prepare(insert_sql)
77: begin
78: assert_equal([
79: build_schema(count: :uint64, private: :boolean),
Error: Arrow::Error::Invalid: [flight-sql-client][prepare]: Invalid: [flight-sql-server][create-prepared-statement]: garrow - error - quark(4): invalid SQL
/Users/runner/work/arrow/arrow/c_glib/test/helper/flight-sql-server.rb:52:in `virtual_do_create_prepared_statement'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:715:in `invoke'
/opt/homebrew/lib/ruby/gems/3.3.0/gems/gobject-introspection-4.3.3/lib/gobject-introspection/loader.rb:583:in `prepare'
/Users/runner/work/arrow/arrow/c_glib/test/flight-sql/test-client.rb:76:in `test_success'
/Users/runner/work/arrow/arrow/cpp/src/gandiva/engine.cc:313: Detected CPU Name : generic
/Users/runner/work/arrow/arrow/cpp/src/gandiva/engine.cc:314: Detected CPU Features: []
===============================================================================
Finished in 11.393481 seconds.
2079 tests, 2263 assertions, 0 failures, 2 errors, 0 pendings, 25 omissions, 0 notifications
Error: Process completed with exit code 1.
See on the following PRs:
- GH-47840: [CI][C++] Check whether the CSV module/thread sanitizer is enabled or not before building example #47841
- GH-47836: [C++] Fix Meson configuration after bpacking changes #47837
- GH-47838: [C++][Parquet] Set Variant specification version to 1 to align with the variant spec #47835
It does not seem to fail on the latest commit on main, see the job:
- https://github.com/apache/arrow/actions/runs/18565417452/job/52925031980
for commit: 7a38744
Component(s)
FlightRPC, Continuous Integration, Ruby