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

ccl/schemachangerccl: TestBackupSuccess_base_alter_table_multiple_commands failed #108238

Closed
cockroach-teamcity opened this issue Aug 5, 2023 · 2 comments
Closed

ccl/schemachangerccl: TestBackupSuccess_base_alter_table_multiple_commands failed #108238

cockroach-teamcity opened this issue Aug 5, 2023 · 2 comments
Assignees
@Xiang-Gu
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone
23.2

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Aug 5, 2023 •
edited by cockroach-jira-scripts
Loading

ccl/schemachangerccl.TestBackupSuccess_base_alter_table_multiple_commands failed with artifacts on master @ 695d4ec85157a4da0c97237e6f16bf919eebf6c5:

    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_6_of_31 (118.88s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_8_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_8_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_8_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_8_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_8_of_31 (120.01s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_15_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_15_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_15_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_15_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_15_of_31 (127.55s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_1_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_1_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_1_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_1_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_1_of_31 (117.32s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_4_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_4_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_4_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_4_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_4_of_31 (118.62s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31 (118.72s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_12_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_12_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_12_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_12_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_12_of_31 (124.18s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31 (119.89s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_30_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_30_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_30_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_30_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_30_of_31 (118.62s)
Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-30374
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Aug 5, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.2 milestone Aug 5, 2023
@cockroach-teamcity
Copy link
Member Author

ccl/schemachangerccl.TestBackupSuccess_base_alter_table_multiple_commands failed with artifacts on master @ f1623e0a2cffc81580ee3c3b71035efd854d89c9:

    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_22_of_31 (130.26s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_5_of_31 (138.80s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_17_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_17_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_17_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_17_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_17_of_31 (140.45s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/5153/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/schemachangerccl/schemachangerccl_test_/schemachangerccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/schemachanger/testdata/end_to_end/alter_table_multiple_commands/alter_table_multiple_commands.definition:1:
        setup [0 args]
        CREATE TABLE t (i INT PRIMARY KEY, j INT NOT NULL, k INT, FAMILY "primary" (i, j, k));
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/5153/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/schemachangerccl/schemachangerccl_test_/schemachangerccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/schemachanger/testdata/end_to_end/alter_table_multiple_commands/alter_table_multiple_commands.definition:5:
        stage-exec [2 args]
        INSERT INTO t(j,i) VALUES($stageKey, $stageKey);
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/5153/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/schemachangerccl/schemachangerccl_test_/schemachangerccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/schemachanger/testdata/end_to_end/alter_table_multiple_commands/alter_table_multiple_commands.definition:11:
        stage-query [2 args]
        SELECT count(*)=$successfulStageCount FROM t;
        ----
        true
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/5153/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/schemachangerccl/schemachangerccl_test_/schemachangerccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/schemachanger/testdata/end_to_end/alter_table_multiple_commands/alter_table_multiple_commands.definition:17:
        test [0 args]
        ALTER TABLE t ALTER PRIMARY KEY USING COLUMNS (j), DROP COLUMN k, ADD COLUMN p INT DEFAULT 30;
        ----
    --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group (39.25s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_26_of_31 (143.58s)
=== RUN   TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_3_of_31
=== PAUSE TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_3_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_3_of_31
=== CONT  TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_3_of_31
    framework.go:885: condition failed to evaluate within 45s: from framework.go:891: waiting for statements to execute
        --- FAIL: TestBackupSuccess_base_alter_table_multiple_commands/group/post_commit_stage_3_of_31 (130.46s)
Help

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

This test on roachdash | Improve this report!

This was referenced Aug 7, 2023
Merged
Closed
@Xiang-Gu Xiang-Gu mentioned this issue Aug 7, 2023
Merged
@rafiss
Copy link
Collaborator

rafiss commented Aug 7, 2023

closing in favor of #108221

@rafiss rafiss closed this as completed Aug 7, 2023
craig bot pushed a commit that referenced this issue Aug 7, 2023
@Xiang-Gu
Merge #108289
898c592 
108289: schemachanger: Skip some reported timeout backup tests r=rafiss a=Xiang-Gu

There has been a few timeout failures from the BACKUP/RESTORE testing suites so let's skip
them for now until we know more of the issue.

Informs ##108238
Informs #108221
Epic: None
Release note: None

Co-authored-by: Xiang Gu <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Xiang-Gu Xiang-Gu

Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
23.2
Development

No branches or pull requests
3 participants
@rafiss @cockroach-teamcity @Xiang-Gu