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/sql/schemachanger/schemachanger_test: TestConcurrentSchemaChanges failed #130069

Open
cockroach-teamcity opened this issue Sep 4, 2024 · 0 comments
Labels
branch-release-23.2 Used to mark GA and release blockers, technical advisories, and bugs for 23.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-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Sep 4, 2024

pkg/sql/schemachanger/schemachanger_test.TestConcurrentSchemaChanges failed with artifacts on release-23.2 @ b658f8a1a5c7924c1879fe66bb87bab2ce46e789:

    schemachanger_test.go:767: Parent database or schema is renamed; skipping this table renaming.
    schemachanger_test.go:767: Parent database or schema is renamed; skipping this table renaming.
    schemachanger_test.go:767: Parent database or schema is renamed; skipping this table renaming.
    schemachanger_test.go:767: Parent database or schema is renamed; skipping this table renaming.
    schemachanger_test.go:767: Parent database or schema is renamed; skipping this table renaming.
    schemachanger_test.go:783: ADD COLUMN col_461 TO testdb_448.testsc_431.t_441
    schemachanger_test.go:807: DROP COLUMN col_461 FROM testdb_448.testsc_431.t_441
    schemachanger_test.go:783: ADD COLUMN col_465 TO testdb_448.testsc_431.t_441
    schemachanger_test.go:783: ADD COLUMN col_469 TO testdb_448.testsc_431.t_441
    schemachanger_test.go:830: CREATE INDEX idx_471 ON testdb_448.testsc_431.t_441(col_465)
    schemachanger_test.go:762: DROP TABLE t_466
    schemachanger_test.go:760: RENAME TABLE TO t_473
    schemachanger_test.go:783: ADD COLUMN col_472 TO testdb_448.testsc_431.t_441
    schemachanger_test.go:811: Parent database or schema or table is renamed; skipping this column removal.
    schemachanger_test.go:783: ADD COLUMN col_474 TO testdb_448.testsc_431.t_473
    schemachanger_test.go:830: CREATE INDEX idx_475 ON testdb_448.testsc_431.t_473(col_472)
    schemachanger_test.go:783: ADD COLUMN col_476 TO testdb_448.testsc_431.t_473
    schemachanger_test.go:863: Parent database or schema or table is renamed or index is dropped; skipping this index removal.
    schemachanger_test.go:838: Parent database or schema or table is renamed or column is dropped or index already exists; skipping this index creation.
    schemachanger_test.go:807: DROP COLUMN col_472 FROM testdb_448.testsc_431.t_473
    schemachanger_test.go:830: CREATE INDEX idx_480 ON testdb_448.testsc_431.t_473(col_474)
    schemachanger_test.go:783: ADD COLUMN col_479 TO testdb_448.testsc_431.t_473
    schemachanger_test.go:807: DROP COLUMN col_476 FROM testdb_448.testsc_431.t_473
    schemachanger_test.go:783: ADD COLUMN col_482 TO testdb_448.testsc_431.t_473
    schemachanger_test.go:762: DROP TABLE t_477
    schemachanger_test.go:762: DROP TABLE t_483
    schemachanger_test.go:734: DROP SCHEMA TO testsc_431
    schemachanger_test.go:838: Parent database or schema or table is renamed or column is dropped or index already exists; skipping this index creation.
    schemachanger_test.go:863: Parent database or schema or table is renamed or index is dropped; skipping this index removal.
    schemachanger_test.go:783: ADD COLUMN col_484 TO testdb_448.testsc_431.t_473
    schemachanger_test.go:830: CREATE INDEX idx_489 ON testdb_448.testsc_431.t_473(col_484)
    schemachanger_test.go:807: DROP COLUMN col_484 FROM testdb_448.testsc_431.t_473
    schemachanger_test.go:783: ADD COLUMN col_490 TO testdb_448.testsc_431.t_473
    schemachanger_test.go:679: rename-db-worker encounters error driver: bad connection; signal to main routine and finish working
    schemachanger_test.go:675: create-index-worker is signaled to finish work
    schemachanger_test.go:675: add-column-worker is signaled to finish work
    schemachanger_test.go:675: drop-index-worker is signaled to finish work
    schemachanger_test.go:675: drop-column-worker is signaled to finish work
    schemachanger_test.go:762: DROP TABLE t_491
    schemachanger_test.go:675: rename-tbl-worker is signaled to finish work
    schemachanger_test.go:734: DROP SCHEMA TO testsc_431
    schemachanger_test.go:675: rename-schema-worker is signaled to finish work
    schemachanger_test.go:869: 
        	Error Trace:	pkg/sql/schemachanger/schemachanger_test_test/pkg/sql/schemachanger/schemachanger_test.go:869
        	Error:      	Received unexpected error:
        	            	driver: bad connection
        	Test:       	TestConcurrentSchemaChanges
    panic.go:523: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/30f4dfc616eac199fee667c9faa35314/logTestConcurrentSchemaChanges376413842
--- FAIL: TestConcurrentSchemaChanges (164.14s)
Help

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

Same failure on other branches

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-41862

@cockroach-teamcity cockroach-teamcity added branch-release-23.2 Used to mark GA and release blockers, technical advisories, and bugs for 23.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-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Sep 4, 2024
@cockroach-teamcity cockroach-teamcity added this to the 23.2 milestone Sep 4, 2024
@fqazi fqazi self-assigned this Sep 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-23.2 Used to mark GA and release blockers, technical advisories, and bugs for 23.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-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

No branches or pull requests

2 participants