Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
cockroach-teamcity opened this issue Sep 10, 2021 · 124 comments
Closed

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

cockroach-teamcity opened this issue Sep 10, 2021 · 124 comments
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Sep 10, 2021 •
edited by cockroach-jira-scripts
Loading

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 99a4816fc272228a63df20dae3cc41d235e705f3:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:46.030643",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SEQUENCE public.seq573"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.seq573\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:46.135861",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE IF EXISTS public.table550 CASCADE",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:46.068299",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table603 (col603_604 NAME NULL, col603_605 GEOMETRY, col603_606 UUID, col603_607 FLOAT4 NULL, col603_608 TIMESTAMPTZ, col603_609 JSONB NULL, col603_610 FLOAT4, col603_611 \"char\" NULL, col603_612 INTERVAL NULL, col603_613 NAME NOT NULL, col603_614 REGCLASS NULL, col603_615 REGROLE NOT NULL, col603_616 REGPROCEDURE NOT NULL, col603_617 FLOAT4 NULL AS (col603_607 + col603_610) VIRTUAL, col603_618 STRING NULL AS (lower(col603_604)) STORED, col603_619 FLOAT4 NULL AS (col603_607 + col603_610) VIRTUAL, col603_620 FLOAT4 AS (col603_610 + col603_607) VIRTUAL, col603_621 STRING AS (lower(CAST(col603_605 AS STRING))) STORED, col603_622 STRING NOT NULL AS (lower(CAST(col603_616 AS STRING))) STORED, UNIQUE (lower(CAST(col603_614 AS STRING)), col603_621 ASC, col603_604, col603_619 ASC, col603_607 ASC, col603_622 ASC, col603_618 DESC), UNIQUE (col603_611), FAMILY (col603_612, col603_606), FAMILY (col603_607, col603_621), FAMILY (col603_610), FAMILY (col603_605, col603_618, col603_616), FAMILY (col603_615, col603_609), FAMILY (col603_608), FAMILY (col603_622), FAMILY (col603_611), FAMILY (col603_614, col603_613), FAMILY (col603_604))",
		  |   "DROP SCHEMA \"schema625\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: unknown schema \"schema625\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:46.126758",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP VIEW IF EXISTS public.view593",
		  |   "DROP TABLE IF EXISTS public.table550 CASCADE"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: relation \"public.table550\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

Jira issue: CRDB-9893
@cockroach-teamcity cockroach-teamcity added branch-release-21.2 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. labels Sep 10, 2021
@blathers-crl blathers-crl bot added the T-sql-schema-deprecated Use T-sql-foundations instead label Sep 10, 2021
This was referenced Sep 10, 2021
Closed
Closed
@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 4811bb9c8c1d20b9f200d44bc7df388ad2d80898:

		  |   "DROP VIEW IF EXISTS schema69.view70 RESTRICT",
		  |   "DROP SEQUENCE IF EXISTS public.seq80",
		  |   "ALTER TABLE public.table84 RENAME TO public.table85"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table84\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:17.062258",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table40 (col40_41 CHAR NOT NULL, col40_42 FLOAT4 NOT NULL, col40_43 BYTES NULL, col40_44 \"char\" NOT NULL, col40_45 INT8 NOT NULL, col40_46 FLOAT8 NOT NULL, col40_47 DECIMAL NOT NULL, col40_48 FLOAT4 NULL, col40_49 DATE NOT NULL, col40_50 BIT(11) NULL, col40_51 CHAR NULL, col40_52 INET NOT NULL, col40_53 FLOAT8 NOT NULL, col40_54 REGCLASS NOT NULL, col40_55 \"char\" NULL, PRIMARY KEY (col40_41, col40_52 ASC, col40_45, col40_47, col40_54, col40_53, col40_46, col40_49 ASC, col40_44), UNIQUE (col40_55, col40_54 DESC, col40_50 ASC, col40_51 DESC, col40_46, col40_44, col40_48, col40_53, col40_42, col40_49, col40_43 DESC, col40_47 DESC, col40_45, col40_52 ASC, col40_41), INDEX (col40_51 ASC, col40_53 ASC, col40_50 DESC, col40_43 ASC, col40_48, col40_46 DESC, col40_55, col40_41, col40_47 ASC, col40_49 DESC, col40_54 DESC, ((col40_46 + col40_42) + col40_48) DESC) STORING (col40_42), UNIQUE (col40_52 ASC, col40_54 ASC, ((col40_46 + col40_53) + col40_42) ASC, lower(CAST(col40_50 AS STRING)), col40_51 ASC, col40_43 ASC, col40_44 DESC, col40_46, col40_47, col40_49 ASC, col40_48, col40_50) STORING (col40_42, col40_55), INDEX (((col40_46 + col40_53) + col40_48), col40_47, col40_55 DESC, col40_50, col40_51 ASC, col40_49, col40_54, col40_48 DESC, col40_53 DESC, col40_46 DESC, col40_41 ASC) STORING (col40_42, col40_43), UNIQUE (col40_49 ASC, col40_44 DESC, col40_52, col40_48, col40_53 DESC, col40_41 DESC, (((col40_48 + col40_53) + col40_42) + col40_46) ASC, col40_43 ASC, col40_50 ASC, col40_46, col40_51 ASC, col40_47 DESC, col40_42, col40_54), UNIQUE (col40_44 DESC, col40_53 ASC, col40_43 ASC, col40_54, col40_51 DESC, lower(CAST(col40_50 AS STRING)) ASC, lower(CAST(col40_50 AS STRING)) ASC, col40_50 ASC, (((col40_42 + col40_48) + col40_53) + col40_46) ASC, col40_49 DESC, col40_47, col40_52, col40_42 DESC, col40_41 DESC), UNIQUE (col40_47 DESC) STORING (col40_43, col40_50, col40_55), INDEX (col40_47, col40_44 ASC, col40_42 ASC, col40_50 ASC, col40_48 DESC, col40_49 ASC, col40_54, col40_55 ASC, col40_41, col40_52 ASC, col40_46 DESC, col40_51, col40_43 DESC))",
		  |   "ALTER TABLE public.table40 ADD COLUMN col40_79 UUID NULL",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:16.835479",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE SCHEMA IF NOT EXISTS schema38 AUTHORIZATION root",
		  |   "CREATE TYPE public.enum86 AS ENUM ('asfsfs', 'addasf', 'ddaa', 'sdfsff', 'd')",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=042662cd key=/Table/SystemConfigSpan/Start pri=0.01640152 epo=0 ts=1631345177.388822712,1 min=1631345176.835432631,0 seq=24} lock=true stat=PENDING rts=1631345176.835432631,0 wto=false gul=1631345177.335432631,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:17.287852",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table40 ALTER COLUMN \"col40_41\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P16",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col40_41\" is in a primary index (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 8d491ced731e13da2377cda9961f577d7487d6a0:

		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot alter a table's LOCALITY if its database is not multi-region enabled (SQLSTATE 42P16)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:40.518379",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema1.table108 ALTER COLUMN \"col108_110\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col108_110\" is not a computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:39.928531",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE schema1.table108",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:40.438179",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema1.table108 ALTER COLUMN \"col108_109\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col108_109\" is not a computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:26:40.5183",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table117 (col117_118 TIME, col117_119 BYTES, col117_120 STRING NOT NULL, col117_121 FLOAT4 NULL, col117_122 TIMETZ[], col117_123 STRING AS (lower(CAST(col117_118 AS STRING))) STORED, INVERTED INDEX (col117_120 ASC, col117_123 ASC, (CASE WHEN col117_119 IS NULL THEN e')\\x12\\x1af':::STRING ELSE 'E':::STRING END) ASC, col117_122 ASC), INVERTED INDEX (col117_121 DESC, col117_118 DESC, col117_120 ASC, col117_123 DESC, col117_119 DESC, col117_122), UNIQUE (col117_120 DESC, col117_119, (col117_121 + (-1.9321986436843872):::FLOAT8) DESC) STORING (col117_118, col117_121), FAMILY (col117_121), FAMILY (col117_122, col117_120), FAMILY (col117_123, col117_118), FAMILY (col117_119))",
		  |   "DROP TABLE public.table117 CASCADE"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: relation \"public.table117\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 14411b999aae710ca0f4a6376d58e302b197281b:

		  |  "clientTimestamp": "07:15:49.947917",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq42",
		  |   "CREATE INDEX \"IrrelevantName\" ON public.table65 (\"IrrelevantColumn\" ASC)"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table65\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:50.115639",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA schema27 AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=7e9b5b47 key=/Table/SystemConfigSpan/Start pri=0.01041661 epo=0 ts=1631603750.302828160,1 min=1631603750.115527464,0 seq=15} lock=true stat=ABORTED rts=1631603750.115527464,0 wto=false gul=1631603750.615527464,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:49.94664",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE SCHEMA IF NOT EXISTS schema41 AUTHORIZATION root",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=503ffd18 key=/Table/SystemConfigSpan/Start pri=0.00060415 epo=0 ts=1631603750.352506997,1 min=1631603749.946553623,0 seq=15} lock=true stat=PENDING rts=1631603749.946553623,0 wto=false gul=1631603750.446553623,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:49.945149",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS public AUTHORIZATION root",
		  |   "CREATE TABLE public.table29 (col29_30 REGPROC NULL, col29_31 BOX2D, col29_32 REGNAMESPACE NOT NULL, col29_33 INET NOT NULL, col29_34 REGTYPE, col29_35 GEOMETRY NULL, col29_36 BIT(46) NOT NULL, col29_37 REGCLASS NOT NULL, PRIMARY KEY (col29_36 ASC, col29_37, col29_33, col29_32))",
		  |   "CREATE TYPE public.enum40 AS ENUM ('asdfdf', 'ddasa')",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 59, db schemachange, schema public, name table29: relation \"table29\" (59): invalid locality config: database schemachange is multi-region enabled, but table table29 has no locality set"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ d3fc366bcba04ab19f4cb59844212e908e2a9aa8:

		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:24:47.954452",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table332 AS SELECT public.table275.col275_277, public.table275.crdb_internal_idx_expr, public.table275.col275_276, public.table275.col275_277, public.table275.col275_276, public.table275.crdb_internal_idx_expr FROM public.table275, public.table275"
		  |  ],
		  |  "expectedExecErrors": "42701,42712",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: source name \"table275\" specified more than once (missing AS clause) (SQLSTATE 42712)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:24:47.678683",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq302",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE TYPE public.enum310 AS ENUM ('fddfds', 'aff', 'ddffs')",
		  |   "DROP SEQUENCE public.seq302",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=3c64182a key=/Table/SystemConfigSpan/Start pri=0.03632717 epo=0 ts=1631690688.016105852,1 min=1631690687.678594283,0 seq=31} lock=true stat=PENDING rts=1631690687.678594283,0 wto=false gul=1631690688.178594283,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:24:48.099814",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:24:48.265472",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE INDEX \"IrrelevantName\" ON public.table338 (\"IrrelevantColumn\" ASC)"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table338\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ ed81878bb4697c3a0a09e69b8a5053566297b142:

		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=8e3e86b4 key=/Table/SystemConfigSpan/Start pri=0.04957523 epo=0 ts=1631776832.935510884,1 min=1631776832.278633613,0 seq=1} lock=true stat=PENDING rts=1631776832.278633613,0 wto=false gul=1631776832.778633613,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:20:32.462957",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP INDEX public.table30@\"index30_86\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "42704",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: index \"index30_86\" does not exist (SQLSTATE 42704)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:20:32.808982",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table30 ALTER COLUMN \"col30_31\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P16",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col30_31\" is in a primary index (SQLSTATE 42P16)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:20:32.862873",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE IF EXISTS public.table30 RESTRICT",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=c4390256 key=/Table/SystemConfigSpan/Start pri=0.02033566 epo=0 ts=1631776832.935510884,1 min=1631776832.862786161,0 seq=13} lock=true stat=PENDING rts=1631776832.862786161,0 wto=false gul=1631776833.362786161,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:20:32.799385",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE UNIQUE INDEX IF NOT EXISTS index30_88 ON public.table30 (col30_31 DESC)"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 60, db schemachange, schema public, name table30: mutation job 693719640085200897: job not found"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 0babf97f52ed9e44036851b2a9868e17eeee95ed:

		  | (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 --txn-log /mnt/data1/cockroach/transactions.json
		  |   | ``````
		  | 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 ...>
		  | tSchemaID\\\" = schema_id.id\\n                      ),\\n       descriptors AS (\\n                    SELECT crdb_internal.pb_to_json(\\n                            'cockroach.sql.sqlbase.Descriptor',\\n                            descriptor\\n                           ) AS descriptor\\n                      FROM system.descriptor AS descriptors\\n                      JOIN descriptor_ids ON descriptors.id\\n                                             = descriptor_ids.id\\n                   ),\\n       types AS (\\n                SELECT descriptor\\n                  FROM descriptors\\n                 WHERE (descriptor-\u003e'type') IS NOT NULL\\n             ),\\n       table_references AS (\\n                            SELECT json_array_elements(\\n                                    descriptor-\u003e'table'-\u003e'dependedOnBy'\\n                                   ) AS ref\\n                              FROM descriptors\\n                             WHERE (descriptor-\u003e'table') IS NOT NULL\\n                        ),\\n       dependent AS (\\n                    SELECT (ref-\u003e\u003e'id')::INT8 AS id FROM table_references\\n                 ),\\n       referenced_descriptors AS (\\n                                SELECT json_array_elements_text(\\n                                        descriptor-\u003e'type'-\u003e'referencingDescriptorIds'\\n                                       )::INT8 AS id\\n                                  FROM types\\n                              )\\nSELECT EXISTS(\\n        SELECT *\\n          FROM system.namespace\\n         WHERE id IN (SELECT id FROM referenced_descriptors)\\n           AND \\\"parentSchemaID\\\" NOT IN (SELECT id FROM schema_id)\\n           AND id NOT IN (SELECT id FROM dependent)\\n       );\" [\"public\"]: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=6d5c82ac key=/Table/SystemConfigSpan/Start pri=0.00431435 epo=0 ts=1631863031.204388099,1 min=1631863031.191834656,0 seq=7} lock=true stat=ABORTED rts=1631863031.191834656,0 wto=false gul=1631863031.691834656,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:17:11.175156",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER SEQUENCE public.seq186 RENAME TO public.seq212",
		  |   "ALTER DATABASE schemachange SURVIVE ZONE FAILURE"
		  |  ],
		  |  "expectedExecErrors": "42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: database must have associated regions before a survival goal can be set (SQLSTATE 42602)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:17:11.175834",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema233 AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "querying for validation errors failed: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=c7fa249e key=/Table/SystemConfigSpan/Start pri=0.00140476 epo=0 ts=1631863031.457421442,1 min=1631863031.175699915,0 seq=15} lock=true stat=ABORTED rts=1631863031.175699915,0 wto=false gul=1631863031.675699915,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:17:11.046836",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table213 (col213_214 FLOAT8[] NULL, col213_215 FLOAT8, INVERTED INDEX (col213_214 DESC), INVERTED INDEX (col213_215 ASC, col213_214 ASC), INVERTED INDEX (col213_215 DESC, col213_214 DESC), UNIQUE (col213_215 ASC) STORING (col213_214), UNIQUE ((col213_215 + (-0.3296718145384766):::FLOAT8) DESC, col213_215), INVERTED INDEX (col213_215, col213_214), INVERTED INDEX (col213_215, col213_214 ASC), FAMILY (col213_214), FAMILY (col213_215))",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ a29fd0ad538d51050d82e92583a8206983622f6b:

		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq7",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:19:27.174357",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "CREATE INDEX \"IrrelevantName\" ON public.table36 (\"IrrelevantColumn\" ASC)"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table36\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:19:27.173028",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table4 (col4_5 JSONB NOT NULL, col4_6 DATE NOT NULL, INVERTED INDEX (col4_6, col4_5 DESC), INVERTED INDEX (col4_5 ASC), INVERTED INDEX (col4_6 DESC, col4_5 DESC), INVERTED INDEX (col4_6 DESC, col4_5 DESC), INDEX (col4_6), FAMILY (col4_6, col4_5))",
		  |   "ALTER TABLE public.table4 ADD COLUMN col4_20 INT8",
		  |   "CREATE TYPE public.enum37 AS ENUM ('addss')",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=95c0ec8b key=/Table/SystemConfigSpan/Start pri=0.10799556 epo=0 ts=1631949567.175685226,1 min=1631949567.172790380,0 seq=22} lock=true stat=PENDING rts=1631949567.172790380,0 wto=false gul=1631949567.672790380,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:19:27.172799",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE TYPE public.enum38 AS ENUM ('fadfd', 'dfd', 'ddfd', 'dsasfa', 'a')",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 5202c97fcfe7e51e244335c3cd68bd33647860ff:

		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:44.46897",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table4 (col4_5 BIT(31) NOT NULL, PRIMARY KEY (col4_5), UNIQUE (col4_5 DESC), INDEX (col4_5 DESC), UNIQUE (col4_5), UNIQUE (col4_5), INDEX (col4_5 ASC), UNIQUE (col4_5 DESC))",
		  |   "CREATE SCHEMA schema11 AUTHORIZATION root",
		  |   "CREATE TABLE public.table33 AS SELECT public.table4.col4_5, public.table4.col4_5, public.table4.col4_5 FROM public.table4, public.table4, public.table4"
		  |  ],
		  |  "expectedExecErrors": "42701,42712",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: source name \"table4\" specified more than once (missing AS clause) (SQLSTATE 42712)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:44.677474",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023,42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: database must have associated regions before a survival goal can be set (SQLSTATE 42602)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:44.76241",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:15:44.469244",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "DROP SEQUENCE IF EXISTS public.seq39",
		  |   "ALTER DATABASE schemachange SURVIVE ZONE FAILURE"
		  |  ],
		  |  "expectedExecErrors": "42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "***FAIL; Failed to receive an execution error when errors were expected"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ db7de996a04d0b7e7959decd06c2cd40d80e501f:

		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:30.662175",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table32 (col32_33 REGROLE NULL, col32_34 UUID, col32_35 OID NULL, col32_36 REGPROC, col32_37 TIMESTAMPTZ NOT NULL, col32_38 REGPROC NULL, col32_39 JSONB, col32_40 UUID NULL, col32_41 BOX2D NOT NULL, col32_42 REGCLASS, col32_43 STRING, col32_44 BIT(6) NULL, col32_45 GEOMETRY, col32_46 GEOMETRY, col32_47 TIMESTAMPTZ, col32_48 BIT(4) NULL, col32_49 CHAR NOT NULL, col32_50 STRING NOT NULL AS (lower(col32_49)) VIRTUAL, FAMILY (col32_37), FAMILY (col32_34, col32_41), FAMILY (col32_42, col32_49, col32_40), FAMILY (col32_47, col32_46), FAMILY (col32_33, col32_36), FAMILY (col32_43), FAMILY (col32_48), FAMILY (col32_45, col32_44, col32_38), FAMILY (col32_35, col32_39))",
		  |   "DROP VIEW public.view56"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.view56\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:30.666543",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum55 AS ENUM ('dsdd', 'ffs')",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:30.65839",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:30.665939",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 184cac1592349a665c39a54e688de072388e7886:

		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=4a8f4d93 key=/Table/SystemConfigSpan/Start pri=0.05425015 epo=0 ts=1632383222.650024406,1 min=1632383222.576203423,0 seq=22} lock=true stat=PENDING rts=1632383222.576203423,0 wto=false gul=1632383223.076203423,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:47:02.412173",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table142 AS SELECT public.table115.col115_119, public.table115.col115_117, public.table115.col115_116, public.table115.col115_118 FROM public.table115",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:47:02.376577",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table115 ALTER COLUMN \"col115_117\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col115_117\" is not a computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:47:02.333698",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA schema122 AUTHORIZATION root",
		  |   "CREATE TYPE public.enum144 AS ENUM ('sdad', 'fa', 'ss', 'fs')"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "failed to get regions: SELECT region FROM [SHOW REGIONS FROM DATABASE]: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - intent pushed): \"sql txn\" meta={id=67fbcc22 key=/Table/SystemConfigSpan/Start pri=0.01938958 epo=0 ts=1632383222.922588064,1 min=1632383222.333644652,0 seq=0} lock=true stat=PENDING rts=1632383222.333644652,0 wto=false gul=1632383222.833644652,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:47:02.543492",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table115 RENAME COLUMN \"crdb_internal_idx_expr\" TO \"col115_141\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: column \"crdb_internal_idx_expr\" is inaccessible and cannot be renamed (SQLSTATE 42703)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ c46f5a5a098577b936e56f03d20c97300b4cce61:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:30:44.094248",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema16 AUTHORIZATION root",
		  |   "CREATE SCHEMA schema129 AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=1b1b96f9 key=/Table/SystemConfigSpan/Start pri=0.01735366 epo=0 ts=1632468644.855779313,1 min=1632468644.094184451,0 seq=8} lock=true stat=PENDING rts=1632468644.094184451,0 wto=false gul=1632468644.594184451,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:30:44.341375",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table114 (col114_115 REGNAMESPACE, col114_116 GEOMETRY NOT NULL, col114_117 BIT(7) NOT NULL, col114_118 INT4 NOT NULL, col114_119 BIT(19) NULL, col114_120 INET NULL, col114_121 STRING NULL AS (lower(CAST(col114_119 AS STRING))) STORED, col114_122 STRING AS (lower(CAST(col114_115 AS STRING))) VIRTUAL, col114_123 STRING NULL AS (lower(CAST(col114_119 AS STRING))) VIRTUAL, col114_124 STRING NOT NULL AS (lower(CAST(col114_116 AS STRING))) VIRTUAL, col114_125 STRING NOT NULL AS (lower(CAST(col114_116 AS STRING))) VIRTUAL, UNIQUE (col114_120 ASC, lower(CAST(col114_120 AS STRING)) DESC), UNIQUE (col114_117 DESC, col114_118 DESC, col114_122 DESC) STORING (col114_115, col114_116, col114_120), UNIQUE (col114_121) STORING (col114_115, col114_118))",
		  |   "ALTER TABLE public.table114 DROP CONSTRAINT \"table114_col114_117_col114_118_col114_122_key\""
		  |  ],
		  |  "expectedExecErrors": "0A000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: unimplemented: cannot drop UNIQUE constraint \"table114_col114_117_col114_118_col114_122_key\" using ALTER TABLE DROP CONSTRAINT, use DROP INDEX CASCADE instead (SQLSTATE 0A000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:30:44.094423",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE schema16.enum126 AS ENUM ('ddf', 'faffsa', 'saafff', 'dsds')",
		  |   "DROP SCHEMA \"schema16\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=06bdb500 key=/Table/SystemConfigSpan/Start pri=0.00476623 epo=0 ts=1632468644.855779313,1 min=1632468644.094353924,0 seq=21} lock=true stat=PENDING rts=1632468644.094353924,0 wto=false gul=1632468644.594353924,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:30:44.555256",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE public.table145 (col145_146 REGNAMESPACE NOT NULL, col145_147 TIMETZ NOT NULL, PRIMARY KEY (col145_147 ASC), INDEX (col145_146 ASC, col145_147 DESC), INDEX (col145_146 DESC, col145_147), UNIQUE (col145_146 ASC), UNIQUE (col145_146 ASC), UNIQUE (col145_146 ASC, col145_147))"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"public.table145\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 24021ba163e4ac438b169d575cf1527a4aae394d:

		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema287.table359\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:51:16.73211",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE SEQUENCE IF NOT EXISTS schema360.seq361"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot create \"schema360.seq361\" because the target database or schema does not exist (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:51:16.817247",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER VIEW public.view363 RENAME TO schema287.view364"
		  |  ],
		  |  "expectedExecErrors": "42602,42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.view363\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:51:16.400641",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum362 AS ENUM ('d', 'adadf', 'sdafa')",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:51:16.292791",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS schema287.table320 (col320_321 TIMESTAMP NULL, col320_322 JSONB, col320_323 INET, col320_324 BIT(47), col320_325 BYTES NULL, col320_326 REGPROC NOT NULL, col320_327 INTERVAL NOT NULL, col320_328 BIT(5), col320_329 STRING[] NOT NULL, col320_330 REGPROC NULL, col320_331 STRING AS (lower(CAST(col320_323 AS STRING))) VIRTUAL, col320_332 STRING NULL AS (CASE WHEN col320_325 IS NULL THEN 'tt|':::STRING ELSE NULL END) VIRTUAL, INDEX (col320_328, col320_326 DESC, col320_331 DESC), UNIQUE (lower(CAST(col320_328 AS STRING)) ASC), INDEX (col320_332 DESC, col320_331 DESC) STORING (col320_321, col320_323, col320_324, col320_325, col320_326, col320_327, col320_329, col320_330), INVERTED INDEX (col320_326, col320_327, (CASE WHEN col320_329 IS NULL THEN e'_/d\\t\\x05':::STRING ELSE e'\\x7f\\f\u003eoOS':::STRING END) DESC, col320_323 DESC, col320_329 DESC), INDEX (col320_328 DESC))"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"schema287.table320\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 947d24dc88c05bf698d8011e1b5cf3b2017f26a3:

		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:22:36.935238",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=2f933f39 key=/Table/SystemConfigSpan/Start pri=0.01270566 epo=0 ts=1632813757.756661223,1 min=1632813756.935184600,0 seq=8} lock=true stat=PENDING rts=1632813756.935184600,0 wto=false gul=1632813757.435184600,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:22:37.621342",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table88 (col88_89 VARCHAR NOT NULL, col88_90 REGCLASS NOT NULL, col88_91 REGTYPE NOT NULL, col88_92 NAME NOT NULL, col88_93 BOOL NOT NULL, col88_94 TIMESTAMPTZ NOT NULL, col88_95 REGCLASS NULL, PRIMARY KEY (col88_94 DESC, col88_93 ASC, col88_92 ASC, col88_91 ASC, col88_89 DESC, col88_90 ASC), col88_96 STRING NOT NULL AS (lower(CAST(col88_90 AS STRING))) STORED, col88_97 STRING NOT NULL AS (CASE WHEN col88_94 IS NULL THEN '':::STRING ELSE '':::STRING END) VIRTUAL, col88_98 STRING NOT NULL AS (lower(CAST(col88_91 AS STRING))) VIRTUAL, col88_99 STRING NOT NULL AS (lower(CAST(col88_93 AS STRING))) VIRTUAL, INDEX (col88_96 ASC, col88_89 ASC, col88_91, col88_99, col88_98, col88_97 DESC, col88_94 ASC, col88_92 DESC, col88_93 ASC, col88_95, col88_90 ASC), INDEX (col88_99, col88_98, col88_96, col88_95, col88_90, col88_94 DESC), INDEX (col88_89 DESC, col88_96, col88_91 ASC), INDEX (col88_94 DESC), INDEX (col88_98, col88_90, col88_89 ASC, col88_92, col88_91 DESC, col88_96 ASC, col88_99 ASC, col88_97 DESC), UNIQUE (col88_94, col88_98), UNIQUE (col88_94 ASC, col88_99 DESC, col88_91 ASC, col88_97 DESC, col88_90 DESC, col88_93 ASC) STORING (col88_95), UNIQUE (col88_97, col88_91 ASC, col88_94 DESC, col88_98, col88_89 DESC, lower(CAST(col88_91 AS STRING)), col88_92, col88_95))",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=52928137 key=/Table/SystemConfigSpan/Start pri=0.07579350 epo=0 ts=1632813757.638616749,1 min=1632813757.621303006,0 seq=8} lock=true stat=PENDING rts=1632813757.621303006,0 wto=false gul=1632813758.121303006,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:22:37.53943",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE schema1.table101 ALTER COLUMN \"IrrelevantColumnName\" DROP DEFAULT"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema1.table101\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:22:37.561538",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table69 (col69_70 FLOAT4 NOT NULL, col69_71 REGNAMESPACE NOT NULL, PRIMARY KEY (col69_70 DESC, col69_71 ASC), col69_72 FLOAT4 NOT NULL AS (col69_70 + 1.9244896173477173:::FLOAT8) STORED, UNIQUE (col69_71 ASC, col69_70 DESC, col69_72 ASC), UNIQUE (col69_71, col69_70 ASC), UNIQUE ((col69_70 + 1.0937436819076538:::FLOAT8) ASC, col69_71 ASC, col69_72 DESC), UNIQUE (col69_70 DESC, col69_72 ASC), UNIQUE (col69_70), UNIQUE (col69_72, col69_71 DESC, col69_70 DESC), UNIQUE (col69_72))",
		  |   "ALTER TABLE public.table69 RENAME TO public.table78",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: relation \"public.table69\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 8d1d2b688ceedb0e5577d1da789da74d060c92ad:

		  |  "workerId": 0,
		  |  "clientTimestamp": "07:09:54.649257",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:09:54.39073",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema33 AUTHORIZATION root",
		  |   "CREATE TABLE IF NOT EXISTS public.table80 (col80_81 INET NULL, col80_82 OID NOT NULL, PRIMARY KEY (col80_82), col80_83 STRING NULL AS (lower(CAST(col80_81 AS STRING))) STORED, UNIQUE (col80_83 DESC), INDEX (col80_82 DESC), INDEX (col80_82 DESC, col80_81 DESC), INDEX (col80_83 DESC, col80_82 ASC, col80_81))",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=da6b64fe key=/Table/SystemConfigSpan/Start pri=0.00011437 epo=0 ts=1632899394.842118127,1 min=1632899394.390656516,0 seq=22} lock=true stat=PENDING rts=1632899394.390656516,0 wto=false gul=1632899394.890656516,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:09:54.572184",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:09:54.515265",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table37 (col37_38 FLOAT4, col37_39 REGCLASS NOT NULL, col37_40 CHAR NOT NULL, col37_41 BOX2D, col37_42 INT4, col37_43 GEOMETRY NOT NULL, col37_44 REGROLE NOT NULL, col37_45 \"char\", col37_46 CHAR NOT NULL, col37_47 TIMESTAMPTZ NOT NULL, col37_48 STRING NOT NULL AS (lower(col37_40)) VIRTUAL, col37_49 INT4 AS (col37_42 + NULL) VIRTUAL, col37_50 STRING NOT NULL AS (lower(col37_46)) STORED, col37_51 STRING AS (lower(CAST(col37_41 AS STRING))) STORED, col37_52 STRING NOT NULL AS (lower(col37_40)) VIRTUAL, col37_53 STRING NOT NULL AS (lower(CAST(col37_43 AS STRING))) STORED, col37_54 STRING NOT NULL AS (lower(col37_46)) VIRTUAL, col37_55 STRING NOT NULL AS (CASE WHEN col37_47 IS NULL THEN 't':::STRING ELSE e'DH\\x16=\\'C\"':::STRING END) VIRTUAL, INDEX ((CASE WHEN col37_47 IS NULL THEN e'}\\x19Hc6\\x1fj3\\x14':::STRING ELSE e'cd\\x13FyX\\x0e!T':::STRING END) DESC), INDEX (col37_51, col37_41, col37_53, col37_44 ASC, col37_42, col37_40 DESC, col37_54, col37_55, col37_49 ASC, col37_46 ASC, col37_38, col37_50 DESC) STORING (col37_43), UNIQUE (col37_38), INDEX (col37_40 DESC, col37_38 DESC, col37_49 DESC, col37_51 DESC, col37_46, col37_52 ASC, col37_39, col37_50 DESC, lower(col37_46), col37_45, col37_42 ASC, col37_53 ASC, col37_55 ASC, col37_41, col37_44 ASC, col37_47 ASC, col37_48 DESC) STORING (col37_43), INDEX (col37_53 ASC) STORING (col37_38, col37_39, col37_42, col37_45, col37_46, col37_51))",
		  |   "CREATE INDEX IF NOT EXISTS index37_79 ON public.table37 (crdb_internal_idx_expr ASC) STORING (col37_45, col37_39, col37_38, col37_40, crdb_internal_idx_expr_1, col37_41, col37_53, col37_46, col37_44, col37_48, col37_51, col37_42, col37_52, col37_55, col37_50, col37_49, col37_43)"
		  |  ],
		  |  "expectedExecErrors": "XXUUU",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: column \"crdb_internal_idx_expr\" is inaccessible and cannot be referenced (SQLSTATE 42703)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 88d8c1ce72a3988332e502e103421996d3908ab3:

		  |   "CREATE TABLE IF NOT EXISTS public.table202 (col202_203 BIT(26) NOT NULL, col202_204 INET NOT NULL, col202_205 REGROLE NOT NULL, col202_206 REGNAMESPACE NOT NULL, col202_207 STRING NOT NULL, col202_208 TIMESTAMPTZ NOT NULL, PRIMARY KEY (col202_205 DESC, col202_203 DESC, col202_208, col202_207, col202_206 DESC, col202_204 ASC), col202_209 STRING NOT NULL AS (lower(CAST(col202_204 AS STRING))) STORED, col202_210 STRING NOT NULL AS (lower(CAST(col202_203 AS STRING))) STORED, col202_211 STRING NOT NULL AS (lower(CAST(col202_205 AS STRING))) STORED, INDEX (col202_211 ASC, col202_205 DESC, col202_206, col202_209) STORING (col202_210), INDEX (col202_203, col202_210, col202_204, col202_211 DESC, col202_207, col202_209 ASC, col202_205), UNIQUE (col202_206 DESC, col202_210, col202_204 ASC), UNIQUE (col202_206 DESC, col202_210 DESC, lower(CAST(col202_206 AS STRING)), col202_203 DESC, col202_204 ASC, lower(CAST(col202_206 AS STRING)) DESC, lower(CAST(col202_206 AS STRING)) ASC, col202_207 DESC, lower(CAST(col202_205 AS STRING)) DESC), INDEX (col202_208 ASC, col202_211 DESC) STORING (col202_209, col202_210), UNIQUE (col202_206, col202_211, col202_203, col202_210, col202_209 DESC, col202_205, col202_208, col202_207 DESC), INDEX (col202_208 DESC, col202_205, col202_203 ASC, col202_209), UNIQUE (col202_203 DESC, col202_207 ASC), UNIQUE (col202_206 DESC, col202_210 DESC, col202_204 DESC, lower(CAST(col202_205 AS STRING)) DESC, col202_203 ASC))",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  |     3.0s        0           24.0           30.3     10.0    704.6    805.3    805.3 opOk
		  |     3.0s        0            1.0            4.3    570.4    570.4    570.4    570.4 txnCmtErr
		  |     3.0s        0            1.0            1.3    176.2    176.2    176.2    176.2 txnOk
		  |     3.0s        0           22.0           29.0      1.8    167.8    402.7    402.7 txnRbk
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:17:22.417083",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SEQUENCE public.seq49"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR DURING ROLLBACK;: conn closed"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError

	cluster.go:1249,context.go:89,cluster.go:1237,test_runner.go:866: dead node detection: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod monitor teamcity-3518619-1632982909-22-n3cpu4 --oneshot --ignore-empty-nodes: exit status 1 3: 11510
		2: 11344
		1: dead (exit status 134)
		Error: UNCLASSIFIED_PROBLEM: 1: dead (exit status 134)
		(1) UNCLASSIFIED_PROBLEM
		Wraps: (2) attached stack trace
		  -- stack trace:
		  | main.glob..func14
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1173
		  | main.wrap.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:281
		  | github.com/spf13/cobra.(*Command).execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:856
		  | github.com/spf13/cobra.(*Command).ExecuteC
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:960
		  | github.com/spf13/cobra.(*Command).Execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:897
		  | main.main
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:2107
		  | runtime.main
		  | 	/usr/local/go/src/runtime/proc.go:225
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
		Wraps: (3) 1: dead (exit status 134)
		Error types: (1) errors.Unclassified (2) *withstack.withStack (3) *errutil.leafError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 57bb9046cd2a3090dc5f17b79912f34db8dde33e:

		  |  "clientTimestamp": "07:12:57.267153",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table67 ALTER COLUMN \"col67_73\" DROP NOT NULL",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:12:56.930593",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table67 ALTER COLUMN \"col67_74\" SET NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=4eee7e60 key=/Table/SystemConfigSpan/Start pri=0.08925200 epo=0 ts=1633072377.830435736,1 min=1633072376.930469877,0 seq=1} lock=true stat=PENDING rts=1633072376.930469877,0 wto=false gul=1633072377.430469877,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:12:57.8156",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq95 OWNED BY public.table21.col21_25",
		  |   "ALTER TABLE public.table67 ALTER COLUMN \"col67_70\" DROP NOT NULL",
		  |   "ALTER TABLE public.table67 ALTER COLUMN col67_69 SET DEFAULT B'000000000000000000000000000000000000000000'",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: cannot publish new versions for descriptors: [{table21 57 1} {table67 74 1}], old versions still in use (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:12:57.196609",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table21 RENAME COLUMN \"col21_25\" TO \"col21_103\"",
		  |   "ALTER TABLE public.table21 ALTER COLUMN \"col21_32\" DROP DEFAULT",
		  |   "ALTER TABLE public.table21 ALTER COLUMN \"col21_23\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 57, db schemachange, schema public, name table21: mutation job 697964882581979137: job not found"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 47b426a9d692a9faebb3749f25fcbfef4f64af34:

		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=04d325d0 key=/Table/SystemConfigSpan/Start pri=0.01300042 epo=0 ts=1633159910.837482130,1 min=1633159910.467577431,0 seq=24} lock=true stat=PENDING rts=1633159910.467577431,0 wto=false gul=1633159910.967577431,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:31:50.470022",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=3761c802 key=/Table/SystemConfigSpan/Start pri=0.02429173 epo=0 ts=1633159910.837482130,2 min=1633159910.469936430,0 seq=24} lock=true stat=PENDING rts=1633159910.469936430,0 wto=false gul=1633159910.969936430,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:31:50.470255",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE IF EXISTS public.table25",
		  |   "CREATE SCHEMA schema26 AUTHORIZATION root",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:31:50.471078",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum19 AS ENUM ('dsdf', 'fafsff')",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq27",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED COMMIT ERROR; Received an unexpected commit error: ERROR: relation \"seq27\" (64): invalid locality config: database schemachange is multi-region enabled, but table seq27 has no locality set (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ d1231cff60125b397ccce6c79c9aeea771cdcca4:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "06:56:28.822672",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=2046f5f8 key=/Table/SystemConfigSpan/Start pri=0.02775639 epo=0 ts=1633244189.148210990,1 min=1633244188.822611672,0 seq=1} lock=true stat=PENDING rts=1633244188.822611672,0 wto=false gul=1633244189.322611672,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "06:56:28.697986",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS schema37.seq165",
		  |   "DROP SEQUENCE IF EXISTS schema37.seq126"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=f374e3a0 key=/Table/SystemConfigSpan/Start pri=0.01952578 epo=0 ts=1633244189.218097152,1 min=1633244188.697922686,0 seq=9} lock=true stat=PENDING rts=1633244188.697922686,0 wto=false gul=1633244189.197922686,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "06:56:28.851476",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE schema37.enum188 AS ENUM ('dfs', 'd', 'sfsd', 'fsadss', 'adaa', 'sfafsa')",
		  |   "DROP SCHEMA \"schema37\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=712b7ac7 key=/Table/SystemConfigSpan/Start pri=0.00358522 epo=0 ts=1633244189.218097152,1 min=1633244188.851390694,0 seq=10} lock=true stat=PENDING rts=1633244188.851390694,0 wto=false gul=1633244189.351390694,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "06:56:28.691262",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE schema37.table166 (col166_167 TIMESTAMP NOT NULL, col166_168 TIMETZ, PRIMARY KEY (col166_167 DESC), col166_169 STRING NOT NULL AS (lower(CAST(col166_167 AS STRING))) VIRTUAL, INDEX (col166_168 DESC, col166_167 DESC), UNIQUE (lower(CAST(col166_168 AS STRING)), col166_168 DESC, col166_167 ASC), UNIQUE (col166_167 ASC, col166_169), UNIQUE (col166_167, col166_169 ASC, col166_168), UNIQUE (col166_169 ASC, col166_168 DESC), INDEX (col166_169, col166_167 DESC, col166_168), UNIQUE (col166_169 ASC, col166_167))",
		  |   "ALTER TABLE schema37.table166 RENAME TO schema37.table192"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: relation \"schema37.table166\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ bd00c351494b44b31178350e79c72244c93ea224:

		  |  "clientTimestamp": "07:05:07.745847",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table25 ADD COLUMN col25_152 BIT(4) NULL UNIQUE",
		  |   "ALTER TABLE public.table12 ALTER COLUMN col12_14 SET DEFAULT 0:::OID"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=962e61c5 key=/Table/SystemConfigSpan/Start pri=0.00164816 epo=0 ts=1633331108.170782161,1 min=1633331107.745793005,0 seq=6} lock=true stat=ABORTED rts=1633331107.745793005,0 wto=false gul=1633331108.245793005,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:08.18637",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:08.170853",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"schema122\" CASCADE",
		  |   "ALTER TABLE public.table25 RENAME COLUMN \"col25_30\" TO \"col25_173\"",
		  |   "DROP SEQUENCE IF EXISTS public.seq32"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=7510f8dc key=/Table/SystemConfigSpan/Start pri=0.02054800 epo=0 ts=1633331108.181600053,1 min=1633331108.170782161,0 seq=28} lock=true stat=ABORTED rts=1633331108.170782161,0 wto=false gul=1633331108.670782161,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:07.995351",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE IF EXISTS public.table12 CASCADE",
		  |   "CREATE TYPE schema122.enum175 AS ENUM ('a', 'asa', 'fsff', 'ssff')",
		  |   "ALTER TABLE public.table25 ALTER COLUMN \"col25_26\" DROP DEFAULT",
		  |   "ALTER TABLE public.table25 RENAME COLUMN \"crdb_internal_idx_expr\" TO \"col25_179\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: column \"crdb_internal_idx_expr\" is inaccessible and cannot be renamed (SQLSTATE 42703)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 95c3da44a6c38aa1ae22fe9de5549632b7527aa5:

		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema93.table391\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:48.375939",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER VIEW public.view396 RENAME TO public.view397"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.view396\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:47.959059",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE schema360.table361 (col361_362 UUID, col361_363 BIT(8) NOT NULL, col361_364 STRING NOT NULL, col361_365 TIMESTAMP NULL, col361_366 GEOGRAPHY NOT NULL, col361_367 FLOAT8 NOT NULL, col361_368 OID, col361_369 TIME NOT NULL, col361_370 REGPROCEDURE NOT NULL, col361_371 VARCHAR NOT NULL, col361_372 INET NULL, col361_373 TIMESTAMPTZ NOT NULL, col361_374 FLOAT8 NOT NULL, PRIMARY KEY (col361_364, col361_363 ASC, col361_370 ASC, col361_373), col361_375 FLOAT8 NOT NULL AS (col361_374 + col361_367) STORED, col361_376 STRING NOT NULL AS (CASE WHEN col361_373 IS NULL THEN e'5~T\\x18~]85':::STRING ELSE e'Bd\\x16\\x07=\\rS\\x17':::STRING END) VIRTUAL, col361_377 STRING NOT NULL AS (lower(col361_371)) STORED, col361_378 FLOAT8 NOT NULL AS (col361_374 + col361_367) VIRTUAL, col361_379 STRING NULL AS (lower(CAST(col361_365 AS STRING))) VIRTUAL, col361_380 FLOAT8 NOT NULL AS (col361_374 + col361_367) VIRTUAL, UNIQUE (col361_367, col361_363 ASC, col361_375, col361_380 ASC, col361_368 ASC, col361_369 DESC, lower(CAST(col361_363 AS STRING)) DESC, (col361_374 + col361_367)) STORING (col361_362, col361_365, col361_366, col361_374, col361_377), UNIQUE (col361_372 ASC), UNIQUE (col361_379, col361_363 ASC, col361_377 DESC, (col361_374 + col361_367) ASC, col361_372 DESC, col361_375 ASC, lower(CAST(col361_363 AS STRING)) DESC, col361_369), FAMILY (col361_373), FAMILY (col361_363), FAMILY (col361_375), FAMILY (col361_364, col361_362), FAMILY (col361_370), FAMILY (col361_366, col361_369, col361_372, col361_367, col361_377, col361_371, col361_368), FAMILY (col361_365), FAMILY (col361_374))"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot create \"schema360.table361\" because the target database or schema does not exist (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:48.366684",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table384 ALTER COLUMN \"col384_387\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col384_387\" is not a computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:18:47.886121",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE VIEW schema405.view406 AS SELECT public.table384.col384_387, public.table384.col384_385, public.table384.col384_385 FROM public.table384, public.table384"
		  |  ],
		  |  "expectedExecErrors": "3F000,42701,42712",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot create \"schema405.view406\" because the target database or schema does not exist (SQLSTATE 3F000)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ f542fd2731127dab80599943b6041364fcc920e5:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:24.055432",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=e4c2071c key=/Table/SystemConfigSpan/Start pri=0.01731194 epo=0 ts=1633503924.150824103,1 min=1633503924.055348955,0 seq=8} lock=true stat=PENDING rts=1633503924.055348955,0 wto=false gul=1633503924.555348955,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:23.968115",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq254",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=e48501e2 key=/Table/SystemConfigSpan/Start pri=0.09614010 epo=0 ts=1633503924.169778576,1 min=1633503923.968068789,0 seq=16} lock=true stat=PENDING rts=1633503923.968068789,0 wto=false gul=1633503924.468068789,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:24.150871",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: at least 3 regions are required for surviving a region failure (SQLSTATE 22023)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:05:23.953038",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE schema23.table233 (col233_234 JSONB NOT NULL, col233_235 BOOL, col233_236 UUID NOT NULL, col233_237 REGTYPE, col233_238 BIT(16), col233_239 REGROLE NOT NULL, col233_240 INT8, col233_241 OID NOT NULL, col233_242 NAME, col233_243 INET, col233_244 DATE, col233_245 STRING NOT NULL AS (lower(CAST(col233_241 AS STRING))) STORED, col233_246 STRING AS (lower(CAST(col233_237 AS STRING))) STORED, col233_247 STRING NOT NULL AS (lower(CAST(col233_239 AS STRING))) STORED, col233_248 STRING AS (lower(col233_242)) STORED, col233_249 INT8 AS (col233_240 + 7834736123512640689:::INT8) VIRTUAL, INVERTED INDEX (col233_238 ASC, col233_244 DESC, col233_249, col233_236, col233_237, col233_240, col233_239 ASC, col233_241, col233_243 ASC, col233_248 ASC, col233_242, col233_235, col233_245, col233_234 ASC))",
		  |   "ALTER TABLE schema23.table233 RENAME TO schema23.table275"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: relation \"schema23.table233\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 79c1f34aa3c91977ed6784338d7383931733d0b6:

		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=d9e1f3e0 key=/Table/SystemConfigSpan/Start pri=0.00513503 epo=0 ts=1644307995.783943242,1 min=1644307995.432030283,0 seq=8} lock=true stat=PENDING rts=1644307995.432030283,0 wto=false gul=1644307995.932030283,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:15.130608",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=6141b8a3 key=/Table/SystemConfigSpan/Start pri=0.01587253 epo=0 ts=1644307995.783943242,1 min=1644307995.130510942,0 seq=8} lock=true stat=PENDING rts=1644307995.130510942,0 wto=false gul=1644307995.630510942,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:15.410124",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS schema37.seq415",
		  |   "ALTER TABLE public.table419 ALTER COLUMN \"IrrelevantColumnName\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table419\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:15.674317",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: at least 3 regions are required for surviving a region failure (SQLSTATE 22023)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:15.130122",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS schema278.table399 (col399_400 FLOAT8 NOT NULL, col399_401 DATE NULL, col399_402 INTERVAL NOT NULL, col399_403 VARCHAR NOT NULL, col399_404 REGPROC, col399_405 TIMETZ NOT NULL, col399_406 BOOL NOT NULL, PRIMARY KEY (col399_403 ASC, col399_400 ASC, col399_405 DESC), col399_407 STRING NOT NULL AS (lower(col399_403)) VIRTUAL, col399_408 STRING NOT NULL AS (CASE WHEN col399_402 IS NULL THEN '1|':::STRING ELSE 'Eg':::STRING END) VIRTUAL, col399_409 STRING NOT NULL AS (lower(col399_403)) VIRTUAL, col399_410 STRING NOT NULL AS (lower(CAST(col399_405 AS STRING))) STORED, col399_411 STRING NOT NULL AS (lower(CAST(col399_406 AS STRING))) VIRTUAL, col399_412 STRING NOT NULL AS (lower(col399_403)) VIRTUAL, UNIQUE (col399_401 DESC, col399_407 DESC, col399_406 ASC, col399_409, col399_400 DESC, lower(CAST(col399_405 AS STRING)) DESC, col399_408, col399_412 ASC, col399_404, col399_411, col399_402 DESC, col399_410 DESC), FAMILY (col399_404), FAMILY (col399_405, col399_403), FAMILY (col399_402), FAMILY (col399_406, col399_400), FAMILY (col399_401, col399_410))"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"schema278.table399\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 92dfb8a4370274257b99cd9bccbe3854e243c268:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:01:01.180857",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:01:01.302437",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange SURVIVE ZONE FAILURE"
		  |  ],
		  |  "expectedExecErrors": "42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: database must have associated regions before a survival goal can be set (SQLSTATE 42602)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:01:01.180365",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema21 AUTHORIZATION root",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE public.table59 ALTER COLUMN \"IrrelevantColumnName\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table59\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:01:01.174211",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ c7d2f46924e8af82a3b2bf175e32adc1d44b06f7:

		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:50.590453",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema143 AUTHORIZATION root",
		  |   "CREATE TABLE IF NOT EXISTS public.table145 (col145_146 DATE, col145_147 VARCHAR, col145_148 FLOAT4, col145_149 DATE, col145_150 INT8 NULL, col145_151 TIMESTAMPTZ NOT NULL, col145_152 JSONB NULL, PRIMARY KEY (col145_151 DESC), col145_153 STRING NOT NULL AS (CASE WHEN col145_151 IS NULL THEN e'\\x15IW\\t':::STRING ELSE e'\\\\|0bC\\x16u':::STRING END) STORED, col145_154 STRING AS (CASE WHEN col145_146 IS NULL THEN e'$c6\\x14\\x03\\b\\x15':::STRING ELSE e'O_X~-:\\x1ei\\x1c':::STRING END) STORED, col145_155 STRING AS (lower(col145_147)) VIRTUAL, INDEX (col145_148 ASC, col145_146 ASC, col145_149, lower(CAST(col145_152 AS STRING)), (CASE WHEN col145_151 IS NULL THEN 'l.':::STRING ELSE e'\\x16':::STRING END) ASC, col145_147 ASC, col145_154, col145_155 DESC, col145_153 DESC, col145_151 ASC), INDEX (col145_154 DESC))",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:50.427458",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE TYPE public.enum176 AS ENUM ('aa')",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:50.803095",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table145 ADD COLUMN col145_151 CHAR NULL UNIQUE"
		  |  ],
		  |  "expectedExecErrors": "42701",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col145_151\" of relation \"table145\" already exists (SQLSTATE 42701)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:50.850256",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table145 ALTER COLUMN col145_155 SET DEFAULT NULL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: relation \"table145\" (116): computed column \"col145_155\" cannot also have a DEFAULT expression (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 9eb99ad45fdc4d52315b502a594c13ebbfabea94:

		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SEQUENCE IF EXISTS public.seq140",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:22:34.011521",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq232",
		  |   "DROP SEQUENCE schema197.seq252"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema197.seq252\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:22:33.345004",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum146 AS ENUM ('fdadas', 'addas', 'faa', 'dfasda', 'dafsff')",
		  |   "ALTER SEQUENCE public.seq149 RENAME TO public.seq173",
		  |   "DROP SEQUENCE IF EXISTS public.seq174",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq194",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:22:34.096142",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum234 AS ENUM ('sfdafd', 'fa', 'sffs')",
		  |   "CREATE TABLE IF NOT EXISTS public.table236 (col236_237 INET NULL, col236_238 NAME, col236_239 GEOGRAPHY NOT NULL, col236_240 REGCLASS NOT NULL, col236_241 REGPROC NULL, col236_242 TIMETZ, col236_243 REGPROC, col236_244 STRING AS (lower(CAST(col236_242 AS STRING))) VIRTUAL, col236_245 STRING NULL AS (CASE WHEN col236_241 IS NULL THEN NULL ELSE e'\\x0bqN':::STRING END) VIRTUAL, col236_246 STRING AS (lower(col236_238)) STORED, UNIQUE (col236_241 ASC, (CASE WHEN col236_243 IS NULL THEN 'TNU':::STRING ELSE e'\\'':::STRING END) ASC, col236_245 ASC, col236_240 DESC, col236_244 ASC, col236_246 ASC, col236_238 DESC) STORING (col236_237), UNIQUE (col236_244 ASC), INDEX (col236_243, col236_240, col236_245 ASC, col236_237) STORING (col236_239, col236_241), UNIQUE ((CASE WHEN col236_241 IS NULL THEN e'_@\\x04':::STRING ELSE 'fO^0!|':::STRING END) ASC, col236_237 ASC, col236_240), UNIQUE (col236_240 ASC, col236_238 ASC, col236_246 DESC, col236_244 DESC, col236_243), INVERTED INDEX (col236_242, col236_243 DESC, col236_246 ASC, col236_245 ASC, col236_237 ASC, col236_240, col236_241 ASC, col236_238, col236_244, col236_239 ASC))"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"public.table236\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ d7a023225d0db89453ebe3193d59678907e464f3:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:55:58.473199",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table67 RENAME TO public.table86",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=76b5be6d key=/Table/SystemConfigSpan/Start pri=0.01694565 epo=0 ts=1644825358.631288474,1 min=1644825358.473103268,0 seq=14} lock=true stat=PENDING rts=1644825358.473103268,0 wto=false gul=1644825358.973103268,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:55:58.702328",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: at least 3 regions are required for surviving a region failure (SQLSTATE 22023)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:55:58.405264",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER SEQUENCE public.seq88 RENAME TO public.seq89"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.seq88\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:55:58.220762",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE SCHEMA IF NOT EXISTS schema115 AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=09060a31 key=/Table/SystemConfigSpan/Start pri=0.02806312 epo=0 ts=1644825358.814556276,1 min=1644825358.220676451,0 seq=8} lock=true stat=PENDING rts=1644825358.220676451,0 wto=false gul=1644825358.720676451,0 (SQLSTATE 40001)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ c7cfac57476f06e3154b2fc38e77982a8bbc64c2:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:23.696553",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA public AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "42P06",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: schema \"public\" already exists (SQLSTATE 42P06)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:22.826885",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table12 ALTER COLUMN \"col12_13\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P16",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col12_13\" is in a primary index (SQLSTATE 42P16)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:22.66725",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table12 RENAME TO public.table34",
		  |   "ALTER TABLE public.table34 RENAME COLUMN \"col12_13\" TO \"col34_64\"",
		  |   "DROP TABLE IF EXISTS public.table34"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - intent pushed): \"sql txn\" meta={id=b425fae3 key=/Table/SystemConfigSpan/Start pri=0.02817083 epo=0 ts=1644912563.408522920,1 min=1644912562.667188729,0 seq=0} lock=true stat=PENDING rts=1644912562.667188729,0 wto=false gul=1644912563.167188729,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:22.930867",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table22 ALTER COLUMN \"col22_23\" DROP DEFAULT",
		  |   "ALTER TABLE public.table22 RENAME TO public.table73"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: ERROR: relation \"public.table22\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 22ddaccf3fa6cd672612063dcea9bcb52649661e:

		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table22 ALTER COLUMN col22_23 SET DEFAULT NULL",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:07:12.517627",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE public.table22 ALTER COLUMN \"col22_32\" DROP DEFAULT",
		  |   "ALTER TABLE public.table22 ALTER COLUMN \"col22_33\" DROP DEFAULT",
		  |   "CREATE TABLE IF NOT EXISTS public.table129 (col129_130 GEOGRAPHY NOT NULL, col129_131 UUID, col129_132 INT4 NOT NULL, col129_133 INET NOT NULL, col129_134 STRING NULL, col129_135 REGROLE NOT NULL, col129_136 TIMESTAMPTZ NOT NULL, col129_137 INT8, col129_138 NAME NOT NULL, col129_139 INT4 AS (col129_132 + col129_137) STORED, col129_140 STRING NULL AS (lower(col129_134)) STORED, col129_141 INT4 AS (col129_132 + col129_137) STORED, col129_142 INT8 AS (col129_137 + col129_132) STORED, UNIQUE (col129_140 ASC, col129_142 DESC, (col129_132 + col129_137)))",
		  |   "CREATE TYPE public.enum143 AS ENUM ('f', 'sasfa', 'saa')",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=29925c85 key=/Table/SystemConfigSpan/Start pri=0.00286321 epo=0 ts=1644998833.550657617,1 min=1644998832.517524909,0 seq=35} lock=true stat=PENDING rts=1644998832.517524909,0 wto=false gul=1644998833.017524909,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:07:12.955186",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table22 RENAME COLUMN \"col22_25\" TO \"col22_98\"",
		  |   "CREATE UNIQUE INDEX index22_144 ON public.table22 (col22_28 ASC, col22_24 DESC, col22_98 DESC, col22_32, col22_29 DESC, col22_27 ASC, col22_31, col22_30, col22_34, col22_33 ASC, col22_23 ASC, col22_26 DESC)"
		  |  ],
		  |  "expectedExecErrors": "0A000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: unimplemented: the following columns are not indexable due to their type: col22_98 (type jsonb), col22_29 (type jsonb), col22_31 (type jsonb) (SQLSTATE 0A000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:07:13.147668",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table22 ALTER COLUMN \"col22_31\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 60, db schemachange, schema public, name table22: mutation job 737045490664374273: job not found"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ d625926de309d74b43acc2e1fb11bf4fba607c25:

		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col42_56\" is not a stored computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:52:36.951929",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=084a0ff0 key=/Table/SystemConfigSpan/Start pri=0.03289725 epo=0 ts=1645084357.539150713,1 min=1645084356.951795956,0 seq=8} lock=true stat=PENDING rts=1645084356.951795956,0 wto=false gul=1645084357.451795956,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:52:37.035548",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=621eb245 key=/Table/SystemConfigSpan/Start pri=0.01963791 epo=0 ts=1645084357.604865322,1 min=1645084357.035457541,0 seq=8} lock=true stat=PENDING rts=1645084357.035457541,0 wto=false gul=1645084357.535457541,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:52:37.380371",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table42 ALTER COLUMN \"col42_86\" SET NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42703",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col42_86\" does not exist (SQLSTATE 42703)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:52:37.043743",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema84 AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=5248be84 key=/Table/SystemConfigSpan/Start pri=0.00779396 epo=0 ts=1645084357.629867297,1 min=1645084357.043704028,0 seq=8} lock=true stat=PENDING rts=1645084357.043704028,0 wto=false gul=1645084357.543704028,0 (SQLSTATE 40001)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 6133ffd5459ae01d79e3dfd98528e557bb868eca:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:10.459865",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq638",
		  |   "ALTER SEQUENCE public.seq638 RENAME TO public.seq646",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=04f80825 key=/Table/SystemConfigSpan/Start pri=0.01048106 epo=0 ts=1645171030.467498246,2 min=1645171030.459806016,0 seq=16} lock=true stat=PENDING rts=1645171030.459806016,0 wto=false gul=1645171030.959806016,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:10.161512",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:10.518316",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE public.table652 DROP CONSTRAINT IrrelevantConstraintName"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table652\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:10.140941",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 0bb1218f1c16dbebda16ace42d2d682b22aa3c96:

		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SEQUENCE public.seq73",
		  |   "ALTER TABLE public.table170 ALTER COLUMN \"col170_180\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col170_180\" is not a stored computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:07:01.699515",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table170 ALTER COLUMN \"col170_179\" DROP DEFAULT",
		  |   "ALTER TABLE public.table170 RENAME TO public.table254",
		  |   "DROP TABLE public.table254",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=22c58e81 key=/Table/SystemConfigSpan/Start pri=0.00879671 epo=0 ts=1645344422.424586967,1 min=1645344421.699446637,0 seq=26} lock=true stat=PENDING rts=1645344421.699446637,0 wto=false gul=1645344422.199446637,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:07:02.21103",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE TABLE public.table258 AS SELECT public.table243.col170_174, public.table243.col170_172, public.table243.col170_178, public.table243.col170_175, public.table243.col170_180, public.table243.col170_176, public.table243.col170_175, public.table243.col170_180, public.table243.col170_181, public.table243.col170_176, public.table243.col170_172 FROM public.table243, public.table243"
		  |  ],
		  |  "expectedExecErrors": "42701,42712",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: source name \"table243\" specified more than once (missing AS clause) (SQLSTATE 42712)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:07:02.42466",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum245 AS ENUM ('sf', 'aaasfa', 'sfdd')",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE public.table170 ALTER COLUMN col170_181 SET DEFAULT '\"':::STRING"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: relation \"table170\" (103): computed column \"col170_181\" cannot also have a DEFAULT expression (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 514b79fa4723584ea1359e0ad4118962a78c1a48:

		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:15.010574",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum1014 AS ENUM ('d', 'a', 'addaf', 'sad', 'afffd', 'fafads')",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:14.440124",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE schema473.enum997 AS ENUM ('sfsa', 'dsd', 'asasad', 'a', 'dsdaff')",
		  |   "CREATE TABLE IF NOT EXISTS public.table999 (col999_1000 INT8 NULL, col999_1001 INTERVAL NOT NULL, col999_1002 NAME NULL, col999_1003 INT8 NOT NULL, col999_1004 BIT(19) NOT NULL, col999_1005 JSONB, col999_1006 GEOGRAPHY NOT NULL, col999_1007 GEOMETRY, col999_1008 INT2, col999_1009 TIMESTAMP, col999_1010 INT2 AS (col999_1008 + col999_1003) VIRTUAL, col999_1011 STRING NOT NULL AS (lower(CAST(col999_1006 AS STRING))) VIRTUAL, FAMILY (col999_1000), FAMILY (col999_1001), FAMILY (col999_1002), FAMILY (col999_1006, col999_1009, col999_1004, col999_1007), FAMILY (col999_1003, col999_1005, col999_1008))",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:14.516264",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:13:14.537827",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema473.table995 ALTER COLUMN \"IrrelevantColumnName\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema473.table995\" does not exist (SQLSTATE 42P01)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 7609772f419a5bfe70028f27cb864e8058fdc6cc:

		  |  "clientTimestamp": "08:08:38.438915",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE SCHEMA schema705 AUTHORIZATION root",
		  |   "CREATE SEQUENCE IF NOT EXISTS schema705.seq717",
		  |   "ALTER TABLE public.table740 ALTER COLUMN IrrelevantColumnName DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table740\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:38.35813",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP VIEW IF EXISTS public.view694 CASCADE",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:37.968942",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=080e99e7 key=/Table/SystemConfigSpan/Start pri=0.01335205 epo=0 ts=1645690118.901795504,1 min=1645690117.968854498,0 seq=8} lock=true stat=PENDING rts=1645690117.968854498,0 wto=false gul=1645690118.468854498,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:08:38.126621",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE TABLE public.table720 (col720_721 CHAR NOT NULL, col720_722 FLOAT8 NOT NULL, col720_723 FLOAT4 NOT NULL, col720_724 TIME NOT NULL, col720_725 JSONB NULL, col720_726 \"char\" NOT NULL, col720_727 TIMESTAMPTZ NOT NULL, col720_728 BOX2D NOT NULL, col720_729 TIMETZ NOT NULL, col720_730 FLOAT4 NOT NULL, PRIMARY KEY (col720_728 DESC, col720_730, col720_729 ASC, col720_721 DESC, col720_722), col720_731 STRING NOT NULL AS (CASE WHEN col720_727 IS NULL THEN e'\\x1fg\\x04\\x1cTitsy':::STRING ELSE e'\\x07c\\'Gz':::STRING END) VIRTUAL, col720_732 BOOL NOT NULL AS (true) VIRTUAL, col720_733 FLOAT8 NOT NULL AS ((col720_722 + col720_723) + col720_730) VIRTUAL, col720_734 FLOAT4 NOT NULL AS (col720_723 + col720_730) VIRTUAL, INDEX (col720_734 ASC, col720_727, col720_722 ASC))"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"public.table720\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 9f653e24bbf10c30518de462a4942be8347edf20:

		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=b17d871f key=/Table/SystemConfigSpan/Start pri=0.00204104 epo=0 ts=1645775850.195389866,1 min=1645775849.730924340,0 seq=39} lock=true stat=PENDING rts=1645775849.730924340,0 wto=false gul=1645775850.230924340,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:30.053666",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: at least 3 regions are required for surviving a region failure (SQLSTATE 22023)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:29.715029",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE public.enum171 AS ENUM ('fa', 's', 'adafds', 'afaf', 'daasss', 'asffd')",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER INDEX public.table187@\"IrrelevantConstraintName\" RENAME TO \"OtherConstraintName\""
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table187\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:29.963453",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:57:30.228958",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42710",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: region \"us-east1\" already added to database (SQLSTATE 42710)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 311dc229bb0d3e932f988f88be9f312cb6026e46:

		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: unimplemented: cannot drop UNIQUE constraint \"table2_expr_key\" using ALTER TABLE DROP CONSTRAINT, use DROP INDEX CASCADE instead (SQLSTATE 0A000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:54:27.02058",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange ADD REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "42P12",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot add region \"us-east1\" to database schemachange (SQLSTATE 42P12)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:54:26.849249",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table144 RENAME TO public.table145"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table144\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:54:26.914318",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE public.table2 DROP CONSTRAINT \"table2_expr_key\""
		  |  ],
		  |  "expectedExecErrors": "0A000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: unimplemented: cannot drop UNIQUE constraint \"table2_expr_key\" using ALTER TABLE DROP CONSTRAINT, use DROP INDEX CASCADE instead (SQLSTATE 0A000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "07:54:26.563352",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\""
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"public.table2\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 89d2922ba1914a6b0c5209c85bb0079a55abce2f:

		  |  "clientTimestamp": "08:11:23.575105",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table30 DROP CONSTRAINT \"primary\"",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "0A000",
		  |  "message": "COMMIT; Successfully got expected commit error"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:11:23.40179",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table30 ALTER COLUMN \"col30_32\" DROP DEFAULT",
		  |   "ALTER TABLE public.table30 ADD COLUMN col30_220 TIME NOT NULL",
		  |   "CREATE TABLE public.table221 AS SELECT public.table30.col30_45, public.table30.col30_40, public.table30.col30_32, public.table30.col30_44, public.table30.col30_38, public.table30.col30_44, public.table30.col30_36, public.table30.col30_40, public.table30.col30_45, public.table30.col30_43 FROM public.table30, public.table30"
		  |  ],
		  |  "expectedExecErrors": "42701,42712",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: source name \"table30\" specified more than once (missing AS clause) (SQLSTATE 42712)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:11:22.952992",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table30 ALTER COLUMN \"col30_31\" SET NOT NULL",
		  |   "ALTER TABLE public.table30 ALTER COLUMN \"col30_43\" SET NOT NULL",
		  |   "ALTER TABLE public.table30 ALTER COLUMN \"col30_46\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col30_46\" is not a stored computed column (SQLSTATE 42611)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:11:23.039423",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE INDEX IF NOT EXISTS index30_206 ON public.table30 (col30_41 ASC, col30_45 ASC, col30_37 ASC, col30_46, col30_43, col30_36 ASC, col30_40 DESC, col30_35 DESC) STORING (col30_44, col30_38, col30_39)",
		  |   "ALTER TABLE public.table30 ALTER COLUMN col30_46 SET DEFAULT (-3.841043242939895976E+36):::DECIMAL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: relation \"table30\" (59): computed column \"col30_46\" cannot also have a DEFAULT expression (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 4093fcfe312ff3c37e60fe84d268a39a7280b90a:

		  |   "CREATE TYPE schema242.enum778 AS ENUM ('afd', 'sdfsa', 'sfasd', 'faf')",
		  |   "DROP TABLE IF EXISTS public.table779 RESTRICT",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023,42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: database must have associated regions before a survival goal can be set (SQLSTATE 42602)"
		  | }
		  |     7.0s        0           26.0           40.6      7.9    243.3    268.4    268.4 opOk
		  |     7.0s        0            6.0            8.3    570.4    738.2    738.2    738.2 txnCmtErr
		  |     7.0s        0            1.0            1.9     96.5     96.5     96.5     96.5 txnOk
		  |     7.0s        0           34.0           34.1      5.2    104.9    176.2    176.2 txnRbk
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:24:27.690567",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TYPE schema50.enum755 AS ENUM ('sa', 'ddfsfs', 'asssfs', 'addf')",
		  |   "ALTER TABLE schema242.table644 ALTER COLUMN \"col644_657\" DROP DEFAULT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=8aca3e38 key=/Table/SystemConfigSpan/Start pri=0.03178949 epo=0 ts=1646123067.816184096,1 min=1646123067.690416804,0 seq=9} lock=true stat=ABORTED rts=1646123067.690416804,0 wto=false gul=1646123068.190416804,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:24:27.816244",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:24:27.746673",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema242.table644 RENAME TO schema242.table758",
		  |   "CREATE UNIQUE INDEX index758_782 ON schema242.table758 (col644_658 ASC, col644_645 ASC, col644_652, col644_649 DESC, col644_661, col644_656 ASC, col644_648 ASC, col644_647, col644_657, col644_650 ASC, col644_655 ASC, col644_653 ASC, col644_651 ASC, col644_660 DESC, col644_659, col644_646) STORING (col644_654)"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 276, db schemachange, schema schema242, name table758: mutation job 740729382438076417: job not found"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 93a02dffaabcca5e453c8d62e9cd0051c123a18b:

		  |   | ./workload run schemachange --verbose=1 --tolerate-errors=false  --histograms=perf/stats.json --max-ops 10000 --concurrency 20 --txn-log /mnt/data1/cockroach/transactions.json
		  |   | ``````
		  | 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 ...>
		  |                                  = descriptor_ids.id\\n                   ),\\n       types AS (\\n                SELECT descriptor\\n                  FROM descriptors\\n                 WHERE (descriptor-\u003e'type') IS NOT NULL\\n             ),\\n       table_references AS (\\n                            SELECT json_array_elements(\\n                                    descriptor-\u003e'table'-\u003e'dependedOnBy'\\n                                   ) AS ref\\n                              FROM descriptors\\n                             WHERE (descriptor-\u003e'table') IS NOT NULL\\n                        ),\\n       dependent AS (\\n                    SELECT (ref-\u003e\u003e'id')::INT8 AS id FROM table_references\\n                 ),\\n       referenced_descriptors AS (\\n                                SELECT json_array_elements_text(\\n                                        descriptor-\u003e'type'-\u003e'referencingDescriptorIds'\\n                                       )::INT8 AS id\\n                                  FROM types\\n                              )\\nSELECT EXISTS(\\n        SELECT *\\n          FROM system.namespace\\n         WHERE id IN (SELECT id FROM referenced_descriptors)\\n           AND \\\"parentSchemaID\\\" NOT IN (SELECT id FROM schema_id)\\n           AND id NOT IN (SELECT id FROM dependent)\\n       );\" [\"public\"]: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_PUSHER_ABORTED): \"sql txn\" meta={id=c3c776df key=/Table/SystemConfigSpan/Start pri=0.00386899 epo=0 ts=1646208878.965115355,1 min=1646208878.690721346,0 seq=16} lock=true stat=ABORTED rts=1646208878.690721346,0 wto=false gul=1646208879.190721346,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:14:38.681812",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA schema209 AUTHORIZATION root",
		  |   "DROP SCHEMA \"schema209\" CASCADE",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq237",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=9d580e40 key=/Table/SystemConfigSpan/Start pri=0.02314704 epo=0 ts=1646208879.141802324,1 min=1646208878.681742041,0 seq=45} lock=true stat=PENDING rts=1646208878.681742041,0 wto=false gul=1646208879.181742041,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:14:38.685889",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER DATABASE schemachange SURVIVE ZONE FAILURE",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=fc9ecef3 key=/Table/SystemConfigSpan/Start pri=0.00036908 epo=0 ts=1646208879.141802324,1 min=1646208878.685810759,0 seq=16} lock=true stat=PENDING rts=1646208878.685810759,0 wto=false gul=1646208879.185810759,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:14:38.471741",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE schema1.table216 (col216_217 FLOAT4 NOT NULL, PRIMARY KEY (col216_217 ASC), UNIQUE (col216_217 DESC), UNIQUE ((col216_217 + '-Inf':::FLOAT8) ASC), INDEX (col216_217 DESC), INDEX (col216_217 ASC), UNIQUE (col216_217 ASC))",
		  |   "CREATE SCHEMA IF NOT EXISTS schema219 AUTHORIZATION root"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"schema1.table216\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 16bfeec562bf793f958fe9583eaa051d7ba9341c:

		  |  "expectedCommitErrors": "",
		  |  "message": ""
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:35.146778",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table147 RENAME TO public.table289",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=8f0a9c54 key=/Table/SystemConfigSpan/Start pri=0.01086346 epo=0 ts=1646294976.035079553,2 min=1646294975.146711161,0 seq=14} lock=true stat=PENDING rts=1646294975.146711161,0 wto=false gul=1646294975.646711161,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:35.872323",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER VIEW public.view313 RENAME TO public.view314"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.view313\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:36.134456",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table318 SET LOCALITY REGIONAL BY ROW"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table318\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:09:35.259611",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table147 ALTER COLUMN \"col147_156\" SET NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 94, db schemachange, schema public, name table147: mutation job 741292689315790849: job not found"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ c72adc72a1aef01f0902fe004d7262d3fc685144:

		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot alter a table's LOCALITY if its database is not multi-region enabled (SQLSTATE 42P16)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:06:03.429899",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER VIEW public.view297 RENAME TO public.view354",
		  |   "CREATE VIEW public.view384 AS SELECT public.table336.col336_339, public.table336.col336_341, public.table336.col336_338, public.table336.col336_337, public.table248.col248_250, public.table248.col248_249, public.table248.col248_249, public.table248.col248_260 FROM public.table336, public.table248, public.table248"
		  |  ],
		  |  "expectedExecErrors": "42701,42712",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: source name \"table248\" specified more than once (missing AS clause) (SQLSTATE 42712)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:06:03.655983",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table258 ALTER COLUMN \"col258_385\" SET NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42703",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col258_385\" does not exist (SQLSTATE 42703)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:06:03.679659",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table258 RENAME TO public.table388"
		  |  ],
		  |  "expectedExecErrors": "2BP01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot rename relation \"public.table258\" because view \"view297\" depends on it (SQLSTATE 2BP01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:06:03.7632",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE public.table369 ALTER COLUMN col369_378 SET DEFAULT false"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: relation \"table369\" (196): computed column \"col369_378\" cannot also have a DEFAULT expression (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 08814ae47e600692591605f9f811701e638981aa:

		  |  "workerId": 0,
		  |  "clientTimestamp": "08:23:28.264247",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE IF EXISTS public.table28 CASCADE",
		  |   "CREATE TABLE public.table40 AS SELECT \"IrrelevantColumnName\" FROM public.table39"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"public.table39\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:23:28.260919",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SCHEMA IF NOT EXISTS schema3 AUTHORIZATION root",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq42",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=fe2107bf key=/Table/SystemConfigSpan/Start pri=0.00351439 epo=0 ts=1646727808.318599293,1 min=1646727808.260839989,0 seq=23} lock=true stat=PENDING rts=1646727808.260839989,0 wto=false gul=1646727808.760839989,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:23:28.261599",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq24",
		  |   "DROP SCHEMA \"public\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "3F000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot drop schema \"public\" (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:23:28.264787",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table5 (col5_6 TIMETZ[] NULL, col5_7 NAME NULL, col5_8 CHAR NULL, col5_9 DATE NOT NULL, col5_10 \"char\" NULL, col5_11 BIT(16) NULL, col5_12 INT8 NULL, col5_13 REGPROCEDURE NULL, col5_14 BOOL NULL, col5_15 GEOGRAPHY NOT NULL, col5_16 CHAR NULL, col5_17 NAME[] NULL, col5_18 BOX2D, col5_19 STRING AS (lower(CAST(col5_18 AS STRING))) VIRTUAL, col5_20 INT8 NULL AS (col5_12 + 8373031044963958754:::INT8) VIRTUAL, col5_21 STRING NULL AS (CASE WHEN col5_17 IS NULL THEN e'\\\\_Kf2\\x0eG ':::STRING ELSE e'haI\\x1a':::STRING END) VIRTUAL, col5_22 STRING AS (lower(CAST(col5_18 AS STRING))) STORED, col5_23 STRING NULL AS (CASE WHEN col5_17 IS NULL THEN e'0\\f9U\\x02\\'\\x04\\x0bQ':::STRING ELSE '':::STRING END) VIRTUAL, UNIQUE (col5_18 ASC), FAMILY (col5_7), FAMILY (col5_16, col5_10, col5_11), FAMILY (col5_6), FAMILY (col5_13, col5_12), FAMILY (col5_18), FAMILY (col5_22, col5_17, col5_9, col5_14), FAMILY (col5_8), FAMILY (col5_15))",
		  |   "ALTER TABLE public.table5 ALTER COLUMN col5_21 SET DEFAULT e'\\x17,1#?|\\t':::STRING"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: relation \"table5\" (54): computed column \"col5_21\" cannot also have a DEFAULT expression (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 37dee546a7c52870a8dc58826f0cffe2afa8d47a:

		  |  "clientTimestamp": "08:10:29.512958",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "CREATE TABLE IF NOT EXISTS public.table685 (col685_686 NAME NOT NULL, PRIMARY KEY (col685_686 DESC), UNIQUE (col685_686 DESC), UNIQUE (col685_686), INDEX (col685_686), UNIQUE (col685_686), UNIQUE (col685_686), UNIQUE (col685_686), UNIQUE (col685_686 ASC), INDEX (col685_686), UNIQUE (col685_686 DESC))",
		  |   "ALTER TABLE schema638.table689 ALTER COLUMN IrrelevantColumnName SET NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema638.table689\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:27.758612",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP TABLE IF EXISTS schema31.table484",
		  |   "CREATE TYPE schema31.enum690 AS ENUM ('sdasds', 'saaffa', 'fadsda', 'fffs', 'fffad', 'fdd')",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=53d26e3f key=/Table/SystemConfigSpan/Start pri=0.06190655 epo=0 ts=1646813429.556249366,1 min=1646813427.758561198,0 seq=22} lock=true stat=PENDING rts=1646813427.758561198,0 wto=false gul=1646813428.258561198,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:28.147839",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema31.table484 ALTER COLUMN \"col326_339\" DROP DEFAULT",
		  |   "ALTER TABLE schema31.table484 SET LOCALITY REGIONAL BY ROW"
		  |  ],
		  |  "expectedExecErrors": "42P16",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot alter a table's LOCALITY if its database is not multi-region enabled (SQLSTATE 42P16)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:27.884391",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE schema31.table484 ALTER COLUMN \"col326_331\" SET NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: Validation FAIL:\nid 195, db schemachange, schema schema31, name table484: mutation job 742991555639345153: job not found"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ a7d42a38a7843fa4f83c83a0b574935a2bc44efb:

		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=51a99d8a key=/Table/SystemConfigSpan/Start pri=0.00529089 epo=0 ts=1646899806.553310620,1 min=1646899806.163392836,0 seq=26} lock=true stat=PENDING rts=1646899806.163392836,0 wto=false gul=1646899806.663392836,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:05.884513",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"schema1337\" CASCADE",
		  |   "ALTER DATABASE schemachange SURVIVE REGION FAILURE"
		  |  ],
		  |  "expectedExecErrors": "22023,42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: database must have associated regions before a survival goal can be set (SQLSTATE 42602)"
		  | }
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |    21.0s        0           40.0           35.0     19.9    352.3    369.1    369.1 opOk
		  |    21.0s        0            8.0            6.6    486.5    805.3    805.3    805.3 txnCmtErr
		  |    21.0s        0            2.0            2.2    125.8    402.7    402.7    402.7 txnOk
		  |    21.0s        0           24.0           26.8      1.8    201.3    419.4    419.4 txnRbk
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:05.999537",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SEQUENCE IF EXISTS public.seq1205",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER TABLE schema1337.table1693 ALTER COLUMN \"IrrelevantColumnName\" DROP NOT NULL"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema1337.table1693\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:06.17277",
		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE TABLE IF NOT EXISTS public.table1673 (col1673_1674 REGCLASS NOT NULL, col1673_1675 FLOAT8 NOT NULL, col1673_1676 REGPROCEDURE NOT NULL, col1673_1677 UUID NOT NULL, col1673_1678 REGNAMESPACE NULL, PRIMARY KEY (col1673_1675, col1673_1677 DESC), col1673_1679 STRING NOT NULL AS (CASE WHEN col1673_1674 IS NULL THEN 'C/M':::STRING ELSE '3TU.NoYW':::STRING END) STORED, col1673_1680 STRING NULL AS (CASE WHEN col1673_1678 IS NULL THEN e'\\x011\\x0ba[\"Wm\u0026':::STRING ELSE e'.F_R$\\x19q':::STRING END) STORED, col1673_1681 STRING NOT NULL AS (lower(CAST(col1673_1677 AS STRING))) VIRTUAL, col1673_1682 STRING NOT NULL AS (lower(CAST(col1673_1677 AS STRING))) VIRTUAL, INDEX (col1673_1676 ASC, col1673_1675 ASC) STORING (col1673_1679), UNIQUE (col1673_1675 ASC, col1673_1678), INDEX (col1673_1678 DESC), UNIQUE (col1673_1679, col1673_1676 DESC, col1673_1674, col1673_1682, col1673_1680, col1673_1677 DESC, col1673_1675, col1673_1681, col1673_1678 DESC), UNIQUE (col1673_1679 DESC), INDEX (col1673_1677 ASC, col1673_1675, col1673_1680) STORING (col1673_1676, col1673_1678, col1673_1679), INDEX (col1673_1681, col1673_1679, col1673_1674, col1673_1677, col1673_1682 ASC, col1673_1676, col1673_1678 ASC, col1673_1675 DESC))",
		  |   "ALTER TABLE public.table1673 ALTER COLUMN col1673_1680 SET DEFAULT e'\\x16Cm\\f\\x1d\\fs':::STRING"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: relation \"table1673\" (610): computed column \"col1673_1680\" cannot also have a DEFAULT expression (SQLSTATE 42P16)"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ ccff2c10d776491becd004bb62cb0773eb9fcfa6:

		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: unimplemented: cannot drop UNIQUE constraint \"table147_col147_148_key\" using ALTER TABLE DROP CONSTRAINT, use DROP INDEX CASCADE instead (SQLSTATE 0A000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:43.618598",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema25.table135 ALTER COLUMN col135_141 SET DEFAULT 1004332025:::OID"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - intent pushed): \"sql txn\" meta={id=c33541e5 key=/Table/SystemConfigSpan/Start pri=0.10306686 epo=0 ts=1646986243.970278908,1 min=1646986243.618528664,0 seq=0} lock=true stat=PENDING rts=1646986243.618528664,0 wto=false gul=1646986244.118528664,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:43.704723",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "CREATE INDEX \"IrrelevantName\" ON schema25.table159 (\"IrrelevantColumn\" ASC)"
		  |  ],
		  |  "expectedExecErrors": "42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema25.table159\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:43.543637",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SCHEMA \"schema25\" CASCADE"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): \"sql txn\" meta={id=9b99b310 key=/Table/SystemConfigSpan/Start pri=0.00119228 epo=0 ts=1646986243.969319302,1 min=1646986243.543597814,0 seq=10} lock=true stat=PENDING rts=1646986243.543597814,0 wto=false gul=1646986244.043597814,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:10:43.605702",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"schema25.table135\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on release-21.2 @ 9d6589f3cf8772899902429333f0707ddca083cf:

		  |  "ops": [
		  |   "BEGIN",
		  |   "CREATE SEQUENCE IF NOT EXISTS public.seq64",
		  |   "ALTER SEQUENCE public.seq64 RENAME TO public.seq143",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=88a498bb key=/Table/SystemConfigSpan/Start pri=0.00166502 epo=0 ts=1647072958.268542798,1 min=1647072957.385920945,0 seq=14} lock=true stat=PENDING rts=1647072957.385920945,0 wto=false gul=1647072957.885920945,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:15:57.458038",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "COMMIT"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "TXN RETRY ERROR; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): \"sql txn\" meta={id=627fd6f8 key=/Table/SystemConfigSpan/Start pri=0.01413925 epo=0 ts=1647072958.298960821,1 min=1647072957.457894160,0 seq=16} lock=true stat=PENDING rts=1647072957.457894160,0 wto=false gul=1647072957.957894160,0 (SQLSTATE 40001)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:15:57.197621",
		  |  "ops": [
		  |   "BEGIN",
		  |   "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()",
		  |   "ALTER DATABASE schemachange PRIMARY REGION \"us-east1\"",
		  |   "ALTER SEQUENCE public.seq64 RENAME TO schema205.seq206"
		  |  ],
		  |  "expectedExecErrors": "3F000,42602",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot create \"schema205.seq206\" because the target database or schema does not exist (SQLSTATE 3F000)"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "08:15:57.781508",
		  |  "ops": [
		  |   "BEGIN",
		  |   "DROP SEQUENCE IF EXISTS public.seq183",
		  |   "CREATE TABLE IF NOT EXISTS public.table184 (col184_185 GEOMETRY NULL, col184_186 DATE, col184_187 REGTYPE NOT NULL, col184_188 BYTES, col184_189 REGROLE, col184_190 REGNAMESPACE NULL, col184_191 BIT(36), col184_192 TIMETZ NULL, col184_193 BIT(29) NULL, col184_194 UUID NOT NULL, col184_195 FLOAT8, col184_196 BOOL NOT NULL, col184_197 REGROLE NOT NULL, col184_198 UUID[], col184_199 INTERVAL NOT NULL, col184_200 BIT(13), col184_201 NAME, PRIMARY KEY (col184_197 DESC, col184_187 DESC, col184_194 ASC), col184_202 STRING NULL AS (lower(CAST(col184_192 AS STRING))) VIRTUAL, col184_203 STRING AS (CASE WHEN col184_189 IS NULL THEN e'up\\x19':::STRING ELSE e'\\x1c@K\\t':::STRING END) STORED, UNIQUE (col184_187 DESC, col184_203 DESC), INDEX (col184_200 ASC, col184_195 ASC, col184_188 DESC, col184_191 ASC, col184_202 DESC, col184_190 DESC, col184_203 DESC, col184_196, col184_199 ASC), FAMILY (col184_203), FAMILY (col184_191, col184_185, col184_198), FAMILY (col184_193, col184_188, col184_195), FAMILY (col184_194, col184_192, col184_199), FAMILY (col184_186, col184_201), FAMILY (col184_197, col184_189), FAMILY (col184_187), FAMILY (col184_190, col184_200), FAMILY (col184_196))"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Failed to generate a random operation: scanBool: \"\\n\\t\\tSELECT json_array_length(\\n        crdb_internal.pb_to_json(\\n            'cockroach.sql.sqlbase.Descriptor',\\n            descriptor\\n        )-\u003e'table'-\u003e'mutations'\\n       )\\n       \u003e 0\\n\\t\\tFROM system.descriptor\\n\\t  WHERE id = $1::REGCLASS\\n\\t\\t\" [\"public.table184\"]: can't scan into dest[0]: cannot assign NULL to *bool"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *exec.ExitError
Reproduce

See: roachtest README

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

@healthy-pod healthy-pod added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-schema-deprecated Use T-sql-foundations instead labels May 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@jlinder @postamar @cockroach-teamcity @healthy-pod