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

[cockroach-teamcity]

(roachtest).scbench/randomload/nodes=3/ops=10000/conc=20 failed on 56248@41a457fe4371268763d832bbc7b6182b24ef0c6c:

		  | I201110 18:16:41.697540 1 workload/cli/run.go:387  creating load generator... done (took 81.054385ms)
		  | Error: ***UNEXPECTED ERROR: ERROR: descriptor is being dropped (SQLSTATE XXUUU)
		  | Error: COMMAND_PROBLEM: exit status 1
		  | (1) COMMAND_PROBLEM
		  | Wraps: (2) Node 1. Command with error:
		  |   | ```
		  |   | ./workload run schemachange --verbose=1 --tolerate-errors=false  --histograms=perf/stats.json --max-ops 10000 --concurrency 20
		  |   | ```
		  | Wraps: (3) exit status 1
		  | Error types: (1) errors.Cmd (2) *hintdetail.withDetail (3) *exec.ExitError
		  |
		  | stdout:
		  | <... some data truncated by circular buffer; go to artifacts for details ...>
		  | ), col202_7 REGPROCEDURE NULL, col202_8 BOX2D NOT NULL, col202_9 BOX2D NOT NULL, col202_10 INT4 NOT NULL, col202_11 OID NOT NULL, col202_12 BIT(16), col202_13 TIMESTAMP NULL, UNIQUE (col202_2 DESC, col202_3 ASC, col202_8 ASC, col202_10 DESC, col202_6 ASC, col202_0, col202_12 DESC, col202_5 DESC, col202_4 ASC) STORING (col202_7, col202_11), FAMILY (col202_0), FAMILY (col202_5, col202_11, col202_7, col202_3, col202_6, col202_2, col202_12, col202_4, col202_8, col202_13, col202_1), FAMILY (col202_10), FAMILY (col202_9));
		  |   CREATE TABLE IF NOT EXISTS public.table206 (col206_0 CHAR, col206_1 TIMESTAMP, col206_2 INTERVAL NOT NULL, col206_3 REGPROCEDURE NOT NULL, col206_4 TIME NOT NULL, col206_5 INT4 NOT NULL, col206_6 REGTYPE NULL, col206_7 UUID, col206_8 UUID, col206_9 OID, col206_10 UUID NULL, col206_11 "char" NOT NULL, col206_12 REGTYPE, col206_13 REGNAMESPACE, PRIMARY KEY (col206_4, col206_11 ASC), INDEX (col206_5 DESC, col206_9 DESC), UNIQUE (col206_8, col206_2 DESC, col206_3 ASC, col206_5 DESC, col206_13, col206_0 DESC, col206_9 ASC, col206_6, col206_11 ASC, col206_12, col206_1 ASC), INDEX (col206_8, col206_12 ASC, col206_6 DESC, col206_3 ASC, col206_13 DESC), INDEX (col206_11, col206_10, col206_1, col206_9 DESC, col206_7 ASC) STORING (col206_0, col206_5, col206_12, col206_13));
		  |   DROP SCHEMA "schema93" CASCADE;
		  | COMMIT;  ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=4a50dde0 key=/Table/SystemConfigSpan/Start pri=0.05264143 epo=0 ts=1605032205.522042406,1 min=1605032204.836677254,0 seq=31} lock=true stat=PENDING rts=1605032204.836677254,0 wto=false max=1605032205.336677254,0 (SQLSTATE 40001)
		  | BEGIN
		  |   CREATE SCHEMA schema222 AUTHORIZATION root;
		  | ROLLBACK; ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)
		  | BEGIN
		  |   DROP SEQUENCE "seq34";
		  |   CREATE TYPE "schema93.enum208" AS ENUM ('s', 'sddsad', 'asd', 'aa', 'dfdf');
		  |   DROP SCHEMA "schema84" CASCADE;
		  | ROLLBACK; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): "sql txn" meta={id=079fc008 key=/Table/SystemConfigSpan/Start pri=0.00632838 epo=0 ts=1605032205.544844803,2 min=1605032204.853395733,0 seq=21} lock=true stat=PENDING rts=1605032204.853395733,0 wto=false max=1605032204.853395733,0 (SQLSTATE 40001)
		  | BEGIN
		  |   CREATE SEQUENCE "seq223";
		  | ROLLBACK; ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)
		  | BEGIN
		  |   CREATE TYPE "schema93.enum218" AS ENUM ('ds', 'd', 'fdf', 'ada');
		  |   ALTER SEQUENCE "seq34" RENAME TO "seq224";
		  |   SELECT 'validating all objects';
		  | COMMIT;  ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=4d8e2cc2 key=/Table/SystemConfigSpan/Start pri=0.00555725 epo=0 ts=1605032205.597193023,1 min=1605032204.975227216,0 seq=21} lock=true stat=PENDING rts=1605032204.975227216,0 wto=false max=1605032205.475227216,0 (SQLSTATE 40001)
		  | BEGIN
		  |   DROP SEQUENCE "seq34";
		  |   CREATE SCHEMA schema93 AUTHORIZATION root;
		  | ROLLBACK; ERROR: schema "schema93" already exists (SQLSTATE 42P06)
		  |     4.0s        0           41.0           44.7     11.5    419.4    838.9    838.9 opOk
		  |     4.0s        0            9.0            8.2    906.0   1140.9   1140.9   1140.9 txnCmtErr
		  |     4.0s        0            2.0            4.0    209.7    318.8    318.8    318.8 txnOk
		  |     4.0s        0           22.0           21.7      1.2    104.9    260.0    260.0 txnRbk
		  | BEGIN
		  |   DROP SCHEMA "schema226" CASCADE;
		  | ROLLBACK; ERROR: unknown schema "schema226" (SQLSTATE 3F000)
		  | BEGIN
		  |   CREATE SEQUENCE "seq198";
		  |   CREATE TABLE schema84.table227 (col227_0 INT8 NOT NULL, col227_1 NAME NOT NULL, PRIMARY KEY (col227_0 ASC, col227_1 ASC), INDEX (col227_0, col227_1 ASC));
		  | ***FAIL; Expected no errors, but got ERROR: descriptor is being dropped (SQLSTATE XXUUU)
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *main.withCommandDetails (4) *exec.ExitError

More

Artifacts: /scbench/randomload/nodes=3/ops=10000/conc=20
Related:

• 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 release-blocker

See this test on roachdash
_{powered by pkg/cmd/internal/issues}

[thoszhang]

Closing in favor of #56230.