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

sql: "liveness session expired" in RBR table when altering primary key in a logic test #92877

Closed
yuzefovich opened this issue Dec 2, 2022 · 2 comments
Closed

sql: "liveness session expired" in RBR table when altering primary key in a logic test #92877

yuzefovich opened this issue Dec 2, 2022 · 2 comments
Assignees
@ajwerner
Labels
C-investigation Further steps needed to qualify. C-label will change. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@yuzefovich
Copy link
Member

yuzefovich commented Dec 2, 2022 •
edited by cockroach-jira-scripts
Loading

Seen here in TestCCLLogic_regional_by_row_hash_sharded_index

[21:13:20] setting distsql_workmem='44610B';
[21:13:35] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/8316/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/multiregion-9node-3region-3azs-no-los/multiregion-9node-3region-3azs-no-los_test_/multiregion-9node-3region-3azs-no-los_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/regional_by_row_hash_sharded_index: 11 statements
[21:13:57] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/8316/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/multiregion-9node-3region-3azs-no-los/multiregion-9node-3region-3azs-no-los_test_/multiregion-9node-3region-3azs-no-los_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/regional_by_row_hash_sharded_index: 13 statements
    logic.go:3193: 
        
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/8316/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/multiregion-9node-3region-3azs-no-los/multiregion-9node-3region-3azs-no-los_test_/multiregion-9node-3region-3azs-no-los_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/regional_by_row_hash_sharded_index:90: 
        expected success, but found
        (XXUUU) polling for queued jobs to complete: poll-show-jobs: liveness session expired 1.578610091s before transaction
        leased_descriptors.go:206: in maybeUpdateDeadline()

Jira issue: CRDB-22016
@yuzefovich yuzefovich added the C-investigation Further steps needed to qualify. C-label will change. label Dec 2, 2022
@blathers-crl blathers-crl bot added the T-sql-schema-deprecated Use T-sql-foundations instead label Dec 2, 2022
@tbg
Copy link
Member

tbg commented Dec 7, 2022

Also just seen in bors

https://teamcity.cockroachdb.com/viewLog.html?buildId=7873712&tab=buildResultsDiv&buildTypeId=Cockroach_UnitTests_BazelUnitTests

@rytaft rytaft mentioned this issue Mar 23, 2023
Closed
@ajwerner
Copy link
Contributor

ajwerner commented Apr 6, 2023

I think maybe this is fixed by #99760

@ajwerner ajwerner closed this as completed Apr 6, 2023
@exalate-issue-sync exalate-issue-sync bot added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-schema-deprecated Use T-sql-foundations instead labels May 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ajwerner ajwerner

Labels
C-investigation Further steps needed to qualify. C-label will change. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ajwerner @tbg @yuzefovich