search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.86k stars 3.77k forks source link

roachtest: schemachange/mixed-versions failed [computed column cannot also have DEFAULT] #126883

Closed cockroach-teamcity closed 2 weeks ago

cockroach-teamcity commented 2 months ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 0d324e80b3fbe2cebfb7e27f0d0dd8621cf45c8c:

(mixedversion.go:620).Run: mixed-version test failure while running step 7 (run "run schemachange workload and validation in mixed version"): full command output in run_061913.647393528_n4_COCKROACHRANDOMSEED1.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126882 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.1.2-rc release-blocker] - #126784 roachtest: schemachange/mixed-versions failed [descriptor ID generator unavailable, migration in progress, retry later] [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1] - #126374 roachtest: schemachange/mixed-versions failed [existing descriptors that still need to be dropped] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #125379 roachtest: schemachange/mixed-versions failed [attempting to append refresh spans after the tracked timestamp has moved forward] [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.2]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-40168

rafiss commented 2 months ago 
{
 "workerId": 1,
 "clientTimestamp": "06:19:20.645467",
 "ops": [
  "BEGIN",
  {
   "sql": "ALTER TABLE schema_w0_23.table_w0_31 ADD CONSTRAINT \"table_w0_31_c%ol31_w0_38_table_w0_31_col31_w0_35_fk\" FOREIGN KEY (col31_w0_35) REFERENCES schema_w0_23.table_w0_31 (\"c%ol31_w0_38\") ON DELETE CASCADE ON UPDATE CASCADE",
   "expectedExecErr": "23503",
   "potentialExecErr": "23503"
  }
 ],
 "expectedExecErrors": "23503",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)",

there's a concurrent insert around the same time that could be related

{
 "workerId": 3,
 "clientTimestamp": "06:19:20.541274",
 "ops": [
  "BEGIN",
  {
   "sql": "ALTER SEQUENCE schema_w4_16.seq_w0_43 RENAME TO schema_w4_16.seq_w3_32"
  },
  {
   "sql": "INSERT INTO schema_w0_23.table_w0_31 (col̬31_w0_32,col31_w0_33,col31_w0_34,col31_w0_35,col31_w0_36,col31_w0_37,\"c%ol31_w0_38\",col31_w0_39,\"col3 1'_w0_40\",\"Col' \\\\U000B19DE31_w0_41\") VALUES (73896.55440221963076:::DECIMAL,'11:54:42.201891-10:20':::TIMETZ,1266:::OID,e'\\rKV{9\\rI':::REFCURSOR,1.1548348665237427:::FLOAT8,'274d:8919:1a43:f8ad:da9a:bdd:fada:fcff/62':::INET,e'}\\x10':::REFCURSOR,3802:::OID,(-48):::INT8,'1974-04-23':::DATE),((-2.830802057006195896E+25):::DECIMAL,'24:00:00-15:59':::TIMETZ,3615:::OID,'+':::REFCURSOR,(-2.2279863357543945):::FLOAT8,'122.40.214.194/30':::INET,e'wEy\\x0fo':::REFCURSOR,3220:::OID,(-74):::INT8,'1987-06-06':::DATE)"
  },
cockroach-teamcity commented 1 month ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ dba532e47f9da689cc9103ee3f08b192998559b6:

(mixedversion.go:620).Run: mixed-version test failure while running step 24 (run "run schemachange workload and validation after upgrade has finalized"): full command output in run_061535.850730348_n4_cockroach-debug-doct.log: COMMAND_PROBLEM: exit status 125
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #126374 roachtest: schemachange/mixed-versions failed [existing descriptors that still need to be dropped] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #125379 roachtest: schemachange/mixed-versions failed [attempting to append refresh spans after the tracked timestamp has moved forward] [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 4 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 452463c77ca8027562283f9cb4e2a140ddeed0ff:

(mixedversion.go:694).Run: mixed-version test failure while running step 6 (run "run schemachange workload and validation in mixed version"): full command output in run_103410.115946393_n4_COCKROACHRANDOMSEED8.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #128654 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master] - #128438 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1 release-blocker] - #128093 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 452463c77ca8027562283f9cb4e2a140ddeed0ff:

(mixedversion.go:694).Run: mixed-version test failure while running step 8 (run "run schemachange workload and validation in mixed version"): full command output in run_065339.020074801_n4_COCKROACHRANDOMSEED1.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #128654 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master] - #128438 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1 release-blocker] - #128093 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ a905886cb93df55c90bbaeacb1d563b704f50b59:

(mixedversion.go:694).Run: mixed-version test failure while running step 7 (run "run schemachange workload and validation in mixed version"): full command output in run_070142.674897145_n4_COCKROACHRANDOMSEED4.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #128947 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.1.4-rc release-blocker] - #128946 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker] - #128093 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ 957fad03d6876049dc0faef2217858e5ea92f5ca:

(mixedversion.go:694).Run: mixed-version test failure while running step 13 (run "run schemachange workload and validation in mixed version"): full command output in run_085906.939769521_n4_COCKROACHRANDOMSEED2.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #129104 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.10-rc release-blocker] - #128947 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.1.4-rc] - #128946 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master] - #128093 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ c977778dc8419323431a990baf3d702db4fd584b:

(mixedversion.go:694).Run: mixed-version test failure while running step 15 (run "run schemachange workload and validation in mixed version"): full command output in run_084454.240915744_n4_COCKROACHRANDOMSEED4.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #129163 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker] - #129160 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1 release-blocker] - #129104 roachtest: schemachange/mixed-versions failed [pg_lsn in mixed version] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-23.2.10-rc] - #128947 roachtest: schemachange/mixed-versions failed [computed column cannot also have DEFAULT] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1.4-rc] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

rafiss commented 3 weeks ago 
{
 "workerId": 4,
 "clientTimestamp": "08:59:17.82389",
 "ops": [
  "BEGIN",
  {
   "sql": "ALTER TABLE schema_w1_179.table_w2_402 ALTER COLUMN \"col402_w2_415\" SET DEFAULT '':::STRING",
   "expectedExecErr": "42601"
  }
 ],
 "expectedExecErrors": "42601",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: relation \"table_w2_402\" (391): computed column \"col402_w2_415\" cannot also have a DEFAULT expression (SQLSTATE 42P16)",
 "errorState": {
  "expectedErrors": [
   "42601"
  ],
cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ c977778dc8419323431a990baf3d702db4fd584b:

(mixedversion.go:694).Run: mixed-version test failure while running step 7 (run "run schemachange workload and validation in mixed version"): full command output in run_074715.423726650_n4_COCKROACHRANDOMSEED8.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #129185 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2 release-blocker] - #129163 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker] - #129160 roachtest: schemachange/mixed-versions failed [count-leases: column "crdb_region" does not exist] [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1] - #129104 roachtest: schemachange/mixed-versions failed [pg_lsn in mixed version] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-23.2.10-rc] - #128947 roachtest: schemachange/mixed-versions failed [computed column cannot also have DEFAULT] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1.4-rc] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ c977778dc8419323431a990baf3d702db4fd584b:

(mixedversion.go:694).Run: mixed-version test failure while running step 9 (run "run schemachange workload and validation in mixed version"): full command output in run_084024.696923684_n4_COCKROACHRANDOMSEED3.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #129185 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2 release-blocker] - #129163 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker] - #129160 roachtest: schemachange/mixed-versions failed [count-leases: column "crdb_region" does not exist] [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.1] - #129104 roachtest: schemachange/mixed-versions failed [pg_lsn in mixed version] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-23.2.10-rc] - #128947 roachtest: schemachange/mixed-versions failed [computed column cannot also have DEFAULT] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1.4-rc] - #127320 roachtest: schemachange/mixed-versions failed [unexpected unique constraint violation] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2]

This test on roachdash | Improve this report!

rafiss commented 2 weeks ago

resolved by https://github.com/cockroachdb/cockroach/pull/129177