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

roachtest: schemachange/mixed-versions-compat failed #100908

Closed
cockroach-teamcity opened this issue Apr 7, 2023 · 10 comments · Fixed by #101105
Closed

roachtest: schemachange/mixed-versions-compat failed #100908

cockroach-teamcity opened this issue Apr 7, 2023 · 10 comments · Fixed by #101105
Assignees
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Apr 7, 2023

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 8e6f530644eb35313a479af529b1f672c12dca38:

W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230407 12:59:19.625124 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230407 12:59:19.629441 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230407 12:59:19.630292 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230407 12:59:19.631137 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

Jira issue: CRDB-26693

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest 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. labels Apr 7, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Apr 7, 2023
@blathers-crl blathers-crl bot added the T-sql-schema-deprecated Use T-sql-foundations instead label Apr 7, 2023
@rafiss
Copy link
Collaborator

rafiss commented Apr 7, 2023

easier to read error:

failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error:
building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE:
failed to satisfy [[CheckConstraint:{DescID: 111, IndexID: 8, ConstraintID: 11}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 111, Name: check_g_h, ConstraintID: 11}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for CREATE INDEX with error:
building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for CREATE INDEX:
failed to satisfy [[CheckConstraint:{DescID: 111, IndexID: 0, ConstraintID: 3}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 111, Name: check_crdb_internal_id2_shard_16, ConstraintID: 3}, PUBLIC], PUBLIC] rule "simple constraint visible before name"

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 8e6f530644eb35313a479af529b1f672c12dca38:

W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230407 18:02:25.987855 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230407 18:02:25.992167 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230407 18:02:25.993027 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230407 18:02:25.993862 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@rafiss rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Apr 7, 2023
@rafiss
Copy link
Collaborator

rafiss commented Apr 7, 2023

we believe only the master branch is affected

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 85e41ca8d3d9edacf5ee3061a2591b159b9b0502:

W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230408 17:19:59.410748 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230408 17:19:59.414938 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230408 17:19:59.415786 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230408 17:19:59.416595 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 85e41ca8d3d9edacf5ee3061a2591b159b9b0502:

W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230408 17:52:36.477159 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230408 17:52:36.481478 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230408 17:52:36.482352 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230408 17:52:36.483170 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 85e41ca8d3d9edacf5ee3061a2591b159b9b0502:

W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230409 17:41:22.959424 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230409 17:41:22.963515 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230409 17:41:22.964339 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230409 17:41:22.965154 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 85e41ca8d3d9edacf5ee3061a2591b159b9b0502:

W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230409 17:58:43.538557 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230409 17:58:43.542665 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230409 17:58:43.543454 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230409 17:58:43.544236 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 85e41ca8d3d9edacf5ee3061a2591b159b9b0502:

W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230410 13:06:26.376476 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230410 13:06:26.380886 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230410 13:06:26.381765 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230410 13:06:26.382650 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ 85e41ca8d3d9edacf5ee3061a2591b159b9b0502:

W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230410 18:03:59.056805 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230410 18:03:59.061084 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230410 18:03:59.061928 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230410 18:03:59.062771 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions-compat failed with artifacts on master @ a5d61d2cf2bfc11bd6bdc27dcab32467334fb123:

W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230411 12:46:43.095774 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=true) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 4}, ABSENT], ABSENT] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 4}, ABSENT], ABSENT] rule "Constraint should be hidden before name"
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230411 12:46:43.099943 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230411 12:46:43.100778 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684  failed building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE with error: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230411 12:46:43.101567 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[UniqueWithoutIndexConstraint:{DescID: 108, IndexID: 0, ConstraintID: 4}, PUBLIC], WRITE_ONLY] -dep-SameStagePrecedence-> [[ConstraintWithoutIndexName:{DescID: 108, Name: unique_address, ConstraintID: 4}, PUBLIC], PUBLIC] rule "simple constraint visible before name"
SQLSTATE: XX000
HINT: You have encountered an unexpected error.
Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.
If you would rather not post publicly, please contact us directly
using the support form.
We appreciate your feedback.
Failed running "debug declarative-corpus-validate"

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

craig bot pushed a commit that referenced this issue Apr 11, 2023
99856: roachtest: update 22.2 predecessor to 22.1.18 r=renatolabs a=cameronnunez

Part of: https://cockroachlabs.atlassian.net/browse/REL-309

Release note: None

100200: pgwire: add server.cockroach_cloud.max_client_connections_per_gateway cluster setting r=alyshanjahani-crl a=alyshanjahani-crl

This setting specifies a maximum number of external connections that a server can have open at any given time. External is defined as connections that are not root connections. In the future, we can have the definition of external be a configurable list of users.
<0 - Connections are unlimited (existing behavior)
=0 - External connections are disabled
>0 - External connections are limited
If a new connection would exceed this limit, an error message is returned as postgres: "cluster connections are limited" with the 53300 error code that corresponds to "too many connections".

This functionality is required for serverless.
Part of: https://cockroachlabs.atlassian.net/browse/CC-9288

Release note: None

100742: ownership of Jobs to DR team r=shermanCRL a=shermanCRL

Epic: CRDB-26380

100911: cli: add system.job_info to debug zip r=adityamaru a=adityamaru

We do not dump the value column when
collecting a redacted zip as it might contain
sensitive data.

Release note: None
Informs: #98829

101095: add DR, CDC, Jobs labels to test failures r=shermanCRL a=shermanCRL

Ensure that test failures via the `cockroach-teamcity` bot labels DR, CDC and Jobs teams

Epic: none
Jira: none


101105: sql/schemachanger: relax rules for setting constraint names r=fqazi a=fqazi

Previously, the rules for adding and removing constraint names were strict, which could lead to mixed version compatibility issues. Specifically, plans on the 23.1 branch could have names set in later stages violating a rule that said a constraint should be public/non-public with the name. To address this, this patch will relax these rules to have Precedence instead of SameStagePrecedence

Fixes: #100908

Release note: None

101169: roachtest: prevent shared mutable state across restore roachtest runs r=benbardin a=msbutler

Previously, all `restore/*` roachtests run with `--count` would provide incomprehensible results because multiple roachtest runs of the same test would override each other's state. Specifically, the latest call of `test_spec.Run()`, would override the `test.Test` harness, and `syncedCluster.Cluster` used by all other tests with the same registration.

This patch fixes this problem by moving all fields in `restoreSpecs` that are set during test execution (i.e. a `test_spec.Run` call), to a new `restoreDriver` struct. Now, `restoreSpecs` gets defined during test registration and is shared across test runs, while `restoreDriver` gets set within a test run.

Epic: none

Release note: None

Co-authored-by: Cameron Nunez <[email protected]>
Co-authored-by: Alyshan Jahani <[email protected]>
Co-authored-by: Matt Sherman <[email protected]>
Co-authored-by: adityamaru <[email protected]>
Co-authored-by: Faizan Qazi <[email protected]>
Co-authored-by: Michael Butler <[email protected]>
@craig craig bot closed this as completed in af1d9cf Apr 11, 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
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants