roachtest: schemachange/mixed-versions failed

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.schemachange/mixed-versions failed with artifacts on release-24.3 @ b2d2353b876af1748607e155ecdfed9d4bba29d3:

(mixedversion.go:732).Run: mixed-version test failure while running step 12 (run "run schemachange workload and validation in mixed version"): full command output in run_112812.421068293_n4_COCKROACHRANDOMSEED7.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_runtimeAssertionsBuild=true
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/mixed-versions failed [use REFCURSOR prior to 23.2] #132815 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.13-rc release-blocker]
• roachtest: schemachange/mixed-versions failed #131335 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1]
• roachtest: schemachange/mixed-versions failed #131162 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-master]
• roachtest: schemachange/mixed-versions failed [don't use refcursor in mixed version state] #130545 roachtest: schemachange/mixed-versions failed [don't use refcursor in mixed version state] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2]
• roachtest: schemachange/mixed-versions failed [computed column cannot reference a foreign key] #130278 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]
• roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] #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]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-43432

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on release-24.3 @ 330f659a3f244d1386bb86c89a258d2da6063959:

(mixedversion.go:732).Run: mixed-version test failure while running step 28 (run "run schemachange workload and validation after upgrade has finalized"): full command output in run_092729.140543695_n4_COCKROACHRANDOMSEED6.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_runtimeAssertionsBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/mixed-versions failed [use REFCURSOR prior to 23.2] #132815 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.13-rc release-blocker]
• roachtest: schemachange/mixed-versions failed #131335 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1]
• roachtest: schemachange/mixed-versions failed #131162 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-master]
• roachtest: schemachange/mixed-versions failed [don't use refcursor in mixed version state] #130545 roachtest: schemachange/mixed-versions failed [don't use refcursor in mixed version state] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2]
• roachtest: schemachange/mixed-versions failed [computed column cannot reference a foreign key] #130278 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]
• roachtest: schemachange/mixed-versions failed [index contains stored column "" with unknown ID 0] #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]

This test on roachdash | Improve this report!

[spilchen]

Here is the failure:

 "ops": [
  "BEGIN",
  {
   "sql": "ALTER SEQUENCE schema_w0_73.seq_w1_159 RENAME TO schema_w0_73.seq_w4_251"
  },
  {
   "sql": "ALTER FUNCTION public.udf_w1_161(public.composite_w1_8, public._composite_w1_8, schema_w1_17.composite_w4_73, schema_w1_17._composite_w4_73, schema_w2_3.enum_w4_85, schema_w2_3._enum_w4_85, \"char\", BIT, BOOL, BOX2D, BPCHAR, BYTES, STRING, DATE, DECIMAL, FLOAT8, GEOGRAPHY, GEOMETRY, INET, INT8, INT2, INT2VECTOR, INT8, INTERVAL, JSONB, NAME, OIDVECTOR, PG_LSN, REFCURSOR, STRING, TIME, TIMESTAMP, TIMESTAMPTZ, TIMETZ, TSQUERY, TSVECTOR, UUID, VARBIT, VARCHAR) SET SCHEMA schema_w2_3"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: function udf_w1_161(composite_w1_8,composite_w1_8[],composite_w4_73,composite_w4_73[],enum_w4_85,enum_w4_85[],\"char\",bit,bool,box2d,char,bytes,string,date,decimal,float,geography,geometry,inet,int,int2,int2vector,int,interval,jsonb,name,oidvector,pg_lsn,refcursor,string,time,timestamp,timestamptz,timetz,tsquery,tsvector,uuid,varbit,varchar) does not exist (SQLSTATE 42883)",

Closing this as a duplicate of #133016