roachtest: sqlsmith/setup=rand-tables/setting=no-mutations failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on release-23.1.22-rc @ 6ed4ef16634f683adfb7d77b4ebf414e0c1e42a7:

(sqlsmith.go:141).func3: error: pq: column "crdb_internal_idx_expr" does not exist
statement: CREATE TABLE "tabl	e4" (co😶l4_0 CHAR NOT NULL, "col 4 _1" TIMETZ NOT NULL, "col
4_2" BOOL NOT NULL, col4_3 STRING NOT NULL, "co'l""4_4" STRING NOT NULL, "col4 _😅5" CHAR NOT NULL, col4_6 REGROLE NULL, col4_7 INET NOT NULL, col4_8 INET NOT NULL, "col4%v_9" BOX2D NOT NULL, col4_10 INT4 NOT NULL, "col4(_11" STRING COLLATE en_US NOT NULL, UNIQUE (col4_3 ASC, lower(CAST("col4(_11" AS STRING)) ASC, col4_10, col4_8 ASC, "col 4 _1" DESC, col4_6 DESC, "col4 _😅5" DESC), UNIQUE ("co'l""4_4", col4_10 DESC, col4_3 ASC, "col
4_2") STORING (co😶l4_0, "col 4 _1", col4_6, col4_7, "col4(_11") WHERE "tabl	e4"."col
4_2", INDEX ("col4%v_9" ASC, "col4(_11", col4_6, "col4 _😅5" ASC, "col 4 _1" ASC) WHERE (((((("tabl	e4"."col4 _😅5" = 'X':::STRING) OR ("tabl	e4".col4_3 > e'\x00':::STRING)) AND ("tabl	e4".co😶l4_0 != e'\'':::STRING)) OR "tabl	e4"."col
4_2") OR ("tabl	e4"."co'l""4_4" != e'\x00':::STRING)) OR ("tabl	e4"."col 4 _1" >= '00:00:00+15:59':::TIMETZ)) AND ("tabl	e4".col4_10 < (-1):::INT8) NOT VISIBLE, INDEX (col4_8, "col
4_2" DESC, co😶l4_0, "col4%v_9") WHERE (((((("tabl	e4"."col 4 _1" != '24:00:00-15:59':::TIMETZ) OR ("tabl	e4".co😶l4_0 >= e'\U00002603':::STRING)) OR ("tabl	e4".col4_3 < '':::STRING)) OR ("tabl	e4"."co'l""4_4" != e'\x00':::STRING)) OR (NOT "tabl	e4"."col
4_2")) AND ("tabl	e4"."col4 _😅5" >= e'\U00002603':::STRING)) AND ("tabl	e4".col4_10 <= (-1):::INT8) NOT VISIBLE)
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-mutations/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-39005

[DrewKimball]

This is likely fixed by #120792 or #120794, which were not backported beyond 24.1. I'll close this for now, and we can consider the (possibly risky) backport if we see more failures.