Closed cockroach-teamcity closed 50 minutes ago
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
See: roachtest README
See: How To Investigate (internal)
See: Grafana
- #132815 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.13-rc release-blocker] - #131335 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1] - #131162 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-master] - #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] - #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] - #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]
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
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:
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
- #132815 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.13-rc release-blocker] - #131335 roachtest: schemachange/mixed-versions failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-24.1] - #131162 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-master] - #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] - #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] - #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