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.89k stars 3.77k forks source link

roachtest: schemachange/mixed-versions failed #129535

Open cockroach-teamcity opened 3 weeks ago

cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ 23a8ffc28d2f31eef0cd13eca69693dc249d1196:

(mixedversion.go:695).Run: mixed-version test failure while running step 20 (run "run schemachange workload and validation in mixed version"): full command output in run_062611.498760039_n4_COCKROACHRANDOMSEED4.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/cpu_arch=arm64/run_1

Parameters:

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #129460 roachtest: schemachange/mixed-versions failed ["show cluster setting version" timed out: value differs between local setting and KV] [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.2 release-blocker] - #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-41578

cockroach-teamcity commented 3 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ ae8318c64466e8a9d5908a1c99df29c0424e70be:

(mixedversion.go:695).Run: mixed-version test failure while running step 20 (run "run schemachange workload and validation in mixed version"): full command output in run_070915.227025889_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

- #129460 roachtest: schemachange/mixed-versions failed ["show cluster setting version" timed out: value differs between local setting and KV] [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.2 release-blocker] - #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot T-sql-foundations branch-master release-blocker] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!

rafiss commented 3 weeks ago

second failure is

{
 "workerId": 0,
 "clientTimestamp": "07:09:34.37874",
 "ops": [
  "BEGIN",
  {
   "sql": "ALTER TABLE schema_w0_251.table_w2_216 ALTER COLUMN \"co😫l216_w2_224\" DROP DEFAULT",
   "expectedExecErr": "42601"
  }
 ],
 "expectedExecErrors": "42601",
 "expectedCommitErrors": "",
 "message": "***FAIL; Failed to receive an execution error when errors were expected",
 "errorState": {
  "expectedErrors": [
   "42601"
  ],

this will be resolved by https://github.com/cockroachdb/cockroach/pull/129249, which is not on this branch.


the first failure is

E240823 06:28:18.256125 1 workload/cli/run.go:591  [-] 3  ***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: operation "show cluster setting version" timed out after 2m0.001s (given timeout 2m0s): value differs between local setting (24.2-upgrading-step--01) and KV (24.1-upgrading-to-24.2-step-012) (SQLSTATE XXUUU)

this will be resolved by https://github.com/cockroachdb/cockroach/pull/129520

cockroach-teamcity commented 2 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ 41ff1f4fcbf6cd934b49c24a47a98be1f909e3e3:

(mixedversion.go:695).Run: mixed-version test failure while running step 12 (run "run schemachange workload and validation in mixed version"): full command output in run_070756.759912699_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

- #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ 41ff1f4fcbf6cd934b49c24a47a98be1f909e3e3:

(mixedversion.go:695).Run: mixed-version test failure while running step 19 (run "run schemachange workload and validation in mixed version"): full command output in run_071331.117678670_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

- #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ 41ff1f4fcbf6cd934b49c24a47a98be1f909e3e3:

(mixedversion.go:695).Run: mixed-version test failure while running step 17 (run "run schemachange workload and validation in mixed version"): full command output in run_070917.325637538_n4_COCKROACHRANDOMSEED7.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

- #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 weeks ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ b95f17a1ddc0676a7cd64c1a0e3415cd85c221ba:

(mixedversion.go:695).Run: mixed-version test failure while running step 13 (run "run schemachange workload and validation in mixed version"): full command output in run_070743.013849492_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

- #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 week ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ 95e6fb913c83be95110e0a250bcc75bbe863c8b1:

(mixedversion.go:695).Run: mixed-version test failure while running step 13 (run "run schemachange workload and validation in mixed version"): full command output in run_070430.323418083_n4_COCKROACHRANDOMSEED6.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

- #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 week ago

roachtest.schemachange/mixed-versions failed with artifacts on release-24.2.1-rc @ 95e6fb913c83be95110e0a250bcc75bbe863c8b1:

(mixedversion.go:695).Run: mixed-version test failure while running step 13 (run "run schemachange workload and validation in mixed version"): full command output in run_062315.399749722_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

- #129395 roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-master] - #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #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]

This test on roachdash | Improve this report!