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: TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid failed #108005

Closed
cockroach-teamcity opened this issue Aug 2, 2023 · 5 comments · Fixed by #108073
Closed

ccl/schemachangerccl: TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid failed #108005

cockroach-teamcity opened this issue Aug 2, 2023 · 5 comments · Fixed by #108073
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 2, 2023 •
edited by cockroach-jira-scripts
Loading

ccl/schemachangerccl.TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid failed with artifacts on master @ 8d2d2bf47cb3da1c27baa140a5afb5d28a5ed8f6:

Fatal error:

panic: test timed out after 14m55s

Stack:

goroutine 969923 [running]:
testing.(*M).startAlarm.func1()
	GOROOT/src/testing/testing.go:2036 +0x8e
created by time.goFunc
	GOROOT/src/time/sleep.go:176 +0x32
Log preceding fatal error 

        true
    datadriven.go:143: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1064/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_alter_primary_key_drop_rowid/alter_table_alter_primary_key_drop_rowid.definition:19:
        stage-exec [2 args]
        INSERT INTO t VALUES($stageKey);
        INSERT INTO t VALUES($stageKey + 1);
        ----
        pq: INSERT has more expressions than target columns, 2 expressions for 1 targets
    datadriven.go:143: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1064/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_alter_primary_key_drop_rowid/alter_table_alter_primary_key_drop_rowid.definition:27:
        stage-query [2 args]
        SELECT count(*)=$successfulStageCount*2 FROM t;
        ----
        true
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_1_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_3_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_3_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_4_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_4_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_6_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_8_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_8_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_10_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_1_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_1_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_5_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_7_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_7_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_8_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_10_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_6_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_9_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_3_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_6_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_9_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_3_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_1_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_2_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_7_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_8_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_10_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_2_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_4_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_4_of_15/restore_database_with_schema_only
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_5_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_5_of_15/restore_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_9_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_2_of_15
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_6_of_15/restore_all_tables_in_database
=== RUN   TestBackupSuccessMixedVersion_base_alter_table_alter_primary_key_drop_rowid/post_commit_stage_11_of_15

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-30283
@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 2, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.2 milestone Aug 2, 2023
@knz
Copy link
Contributor

knz commented Aug 2, 2023

One more https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_BazelEssentialCi/11151111?hideProblemsFromDependencies=false&hideTestsFromDependencies=false&expandBuildProblemsSection=true&expandBuildTestsSection=true

@rafiss
Copy link
Collaborator

rafiss commented Aug 2, 2023

It seems like this times out, similar to how alter_table_add_primary_key_drop_rowid was as well (see #107590 and #107552 (comment))

@Xiang-Gu Xiang-Gu mentioned this issue Aug 2, 2023
Merged
@wenyihu6
Copy link
Contributor

wenyihu6 commented Aug 2, 2023

Here too https://teamcity.cockroachdb.com/viewLog.html?buildId=11166102&buildTypeId=Cockroach_BazelEssentialCi

@mgartner
Copy link
Collaborator

mgartner commented Aug 3, 2023

This is repeatedly failing CI on one of my branches. Example: https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_BazelEssentialCi/11162538?hideProblemsFromDependencies=false&hideTestsFromDependencies=false&expandBuildChangesSection=true&expandBuildProblemsSection=true&expandBuildTestsSection=true

@adityamaru
Copy link
Contributor

anotha one: https://teamcity.cockroachdb.com/viewLog.html?buildId=11178819&buildTypeId=Cockroach_BazelEssentialCi

@craig craig bot closed this as completed in d87a04b Aug 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
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

Successfully merging a pull request may close this issue.

sctest: Parallelize declarative schema change tests Xiang-Gu/cockroach
6 participants
@knz @mgartner @rafiss @adityamaru @cockroach-teamcity @wenyihu6