Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed [ABORT_REASON_CLIENT_REJECT] #139776

Closed
cockroach-teamcity opened this issue Jan 24, 2025 · 1 comment · Fixed by #140607
Assignees
Labels
branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 branch-release-25.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. P-2 Issues/test failures with a fix SLA of 3 months T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Jan 24, 2025

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

=== RUN   TestTenantLogic_grant_in_txn
    test_log_scope.go:165: test logs captured to: outputs.zip/logTestTenantLogic_grant_in_txn2667027343
    test_log_scope.go:76: use -show-logs to present logs inline
[18:42:57] --- 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: 57 statements
    logic.go:2683: 
         
        /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:217: 
        expected:
        testuser must have CREATEROLE or have admin option on role \"role_bar\"
        got:
        pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_CLIENT_REJECT): "sql txn" meta={id=97f47e83 key=/Tenant/10/Table/23/1/"role_foo"/"testuser"/4/1 iso=Serializable pri=0.00513755 epo=0 ts=1737744177.722028840,0 min=1737744177.722028840,0 seq=11} lock=true stat=PENDING rts=1737744177.722028840,0 wto=false gul=1737744178.222028840,0
        HINT: See: https://www.cockroachlabs.com/docs/v24.2/transaction-retry-error-reference.html#abort_reason_client_reject
[18:43:02] --- 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: 66 statements
[18:43:02] --- 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: 66 tests, 1 failures
    logic.go:4202: 
        /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:220: error while processing
    logic.go:4202: /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:220: 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_txn2667027343
--- FAIL: TestTenantLogic_grant_in_txn (11.41s)

Parameters:

  • attempt=1
  • run=22
  • shard=20
Help

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

This test on roachdash | Improve this report!

Jira issue: CRDB-46806

@cockroach-teamcity cockroach-teamcity added branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team labels Jan 24, 2025
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Jan 24, 2025
@yuzefovich yuzefovich added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-queries SQL Queries Team labels Jan 26, 2025
@yuzefovich yuzefovich removed this from SQL Queries Jan 26, 2025
@exalate-issue-sync exalate-issue-sync bot added the P-2 Issues/test failures with a fix SLA of 3 months label Jan 28, 2025
@rafiss rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Jan 28, 2025
@rafiss rafiss self-assigned this Jan 28, 2025
@rafiss rafiss changed the title pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed [ABORT_REASON_CLIENT_REJECT] Jan 28, 2025
@rafiss rafiss assigned fqazi and unassigned rafiss Jan 28, 2025
@exalate-issue-sync exalate-issue-sync bot changed the title pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed [ABORT_REASON_CLIENT_REJECT] pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed Jan 28, 2025
@exalate-issue-sync exalate-issue-sync bot assigned rafiss and unassigned fqazi Jan 28, 2025
@exalate-issue-sync exalate-issue-sync bot changed the title pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_grant_in_txn failed [ABORT_REASON_CLIENT_REJECT] Feb 5, 2025
@exalate-issue-sync exalate-issue-sync bot assigned fqazi and unassigned rafiss Feb 5, 2025
@craig craig bot closed this as completed in #140607 Feb 6, 2025
@craig craig bot closed this as completed in 215d16b Feb 6, 2025
Copy link

blathers-crl bot commented Feb 6, 2025

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.3, branch-release-25.1. 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.

@blathers-crl blathers-crl bot added branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 labels Feb 6, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 branch-release-25.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. P-2 Issues/test failures with a fix SLA of 3 months T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants