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.

Sign up for GitHub

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

Jump to bottom

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

Closed
cockroach-teamcity opened this issue Mar 30, 2024 · 3 comments
Closed

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

cockroach-teamcity opened this issue Mar 30, 2024 · 3 comments
Labels
branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 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 X-duplicate Closed as a duplicate of another issue.
Milestone
24.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Mar 30, 2024 •
edited by cockroach-jira-scripts
Loading

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

=== RUN   TestTenantLogicCCL_cluster_locks_tenant
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant3739399245
    test_log_scope.go:81: use -show-logs to present logs inline
[04:29:36] setting distsql_workmem='69215B';
[04:29:36] setting distsql_workmem='69215B';
    logic.go:3021: let $root_session = 17c17073d2051d7e0000000000000001
    logic.go:3021: let $testuser_session = 17c17073e5aa48fd0000000000000001
    logic.go:3021: let $txn1 = da675f6e-3484-4479-aab2-782a2c621a6b
    logic.go:3021: let $txn2 = 3fdb859e-f02f-43ad-91b6-30c66014fcf8
    logic.go:3021: let $txn3 = 93ed172c-ebed-4ced-b1f4-bcf466c04cf1
    logic.go:3021: let $txn4 = dcfaff9d-f52e-4948-9011-f3826474c160
[04:29:38] --- progress: /var/lib/engflow/worker/work/1/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
    logic.go:2963: 
         
        /var/lib/engflow/worker/work/1/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:230: SELECT count(*) FROM crdb_internal.cluster_locks WHERE table_name IN ('t','t2')
        expected:
            4
            
        but found (query options: "retry") :
            0
            
[04:30:24] --- progress: /var/lib/engflow/worker/work/1/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: 36 statements
[04:30:24] --- done: /var/lib/engflow/worker/work/1/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: 36 tests, 1 failures
    logic.go:4145: 
        /var/lib/engflow/worker/work/1/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:235: error while processing
    logic.go:4145: /var/lib/engflow/worker/work/1/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:235: too many errors encountered, skipping the rest of the input
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant3739399245
--- FAIL: TestTenantLogicCCL_cluster_locks_tenant (51.81s)

Parameters:

  • attempt=1
  • run=3
  • shard=16
Help

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

Same failure on other branches

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-37232
@cockroach-teamcity cockroach-teamcity added branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 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 Mar 30, 2024
@cockroach-teamcity cockroach-teamcity added this to the 24.1 milestone Mar 30, 2024
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Mar 30, 2024
@cockroach-teamcity cockroach-teamcity mentioned this issue Mar 31, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

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

=== RUN   TestTenantLogicCCL_cluster_locks_tenant
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant557066414
    test_log_scope.go:81: use -show-logs to present logs inline
[04:32:35] setting distsql_workmem='16198B';
[04:32:35] setting distsql_workmem='16198B';
    logic.go:3021: let $root_session = 17c1bf323f5bb9c40000000000000001
    logic.go:3021: let $testuser_session = 17c1bf3255a5a1930000000000000001
    logic.go:3021: let $txn1 = d8b7cc30-966f-4ee7-a89e-bb13fb8d30fb
    logic.go:3021: let $txn2 = a68a469e-65ed-424f-a2cf-791628cab7dd
    logic.go:3021: let $txn3 = 9eb0353f-942e-4947-afba-91538e7aa465
    logic.go:3021: let $txn4 = 0e487fd8-ec71-42e9-95b1-051bbee1a15d
[04:32:38] --- 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/cluster_locks_tenant: 26 statements
    logic.go:2963: 
         
        /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/cluster_locks_tenant:230: SELECT count(*) FROM crdb_internal.cluster_locks WHERE table_name IN ('t','t2')
        expected:
            4
            
        but found (query options: "retry") :
            0
            
[04:33:24] --- 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/cluster_locks_tenant: 36 statements
[04:33:24] --- 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/cluster_locks_tenant with config 3node-tenant: 36 tests, 1 failures
    logic.go:4145: 
        /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/cluster_locks_tenant:235: error while processing
    logic.go:4145: /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/cluster_locks_tenant:235: too many errors encountered, skipping the rest of the input
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant557066414
--- FAIL: TestTenantLogicCCL_cluster_locks_tenant (51.85s)

Parameters:

  • attempt=1
  • run=15
  • shard=16
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

=== RUN   TestTenantLogicCCL_cluster_locks_tenant
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant414352819
    test_log_scope.go:81: use -show-logs to present logs inline
[06:09:36] setting distsql_workmem='100486B';
[06:09:36] setting distsql_workmem='100486B';
    logic.go:3021: let $root_session = 17c21311fb475ef90000000000000001
    logic.go:3021: let $testuser_session = 17c2131217e130b80000000000000001
    logic.go:3021: let $txn1 = 8437faaa-174c-472a-8e2b-f83c2d42ede5
    logic.go:3021: let $txn2 = a41a5426-817e-4d3f-b77b-d356e43ddc3a
    logic.go:3021: let $txn3 = a4f67bcb-182f-4039-b9d1-63346225c62b
    logic.go:3021: let $txn4 = 6c0cfef8-a091-41a1-bb7c-11e0050838dd
[06:09:40] --- 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/cluster_locks_tenant: 26 statements
[06:09:40] --- 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/cluster_locks_tenant with config 3node-tenant: 30 tests, 0 failures
    logic.go:4145: 
        /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/cluster_locks_tenant:204: error while processing
    logic.go:4145: 
        /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/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=6c0cfef8 key=/Tenant/10/Table/106/1/"b" iso=Serializable pri=0.00608116 epo=0 ts=1711951776.897314945,2 min=1711951776.867396417,0 seq=2} lock=true stat=PENDING rts=1711951776.897314945,2 wto=false gul=1711951777.367396417,0
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestTenantLogicCCL_cluster_locks_tenant414352819
--- FAIL: TestTenantLogicCCL_cluster_locks_tenant (7.86s)

Parameters:

  • attempt=1
  • run=5
  • shard=16
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@yuzefovich
Copy link
Member

dup of #121401

@github-project-automation github-project-automation bot moved this from Triage to Done in SQL Queries Apr 1, 2024
@yuzefovich yuzefovich added the X-duplicate Closed as a duplicate of another issue. label Apr 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 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 X-duplicate Closed as a duplicate of another issue.
Projects
SQL Queries
Archived in project
Milestone
24.1
Development

No branches or pull requests
2 participants
@yuzefovich @cockroach-teamcity