pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogicCCL_read_committed failed [notice is not found]

[cockroach-teamcity]

pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test.TestTenantLogicCCL_read_committed failed on release-25.1 @ a53e619877e92319a0a26b9c6902751bd2024b2f:

=== RUN   TestTenantLogicCCL_read_committed
    test_log_scope.go:165: test logs captured to: outputs.zip/logTestTenantLogicCCL_read_committed260365285
    test_log_scope.go:76: use -show-logs to present logs inline
    logic.go:4425: -- test log scope end --
test logs left over in: outputs.zip/logTestTenantLogicCCL_read_committed260365285
--- FAIL: TestTenantLogicCCL_read_committed (11.96s)
=== RUN   TestTenantLogicCCL_read_committed/schema_changes_implicit
[17:55:37] --- progress: /var/lib/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/read_committed: 55 statements
    logic.go:3062: 
         
        /var/lib/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/read_committed:311: ALTER SCHEMA s RENAME TO foo
        expected:
            NOTICE: setting transaction isolation level to SERIALIZABLE due to schema change
            
        but found (query options: "noticetrace") :
            
[17:55:43] --- progress: /var/lib/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/read_committed: 63 statements
[17:55:43] --- done: /var/lib/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test_/3node-tenant_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/read_committed with config 3node-tenant: 63 tests, 1 failures
[17:55:44] --- total progress: 63 statements
--- total: 63 tests, 1 failures
    --- FAIL: TestTenantLogicCCL_read_committed/schema_changes_implicit (7.90s)

Parameters:

• attempt=1
• run=7
• shard=48

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

Jira issue: CRDB-46982

[spilchen]

We're missing an expected notice when renaming a schema using ALTER SCHEMA. What's odd is that the test correctly verifies the same notice for several other DDL commands, but the very last one doesn’t receive it as expected. This seems like a timing issue.

[blathers-crl]

Based on the specified backports for linked PR #140607, I applied the following new label(s) to this issue: branch-release-24.1, branch-release-24.2, branch-release-24.3. Please adjust the labels as needed to match the branches actually affected by this issue, including adding any known older branches.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}