roachtest: schemachange/mixed-versions-compat failed

[cockroach-teamcity]

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

W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +already tracked. If you cannot find it there, please report the error
W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +with details by creating a new issue.
W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +If you would rather not post publicly, please contact us directly
W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +using the support form.
W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +
W230411 18:05:57.949199 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 681 +We appreciate your feedback.
W230411 18:05:57.953487 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 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +HINT: You have encountered an unexpected error.
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +Please check the public issue tracker to check whether this problem is
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +already tracked. If you cannot find it there, please report the error
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +with details by creating a new issue.
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +If you would rather not post publicly, please contact us directly
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +using the support form.
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +
W230411 18:05:57.953487 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 682 +We appreciate your feedback.
W230411 18:05:57.954381 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 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +HINT: You have encountered an unexpected error.
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +Please check the public issue tracker to check whether this problem is
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +already tracked. If you cannot find it there, please report the error
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +with details by creating a new issue.
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +If you would rather not post publicly, please contact us directly
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +using the support form.
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +
W230411 18:05:57.954381 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 683 +We appreciate your feedback.
W230411 18:05:57.955250 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 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +HINT: You have encountered an unexpected error.
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +Please check the public issue tracker to check whether this problem is
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +already tracked. If you cannot find it there, please report the error
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +with details by creating a new issue.
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +If you would rather not post publicly, please contact us directly
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +using the support form.
W230411 18:05:57.955250 1 sql/schemachanger/scplan/internal/scstage/build.go:531  [-] 684 +
W230411 18:05:57.955250 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_fs=ext4 , ROACHTEST_localSSD=true , 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-26875

[fqazi]

Fixed with: #101105