Skip to content

sql: TestPrimaryKeyChangeWithOperations failed [ALTER PK fails with "duplicate key value violates unique constraint crdb_internal_index_2_name_placeholder" error] #143343

@cockroach-teamcity

Description

@cockroach-teamcity

sql.TestPrimaryKeyChangeWithOperations failed with artifacts on master @ 6e0be33b7511510a18d58cf2c7416c518a450dc2:

=== RUN   TestPrimaryKeyChangeWithOperations
    test_log_scope.go:165: test logs captured to: /artifacts/tmp/_tmp/1061c85d1b78da61f97933da6fe84ebc/logTestPrimaryKeyChangeWithOperations2446026049
    test_log_scope.go:76: use -show-logs to present logs inline
    test_server_shim.go:141: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
    schema_changer_test.go:343: pq: duplicate key value violates unique constraint "crdb_internal_index_2_name_placeholder"
    schema_changer_test.go:345: schema change ALTER TABLE t.test ALTER PRIMARY KEY USING COLUMNS (k) took 883.330967ms
    schema_changer_test.go:2629: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/1061c85d1b78da61f97933da6fe84ebc/logTestPrimaryKeyChangeWithOperations2446026049
--- FAIL: TestPrimaryKeyChangeWithOperations (3.71s)
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-48762

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.P-1Issues/test failures with a fix SLA of 1 monthT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-masterFailures and bugs on the master branch.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions