pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed [transaction abort]

[cockroach-teamcity]

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

=== RUN   TestTenantLogic_grant_in_txn
    test_log_scope.go:165: test logs captured to: outputs.zip/logTestTenantLogic_grant_in_txn2321681312
    test_log_scope.go:76: use -show-logs to present logs inline
[17:53:10] setting distsql_workmem='66699B';
[17:53:10] setting distsql_workmem='66699B';
[17:53:12] --- 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/sql/logictest/testdata/logic_test/grant_in_txn: 61 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/sql/logictest/testdata/logic_test/grant_in_txn:223: SELECT * FROM information_schema.applicable_roles;
        expected success, but found
        (40001) restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_ABORT_SPAN): "sql txn" meta={id=9db55b2b key=/Tenant/10/Table/23/1/"role_foo"/"testuser" iso=Serializable pri=0.01006140 epo=0 ts=1738173192.912063116,0 min=1738173192.912063116,0 seq=12} lock=true stat=ABORTED rts=1738173192.912063116,0 wto=false gul=1738173193.412063116,0 isn=1
[17:53:17] --- 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/sql/logictest/testdata/logic_test/grant_in_txn: 68 statements
[17:53:17] --- 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/sql/logictest/testdata/logic_test/grant_in_txn with config 3node-tenant: 68 tests, 1 failures
    logic.go:4252: 
        /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/sql/logictest/testdata/logic_test/grant_in_txn:228: error while processing
    logic.go:4252: /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/sql/logictest/testdata/logic_test/grant_in_txn:228: too many errors encountered, skipping the rest of the input
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestTenantLogic_grant_in_txn2321681312
--- FAIL: TestTenantLogic_grant_in_txn (12.27s)

Parameters:

• attempt=1
• run=18
• shard=22

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: TestTenantLogic_grant_in_txn failed [ABORT_REASON_CLIENT_REJECT] #139776 pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed [C-test-failure O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

Jira issue: CRDB-46983

[spilchen]

This appears to be another variation of the issue in #139776. It occurs in the same test case and subtest, with the same TransactionAbortedError, but at a different line—223 here versus 217 in the other instance.

[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.}