roachtest: sqlsmith/setup=empty/setting=default failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=empty/setting=default failed with artifacts on master @ 71a023f9212cf1285a4475ed85d5ab6eefa9bdf7:

					SELECT
						*
					FROM
						(
							VALUES
								(e'\'':::STRING:::NAME),
								('':::STRING:::NAME),
								('9``':::STRING:::NAME),
								(e'm}\x03\x1e&\x1dq':::STRING:::NAME)
						)
							AS tab_818 (col_1382)
				),
			with_208 (col_1383)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									ARRAY['BOX(-1.1031558841385651 -0.26200215036831603,-1.1017062595175766 0.6681974499429677)':::BOX2D,'BOX(-0.8308691589091456 -1.7708239105401296,0.1684104714615714 0.15281704608224672)':::BOX2D,'BOX(-2.0037321968556148 -1.0038997208693066,-1.2815152205689917 -0.6868774059780416)':::BOX2D,'BOX(0.863929967483934 -1.0300145692008704,1.365892433445346 0.39775689369275685)':::BOX2D,'BOX(-0.5767652527256806 -0.40428781250728174,0.5931519372322613 0.8162637926843672)':::BOX2D]
								),
								(
									ARRAY['BOX(0.06600433831200042 -0.6940681820057293,0.7828563629379895 0.0532872512011382)':::BOX2D,'BOX(-0.4544937808097179 -0.1352986670923256,2.427300499649083 1.2824020652279418)':::BOX2D,'BOX(-1.0164103197725225 -0.6230121127698246,0.375654616267881 0.443109347242727)':::BOX2D,'BOX(-0.8270989195948661 -1.7320118010553687,-0.10735125254353806 -1.5029442496379772)':::BOX2D,'BOX(-10 -10,10 10)':::BOX2D]
								)
						)
							AS tab_819 (col_1383)
				),
			with_209 (col_1384)
				AS (
					SELECT
						tab_822.tableoid AS col_1384
					FROM
						defaultdb.public.tab_162 AS tab_820
						JOIN defaultdb.public.tab_162 AS tab_821 ON
								(tab_820.col0_1) = (tab_821.col0_1) AND (tab_820.col0_15) = (tab_821.col0_15),
						defaultdb.public.tab_162@tab_149_col0_6_col0_0_col0_4_col0_12_idx AS tab_822
					WHERE
						false
				)
		SELECT
			count(*) AS col_1385
		FROM
			defaultdb.public.tab_162@tab_149_col0_6_col0_0_col0_4_col0_12_idx AS tab_823
		GROUP BY
			tab_823.col0_6, tab_823.col0_12, tab_823.col0_4, tab_823.col0_0
		ORDER BY
			tab_823.col0_4 DESC
		LIMIT
			26:::INT8;

Reproduce

To reproduce, try:

#!/usr/bin/env bash
#!/bin/bash
set -euxo pipefail

# NB: invoke this script with "caffeinate" on OSX and/or linux to
# prevent runs failing due to standby.

sha=$(git rev-parse HEAD)

if [ ! -f roachtest.$sha ]; then
	./build/builder.sh mkrelease amd64-linux-gnu bin/{roach{prod,test},workload}
	mv -f bin.docker_amd64/roachprod roachprod.$sha
	mv -f bin.docker_amd64/workload workload.$sha
	mv -f bin.docker_amd64/roachtest roachtest.$sha
fi

if [ ! -f cockroach.$sha ]; then
	./build/builder.sh mkrelease amd64-linux-gnu
	mv cockroach-linux-2.6.32-gnu-amd64 cockroach.$sha
fi

# NB: consider adding --debug if it is useful to let the clusters
# for failed tests survive.
./roachtest.$sha run "sqlsmith/setup=empty/setting=default" \
  --port 8080 --count 10 --cpu-quota 500 \
  --roachprod roachprod.${sha} --workload workload.${sha} \
  --cockroach ./cockroach.$sha \
  --artifacts artifacts.$sha | tee roachtest-stress.${sha}

/cc @cockroachdb/sql-queries

Internal log

no author provided

See this test on roachdash

_{Improve this report!}