rafiss
commented
3 weeks ago {
"workerId": 4,
"clientTimestamp": "09:10:53.727297",
"ops": [
"BEGIN",
{
"sql": "CREATE INDEX index_w0_112_w4_613 ON public.table_w0_112 (col112_w0_116, col112_w0_114, \"co\tl1̏12 _w0_113\") STORING (\"co\\\\U0000B125l112_w0_115\", \"co'l112_w0_117\", col11😮2_w0_118)",
"expectedExecErr": "42701"
}
],
"expectedExecErrors": "42701",
"expectedCommitErrors": "",
"message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: error executing StatementPhase stage 1 of 1 with 15 MutationType ops: relation \"table_w0_112\" (253): index \"index_w0_112_w4_613\" contains stored column \"\" with unknown ID 0 (SQLSTATE XXUUU)",
"errorState": {
"expectedErrors": [
"42701"
],table definition is
"sql": "CREATE TABLE IF NOT EXISTS public.table_w0_112 (\"co\tl1Ì12 _w0_113\" STRING COLLATE en_US NOT NULL, col112_w0_114 JSONB NOT NULL, \"co\\\\U0000B125l112_w0_115\" STRING COLLATE en_US NOT NULL, col112_w0_116 CHAR, \"co'l112_w0_117\" NAME NULL, col11😮2_w0_118 STRING NOT NULL AS (lower(CAST(\"co\\\\U0000B125l112_w0_115\" AS STRING))) STORED, PRIMARY KEY (\"co\\\\U0000B125l112_w0_115\" ASC), INVERTED INDEX (col112_w0_116, \"co\\\\U0000B125l112_w0_115\", col11😮2_w0_118 gin_trgm_ops ASC), INDEX (\"co\tl1Ì12 _w0_113\" DESC), INDEX (col112_w0_114 ASC), UNIQUE (col11😮2_w0_118, col112_w0_114 DESC), INDEX (col11😮2_w0_118 DESC) VISIBILITY 0.06, INDEX (\"co\\\\U0000B125l112_w0_115\" DESC, col112_w0_116 ASC, lower(CAST(\"co\tl1Ì12 _w0_113\" AS STRING)) DESC), UNIQUE (col11😮2_w0_118 DESC) STORING (\"co\tl1Ì12 _w0_113\", col112_w0_114, \"co'l112_w0_117\"), INDEX (col11😮2_w0_118 DESC), UNIQUE (lower(col112_w0_116)))"fixed by https://github.com/cockroachdb/cockroach/pull/128240, but that doesn't yet appear in a 24.2 release, so this mixed-version test is hitting the old buggy behavior.
cockroach-teamcity
roachtest.schemachange/mixed-versions failed with artifacts on master @ f1a5aa8a633636138fededdf46a8dcc20f899a48:
Parameters:
ROACHTEST_arch=amd64ROACHTEST_cloud=gceROACHTEST_coverageBuild=falseROACHTEST_cpu=4ROACHTEST_encrypted=falseROACHTEST_metamorphicBuild=falseROACHTEST_ssd=0Help
See: roachtest README
See: How To Investigate (internal)
See: Grafana
Same failure on other branches
- #129308 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.1.4-rc] - #129303 roachtest: schemachange/mixed-versions failed [computed column cannot reference a foreign key] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.2] - #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-41520