roachtest: schemachange/mixed-versions failed

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on master @ 8eeb7f2ae3b2cede564b46ca47e2353fd147c061:

(mixedversion.go:759).Run: mixed-version test failure while running step 19 (run "run schemachange workload and validation in mixed version"): full command output in run_084426.794522807_n4_COCKROACHRANDOMSEED2.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/cpu_arch=arm64/run_1

Parameters:

• arch=arm64
• cloud=azure
• coverageBuild=false
• cpu=4
• encrypted=false
• mvtDeploymentMode=shared-process
• mvtVersions=v24.2.4 → master
• runtimeAssertionsBuild=false
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for azure clusters

Same failure on other branches

- #134636 roachtest: schemachange/mixed-versions failed [function does not exist] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations branch-release-24.2.5-rc]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-44717

[rafiss]

Error:

{
 "workerId": 2,
 "clientTimestamp": "08:44:36.985219",
 "ops": [
  "BEGIN",
  {
   "sql": "ALTER FUNCTION schema_w1_71.udf_w1_422(public._enum_w1_141, public.enum_w1_141, schema_w1_1._enum_w2_33, schema_w1_1.enum_w2_33, schema_w3_19._composite_w0_84, schema_w3_19._composite_w1_53, \"char\", BOOL, BOX2D, BPCHAR, BYTES, STRING, DATE, DECIMAL, FLOAT8, GEOGRAPHY, GEOMETRY, INET, INT8, INT2) SET SCHEMA schema_w2_411"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: function udf_w1_422(enum_w1_141[],enum_w1_141,enum_w2_33[],enum_w2_33,composite_w0_84[],composite_w1_53[],\"char\",bool,box2d,char,bytes,string,date,decimal,float,geography,geometry,inet,int,int2) does not exist (SQLSTATE 42883)",

This test is using these versions:

[mixed-version-test] 2024/11/20 08:40:23 mixedversion.go:751: mixed-version test:
Seed:               -1667707174599514253
Upgrades:           v24.2.4 → master

The related fix (https://github.com/cockroachdb/cockroach/pull/130889) first appears in v24.2.5, which was just released. Once https://github.com/cockroachdb/cockroach/pull/135608 is merged, this mixed version test will use v24.2.5 and should not encounter this issue.

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on master @ cea3ff5562160a3bf2802da052da2aaa40e1ccc1:

(mixedversion.go:759).Run: mixed-version test failure while running step 16 (run "run schemachange workload and validation in mixed version"): full command output in run_093947.940480256_n4_COCKROACHRANDOMSEED1.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

• arch=amd64
• cloud=azure
• coverageBuild=false
• cpu=4
• encrypted=false
• mvtDeploymentMode=shared-process
• mvtVersions=v24.2.4 → master
• runtimeAssertionsBuild=false
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

Grafana is not yet available for azure clusters

Same failure on other branches

- #136065 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.3.0-rc release-blocker] - #134636 roachtest: schemachange/mixed-versions failed [function does not exist] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations]

This test on roachdash | Improve this report!

[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 master @ f717f6bd218121bb5e3376af658545f6bff30c22:

(mixedversion.go:759).Run: mixed-version test failure while running step 17 (run "run schemachange workload and validation in mixed version"): full command output in run_095949.472606119_n4_COCKROACHRANDOMSEED6.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/mixed-versions/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• mvtDeploymentMode=system-only
• mvtVersions=v24.2.4 → master
• runtimeAssertionsBuild=true
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #136065 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.3.0-rc release-blocker] - #134636 roachtest: schemachange/mixed-versions failed [function does not exist] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations]

This test on roachdash | Improve this report!

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on master @ f717f6bd218121bb5e3376af658545f6bff30c22:

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

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• mvtDeploymentMode=separate-process
• mvtVersions=v24.2.4 → master
• runtimeAssertionsBuild=false
• ssd=0
  Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

- #136065 roachtest: schemachange/mixed-versions failed [B-runtime-assertions-enabled C-test-failure O-roachtest O-robot T-sql-foundations branch-release-24.3.0-rc release-blocker] - #134636 roachtest: schemachange/mixed-versions failed [function does not exist] [C-test-failure O-roachtest O-robot P-3 T-sql-foundations]

This test on roachdash | Improve this report!