roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed

[cockroach-teamcity]

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on 63484 @ 9b95b03141aa58a2efe55404ff0bb7714b1999c2:

		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "21:44:18.564647",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER INDEX public.table9752@\"index9752_10483\" RENAME TO \"index9752_10484\""
		  |  ],
		  |  "expectedExecErrors": "42704",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: index \"index9752_10483\" does not exist (SQLSTATE 42704)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "21:44:18.938475",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum4199 AS ENUM ('sa', 'da', 'a')"
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: type \"schemachange.public.enum4199\" already exists (SQLSTATE 42710)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "21:44:18.688954",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table10485 ALTER COLUMN IrrelevantColumnName SET DATA TYPE IrrelevantDataType"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table10485\" does not exist (SQLSTATE 42P01)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "21:44:19.012454",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table9160 ALTER COLUMN \"col9160_9175\" SET DATA TYPE CHAR"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: ALTER COLUMN TYPE from string to char is only supported experimentally (SQLSTATE 0A000)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *main.withCommandDetails (4) *exec.ExitError

Reproduce

To reproduce, try:

# From https://go.crdb.dev/p/roachstress, perhaps edited lightly.
caffeinate ./roachstress.sh scbench/randomload/nodes=3/ops=10000/conc=20

Same failure on other branches

• roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed #63373 roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed [C-test-failure O-roachtest O-robot branch-release-20.2 release-blocker]
• roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed #61688 roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed [C-test-failure O-roachtest O-robot branch-release-21.1]
• roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed #56230 roachtest: scbench/randomload/nodes=3/ops=10000/conc=20 failed [C-test-failure O-roachtest O-robot branch-master]

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

Jira issue: CRDB-6629