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

cockroach-teamcity · 2023-10-14T14:08:01Z

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

W231014 14:07:45.238174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +with details by creating a new issue.
W231014 14:07:45.238174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231014 14:07:45.238174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +If you would rather not post publicly, please contact us directly
W231014 14:07:45.238174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +using the support form.
W231014 14:07:45.238174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231014 14:07:45.238174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +We appreciate your feedback.
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: check_w, ConstraintID: 7}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 7}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +HINT: You have encountered an unexpected error.
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +Please check the public issue tracker to check whether this problem is
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +already tracked. If you cannot find it there, please report the error
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +with details by creating a new issue.
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +If you would rather not post publicly, please contact us directly
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +using the support form.
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231014 14:07:45.239174 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +We appreciate your feedback.
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +HINT: You have encountered an unexpected error.
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +Please check the public issue tracker to check whether this problem is
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +already tracked. If you cannot find it there, please report the error
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +with details by creating a new issue.
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +If you would rather not post publicly, please contact us directly
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +using the support form.
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231014 14:07:45.243043 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +We appreciate your feedback.
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +HINT: You have encountered an unexpected error.
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +Please check the public issue tracker to check whether this problem is
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +already tracked. If you cannot find it there, please report the error
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +with details by creating a new issue.
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +If you would rather not post publicly, please contact us directly
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +using the support form.
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231014 14:07:45.243717 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 109, Name: fk, ConstraintID: 2}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[ForeignKeyConstraint:{DescID: 109, IndexID: 0, ConstraintID: 2, ReferencedDescID: 110}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
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"
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-foundations _{This test on roachdash | Improve this report!

Jira issue: CRDB-32381}

The text was updated successfully, but these errors were encountered:

cockroach-teamcity · 2023-10-15T13:33:11Z

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

W231015 13:32:54.131140 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +with details by creating a new issue.
W231015 13:32:54.131140 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231015 13:32:54.131140 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +If you would rather not post publicly, please contact us directly
W231015 13:32:54.131140 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +using the support form.
W231015 13:32:54.131140 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231015 13:32:54.131140 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +We appreciate your feedback.
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: check_w, ConstraintID: 7}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 7}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +HINT: You have encountered an unexpected error.
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +Please check the public issue tracker to check whether this problem is
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +already tracked. If you cannot find it there, please report the error
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +with details by creating a new issue.
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +If you would rather not post publicly, please contact us directly
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +using the support form.
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231015 13:32:54.132139 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +We appreciate your feedback.
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +HINT: You have encountered an unexpected error.
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +Please check the public issue tracker to check whether this problem is
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +already tracked. If you cannot find it there, please report the error
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +with details by creating a new issue.
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +If you would rather not post publicly, please contact us directly
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +using the support form.
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231015 13:32:54.136001 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +We appreciate your feedback.
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +HINT: You have encountered an unexpected error.
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +Please check the public issue tracker to check whether this problem is
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +already tracked. If you cannot find it there, please report the error
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +with details by creating a new issue.
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +If you would rather not post publicly, please contact us directly
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +using the support form.
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231015 13:32:54.136654 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 109, Name: fk, ConstraintID: 2}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[ForeignKeyConstraint:{DescID: 109, IndexID: 0, ConstraintID: 2, ReferencedDescID: 110}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
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"
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: schemachange/mixed-versions-compat failed #112380 roachtest: schemachange/mixed-versions-compat failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2 release-blocker]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-16T13:19:59Z

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

W231016 13:19:42.675456 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +with details by creating a new issue.
W231016 13:19:42.675456 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231016 13:19:42.675456 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +If you would rather not post publicly, please contact us directly
W231016 13:19:42.675456 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +using the support form.
W231016 13:19:42.675456 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231016 13:19:42.675456 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +We appreciate your feedback.
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: check_w, ConstraintID: 7}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 7}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +HINT: You have encountered an unexpected error.
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +Please check the public issue tracker to check whether this problem is
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +already tracked. If you cannot find it there, please report the error
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +with details by creating a new issue.
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +If you would rather not post publicly, please contact us directly
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +using the support form.
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231016 13:19:42.676382 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +We appreciate your feedback.
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +HINT: You have encountered an unexpected error.
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +Please check the public issue tracker to check whether this problem is
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +already tracked. If you cannot find it there, please report the error
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +with details by creating a new issue.
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +If you would rather not post publicly, please contact us directly
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +using the support form.
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231016 13:19:42.680038 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +We appreciate your feedback.
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +HINT: You have encountered an unexpected error.
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +Please check the public issue tracker to check whether this problem is
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +already tracked. If you cannot find it there, please report the error
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +with details by creating a new issue.
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +If you would rather not post publicly, please contact us directly
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +using the support form.
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231016 13:19:42.680653 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 109, Name: fk, ConstraintID: 2}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[ForeignKeyConstraint:{DescID: 109, IndexID: 0, ConstraintID: 2, ReferencedDescID: 110}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
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"
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: schemachange/mixed-versions-compat failed #112380 roachtest: schemachange/mixed-versions-compat failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2 release-blocker]

_{This test on roachdash | Improve this report!}

rafiss · 2023-10-16T15:29:14Z

This error appears ~100 times. They all reference check_crdb_internal_y_shard_2, so it seems like something is wrong with hash-sharded indexes.

W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57  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 [[ConstraintWithoutIndexName:{DescID: 142, Name: check_crdb_internal_y_shard_2, ConstraintID: 3}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 142, IndexID: 4, ConstraintID: 3}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +HINT: You have encountered an unexpected error.
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +Please check the public issue tracker to check whether this problem is
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +already tracked. If you cannot find it there, please report the error
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +with details by creating a new issue.
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +If you would rather not post publicly, please contact us directly
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +using the support form.
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +
W231016 13:19:18.490475 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 57 +We appreciate your feedback.

cockroach-teamcity · 2023-10-17T17:12:34Z

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

W231017 17:12:14.857713 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +with details by creating a new issue.
W231017 17:12:14.857713 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231017 17:12:14.857713 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +If you would rather not post publicly, please contact us directly
W231017 17:12:14.857713 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +using the support form.
W231017 17:12:14.857713 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231017 17:12:14.857713 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +We appreciate your feedback.
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: check_w, ConstraintID: 7}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 7}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +HINT: You have encountered an unexpected error.
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +Please check the public issue tracker to check whether this problem is
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +already tracked. If you cannot find it there, please report the error
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +with details by creating a new issue.
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +If you would rather not post publicly, please contact us directly
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +using the support form.
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231017 17:12:14.858646 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +We appreciate your feedback.
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +HINT: You have encountered an unexpected error.
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +Please check the public issue tracker to check whether this problem is
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +already tracked. If you cannot find it there, please report the error
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +with details by creating a new issue.
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +If you would rather not post publicly, please contact us directly
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +using the support form.
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231017 17:12:14.862272 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +We appreciate your feedback.
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +HINT: You have encountered an unexpected error.
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +Please check the public issue tracker to check whether this problem is
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +already tracked. If you cannot find it there, please report the error
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +with details by creating a new issue.
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +If you would rather not post publicly, please contact us directly
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +using the support form.
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231017 17:12:14.862893 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 109, Name: fk, ConstraintID: 2}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[ForeignKeyConstraint:{DescID: 109, IndexID: 0, ConstraintID: 2, ReferencedDescID: 110}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
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"
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: schemachange/mixed-versions-compat failed #112380 roachtest: schemachange/mixed-versions-compat failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2 release-blocker]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-18T17:50:22Z

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

W231018 17:50:07.053817 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +with details by creating a new issue.
W231018 17:50:07.053817 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231018 17:50:07.053817 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +If you would rather not post publicly, please contact us directly
W231018 17:50:07.053817 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +using the support form.
W231018 17:50:07.053817 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231018 17:50:07.053817 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +We appreciate your feedback.
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: check_w, ConstraintID: 7}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 7}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +HINT: You have encountered an unexpected error.
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +Please check the public issue tracker to check whether this problem is
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +already tracked. If you cannot find it there, please report the error
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +with details by creating a new issue.
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +If you would rather not post publicly, please contact us directly
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +using the support form.
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231018 17:50:07.054921 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +We appreciate your feedback.
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +HINT: You have encountered an unexpected error.
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +Please check the public issue tracker to check whether this problem is
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +already tracked. If you cannot find it there, please report the error
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +with details by creating a new issue.
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +If you would rather not post publicly, please contact us directly
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +using the support form.
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231018 17:50:07.059216 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +We appreciate your feedback.
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +HINT: You have encountered an unexpected error.
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +Please check the public issue tracker to check whether this problem is
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +already tracked. If you cannot find it there, please report the error
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +with details by creating a new issue.
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +If you would rather not post publicly, please contact us directly
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +using the support form.
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231018 17:50:07.060012 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 109, Name: fk, ConstraintID: 2}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[ForeignKeyConstraint:{DescID: 109, IndexID: 0, ConstraintID: 2, ReferencedDescID: 110}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
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"
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: schemachange/mixed-versions-compat failed #112380 roachtest: schemachange/mixed-versions-compat failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2]

_{This test on roachdash | Improve this report!}

112456: testcluster: clone Settings for each server r=RaduBerinde a=RaduBerinde #### testserver: unembed Settings, RaftConfig There is no reason these should be embedded. Epic: none Release note: None #### testcluster: clone Settings for each server Currently there are many tests where multi-node test clusters share the same `*Settings` object. This is problematic - on one hand, it can make some test failures very hard to debug, and on the other hand, we are missing out on testing more realistic scenarios where nodes in a cluster don't magically have their settings in sync. This change adds some test-only code to clone the Settings object. Fixes #112395 Release note: None 112623: scplan: Remove extra rule in `rule/release_23_1` directory r=Xiang-Gu a=Xiang-Gu We removed a few rule changes present in `rule/release_23_1` directory on master but not present in `rule/current` on `release-23.1` branch. It should have been excluded but was mistakenly added in PR #103349. Informs #112376 Release note: None Co-authored-by: Radu Berinde <[email protected]> Co-authored-by: Xiang Gu <[email protected]>

cockroach-teamcity · 2023-10-19T14:25:10Z

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

W231019 14:24:53.715879 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +with details by creating a new issue.
W231019 14:24:53.715879 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231019 14:24:53.715879 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +If you would rather not post publicly, please contact us directly
W231019 14:24:53.715879 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +using the support form.
W231019 14:24:53.715879 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +
W231019 14:24:53.715879 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 563 +We appreciate your feedback.
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: check_w, ConstraintID: 7}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 7}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +HINT: You have encountered an unexpected error.
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +Please check the public issue tracker to check whether this problem is
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +already tracked. If you cannot find it there, please report the error
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +with details by creating a new issue.
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +If you would rather not post publicly, please contact us directly
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +using the support form.
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +
W231019 14:24:53.716910 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 564 +We appreciate your feedback.
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +HINT: You have encountered an unexpected error.
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +Please check the public issue tracker to check whether this problem is
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +already tracked. If you cannot find it there, please report the error
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +with details by creating a new issue.
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +If you would rather not post publicly, please contact us directly
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +using the support form.
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +
W231019 14:24:53.720846 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 565 +We appreciate your feedback.
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566  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 [[ConstraintWithoutIndexName:{DescID: 118, Name: c, ConstraintID: 5}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[CheckConstraint:{DescID: 118, IndexID: 0, ConstraintID: 5}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +HINT: You have encountered an unexpected error.
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +Please check the public issue tracker to check whether this problem is
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +already tracked. If you cannot find it there, please report the error
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +with details by creating a new issue.
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +If you would rather not post publicly, please contact us directly
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +using the support form.
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +
W231019 14:24:53.721561 1 sql/schemachanger/scplan/internal/scstage/build.go:549  [-] 566 +We appreciate your feedback.
ERROR: building declarative schema changer plan in PostCommitNonRevertiblePhase (rollback=false) for ALTER TABLE: failed to satisfy [[ConstraintWithoutIndexName:{DescID: 109, Name: fk, ConstraintID: 2}, PUBLIC], PUBLIC] -dep-SameStagePrecedence-> [[ForeignKeyConstraint:{DescID: 109, IndexID: 0, ConstraintID: 2, ReferencedDescID: 110}, PUBLIC], PUBLIC] rule "constraint dependent public right before complex constraint"
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"
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: schemachange/mixed-versions-compat failed #112380 roachtest: schemachange/mixed-versions-compat failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-20T13:26:51Z

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

(mixed_version_decl_schemachange_compat.go:86).fetchCorpusToTmpDir: Missing validation corpus for release-24.1 (full command output in run_132638.960564998_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: schemachange/mixed-versions-compat failed #112380 roachtest: schemachange/mixed-versions-compat failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2]

_{This test on roachdash | Improve this report!}

rafiss · 2023-10-20T16:04:39Z

Copying @Xiang-Gu's observations:

The most recent failure suggests our corpus collection didn't have the corpus entry for 24.1

Missing validation corpus for release-24.1 (full command output in run_132638.960564998_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)

run_132638.960564998_n1_gsutil-cp-gscockroac: 13:26:38 cluster.go:2205: >  gsutil cp gs://cockroach-corpus/corpus-release-24.1/corpus /tmp/corpus4032418785/corpus
CommandException: No URLs matched: gs://cockroach-corpus/corpus-release-24.1/corpus
run_132638.960564998_n1_gsutil-cp-gscockroac: 13:26:40 cluster.go:2212: > result: COMMAND_PROBLEM: exit status 1

rafiss · 2023-10-20T16:05:26Z

That's probably since #112271 just bumped the version to 24.1

cockroach-teamcity · 2023-10-21T14:01:29Z

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

(mixed_version_decl_schemachange_compat.go:86).fetchCorpusToTmpDir: Missing validation corpus for release-24.1 (full command output in run_140116.354927228_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-22T14:09:26Z

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

(mixed_version_decl_schemachange_compat.go:86).fetchCorpusToTmpDir: Missing validation corpus for release-24.1 (full command output in run_140913.912976921_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-23T16:17:15Z

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

(mixed_version_decl_schemachange_compat.go:86).fetchCorpusToTmpDir: Missing validation corpus for release-24.1 (full command output in run_161702.472202157_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-24T19:46:05Z

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

(mixed_version_decl_schemachange_compat.go:86).fetchCorpusToTmpDir: Missing validation corpus for release-24.1 (full command output in run_194553.999072734_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2023-10-25T14:34:36Z

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

(mixed_version_decl_schemachange_compat.go:86).fetchCorpusToTmpDir: Missing validation corpus for release-24.1 (full command output in run_143424.182754117_n1_gsutil-cp-gscockroac.log: COMMAND_PROBLEM: exit status 1)
test artifacts and logs in: /artifacts/schemachange/mixed-versions-compat/run_1

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity added this to the 23.2 milestone Oct 14, 2023

cockroach-teamcity mentioned this issue Oct 14, 2023

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

Closed

exalate-issue-sync bot assigned Xiang-Gu Oct 16, 2023

Xiang-Gu mentioned this issue Oct 18, 2023

scplan: extra rule changes mistakenly present in rule/release_23_1 #112610

Closed

rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Oct 18, 2023

Xiang-Gu mentioned this issue Oct 18, 2023

scplan: Remove extra rule in rule/release_23_1 directory #112623

Merged

blathers-crl bot mentioned this issue Oct 18, 2023

release-23.2: scplan: Remove extra rule in rule/release_23_1 directory #112638

Merged

Xiang-Gu mentioned this issue Oct 24, 2023

tests: Fix a bug in schemachange/mixed-versions-compat where corpus is not found #112989

Merged

rafiss mentioned this issue Oct 24, 2023

scplan: create scplan/internal/rules/release_23_2 #112571

Closed

craig bot closed this as completed in d482162 Oct 25, 2023

github-project-automation bot added this to SQL Foundations Aug 28, 2024

github-project-automation bot moved this to Done in SQL Foundations Aug 28, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

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

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

cockroach-teamcity commented Oct 14, 2023 •

edited by cockroach-jira-scripts

Loading

cockroach-teamcity commented Oct 15, 2023

cockroach-teamcity commented Oct 16, 2023

rafiss commented Oct 16, 2023

cockroach-teamcity commented Oct 17, 2023

cockroach-teamcity commented Oct 18, 2023

cockroach-teamcity commented Oct 19, 2023

cockroach-teamcity commented Oct 20, 2023

rafiss commented Oct 20, 2023

rafiss commented Oct 20, 2023

cockroach-teamcity commented Oct 21, 2023

cockroach-teamcity commented Oct 22, 2023

cockroach-teamcity commented Oct 23, 2023

cockroach-teamcity commented Oct 24, 2023

cockroach-teamcity commented Oct 25, 2023

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

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

Comments

cockroach-teamcity commented Oct 14, 2023 • edited by cockroach-jira-scripts Loading

cockroach-teamcity commented Oct 15, 2023

cockroach-teamcity commented Oct 16, 2023

rafiss commented Oct 16, 2023

cockroach-teamcity commented Oct 17, 2023

cockroach-teamcity commented Oct 18, 2023

cockroach-teamcity commented Oct 19, 2023

cockroach-teamcity commented Oct 20, 2023

rafiss commented Oct 20, 2023

rafiss commented Oct 20, 2023

cockroach-teamcity commented Oct 21, 2023

cockroach-teamcity commented Oct 22, 2023

cockroach-teamcity commented Oct 23, 2023

cockroach-teamcity commented Oct 24, 2023

cockroach-teamcity commented Oct 25, 2023

cockroach-teamcity commented Oct 14, 2023 •

edited by cockroach-jira-scripts

Loading