roachtest: activerecord failed [relation does exist + others]

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.activerecord failed with artifacts on master @ 5b931856d005214057f0703890ce3a77cdc21f30:

(orm_helpers.go:224).summarizeFailed: 
Tests run on Cockroach v25.2.0-alpha.00000000-dev-5b931856d005214057f0703890ce3a77cdc21f30
Tests run against activerecord 7.2.1
8478 Total Tests Run
8475 tests passed
3 tests failed
60 tests skipped
14 tests ignored
0 tests passed unexpectedly
2 tests 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: PostgresqlArrayTest#test_uniqueness_validation (unexpected)
--- FAIL: HasManyThroughAssociationsTest#test_circular_autosave_association_correctly_saves_multiple_records (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
• metamorphicLeases=default
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-47032

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.activerecord failed with artifacts on master @ f7d019d5e675fa2711b61ffd54a9990b6a1a1da8:

(orm_helpers.go:224).summarizeFailed: 
Tests run on Cockroach v25.2.0-alpha.00000000-dev-f7d019d5e675fa2711b61ffd54a9990b6a1a1da8
Tests run against activerecord 7.2.1
8478 Total Tests Run
8476 tests passed
2 tests failed
60 tests skipped
14 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: PostgresqlArrayTest#test_uniqueness_validation (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
• metamorphicLeases=leader
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.activerecord failed with artifacts on master @ 507c68f8abb0c9a3f527c66cb42129c2cb096e7d:

(orm_helpers.go:224).summarizeFailed: 
Tests run on Cockroach v25.2.0-alpha.00000000-dev-507c68f8abb0c9a3f527c66cb42129c2cb096e7d
Tests run against activerecord 7.2.1
8478 Total Tests Run
8473 tests passed
5 tests failed
60 tests skipped
14 tests ignored
0 tests passed unexpectedly
4 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: HasManyThroughAssociationsTest#test_circular_autosave_association_correctly_saves_multiple_records (unexpected)
--- FAIL: PostgresqlInvertibleMigrationTest#test_migrate_revert_drop_enum (unexpected)
--- FAIL: PostgresqlInvertibleMigrationTest#test_migrate_revert_create_enum (unexpected)
--- FAIL: PostgresqlArrayTest#test_uniqueness_validation (unexpected)
--- PASS: SerializedAttributeTest#test_unexpected_serialized_type (expected)
--- PASS: SerializedAttributeTestWithYamlSafeLoad#test_unexpected_serialized_type (expected)
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
• metamorphicLeases=leader
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.activerecord failed with artifacts on master @ 507c68f8abb0c9a3f527c66cb42129c2cb096e7d:

(orm_helpers.go:224).summarizeFailed: 
Tests run on Cockroach v25.2.0-alpha.00000000-dev-507c68f8abb0c9a3f527c66cb42129c2cb096e7d
Tests run against activerecord 7.2.1
8478 Total Tests Run
8474 tests passed
4 tests failed
60 tests skipped
14 tests ignored
0 tests passed unexpectedly
3 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: SerializedAttributeTestWithYamlSafeLoad#test_unexpected_serialized_type (expected)
--- FAIL: PostgresqlArrayTest#test_uniqueness_validation (unexpected)
--- FAIL: PostgresqlInvertibleMigrationTest#test_migrate_revert_drop_enum (unexpected)
--- PASS: SerializedAttributeTest#test_unexpected_serialized_type (expected)
--- FAIL: PostgresqlInvertibleMigrationTest#test_migrate_revert_create_enum (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
• metamorphicLeases=default
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

[spilchen]

It looks like we're seeing some new failures, though they don’t appear to be consistent across all test cases in each run.

[cockroach-teamcity]

roachtest.activerecord failed with artifacts on master @ 82b1a2b174dcedfd23b0a3a40c6069143f4b038f:

(orm_helpers.go:224).summarizeFailed: 
Tests run on Cockroach v25.2.0-alpha.00000000-dev-82b1a2b174dcedfd23b0a3a40c6069143f4b038f
Tests run against activerecord 7.2.1
8478 Total Tests Run
8475 tests passed
3 tests failed
60 tests skipped
14 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: SerializedAttributeTestWithYamlSafeLoad#test_unexpected_serialized_type (expected)
--- FAIL: PostgresqlArrayTest#test_uniqueness_validation (unexpected)
--- PASS: SerializedAttributeTest#test_unexpected_serialized_type (expected)
--- FAIL: HasManyThroughAssociationsTest#test_circular_autosave_association_correctly_saves_multiple_records (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
• metamorphicLeases=epoch
• runtimeAssertionsBuild=false
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

[spilchen]

More details on each of the errors:

  7) Error:
PostgresqlArrayTest#test_uniqueness_validation:
ActiveRecord::StatementInvalid: PG::SEInvalidSpecification: ERROR:  savepoint "active_record_1" does not exist

 32) Error:
HasManyThroughAssociationsTest#test_circular_autosave_association_correctly_saves_multiple_records:
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "sections" does not exist

 60) Error:
HasManyThroughAssociationsTest#test_circular_autosave_association_correctly_saves_multiple_records:
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "sections" does not exist

 62) Failure:
PostgresqlInvertibleMigrationTest#test_migrate_revert_create_enum [/usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-6cfa24f9dfdd/activerecord/test/cases/adapters/postgresql/invertible_migration_test.rb:82]:
--- expected
+++ actual
@@ -1 +1 @@
-[["color", "blue,green"]]
+[["feeling", "sad,ok,happy"], ["color", "blue,green"]]


 63) Failure:
PostgresqlInvertibleMigrationTest#test_migrate_revert_drop_enum [/usr/local/lib/ruby/gems/3.3.0/bundler/gems/rails-6cfa24f9dfdd/activerecord/test/cases/adapters/postgresql/invertible_migration_test.rb:91]:
Expected: []
  Actual: [["feeling", "sad,ok,happy"]]

I also see TransactionRetryWithProtoRefreshError in the cockroach.log. The fact that the failures are consistent make me think that they are related to the auto_commit_ddl change.