pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test: TestReadCommittedLogic_select_for_share failed

[cockroach-teamcity]

pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test.TestReadCommittedLogic_select_for_share failed on master @ 5b1702fc72dba825e94c60ac581f7f2bdc04d1fb:

=== RUN   TestReadCommittedLogic_select_for_share
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestReadCommittedLogic_select_for_share1248176384
    test_log_scope.go:81: use -show-logs to present logs inline
    test_server_shim.go:144: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
[10:23:27] setting distsql_workmem='72074B';
    logictestbase.go:555: statement/query skipped with reason: unsupported configuration weak-iso-level-configs (no issue given)
    logic.go:3012: 
         
        /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test_/local-read-committed_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_share:53: SELECT database_name, schema_name, table_name, lock_key_pretty, lock_strength, durability, replace(isolation_level, ' ', '_') AS isolation_level, granted, contended FROM crdb_internal.cluster_locks
        expected:
            database_name  schema_name  table_name  lock_key_pretty   lock_strength  durability  isolation_level  granted  contended
            test           public       t           /Table/106/1/1/0  Shared         Replicated  READ_COMMITTED   true     true
            test           public       t           /Table/106/1/1/0  Exclusive      Replicated  READ_COMMITTED   false    true
            test           public       t           /Table/106/1/1/0  Shared         Replicated  READ_COMMITTED   true     true
            
        but found (query options: "colnames,retry,rowsort" -> ignore the following ordering of rows) :
            database_name  schema_name  table_name  lock_key_pretty   lock_strength  durability  isolation_level  granted  contended
            test           public       t           /Table/106/1/1/0  Shared         Replicated  READ_COMMITTED   true     true
            test           public       t           /Table/106/1/1/0  Exclusive      Replicated  SERIALIZABLE     false    true
            test           public       t           /Table/106/1/1/0  Shared         Replicated  READ_COMMITTED   true     true
            
[10:24:14] --- progress: /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test_/local-read-committed_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_share: 10 statements
[10:24:14] --- done: /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test_/local-read-committed_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_share with config local-read-committed: 10 tests, 1 failures
    logic.go:4198: 
        /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test_/local-read-committed_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_share:61: error while processing
    logic.go:4198: /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test_/local-read-committed_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/select_for_share:61: too many errors encountered, skipping the rest of the input
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestReadCommittedLogic_select_for_share1248176384
--- FAIL: TestReadCommittedLogic_select_for_share (46.69s)

Parameters:

• attempt=1
• run=14
• shard=38

Help

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

This test on roachdash | Improve this report!

Jira issue: CRDB-41773

[michae2]

I'm able to reproduce this on my laptop after about 1500 runs with:

./dev testlogic ccl --config=local-read-committed --files=select_for_share --ignore-cache --stress --count 10000