roachtest: schemachange/mixed-versions failed

[cockroach-teamcity]

roachtest.schemachange/mixed-versions failed with artifacts on release-24.1 @ da6b956705c73568e810461d85ae47aaad728829:

(mixedversion.go:594).Run: mixed-version test failure while running step 12 (run "run schemachange workload and validation in mixed version"): full command output in run_063135.484793627_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_metamorphicBuild=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 [attempting to append refresh spans after the tracked timestamp has moved forward] #125379 roachtest: schemachange/mixed-versions failed [attempting to append refresh spans after the tracked timestamp has moved forward] [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.2]
• roachtest: schemachange/mixed-versions failed [debug doctor validation: existing descriptors that still need to be dropped] #124722 roachtest: schemachange/mixed-versions failed [debug doctor validation: existing descriptors that still need to be dropped] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1.22-rc]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-39529

[rafiss]

{
 "workerId": 2,
 "clientTimestamp": "06:32:12.255194",
 "ops": [
  "BEGIN",
  {
   "sql": "CREATE FUNCTION udf_w2_281()\n\tRETURNS VOID\n\tLANGUAGE SQL\n\tAS $$ SELECT 'dasdda'::schema_w4_14.enum_w4_49 $$",
   "expectedExecErr": "22023"
  }
 ],
 "expectedExecErrors": "22023",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: enum value \"dasdda\" is not yet public (SQLSTATE XXUUU)",
 "errorState": {

We need to make sure the workload only chooses enum values that are public.