roachtest: schemachange/random-load failed [workload chooses enum that is being dropped]

[cockroach-teamcity]

roachtest.schemachange/random-load failed with artifacts on release-23.2 @ 92084b5138e421e0a3b45bb63c5fcf13f7ffe324:

(schemachange_random_load.go:122).runSchemaChangeRandomLoad: full command output in run_183541.396154317_n1_workload-run-schemac.log: COMMAND_PROBLEM: exit status 1
test artifacts and logs in: /artifacts/schemachange/random-load/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=true
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: schemachange/random-load failed [using NaN values does not work for unique constraints] #120771 roachtest: schemachange/random-load failed [using NaN values does not work for unique constraints] [C-test-failure O-roachtest O-robot P-2 T-sql-foundations X-noreuse branch-master]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38735

[rafiss]

there are 2 concurrent transactions:

{
 "workerId": 9,
 "clientTimestamp": "18:36:48.932602",
 "ops": [
  "BEGIN",
  {
   "sql": "DROP SCHEMA \"schema848\" CASCADE"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "unexpected EOF"
}

 "ops": [
  "BEGIN",
  {
   "sql": "DROP SEQUENCE IF EXISTS schema848.seq905"
  },
  {
   "sql": "SELECT t1.col906_907 AS col0,t1.col906_907 AS col1,t0.col906_908 AS col2,t0.col906_907 AS col3 FROM schema848.table906 AS t0 ,schema848.table906 AS t1  FETCH FIRST 1 ROWS ONLY",
   "potentialExecErr": "53100,53200,57014"
  },
  {
   "sql": "DROP TABLE schema848.table906 CASCADE"
  },
  {
   "sql": "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()"
  },
  {
   "sql": "ALTER TYPE schema848.enum909 DROP VALUE 'adds'"
  },
  "COMMIT"
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED COMMIT ERROR; Received an unexpected commit error: ERROR: transaction committed but schema change aborted with error: (XXUUU): descriptor is being dropped (SQLSTATE XXUUU)",
 "errorState": {

we should fix this by making sure the workload does not pick an enum type that is currently being dropped.