internal/sqlsmith: TestSetups failed

[cockroach-teamcity]

(internal/sqlsmith).TestSetups failed on release-20.2@018118fd4647ff4f4a86241981d7293bc981c9fd:

I201019 22:05:27.501030 4954 server/server.go:1538  [n1] advertising CockroachDB node at 127.0.0.1:33873
I201019 22:05:27.546583 4954 sql/sqlliveness/slinstance/slinstance.go:252  [n1] starting SQL liveness instance
I201019 22:05:27.548016 5185 sql/temporary_schema.go:497  [n1] running temporary object cleanup background job
I201019 22:05:27.552823 5143 kv/kvserver/replica_rangefeed.go:608  [n1,s1,r6/1:/Table/{SystemCon…-11}] RangeFeed closed timestamp is empty
I201019 22:05:27.566655 5185 sql/temporary_schema.go:532  [n1] found 0 temporary schemas
I201019 22:05:27.566901 5185 sql/temporary_schema.go:535  [n1] early exiting temporary schema cleaner as no temporary schemas were found
I201019 22:05:27.567090 5185 sql/temporary_schema.go:536  [n1] completed temporary object cleanup job
I201019 22:05:27.567234 5185 sql/temporary_schema.go:614  [n1] temporary object cleaner next scheduled to run at 2020-10-19 22:35:27.547724172 +0000 UTC
I201019 22:05:27.575628 5183 sql/sqlliveness/slstorage/slstorage.go:342  [n1] inserted sqlliveness session e303d68e266c44c7ac1b598e8b72aa4a
I201019 22:05:27.575942 5183 sql/sqlliveness/slinstance/slinstance.go:143  [n1] created new SQL liveness session e303d68e266c44c7ac1b598e8b72aa4a
I201019 22:05:27.596485 5181 sql/event_log.go:146  [n1] Event: "node_join", target: 1, info: {Descriptor:{NodeID:1 Address:127.0.0.1:33873 Attrs: Locality: ServerVersion:20.2 BuildTag:v20.2.0-rc.1-42-g018118fd46 StartedAt:1603145127441735418 LocalityAddress:[] ClusterName: SQLAddress:127.0.0.1:39287} ClusterID:8a2a4898-5ab3-4436-a2b6-c5332e0f2ce5 StartedAt:1603145127441735418 LastUp:1603145127441735418}
I201019 22:05:27.616683 5586 sql/event_log.go:146  [n1,intExec=optInToDiagnosticsStatReporting] Event: "set_cluster_setting", target: 0, info: {SettingName:diagnostics.reporting.enabled Value:true User:root}
I201019 22:05:27.683466 5519 sql/event_log.go:146  [n1,intExec=set-setting] Event: "set_cluster_setting", target: 0, info: {SettingName:version Value:20.2 User:root}
I201019 22:05:27.819551 5594 sql/event_log.go:146  [n1,intExec=initializeClusterSecret] Event: "set_cluster_setting", target: 0, info: {SettingName:cluster.secret Value:8b3cc77a-bacb-42c9-8940-7e2f04af00e8 User:root}
I201019 22:05:27.866337 6051 sql/event_log.go:146  [n1,intExec=create-default-db] Event: "create_database", target: 50, info: {DatabaseName:defaultdb Statement:CREATE DATABASE IF NOT EXISTS defaultdb User:root}
I201019 22:05:27.898622 6041 sql/event_log.go:146  [n1,intExec=create-default-db] Event: "create_database", target: 51, info: {DatabaseName:postgres Statement:CREATE DATABASE IF NOT EXISTS postgres User:root}
I201019 22:05:28.033328 4954 server/server_sql.go:753  [n1] done ensuring all necessary migrations have run
I201019 22:05:28.033541 4954 server/server.go:1870  [n1] serving sql connections
I201019 22:05:28.034171 6250 jobs/job_scheduler.go:346  [n1] waiting 3m0s before scheduled jobs daemon start
I201019 22:05:28.053619 6251 server/server_update.go:55  [n1] no need to upgrade, cluster already at the newest version
I201019 22:05:28.130558 6292 sql/event_log.go:146  [n1,client=127.0.0.1:42764,hostssl,user=root] Event: "set_cluster_setting", target: 0, info: {SettingName:sql.stats.automatic_collection.enabled Value:false User:root}
I201019 22:05:28.165378 6292 sql/event_log.go:146  [n1,client=127.0.0.1:42764,hostssl,user=root] Event: "set_cluster_setting", target: 0, info: {SettingName:sql.stats.histogram_collection.enabled Value:false User:root}
I201019 22:05:28.215338 6292 sql/event_log.go:146  [n1,client=127.0.0.1:42764,hostssl,user=root] Event: "create_table", target: 52, info: {TableName:defaultdb.public.table1 Statement:CREATE TABLE table1 (col1_0 "char" NULL, col1_1 TIMESTAMPTZ NOT NULL, col1_2 CHAR NOT NULL, col1_3 INT8, col1_4 FLOAT8 NOT NULL, col1_5 REGPROC NULL, col1_6 DATE NOT NULL, col1_7 OID, col1_8 DECIMAL NOT NULL, col1_9 BIT(26) NOT NULL, col1_10 BOOL, col1_11 TIME NOT NULL, col1_12 TIMESTAMP NULL, PRIMARY KEY (col1_6 ASC, col1_11, col1_9 ASC, col1_2 ASC, col1_8), INDEX (col1_0 DESC, col1_10, col1_11 ASC, col1_3, col1_9, col1_6 ASC, col1_1, col1_2, col1_8) STORING (col1_4, col1_5, col1_7), INDEX (col1_5 ASC) STORING (col1_1, col1_3, col1_4, col1_7, col1_10) WHERE (((((((((table1.col1_12 >= '0001-01-01 00:00:00':::TIMESTAMP) OR (table1.col1_4 < 1.7976931348623157e+308:::FLOAT8)) OR (table1.col1_6 <= 'infinity':::DATE)) AND (table1.col1_11 != '24:00:00':::TIME)) AND (table1.col1_3 = (-128):::INT8)) AND (table1.col1_1 <= '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) AND (table1.col1_2 > '':::STRING)) OR (table1.col1_8 >= 1:::DECIMAL)) OR table1.col1_10) OR (table1.col1_0 > e'\'':::STRING), INDEX (col1_12 ASC, col1_7 DESC, col1_6 DESC, col1_2 DESC, col1_3 DESC, col1_5 ASC, col1_10 ASC, col1_1 ASC, col1_8 ASC, col1_9 DESC, col1_4 ASC, col1_0, col1_11) WHERE ((((((table1.col1_11 = '00:00:00':::TIME) OR (table1.col1_3 <= (-9223372036854775807):::INT8)) OR (table1.col1_12 < '294276-12-31 23:59:59.999999':::TIMESTAMP)) OR (table1.col1_0 > e'\U00002603':::STRING)) OR (table1.col1_1 <= '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) OR (table1.col1_6 >= '5874897-12-31':::DATE)) AND (table1.col1_4 > '+Inf':::FLOAT8), UNIQUE (col1_12 ASC, col1_1 ASC, col1_10, col1_3, col1_5, col1_9 DESC, col1_8 DESC, col1_4 DESC, col1_11 DESC, col1_0 ASC, col1_6 ASC) STORING (col1_7), INDEX (col1_1 ASC, col1_4, col1_11, col1_7, col1_0 DESC, col1_8 ASC, col1_6 ASC, col1_12, col1_9 ASC, col1_2 ASC, col1_3, col1_10 DESC, col1_5), INDEX (col1_10 ASC, col1_2, col1_9 DESC, col1_1 ASC, col1_8 DESC, col1_12, col1_4, col1_6, col1_5, col1_7 DESC, col1_11 ASC) STORING (col1_3)) User:root}
I201019 22:05:28.227067 6428 kv/kvserver/replica_command.go:414  [n1,split,s1,r35/1:/{Table/39-Max}] initiating a split of this range at key /Table/52 [r36] (zone config)
I201019 22:05:28.264407 6292 sql/event_log.go:146  [n1,client=127.0.0.1:42764,hostssl,user=root] Event: "create_table", target: 53, info: {TableName:defaultdb.public.table2 Statement:CREATE TABLE table2 (col2_0 CHAR NOT NULL, col2_1 STRING NOT NULL, col2_2 REGPROC NOT NULL, col2_3 REGNAMESPACE NOT NULL, col2_4 TIMESTAMPTZ NOT NULL, col2_5 INT2 NOT NULL, col2_6 TIMESTAMPTZ NOT NULL, col2_7 NAME NOT NULL, col2_8 TIMESTAMP NOT NULL, col2_9 BOX2D NOT NULL, col2_10 FLOAT4 NOT NULL, col2_11 TIMESTAMPTZ NOT NULL, col2_12 BOX2D NOT NULL, col2_13 CHAR NOT NULL, col2_14 REGPROC NOT NULL, col2_15 "char" NOT NULL, col2_16 STRING NOT NULL, col2_17 UUID NOT NULL, col2_18 DECIMAL NOT NULL, PRIMARY KEY (col2_5, col2_2, col2_3 ASC, col2_16 ASC, col2_8 DESC, col2_10, col2_18 DESC, col2_7 DESC, col2_9 ASC, col2_12 ASC, col2_4, col2_14, col2_6, col2_1 DESC, col2_0 ASC, col2_13, col2_17, col2_15 DESC, col2_11 ASC), INDEX (col2_8 ASC, col2_2 ASC, col2_13 DESC, col2_16 DESC, col2_14 ASC, col2_18 ASC, col2_12 ASC, col2_3 ASC, col2_0, col2_15 DESC), INDEX (col2_5 DESC, col2_10, col2_12, col2_9 DESC), INDEX (col2_9 DESC, col2_6 DESC, col2_18 DESC, col2_4 ASC, col2_7, col2_16, col2_5 DESC, col2_2 ASC, col2_10 ASC, col2_1, col2_15, col2_14 DESC, col2_8, col2_0 ASC) WHERE (((((((((table2.col2_18 >= (-1.234E+401):::DECIMAL) AND (table2.col2_10 < '-Inf':::FLOAT8)) AND (table2.col2_4 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_0 > 'X':::STRING)) OR (table2.col2_1 > '':::STRING)) AND (table2.col2_8 = '294276-12-31 23:59:59.999999':::TIMESTAMP)) OR (table2.col2_13 < '"':::STRING)) OR (table2.col2_5 < 0:::INT8)) OR (table2.col2_11 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_16 = e'\x00':::STRING), UNIQUE (col2_1 DESC, col2_11 ASC, col2_18 DESC, col2_2, col2_14 ASC, col2_3, col2_5, col2_12, col2_7), INDEX (col2_4 DESC, col2_18 DESC, col2_3 DESC, col2_9 ASC, col2_12 ASC, col2_2, col2_11, col2_0 DESC, col2_5 DESC, col2_13 DESC, col2_10, col2_14 ASC), FAMILY (col2_7), FAMILY (col2_15, col2_5), FAMILY (col2_1), FAMILY (col2_14, col2_13), FAMILY (col2_2), FAMILY (col2_9), FAMILY (col2_16), FAMILY (col2_18), FAMILY (col2_8), FAMILY (col2_17), FAMILY (col2_12, col2_4, col2_0, col2_3), FAMILY (col2_6), FAMILY (col2_10, col2_11)) User:root}
I201019 22:05:28.268065 6476 kv/kvserver/replica_command.go:414  [n1,split,s1,r36/1:/{Table/52-Max}] initiating a split of this range at key /Table/53 [r37] (zone config)
I201019 22:05:28.304979 6292 sql/event_log.go:146  [n1,client=127.0.0.1:42764,hostssl,user=root] Event: "create_table", target: 54, info: {TableName:defaultdb.public.table3 Statement:CREATE TABLE table3 (col3_0 INT8 NOT NULL, col3_1 INT4 NOT NULL, col3_2 BOX2D NOT NULL, col3_3 TIMETZ NOT NULL, col3_4 INT2 NOT NULL, col3_5 REGTYPE NOT NULL, col3_6 INTERVAL NOT NULL, col3_7 DECIMAL NOT NULL, col3_8 BOOL, col3_9 REGPROC NULL, col3_10 INET NOT NULL, col3_11 BOOL NOT NULL, col3_12 TIME NOT NULL, col3_13 REGTYPE NOT NULL, col3_14 INET NOT NULL, col3_15 TIMETZ NOT NULL, col3_16 TIMESTAMPTZ NOT NULL, col3_17 TIMESTAMP NULL, col3_18 BYTES NOT NULL, PRIMARY KEY (col3_13, col3_5 ASC, col3_14 ASC, col3_15, col3_0, col3_3 ASC, col3_2 DESC, col3_12, col3_1, col3_11 ASC, col3_4, col3_16 ASC, col3_6 DESC, col3_10), UNIQUE (col3_12, col3_16) WHERE table3.col3_7 <= 'Infinity':::DECIMAL) User:root}
I201019 22:05:28.308995 6648 kv/kvserver/replica_command.go:414  [n1,split,s1,r37/1:/{Table/53-Max}] initiating a split of this range at key /Table/54 [r38] (zone config)
I201019 22:05:28.338477 4954 util/stop/stopper.go:563  quiescing
W201019 22:05:28.338765 5183 sql/sqlliveness/slinstance/slinstance.go:182  [n1] exiting heartbeat loop
I201019 22:05:28.339207 5024 kv/kvclient/kvcoord/transport_race.go:108  transport race promotion: ran 44 iterations on up to 682 requests
W201019 22:05:28.338981 5683 kv/kvserver/intentresolver/intent_resolver.go:770  failed to gc transaction record: could not GC completed transaction anchored at /Table/SystemConfigSpan/Start: node unavailable; try another peer
W201019 22:05:28.338854 5546 jobs/registry.go:669  canceling all adopted jobs due to stopper quiescing
W201019 22:05:28.341014 6648 kv/txn.go:618  [n1,split,s1,r37/1:/{Table/53-Max}] failure aborting transaction: node unavailable; try another peer; abort caused by: failed to send RPC: sending to all replicas failed; last error: node unavailable; try another peer
E201019 22:05:28.341641 6648 kv/kvserver/queue.go:1087  [n1,split,s1,r37/1:/{Table/53-Max}] unable to split [n1,s1,r37/1:/{Table/53-Max}] at key "/Table/54": split at key /Table/54 failed: failed to send RPC: sending to all replicas failed; last error: node unavailable; try another peer
    --- FAIL: TestSetups/rand-tables (1.05s)
        sqlsmith_test.go:51: 
            		SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;
            		SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;
            	CREATE TABLE table1 (col1_0 "char" NULL, col1_1 TIMESTAMPTZ NOT NULL, col1_2 CHAR NOT NULL, col1_3 INT8, col1_4 FLOAT8 NOT NULL, col1_5 REGPROC NULL, col1_6 DATE NOT NULL, col1_7 OID, col1_8 DECIMAL NOT NULL, col1_9 BIT(26) NOT NULL, col1_10 BOOL, col1_11 TIME NOT NULL, col1_12 TIMESTAMP NULL, PRIMARY KEY (col1_6 ASC, col1_11, col1_9 ASC, col1_2 ASC, col1_8), INDEX (col1_0 DESC, col1_10, col1_11 ASC, col1_3, col1_9, col1_6 ASC, col1_1, col1_2, col1_8) STORING (col1_4, col1_5, col1_7), INDEX (col1_5 ASC) STORING (col1_1, col1_3, col1_4, col1_7, col1_10) WHERE (((((((((table1.col1_12 >= '0001-01-01 00:00:00':::TIMESTAMP) OR (table1.col1_4 < 1.7976931348623157e+308:::FLOAT8)) OR (table1.col1_6 <= 'infinity':::DATE)) AND (table1.col1_11 != '24:00:00':::TIME)) AND (table1.col1_3 = (-128):::INT8)) AND (table1.col1_1 <= '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) AND (table1.col1_2 > '':::STRING)) OR (table1.col1_8 >= 1:::DECIMAL)) OR table1.col1_10) OR (table1.col1_0 > e'\'':::STRING), INDEX (col1_12 ASC, col1_7 DESC, col1_6 DESC, col1_2 DESC, col1_3 DESC, col1_5 ASC, col1_10 ASC, col1_1 ASC, col1_8 ASC, col1_9 DESC, col1_4 ASC, col1_0, col1_11) WHERE ((((((table1.col1_11 = '00:00:00':::TIME) OR (table1.col1_3 <= (-9223372036854775807):::INT8)) OR (table1.col1_12 < '294276-12-31 23:59:59.999999':::TIMESTAMP)) OR (table1.col1_0 > e'\U00002603':::STRING)) OR (table1.col1_1 <= '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) OR (table1.col1_6 >= '5874897-12-31':::DATE)) AND (table1.col1_4 > '+Inf':::FLOAT8), UNIQUE (col1_12 ASC, col1_1 ASC, col1_10, col1_3, col1_5, col1_9 DESC, col1_8 DESC, col1_4 DESC, col1_11 DESC, col1_0 ASC, col1_6 ASC) STORING (col1_7), INDEX (col1_1 ASC, col1_4, col1_11, col1_7, col1_0 DESC, col1_8 ASC, col1_6 ASC, col1_12, col1_9 ASC, col1_2 ASC, col1_3, col1_10 DESC, col1_5), INDEX (col1_10 ASC, col1_2, col1_9 DESC, col1_1 ASC, col1_8 DESC, col1_12, col1_4, col1_6, col1_5, col1_7 DESC, col1_11 ASC) STORING (col1_3));
            CREATE TABLE table2 (col2_0 CHAR NOT NULL, col2_1 STRING NOT NULL, col2_2 REGPROC NOT NULL, col2_3 REGNAMESPACE NOT NULL, col2_4 TIMESTAMPTZ NOT NULL, col2_5 INT2 NOT NULL, col2_6 TIMESTAMPTZ NOT NULL, col2_7 NAME NOT NULL, col2_8 TIMESTAMP NOT NULL, col2_9 BOX2D NOT NULL, col2_10 FLOAT4 NOT NULL, col2_11 TIMESTAMPTZ NOT NULL, col2_12 BOX2D NOT NULL, col2_13 CHAR NOT NULL, col2_14 REGPROC NOT NULL, col2_15 "char" NOT NULL, col2_16 STRING NOT NULL, col2_17 UUID NOT NULL, col2_18 DECIMAL NOT NULL, PRIMARY KEY (col2_5, col2_2, col2_3 ASC, col2_16 ASC, col2_8 DESC, col2_10, col2_18 DESC, col2_7 DESC, col2_9 ASC, col2_12 ASC, col2_4, col2_14, col2_6, col2_1 DESC, col2_0 ASC, col2_13, col2_17, col2_15 DESC, col2_11 ASC), INDEX (col2_8 ASC, col2_2 ASC, col2_13 DESC, col2_16 DESC, col2_14 ASC, col2_18 ASC, col2_12 ASC, col2_3 ASC, col2_0, col2_15 DESC), INDEX (col2_5 DESC, col2_10, col2_12, col2_9 DESC), INDEX (col2_9 DESC, col2_6 DESC, col2_18 DESC, col2_4 ASC, col2_7, col2_16, col2_5 DESC, col2_2 ASC, col2_10 ASC, col2_1, col2_15, col2_14 DESC, col2_8, col2_0 ASC) WHERE (((((((((table2.col2_18 >= (-1.234E+401):::DECIMAL) AND (table2.col2_10 < '-Inf':::FLOAT8)) AND (table2.col2_4 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_0 > 'X':::STRING)) OR (table2.col2_1 > '':::STRING)) AND (table2.col2_8 = '294276-12-31 23:59:59.999999':::TIMESTAMP)) OR (table2.col2_13 < '"':::STRING)) OR (table2.col2_5 < 0:::INT8)) OR (table2.col2_11 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_16 = e'\x00':::STRING), UNIQUE (col2_1 DESC, col2_11 ASC, col2_18 DESC, col2_2, col2_14 ASC, col2_3, col2_5, col2_12, col2_7), INDEX (col2_4 DESC, col2_18 DESC, col2_3 DESC, col2_9 ASC, col2_12 ASC, col2_2, col2_11, col2_0 DESC, col2_5 DESC, col2_13 DESC, col2_10, col2_14 ASC), FAMILY (col2_7), FAMILY (col2_15, col2_5), FAMILY (col2_1), FAMILY (col2_14, col2_13), FAMILY (col2_2), FAMILY (col2_9), FAMILY (col2_16), FAMILY (col2_18), FAMILY (col2_8), FAMILY (col2_17), FAMILY (col2_12, col2_4, col2_0, col2_3), FAMILY (col2_6), FAMILY (col2_10, col2_11));
            CREATE TABLE table3 (col3_0 INT8 NOT NULL, col3_1 INT4 NOT NULL, col3_2 BOX2D NOT NULL, col3_3 TIMETZ NOT NULL, col3_4 INT2 NOT NULL, col3_5 REGTYPE NOT NULL, col3_6 INTERVAL NOT NULL, col3_7 DECIMAL NOT NULL, col3_8 BOOL, col3_9 REGPROC NULL, col3_10 INET NOT NULL, col3_11 BOOL NOT NULL, col3_12 TIME NOT NULL, col3_13 REGTYPE NOT NULL, col3_14 INET NOT NULL, col3_15 TIMETZ NOT NULL, col3_16 TIMESTAMPTZ NOT NULL, col3_17 TIMESTAMP NULL, col3_18 BYTES NOT NULL, PRIMARY KEY (col3_13, col3_5 ASC, col3_14 ASC, col3_15, col3_0, col3_3 ASC, col3_2 DESC, col3_12, col3_1, col3_11 ASC, col3_4, col3_16 ASC, col3_6 DESC, col3_10), UNIQUE (col3_12, col3_16) WHERE table3.col3_7 <= 'Infinity':::DECIMAL);
            ALTER TABLE table1 ADD FOREIGN KEY (col1_11, col1_1) REFERENCES table3 (col3_12, col3_16) ON DELETE RESTRICT;
            ALTER TABLE table1 INJECT STATISTICS e'[{"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7085681519346967085, "histo_buckets": [{"distinct_range": 0, "num_eq": 80, "num_range": 0, "upper_bound": "132919337"}, {"distinct_range": 1233955585917469000, "num_eq": 10000000, "num_range": 1233955585917468918, "upper_bound": "2153578118"}], "histo_col_type": "REGPROC", "name": "__auto__", "null_count": 5873791217761646870, "row_count": 8091611569059563324}, {"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7452617997832842807, "histo_col_type": "", "name": "__auto__", "null_count": 1225396103479179463, "row_count": 8091611569059563324}, {"columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4199487070050187915, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}, {"columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 11295734782757140, "histo_buckets": [{"distinct_range": 0, "num_eq": 10000000000, "num_range": 0, "upper_bound": "false"}, {"distinct_range": 0, "num_eq": 4686036629547336184, "num_range": 884772049418317623, "upper_bound": "true"}], "histo_col_type": "BOOL", "name": "__auto__", "null_count": 350916747891389746, "row_count": 8091611569059563324}, {"columns": ["col1_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6418201048343995414, "histo_buckets": [{"distinct_range": 0, "num_eq": 9000000, "num_range": 0, "upper_bound": "1970-01-06 06:59:47.000648"}, {"distinct_range": 0, "num_eq": 2000, "num_range": 20000000000, "upper_bound": "294276-12-31 23:59:59.999999"}], "histo_col_type": "TIMESTAMP", "name": "__auto__", "null_count": 6110497796467163758, "row_count": 8091611569059563324}, {"columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5033369100296441343, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}, {"columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6959311203638996637, "histo_col_type": "", "name": "__auto__", "null_count": 2988341075645951707, "row_count": 8091611569059563324}, {"columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4444879333277804383, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}, {"columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7074788775628114957, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}, {"columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6203178824011075008, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}, {"columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1445352272943419102, "histo_buckets": [{"distinct_range": 0, "num_eq": 7000000, "num_range": 0, "upper_bound": ""}, {"distinct_range": 24520570500.160492, "num_eq": 400000000, "num_range": 100000000000, "upper_bound": "\\u001blvH\\u001d\\u001e"}, {"distinct_range": 0, "num_eq": 4961756986300924239, "num_range": 0, "upper_bound": " p9!"}, {"distinct_range": 0, "num_eq": 900000, "num_range": 900, "upper_bound": "\'\\u001cI(5%`\\u0003"}, {"distinct_range": 65.07296335489296, "num_eq": 100, "num_range": 500, "upper_bound": "|\x7f"}], "histo_col_type": "\\"char\\"", "name": "__auto__", "null_count": 7373545407928354013, "row_count": 8091611569059563324}, {"columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6714088450389002035, "histo_buckets": [{"distinct_range": 0, "num_eq": 30000, "num_range": 0, "upper_bound": "-4713-11-24 00:00:00+00:00"}, {"distinct_range": 3560007.4916831115, "num_eq": 2575251848623516160, "num_range": 40000000, "upper_bound": "0001-01-01 00:00:00+00:00"}, {"distinct_range": 0, "num_eq": 5586181065494749606, "num_range": 40000000, "upper_bound": "1970-01-03 22:58:23.000789+00:00"}, {"distinct_range": 8270332349258185000, "num_eq": 3308395867501859000, "num_range": 8270332349258184818, "upper_bound": "1970-01-08 23:07:58.000474+00:00"}, {"distinct_range": 0, "num_eq": 3115832326753104270, "num_range": 50000, "upper_bound": "1970-01-09 12:59:48.000327+00:00"}, {"distinct_range": 0, "num_eq": 1000000000, "num_range": 3666357873377432534, "upper_bound": "1970-01-10 19:28:36.000917+00:00"}], "histo_col_type": "TIMESTAMPTZ", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}, {"columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4823887128604389727, "histo_buckets": [{"distinct_range": 0, "num_eq": 4000, "num_range": 0, "upper_bound": "1973-01-06"}, {"distinct_range": 56557886.272301264, "num_eq": 3035784686867258514, "num_range": 70000000, "upper_bound": "1975-06-02"}, {"distinct_range": 0, "num_eq": 10000, "num_range": 20, "upper_bound": "1981-12-25"}, {"distinct_range": 0, "num_eq": 4954239753414110779, "num_range": 10000000000, "upper_bound": "1989-03-18"}, {"distinct_range": 0, "num_eq": 700, "num_range": 600000000, "upper_bound": "1992-12-07"}, {"distinct_range": 0, "num_eq": 4953695563084449029, "num_range": 7765310451711600043, "upper_bound": "1994-03-22"}, {"distinct_range": 30, "num_eq": 60000, "num_range": 30, "upper_bound": "1996-02-12"}, {"distinct_range": 40000000000, "num_eq": 30, "num_range": 40000000000, "upper_bound": "infinity"}], "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 8091611569059563324}]':::JSONB;
            ALTER TABLE table2 INJECT STATISTICS e'[{"columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 322570831457153027, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 455913321011726796, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1417830649916221281, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 711638033205236090, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2749361428805638684, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1921355969481749067, "histo_buckets": [{"distinct_range": 0, "num_eq": 7886547781361495599, "num_range": 0, "upper_bound": "4919"}, {"distinct_range": 5238.933004043183, "num_eq": 5533675701967498845, "num_range": 200000, "upper_bound": "5985"}, {"distinct_range": 768753607456137900, "num_eq": 8011994620839014518, "num_range": 2587617488229039711, "upper_bound": "20094"}, {"distinct_range": 0, "num_eq": 3000000, "num_range": 7000000000, "upper_bound": "22564"}, {"distinct_range": 0, "num_eq": 5478360123520535505, "num_range": 500000000, "upper_bound": "22722"}], "histo_col_type": "INT2", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 483151752015681784, "histo_buckets": [{"distinct_range": 0, "num_eq": 1000, "num_range": 0, "upper_bound": "0001-01-01 00:00:00"}, {"distinct_range": 1765695380043582500, "num_eq": 1577183890475501927, "num_range": 1765695380043582461, "upper_bound": "1970-01-01 15:05:08.000268"}, {"distinct_range": 600, "num_eq": 6063167958754858128, "num_range": 600, "upper_bound": "1970-01-04 05:22:25.000487"}, {"distinct_range": 0, "num_eq": 4624173046018029722, "num_range": 6000000, "upper_bound": "1970-01-07 14:28:54.000151"}, {"distinct_range": 0, "num_eq": 5000000, "num_range": 8587032271944824045, "upper_bound": "1970-01-09 07:06:04.00086"}, {"distinct_range": 1257624119377286000, "num_eq": 6425440467716188191, "num_range": 7539652405709730049, "upper_bound": "1970-01-11 12:00:48.000892"}, {"distinct_range": 0, "num_eq": 1909775721800973329, "num_range": 100, "upper_bound": "1970-01-11 12:51:53.000768"}], "histo_col_type": "TIMESTAMP", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3606678199471879062, "histo_buckets": [{"distinct_range": 0, "num_eq": 2091562685881761330, "num_range": 0, "upper_bound": "BOX(-1.2148157193071327 -0.671806921905236,1.4029993169340633 -0.10291457414240923)"}, {"distinct_range": 0, "num_eq": 1354684333741707742, "num_range": 8353987473269630194, "upper_bound": "BOX(-0.9574059020636341 0.6390820448129381,0.10780003499074109 1.9471690825134806)"}, {"distinct_range": 0, "num_eq": 8048194768625593673, "num_range": 80, "upper_bound": "BOX(0.20796191293256783 -0.2077988214711014,1.0665845843777522 0.36820066938989077)"}, {"distinct_range": 0, "num_eq": 4851530575306026793, "num_range": 1000, "upper_bound": "BOX(0.2588483338157186 0.6034718412227299,1.2122298864643781 1.0537596049297848)"}], "histo_col_type": "BOX2D", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1445294536896795868, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2155379068195310153, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1617968405095615306, "histo_buckets": [{"distinct_range": 0, "num_eq": 6058686256527524520, "num_range": 0, "upper_bound": ""}, {"distinct_range": 156161936797309150, "num_eq": 800, "num_range": 1446333840410104668, "upper_bound": "\\"|\\u0003Uwo}"}, {"distinct_range": 0, "num_eq": 8044399979991900746, "num_range": 8448048131222473817, "upper_bound": "%3y\\nOF$"}, {"distinct_range": 18127597.05769359, "num_eq": 0, "num_range": 30000000, "upper_bound": "+\\u0003*,\\u001b}"}, {"distinct_range": 3523496011488264700, "num_eq": 8000000000, "num_range": 7005018223602299049, "upper_bound": "<\\u000bS\\u000c#o"}, {"distinct_range": 20000000000, "num_eq": 5000000, "num_range": 20000000000, "upper_bound": "|f\\u0014^\\u001c\\u0001\\u0005v "}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1013906841273838255, "histo_buckets": [{"distinct_range": 0, "num_eq": 400000, "num_range": 0, "upper_bound": "1970-01-01 05:57:59.000196+00:00"}, {"distinct_range": 0, "num_eq": 40000, "num_range": 100000, "upper_bound": "1970-01-01 14:13:57.000498+00:00"}, {"distinct_range": 58.6371283012817, "num_eq": 4461670879796647800, "num_range": 700, "upper_bound": "1970-01-03 12:45:34.000461+00:00"}, {"distinct_range": 0, "num_eq": 90000, "num_range": 3000000000, "upper_bound": "1970-01-10 11:39:09.000818+00:00"}], "histo_col_type": "TIMESTAMPTZ", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3415943546463388443, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 591120422121835922, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1851724555499339342, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2633392283455452596, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1003911494587293132, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2968594028732372332, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}, {"columns": ["col2_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1874298579592413809, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 3699359316334546382}]':::JSONB;
            ALTER TABLE table3 INJECT STATISTICS '[{"columns": ["col3_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 192, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 731, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 664, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 364, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 728, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 549, "histo_buckets": [{"distinct_range": 0, "num_eq": 80000000, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 0, "num_eq": 3220922622836176238, "num_range": 1196902198478007868, "upper_bound": "594030869"}, {"distinct_range": 0, "num_eq": 1536089456165136207, "num_range": 0, "upper_bound": "842388641"}, {"distinct_range": 0, "num_eq": 50000000, "num_range": 7000000000, "upper_bound": "1086742346"}, {"distinct_range": 2511643108588356000, "num_eq": 1984625066724558809, "num_range": 2511643108588355919, "upper_bound": "1435037559"}, {"distinct_range": 9000000000, "num_eq": 160772949436861732, "num_range": 9000000000, "upper_bound": "2148080886"}, {"distinct_range": 2220104363420753400, "num_eq": 2294520333368939114, "num_range": 5537657223454216312, "upper_bound": "2473195394"}, {"distinct_range": 90, "num_eq": 30000, "num_range": 90, "upper_bound": "3657042704"}, {"distinct_range": 7702687648350594000, "num_eq": 100, "num_range": 7702687648350594210, "upper_bound": "4143641236"}], "histo_col_type": "REGTYPE", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 747, "histo_col_type": "", "name": "__auto__", "null_count": 623, "row_count": 800}, {"columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 591, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 344, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 166, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 556, "histo_buckets": [{"distinct_range": 0, "num_eq": 8067721652470462345, "num_range": 0, "upper_bound": "00:00:00"}, {"distinct_range": 1284216449698090200, "num_eq": 30000000000, "num_range": 1284216449698090287, "upper_bound": "14:09:48.647615"}, {"distinct_range": 500, "num_eq": 60000, "num_range": 500, "upper_bound": "16:12:42.083742"}, {"distinct_range": 125292964059153340, "num_eq": 30000000, "num_range": 785457600367836770, "upper_bound": "17:32:25.181606"}, {"distinct_range": 5405154449546109000, "num_eq": 8344463179394122135, "num_range": 5405154449546109343, "upper_bound": "17:59:12.617907"}, {"distinct_range": 3694.8761609606386, "num_eq": 100000, "num_range": 9000, "upper_bound": "18:05:17.727269"}, {"distinct_range": 60, "num_eq": 4308735726217073614, "num_range": 60, "upper_bound": "18:37:05.571428"}, {"distinct_range": 5022826.462494218, "num_eq": 774735017841455555, "num_range": 20000000, "upper_bound": "20:22:31.412742"}], "histo_col_type": "TIME", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 784, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 673, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 169, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 630, "histo_col_type": "", "name": "__auto__", "null_count": 334, "row_count": 800}, {"columns": ["col3_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 260, "histo_col_type": "", "name": "__auto__", "null_count": 543, "row_count": 800}, {"columns": ["col3_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 483, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}, {"columns": ["col3_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 555, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800}]':::JSONB;
            CREATE TYPE rand_typ_0 AS ENUM ('vaj', 'eias', 'mojqj', 'a');
            CREATE TYPE rand_typ_1 AS ENUM ('g', 'alxc', 'p', 'qq', 'olncv');
            
        sqlsmith_test.go:52: pq: there is no unique constraint matching given keys for referenced table table3

More

Parameters:

• GOFLAGS=-json

make stressrace TESTS=TestSetups PKG=./pkg/internal/sqlsmith TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

[mgartner]

Fixed by #55724.