pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogicCCL_cluster_locks_tenant failed

[cockroach-teamcity]

pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test.TestTenantLogicCCL_cluster_locks_tenant failed on release-24.1 @ ab15ba5ecd31719682e19805ebc03cd291dccf94:

=== RUN   TestTenantLogicCCL_cluster_locks_tenant
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant20831500
    test_log_scope.go:81: use -show-logs to present logs inline
[05:01:32] setting distsql_workmem='36708B';
[05:01:32] setting distsql_workmem='36708B';
    logic.go:3021: let $root_session = 17c349ad5dfc3f4f0000000000000001
    logic.go:3021: let $testuser_session = 17c349ad86229dcd0000000000000001
    logic.go:3021: let $txn1 = 334fd491-70a8-48ea-b659-9e266197ebf8
    logic.go:3021: let $txn2 = 7b75c979-791a-4839-816a-bd82b3aff64d
    logic.go:3021: let $txn3 = 8d82886c-df0f-4414-a1c1-c61c8bba6ac0
    logic.go:3021: let $txn4 = 1d05bde2-6a6c-420b-844f-ff59b662b38a
[05:01:36] --- progress: /var/lib/engflow/worker/work/2/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/cluster_locks_tenant: 26 statements
[05:01:36] --- done: /var/lib/engflow/worker/work/2/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/cluster_locks_tenant with config 3node-tenant: 30 tests, 0 failures
    logic.go:4148: 
        /var/lib/engflow/worker/work/2/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/cluster_locks_tenant:204: error while processing
    logic.go:4148: 
        /var/lib/engflow/worker/work/2/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/cluster_locks_tenant:204: 
        expected success, but found
        (40001) restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE - missing intent on: /Tenant/10/Table/106/1/"c"/0): "sql txn" meta={id=1d05bde2 key=/Tenant/10/Table/106/1/"b" iso=Serializable pri=0.03960067 epo=0 ts=1712293293.133319688,2 min=1712293293.096211192,0 seq=2} lock=true stat=PENDING rts=1712293293.133319688,2 wto=false gul=1712293293.596211192,0
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant20831500
--- FAIL: TestTenantLogicCCL_cluster_locks_tenant (9.59s)

Parameters:

• attempt=1
• run=2
• shard=16

Help

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

Same failure on other branches

• pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogicCCL_cluster_locks_tenant failed #121401 pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogicCCL_cluster_locks_tenant failed [C-bug C-test-failure GA-blocker O-robot P-1 T-kv branch-master]

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-37571

[michae2]

dup of #121401