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

roachtest: schemachange/mixed-versions failed [don't use refcursor in mixed version state] #130545

Open cockroach-teamcity opened 1 week ago

cockroach-teamcity commented 1 week ago

roachtest.schemachange/mixed-versions failed with artifacts on release-23.2 @ 5b748c4b447d3fbf6e342b6c14a9a81133489e1b:

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

- #130278 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.2] - #129535 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.2.1-rc] - #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]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-42115

cockroach-teamcity commented 5 days ago

roachtest.schemachange/mixed-versions failed with artifacts on release-23.2 @ 52d7f3db720359153214894c6dd3b4f96bd8be6b:

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

- #130278 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.2] - #129535 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.2.1-rc] - #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]

This test on roachdash | Improve this report!

rafiss commented 1 day ago 
  |   ],
  |   "previousStatements": [
  |    "ALTER TABLE public.table1588 ALTER COLUMN \"col15\u000c88_1589\" SET DEFAULT 'K':::REFCURSOR"
  |   ]
  |  }
  | }
  |
  | stderr:I240912 06:15:25.428125 1 workload/cli/run.go:431  [-] 1  creating load generator...
  | I240912 06:15:25.553544 1 workload/cli/run.go:470  [-] 2  creating load generator... done (took 125.418429ms)
  | Error: ***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: type "refcursor" does not exist (SQLSTATE 42704)
rafiss commented 1 day ago

Similar to https://github.com/cockroachdb/cockroach/pull/128941, we need to block the refcursor type in ALTER COLUMN SET DEFAULT.