[CI][Ruby][Flight] flight-sql test fails on PRs with invalid SQL

[raulcd]

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

[kou]

Hmm...
prptobuf 32.1.0 -> 33.0.0 update may be related: Homebrew/homebrew-core#249787

[raulcd]

This is currently working on branches now:
https://github.com/apache/arrow/actions/runs/19505316887/job/55829830585?pr=48179

We can close it.
As suspected probably related with protobuf 33.0 and fixed once protobuf 33.1 fix reached homebrew.