roachtest: activerecord failed

[cockroach-teamcity]

roachtest.activerecord failed with artifacts on release-25.3.3-rc @ c9e2699f67c88aa41d354aab9ae149456a7a4b9b:

(orm_helpers.go:226).summarizeFailed: 
Tests run on Cockroach v25.3.3-dev-c9e2699f67c88aa41d354aab9ae149456a7a4b9b
Tests run against activerecord 8.0.1
8556 Total Tests Run
8554 tests passed
2 tests failed
67 tests skipped
38 tests ignored
0 tests passed unexpectedly
1 test failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: SerializedAttributeTest#test_unexpected_serialized_type (expected)
--- PASS: SerializedAttributeTestWithYamlSafeLoad#test_unexpected_serialized_type (expected)
--- FAIL: FixturesWithoutInstantiationTest#test_accessor_methods (unexpected)
For a full summary look at the activerecord artifacts 
An updated blocklist (activeRecordBlocklist) is available in the artifacts' activerecord log
test artifacts and logs in: /artifacts/activerecord/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• fs=ext4
• localSSD=true
• metamorphicBufferedSender=true
• metamorphicLeases=default
• metamorphicWriteBuffering=true
• runtimeAssertionsBuild=false
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: activerecord failed [cached plan must not change result type] #152774 roachtest: activerecord failed [cached plan must not change result type] [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-25.3]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-55556

[rafiss]

 75) Error:
FixturesWithoutInstantiationTest#test_accessor_methods:
ActiveRecord::PreparedStatementCacheExpired: ERROR:  cached plan must not change result type

    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:in `rescue in perform_query'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:145:in `perform_query'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:556:in `block (2 levels) in raw_execute'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:1017:in `block in with_raw_connection'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activesupport/lib/active_support/concurrency/load_interlock_aware_monitor.rb:23:in `handle_interrupt'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activesupport/lib/active_support/concurrency/load_interlock_aware_monitor.rb:23:in `block in synchronize'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activesupport/lib/active_support/concurrency/load_interlock_aware_monitor.rb:19:in `handle_interrupt'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activesupport/lib/active_support/concurrency/load_interlock_aware_monitor.rb:19:in `synchronize'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:986:in `with_raw_connection'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in `block in raw_execute'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activesupport/lib/active_support/notifications/instrumenter.rb:58:in `instrument'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:1137:in `log'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:554:in `raw_execute'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:591:in `internal_execute'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:547:in `internal_exec_query'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:693:in `select'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in `select_all'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:262:in `select_all'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/querying.rb:68:in `_query_by_sql'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1459:in `block (2 levels) in exec_main_query'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/connection_handling.rb:310:in `with_connection'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1458:in `block in exec_main_query'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1480:in `skip_query_cache_if_necessary'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1442:in `exec_main_query'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1420:in `block in exec_queries'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1480:in `skip_query_cache_if_necessary'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1414:in `exec_queries'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1191:in `load'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:353:in `records'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation/finder_methods.rb:587:in `find_take'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation/finder_methods.rb:129:in `take'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation/finder_methods.rb:112:in `find_by'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/querying.rb:24:in `find_by'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/core.rb:284:in `find_by'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/encryption/extended_deterministic_queries.rb:129:in `find_by'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/core.rb:331:in `find_by!'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/fixtures.rb:840:in `block in find'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:1383:in `_scoping'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/relation.rb:558:in `scoping'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/scoping/default.rb:51:in `unscoped'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/fixtures.rb:838:in `find'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/test_fixtures.rb:312:in `block in access_fixture'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/test_fixtures.rb:307:in `map'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/test_fixtures.rb:307:in `access_fixture'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/test_fixtures.rb:294:in `active_record_fixture'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/lib/active_record/test_fixtures.rb:278:in `method_missing'
    /usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-9328b9b42c7c/activerecord/test/cases/fixtures_test.rb:778:in `test_accessor_methods'

Let's check if cockroachdb/activerecord-cockroachdb-adapter#387 could help with this flake.