roachtest: sqlsmith/setup=tpch-sf1/setting=default failed #42107

cockroach-teamcity · 2019-11-01T06:48:39Z

SHA: https://github.com/cockroachdb/cockroach/commits/4c52530a33367c58e434111324fcda8c3d73582a

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1568299&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191101-1568299/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:118,sqlsmith.go:129,test_runner.go:697: ping: dial tcp 34.69.197.230:26257: connect: connection refused
		previous sql:
		WITH
			with_1366 (col_12449)
				AS (
					SELECT
						*
					FROM
						(VALUES (e'\x17':::STRING:::NAME), (e'\x18\t':::STRING:::NAME), (e'\x1eN=A':::STRING:::NAME))
							AS tab_5382 (col_12449)
				),
			with_1369 (col_12450)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(e'nm\x03':::STRING),
								(NULL),
								('oZ':::STRING),
								(e'+B7\x04X':::STRING),
								(NULL),
								('Lm`Q:u':::STRING)
						)
							AS tab_5383 (col_12450)
					INTERSECT SELECT * FROM (VALUES (e'\x0fY':::STRING)) AS tab_5384 (col_12451)
					UNION ALL
						SELECT
							*
						FROM
							(
								VALUES
									(
										(
											WITH
												with_1367 (col_12452)
													AS (
														SELECT
															*
														FROM
															(
																VALUES
																	(0.5308347511098859:::FLOAT8), (0.0553380451804093:::FLOAT8)
															)
																AS tab_5385 (col_12452)
													),
												with_1368 (col_12453)
													AS (
														SELECT
															*
														FROM
															(
																VALUES
																	(
																		((ARRAY[1176266142:::OID,1755422894:::OID,1415338126:::OID,305638357:::OID,2073806048:::OID,2715769549:::OID], ARRAY[]:::TIME[], '-57 years -6 mons -506 days -24:20:01.357369':::INTERVAL, 2460825459:::OID), ARRAY['\xc2fac1':::BYTES], 2273458025:::OID)
																	),
																	(
																		((ARRAY[4137546152:::OID,3959880841:::OID,4069353453:::OID,1405400430:::OID], ARRAY['21:07:44.806922':::TIME,'13:54:45.020073':::TIME], '31 years 3 mons 154 days 21:18:05.75677':::INTERVAL, 2504585302:::OID), ARRAY['\x49':::BYTES,'\x22':::BYTES,'\x9e':::BYTES], 2271528483:::OID)
																	)
															)
																AS tab_5386 (col_12453)
													)
											SELECT
												NULL AS col_12454
											FROM
												with_1368
											LIMIT
												1:::INT8
										)
									),
									('Q':::STRING),
									(e'\t\x19\x0e7':::STRING)
							)
								AS tab_5387 (col_12455)
				)
		SELECT
			tab_5388.col6 AS col_12456,
			NULL AS col_12457,
			tab_5388.col17 AS col_12458,
			0.8178067843824597:::FLOAT8 AS col_12459,
			tab_5388.col9 AS col_12460,
			tab_5388.col_3333 AS col_12461
		FROM
			with_1369, defaultdb.public.tab_824 AS tab_5388
		WHERE
			not_like_escape(tab_5388.col4::STRING, NULL::STRING, experimental_strftime(tab_5388.col16::TIMESTAMP, ('[{":A>Hx": 0.058703442102307074, "^=vxov|)1V]": [1.5250052294736827, [[], "b", "Tna>2f:[d"]], "c": [[[], []], {}, []]}, 0.4478319291555082]':::JSONB::JSONB->>tab_5388.col14::STRING)::STRING::STRING)::STRING::STRING)::BOOL
		ORDER BY
			tab_5388.col18 DESC;

The text was updated successfully, but these errors were encountered:

cockroach-teamcity · 2019-11-08T00:48:36Z

SHA: https://github.com/cockroachdb/cockroach/commits/ff13356a005e446f3f11bd37cc9772f568d8f41f

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1578961&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191107-1578961/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:147,sqlsmith.go:158,test_runner.go:697: ping: dial tcp 35.232.185.39:26257: connect: connection refused
		previous sql:
		ALTER TABLE defaultdb.public.tab_6623 ADD COLUMN col_10823 DECIMAL DEFAULT (cluster_logical_timestamp()::DECIMAL) NULL;

cockroach-teamcity · 2019-11-08T07:40:38Z

SHA: https://github.com/cockroachdb/cockroach/commits/ca3615568aa509606410d36bc7cd70eec0484c26

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1580962&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-2.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191108-1580962/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:148,sqlsmith.go:159,test_runner.go:697: ping: dial tcp 35.223.42.55:26257: connect: connection refused
		previous sql:
		INSERT
		INTO
			defaultdb.public.tab_5105 AS tab_6737 (col0, col1, col_1968)
		WITH
			with_1676 (col_7987, col_7988)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									ARRAY[(-23431):::INT8,9237:::INT8,(-5103):::INT8,13526:::INT8,(-128):::INT8],
									ARRAY[293564979:::OID,1734095339:::OID,743394709:::OID,3949035066:::OID]
								),
								(ARRAY[24039:::INT8], ARRAY[2460079914:::OID,1750605210:::OID]),
								(
									ARRAY[(-7518):::INT8,28924:::INT8,(-27411):::INT8,12736:::INT8,32553:::INT8,(-15755):::INT8,445:::INT8],
									ARRAY[304168332:::OID,2960698566:::OID,3030775905:::OID,2677708782:::OID]
								)
						)
							AS tab_6738 (col_7987, col_7988)
				),
			with_1677 (col_7990)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									(e'\x01\x18\x02':::STRING:::NAME, '':::STRING, '1970-01-07 13:35:41.000905+00:00':::TIMESTAMP)
								),
								(
									(
										SELECT
											(e'~;M\fowcp3':::STRING:::NAME, e',p1d|\x1f&5~':::STRING, '1970-01-08 01:47:47.000261+00:00':::TIMESTAMP)
												AS col_7989
										LIMIT
											1:::INT8
									)
								),
								(('!yw*':::STRING:::NAME, e'wT\x1c':::STRING, '1970-01-06 12:03:43.000923+00:00':::TIMESTAMP)),
								(
									('p|>1E':::STRING:::NAME, e';\x10j\x17j&\x15\t':::STRING, '1970-01-09 12:19:48.000002+00:00':::TIMESTAMP)
								),
								(
									(e'wj\\L':::STRING:::NAME, e'\x15^y.\tEB':::STRING, '1970-01-05 08:58:07.000914+00:00':::TIMESTAMP)
								),
								(
									(e'4\x0b':::STRING:::NAME, e'byK~\nF[W|':::STRING, '1970-01-10 01:25:33.000734+00:00':::TIMESTAMP)
								)
						)
							AS tab_6739 (col_7990)
				)
		SELECT
			0.8453010116026571:::FLOAT8 AS col_7991,
			(
				WITH
					with_1678 (col_7992)
						AS (
							SELECT
								*
							FROM
								(VALUES (B'01110100000010111001001'), (NULL), (B'01010101011100101010000'))
									AS tab_6740 (col_7992)
						)
				SELECT
					tab_6741.col1 AS col_7993
				FROM
					defaultdb.public.tab_5105 AS tab_6741, defaultdb.public.tab_5105 AS tab_6742
				ORDER BY
					tab_6742.col0
				LIMIT
					1:::INT8
			)
				AS col_7994,
			410121826:::OID AS col_7995
		FROM
			with_1677
		WHERE
			NULL
		ORDER BY
			with_1677.col_7990 DESC, with_1677.col_7990
		LIMIT
			27:::INT8;

cockroach-teamcity · 2019-11-08T07:50:36Z

SHA: https://github.com/cockroachdb/cockroach/commits/e206eec2aaac3620d1d27873b830bc5f781c94aa

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1580926&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191108-1580926/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:148,sqlsmith.go:159,test_runner.go:697: ping: dial tcp 35.238.196.29:26257: connect: connection refused
		previous sql:
		INSERT
		INTO
			defaultdb.public.tab_28 AS tab_411
				(
					col0,
					col1,
					col2,
					col3,
					col4,
					col5,
					col6,
					col7,
					col8,
					col9,
					col10,
					col11,
					col12,
					col13,
					col14,
					col15,
					col16,
					col17
				)
		SELECT
			log(CASE WHEN true THEN 0.6110967816860979:::FLOAT8 ELSE 0.253300196158601:::FLOAT8 END::FLOAT8)::FLOAT8
				AS col_1182,
			right('\xba':::BYTES::BYTES, NULL::INT8)::BYTES AS col_1183,
			max(tab_412.col2::OID) OVER (PARTITION BY tab_412.col2)::OID AS col_1184,
			ln('-Infinity':::DECIMAL::DECIMAL)::DECIMAL AS col_1185,
			min(tab_412.col2::OID)::OID AS col_1186,
			B'010011110100010001000100000011111100000100110' AS col_1187,
			e'H\x01\tO\x1e6Q':::STRING AS col_1188,
			round((-1.3509733741809098):::FLOAT8::FLOAT8, (-525808328226329039):::INT8::INT8)::FLOAT8 AS col_1189,
			(-5310):::INT8 AS col_1190,
			cluster_logical_timestamp()::DECIMAL AS col_1191,
			transaction_timestamp():::TIMESTAMP::TIMESTAMP AS col_1192,
			(-1):::INT8 AS col_1193,
			crdb_internal.cluster_id()::UUID AS col_1194,
			gen_random_uuid()::UUID AS col_1195,
			NULL AS col_1196,
			not_similar_to_escape(e'}]\x15':::STRING::STRING, e'ciq\n\x14Q[':::STRING::STRING, 'h;R':::STRING::STRING)::BOOL
				AS col_1197,
			min(tab_412.col2::OID)::OID AS col_1198,
			now():::TIMESTAMPTZ::TIMESTAMPTZ AS col_1199
		FROM
			defaultdb.public.tab_28 AS tab_412
		WHERE
			false
		GROUP BY
			tab_412.col2
		HAVING
			bool_and(tab_412.col15::BOOL)::BOOL;

cockroach-teamcity · 2019-11-14T07:46:32Z

SHA: https://github.com/cockroachdb/cockroach/commits/c2b2cd1def91d9534fa8dabb8a17ae38bf674111

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1591097&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191114-1591097/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:102,sqlsmith.go:177,test_runner.go:697: pq: cannot use "into_db" option when restoring database(s)

cockroach-teamcity · 2019-11-14T08:14:40Z

SHA: https://github.com/cockroachdb/cockroach/commits/8622fad01478fb4a4f05b5579eb0b8561c02e491

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1591079&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191114-1591079/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:102,sqlsmith.go:177,test_runner.go:697: pq: cannot use "into_db" option when restoring database(s)

cockroach-teamcity · 2019-11-19T18:51:33Z

SHA: https://github.com/cockroachdb/cockroach/commits/53eef0857d14cc3af720e136ddaff4eeab026fd0

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1599080&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=provisional_201911182308_v19.2.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191119-1599080/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_80;

cockroach-teamcity · 2019-11-20T07:48:58Z

SHA: https://github.com/cockroachdb/cockroach/commits/647db0fecd18d8de760443131c6edb33828a619a

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1599851&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191120-1599851/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		WITH
			with_2 (col_20) AS (SELECT * FROM (VALUES (B'1')) AS tab_19 (col_20)),
			with_3 (col_21, col_22)
				AS (
					SELECT
						*
					FROM
						(VALUES (1664843972:::OID, ARRAY[false]), (3083885112:::OID, ARRAY[false])) AS tab_20 (col_21, col_22)
				)
		SELECT
			'1989-06-05':::DATE AS col_23, tab_22.l_returnflag AS col_24, tab_22.l_tax AS col_25
		FROM
			defaultdb.public.partsupp AS tab_21, defaultdb.public.lineitem AS tab_22, defaultdb.public.region AS tab_23
		ORDER BY
			tab_22.l_extendedprice ASC;

cockroach-teamcity · 2019-11-20T07:57:26Z

SHA: https://github.com/cockroachdb/cockroach/commits/1c3fce73cd25fa69e5a8c05ce8e215d66b4f49e4

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1599833&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191120-1599833/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_45.p_brand AS col_113,
			tab_45.p_brand AS col_114,
			(
				SELECT
					tab_45.p_comment AS col_115
				FROM
					defaultdb.public.lineitem AS tab_46
				WHERE
					true
				ORDER BY
					tab_46.l_linenumber ASC, tab_46.l_quantity
				LIMIT
					1:::INT8
			)
				AS col_116,
			e'S\\6':::STRING AS col_117
		FROM
			defaultdb.public.part AS tab_45;

cockroach-teamcity · 2019-11-21T07:54:20Z

SHA: https://github.com/cockroachdb/cockroach/commits/205330426e50b966ede8a4644d77570d8265fe66

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1602072&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191121-1602072/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		INSERT
		INTO
			defaultdb.public.orders AS tab_165
				(
					o_orderpriority,
					o_shippriority,
					o_comment,
					o_orderdate,
					o_totalprice,
					o_orderstatus,
					o_clerk,
					o_orderkey,
					o_custkey
				)
		SELECT
			tab_166.s_name AS col_275,
			tab_167.o_orderkey AS col_276,
			tab_166.s_name AS col_277,
			'1970-10-01':::DATE AS col_278,
			(-1.452238714474439):::FLOAT8 AS col_279,
			'&D/#io_':::STRING AS col_280,
			tab_166.s_phone AS col_281,
			NULL AS col_282,
			tab_167.o_orderkey AS col_283
		FROM
			defaultdb.public.supplier AS tab_166,
			defaultdb.public.orders AS tab_167
			JOIN defaultdb.public.lineitem AS tab_168 ON
					(tab_167.o_custkey) = (tab_168.l_partkey) AND (tab_167.o_orderkey) = (tab_168.l_orderkey)
		WHERE
			true
		LIMIT
			64:::INT8;

cockroach-teamcity · 2019-11-21T07:54:50Z

SHA: https://github.com/cockroachdb/cockroach/commits/66290e232d6af34c4d09b2f90f71d520ed47dbe8

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1602090&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191121-1602090/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		UPDATE
			defaultdb.public.orders AS tab_154
		SET
			o_comment = '"':::STRING, o_totalprice = (-1.9930065786116113):::FLOAT8, o_orderdate = '1995-12-07':::DATE;

cockroach-teamcity · 2019-11-21T07:59:50Z

SHA: https://github.com/cockroachdb/cockroach/commits/db252551659b8c404be584e39f2af642d01caee3

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1602108&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191121-1602108/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_63 WHERE true;

cockroach-teamcity · 2019-11-22T07:32:59Z

SHA: https://github.com/cockroachdb/cockroach/commits/c128b5b9a0b1d98181bf124f775154df97948fd2

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1604949&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191122-1604949/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_20 SET l_quantity = (-1.0720350654543798):::FLOAT8;

cockroach-teamcity · 2019-11-22T07:44:20Z

SHA: https://github.com/cockroachdb/cockroach/commits/85b76090c30a58e43f778818795783eaca3758ff

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1604931&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191122-1604931/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			666337676505228157:::INT8 AS col_46, e'nTRs~\x01':::STRING AS col_47, NULL AS col_48, tab_26.l_suppkey AS col_49
		FROM
			defaultdb.public.region AS tab_25, defaultdb.public.lineitem AS tab_26
		ORDER BY
			tab_26.l_linenumber ASC, tab_26.l_commitdate ASC, tab_26.l_extendedprice ASC;

cockroach-teamcity · 2019-11-22T08:22:29Z

SHA: https://github.com/cockroachdb/cockroach/commits/668b66da0b4c7789fb13d77c43334c99a7e65793

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1604967&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191122-1604967/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_20 WHERE true;

cockroach-teamcity · 2019-11-23T07:48:09Z

SHA: https://github.com/cockroachdb/cockroach/commits/1179c76e34d057259854d88c7948830d2b4b05cd

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1606953&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191123-1606953/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		DELETE FROM
			defaultdb.public.lineitem AS tab_92
		WHERE
			EXISTS(
				SELECT
					'1970-01-07 08:18:19.000041+00:00':::TIMESTAMPTZ AS col_154,
					false AS col_155,
					0.2524687500295498:::FLOAT8 AS col_156
				FROM
					defaultdb.public.partsupp AS tab_93
					JOIN defaultdb.public.customer AS tab_94 ON (tab_93.ps_suppkey) = (tab_94.c_custkey)
					JOIN defaultdb.public.partsupp AS tab_95
						JOIN defaultdb.public.partsupp AS tab_96 ON
								(tab_95.ps_partkey) = (tab_96.ps_availqty) AND (tab_95.ps_comment) = (tab_96.ps_comment) ON
							(tab_94.c_custkey) = (tab_96.ps_partkey),
					defaultdb.public.orders AS tab_97,
					defaultdb.public.part AS tab_98,
					defaultdb.public.partsupp AS tab_99
				ORDER BY
					tab_99.ps_availqty DESC,
					tab_97.o_orderstatus ASC,
					tab_98.p_container,
					tab_99.ps_partkey ASC,
					tab_98.p_retailprice DESC
				LIMIT
					42:::INT8
			);

cockroach-teamcity · 2019-11-23T07:59:18Z

SHA: https://github.com/cockroachdb/cockroach/commits/2e1807ad6ac9656d2afa40cda6533f6a29e80383

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1606971&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191123-1606971/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		INSERT
		INTO
			defaultdb.public.region AS tab_43 (r_regionkey, r_name)
		WITH
			with_13 (col_70)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('a25c:14cf:589d:51ae:1cad:4163:9e1:82d9/24':::INET),
								('177.75.113.188/26':::INET),
								('142.75.156.249/25':::INET),
								(
									set_masklen(((-7793182607890836333):::INT8::INT8 + '251.52.152.111/9':::INET::INET)::INET::INET, (-3501330193390724800):::INT8::INT8)::INET
								),
								(
									(3265922626948822093:::INT8::INT8 + ('25.77.66.135/23':::INET::INET & 'd5f7:25c8:9c82:2f99:d1fc:ccf5:a813:8262/87':::INET::INET)::INET::INET)::INET
								)
						)
							AS tab_44 (col_70)
				),
			with_14 (col_71)
				AS (
					SELECT * FROM (VALUES (1491510657:::INT8)) AS tab_45 (col_71)
					EXCEPT ALL
						SELECT
							*
						FROM
							(
								VALUES
									((-565287935):::INT8),
									((-2147483648):::INT8),
									((-441875358):::INT8),
									((-900816912):::INT8),
									(NULL),
									((-1088452946):::INT8)
							)
								AS tab_46 (col_72)
				)
		SELECT
			794451883875514887:::INT8 AS col_73, tab_47.l_linestatus AS col_74
		FROM
			with_13,
			defaultdb.public.lineitem AS tab_47,
			defaultdb.public.supplier AS tab_48
			JOIN defaultdb.public.supplier AS tab_49 ON (tab_48.s_suppkey) = (tab_49.s_nationkey)
		WHERE
			true
		ORDER BY
			tab_47.l_commitdate
		LIMIT
			42:::INT8;

cockroach-teamcity · 2019-11-24T07:44:30Z

SHA: https://github.com/cockroachdb/cockroach/commits/4de1b957fbda6eaa42c8fd7b0fb3278365f7a615

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1607758&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191124-1607758/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_26.o_clerk AS col_56,
			tab_26.o_comment AS col_57,
			tab_25.c_nationkey AS col_58,
			tab_26.o_shippriority AS col_59,
			tab_26.o_totalprice AS col_60,
			'1971-06-28':::DATE AS col_61,
			NULL AS col_62,
			tab_26.o_shippriority AS col_63,
			tab_26.o_totalprice AS col_64,
			7671998558125313623:::INT8 AS col_65,
			tab_26.o_shippriority AS col_66,
			NULL AS col_67,
			tab_25.c_comment AS col_68,
			NULL AS col_69,
			'#`I/O':::STRING AS col_70,
			tab_25.c_address AS col_71
		FROM
			defaultdb.public.customer AS tab_25, defaultdb.public.orders AS tab_26
		ORDER BY
			tab_26.o_clerk ASC, tab_26.o_orderdate DESC;

cockroach-teamcity · 2019-11-25T07:58:02Z

SHA: https://github.com/cockroachdb/cockroach/commits/60b7b3b2ca511cf9adb30799fcf2b8cffd6223d9

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1608628&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191125-1608628/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_28 WHERE true;

cockroach-teamcity · 2019-11-26T07:48:28Z

SHA: https://github.com/cockroachdb/cockroach/commits/9012e6449e63baca6b59c00d3e350bbc3ab0dd3b

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1611118&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191126-1611118/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_3.o_orderkey AS col_1, tab_3.o_orderpriority AS col_2
		FROM
			defaultdb.public.orders AS tab_3, defaultdb.public.nation AS tab_4
		WHERE
			true
		ORDER BY
			tab_3.o_orderpriority DESC, tab_4.n_comment DESC, tab_3.o_orderstatus, tab_3.o_orderdate ASC;

cockroach-teamcity · 2019-11-26T07:52:51Z

SHA: https://github.com/cockroachdb/cockroach/commits/02d62674ad2f9ca16183184ea6552691506675f1

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1611136&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191126-1611136/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_1 SET l_receiptdate = tab_1.l_commitdate WHERE true;

cockroach-teamcity · 2019-11-26T08:02:27Z

SHA: https://github.com/cockroachdb/cockroach/commits/78f8482fd864376a26f32dd983afeb679d1c5977

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1611100&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191126-1611100/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_19 SET l_shipmode = tab_19.l_linestatus, l_shipinstruct = tab_19.l_linestatus;

cockroach-teamcity · 2019-11-27T07:41:49Z

SHA: https://github.com/cockroachdb/cockroach/commits/70d243f36e5193bb8f0a73bf6e06a6f78c0c9f01

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1613970&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-19.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191127-1613970/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		INSERT
		INTO
			defaultdb.public.orders AS tab_90
				(
					o_orderpriority,
					o_shippriority,
					o_comment,
					o_orderdate,
					o_totalprice,
					o_orderstatus,
					o_clerk,
					o_orderkey,
					o_custkey
				)
		SELECT
			'':::STRING AS col_169,
			NULL AS col_170,
			e'Ir}\x7f':::STRING AS col_171,
			tab_93.l_shipdate AS col_172,
			tab_92.ps_supplycost AS col_173,
			tab_93.l_shipmode AS col_174,
			COALESCE(tab_93.l_comment, '52f':::STRING) AS col_175,
			tab_92.ps_availqty AS col_176,
			tab_92.ps_partkey AS col_177
		FROM
			defaultdb.public.partsupp AS tab_91,
			defaultdb.public.partsupp AS tab_92
			JOIN defaultdb.public.lineitem AS tab_93 ON (tab_92.ps_partkey) = (tab_93.l_suppkey)
		ORDER BY
			tab_93.l_orderkey ASC, tab_93.l_comment DESC
		LIMIT
			46:::INT8;

cockroach-teamcity · 2019-11-27T08:00:06Z

SHA: https://github.com/cockroachdb/cockroach/commits/f97dc13163020a032b098ef3eb88e4d9f54a04ba

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1613952&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191127-1613952/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_157 SET l_shipmode = '':::STRING, l_extendedprice = tab_157.l_discount;

cockroach-teamcity · 2019-11-27T08:11:40Z

SHA: https://github.com/cockroachdb/cockroach/commits/7dec3577461a1e53ea70582de62bbd96bf512b73

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1614006&tab=artifacts#/sqlsmith/setup=tpch-sf1/setting=default

The test failed on branch=release-2.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191127-1614006/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_10.o_comment AS col_7,
			tab_10.o_orderkey AS col_8,
			tab_10.o_orderdate AS col_9,
			tan(tab_10.o_totalprice::FLOAT8)::FLOAT8 AS col_10,
			tab_10.o_clerk AS col_11,
			7301859331432744289:::INT8 AS col_12,
			(-0.15302154070999552):::FLOAT8 AS col_13,
			tab_10.o_clerk AS col_14,
			'{':::STRING AS col_15,
			e'\x05#Dj':::STRING AS col_16
		FROM
			defaultdb.public.customer AS tab_9, defaultdb.public.orders AS tab_10
		WHERE
			true
		ORDER BY
			tab_10.o_custkey DESC
		LIMIT
			20:::INT8;

cockroach-teamcity · 2019-12-16T08:08:52Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@beb69e089b6eadc0fde6c92eb533b08d248938fe:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191216-1644933/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_70 WHERE true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS=-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-17T07:44:02Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@dd838bcaa68d3dbb2af8d162d5ba1a7a23fe5098:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191217-1647459/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:144,sqlsmith.go:217,test_runner.go:700: pq: column "is_inverted" does not exist

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS=-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-17T08:12:10Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@5e14e74d1f0b41658ece3d9e618503d7efb4ffb0:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191217-1647441/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_310 WHERE true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS=-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-19T08:03:26Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@0ae55ddaac1f0d18f4ecaa1c2f48c1aafe4c5c2d:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191219-1653460/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_372;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-19T08:11:33Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@277e28b2ea78929563e85cb1c9efc573f37408a4:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191219-1653424/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		UPDATE
			defaultdb.public.lineitem AS tab_88
		SET
			l_discount = tab_88.l_quantity, l_receiptdate = '1974-12-16':::DATE
		WHERE
			true
		ORDER BY
			tab_88.l_orderkey, tab_88.l_discount DESC
		LIMIT
			84:::INT8;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-20T08:08:07Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@a84266e50207e2e9a27828991ec9fc2f62d74a88:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191220-1656791/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		SELECT
			e'$\x1c':::STRING AS col_234,
			tab_170.s_nationkey AS col_235,
			(-1.30406398282854):::FLOAT8 AS col_236,
			7484835968502884579:::INT8 AS col_237,
			tab_170.s_phone AS col_238,
			tab_168.p_comment AS col_239,
			tab_168.p_container AS col_240,
			tab_168.p_size AS col_241,
			e'\x133F':::STRING AS col_242,
			'':::STRING AS col_243
		FROM
			defaultdb.public.part@[0] AS tab_168,
			defaultdb.public.region@[0] AS tab_169,
			defaultdb.public.supplier@s_nk AS tab_170,
			defaultdb.public.customer AS tab_171
			JOIN defaultdb.public.region AS tab_172 ON (tab_171.c_nationkey) = (tab_172.r_regionkey)
		WHERE
			true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-21T08:17:36Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@dd9b1c1f40dda59ee9d446416106d311ae5ce1e6:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191221-1658785/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_288 WHERE true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-22T08:19:05Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@319080c701cb4e13c347e86c4afb2f1c2af78def:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191222-1660313/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:700: query timed out, but did not cancel execution:
		WITH
			with_30 (col_184) AS (SELECT * FROM (VALUES (ARRAY[25947:::INT8,(-18505):::INT8])) AS tab_117 (col_184))
		SELECT
			'':::STRING AS col_185,
			'4714-11-24 BC':::DATE AS col_186,
			1453725245952364662:::INT8 AS col_187,
			tab_118.o_comment AS col_188
		FROM
			defaultdb.public.orders@o_ck AS tab_118
			JOIN defaultdb.public.partsupp@[0] AS tab_119 ON (tab_118.o_orderkey) = (tab_119.ps_availqty)
		WHERE
			true
		ORDER BY
			tab_118.o_orderstatus ASC, tab_119.ps_comment ASC
		LIMIT
			11:::INT8;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-24T08:01:56Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@d23a3df4b9eddd07f02b67b6beb16aee8fd8e65b:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191224-1661413/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		SELECT
			'1997-04-24':::DATE AS col_136
		FROM
			defaultdb.public.supplier@primary AS tab_85,
			defaultdb.public.lineitem@l_cd AS tab_86
			CROSS JOIN defaultdb.public.partsupp@[0] AS tab_87;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-25T08:10:28Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@c172b37ec3316ec982e1ee92d4414a76823680e6:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191225-1662271/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_207;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-26T08:04:24Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@2ddb82b2a8fff0c4e42169cf4e610d33a0fbd2d3:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191226-1663134/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_302 SET l_suppkey = tab_302.l_orderkey WHERE true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-27T07:57:01Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@599c988773fa6fb4544369a50fe8d06b90c64171:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191227-1664336/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		INSERT
		INTO
			defaultdb.public.region AS tab_360 (r_comment, r_regionkey, r_name)
		SELECT
			e'j\x01':::STRING AS col_647, NULL AS col_648, tab_363.l_returnflag AS col_649
		FROM
			defaultdb.public.part AS tab_361
			JOIN defaultdb.public.orders AS tab_362 ON (tab_361.p_partkey) = (tab_362.o_custkey),
			defaultdb.public.lineitem@[0] AS tab_363
		WHERE
			true
		ORDER BY
			tab_363.l_shipmode ASC, tab_363.l_partkey DESC
		LIMIT
			34:::INT8;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-27T08:11:30Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@d54e001248f233734ff926daef5470487c5616b0:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191227-1664318/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		DELETE FROM
			defaultdb.public.lineitem AS tab_324
		WHERE
			true
		ORDER BY
			tab_324.l_discount, tab_324.l_commitdate ASC
		LIMIT
			26:::INT8;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-28T07:54:20Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@8ca08b3ddbfa07eb8fc19a1035cf82539f05c7a3:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191228-1665474/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_29 SET l_shipdate = tab_29.l_commitdate;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-28T08:21:36Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@8f946b8bb62629002c5e958373b81ca9e1920dd6:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191228-1665456/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		UPDATE
			defaultdb.public.lineitem AS tab_265
		SET
			l_commitdate = '5874897-12-31':::DATE
		WHERE
			true
		ORDER BY
			tab_265.l_returnflag, tab_265.l_comment DESC
		LIMIT
			72:::INT8;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2019-12-31T08:00:49Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@3960c23e7b8fef3042d525f74768c5ae85a1cf22:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191231-1668207/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.lineitem AS tab_438 SET l_shipmode = e'\r\x13\x03_?c\r':::STRING WHERE true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-02T08:09:14Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@a99740bb34c03ab3af7558129edce9c17c88d4f9:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200102-1670273/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.orders AS tab_860;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-03T08:19:19Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@9aaf5fb6f7108858d200dd3d199deb11871a09b4:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200103-1671769/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_562;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-03T08:26:58Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@8facb469d66426a3f372a1aed4ea6f34e287b501:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200103-1671733/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		UPDATE defaultdb.public.partsupp AS tab_264 SET ps_availqty = tab_264.ps_partkey;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-04T08:06:58Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@7906cbe3d9c615430f6e892a42e6bccdad2aff00:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200104-1673622/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		UPDATE
			defaultdb.public.partsupp AS tab_60
		SET
			ps_partkey = tab_60.ps_suppkey,
			ps_suppkey
				= (
					SELECT
						tab_60.ps_suppkey AS col_89
					FROM
						defaultdb.public.orders@primary AS tab_61
					ORDER BY
						tab_61.o_shippriority DESC, tab_61.o_orderpriority ASC, tab_61.o_orderstatus DESC
					LIMIT
						1:::INT8
				),
			ps_availqty = tab_60.ps_suppkey,
			ps_comment = tab_60.ps_comment;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-06T08:21:37Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@f180501b7c2ccb946d7f7c8944d5509b87cb0394:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200106-1674751/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_109;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-06T21:51:57Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on 43008@b555d16b4455f7122f4211082512820742f8116f:

The test failed on branch=43008, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200106-1676232/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		WITH
			with_67 (col_429) AS (SELECT * FROM (VALUES (e'd\'\x1abQ"\x1e%':::STRING:::NAME)) AS tab_241 (col_429))
		SELECT
			'8.g.2Gp':::STRING AS col_430,
			(-1.1421941849962882):::FLOAT8 AS col_431,
			tab_243.s_address AS col_432,
			e'\x0b+d7\x11&"`x':::STRING AS col_433,
			tab_242.ps_availqty AS col_434,
			(tab_242.ps_partkey::INT8 % 3761910163681841459:::INT8::INT8)::INT8 AS col_435,
			0.9188143013657374:::FLOAT8 AS col_436
		FROM
			defaultdb.public.partsupp@[0] AS tab_242, defaultdb.public.supplier@s_nk AS tab_243
		ORDER BY
			tab_243.s_address DESC, tab_242.ps_supplycost ASC, tab_243.s_comment, tab_243.s_suppkey DESC
		LIMIT
			9:::INT8;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-07T08:14:18Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@f3bcbd305602c89d52cb7ea4cb114f362c5aee23:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200107-1676733/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:179,sqlsmith.go:184,sqlsmith.go:217,test_runner.go:716: query timed out, but did not cancel execution:
		DELETE FROM defaultdb.public.lineitem AS tab_85 WHERE true;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-07T08:17:19Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@52261c39c65aecf960e3c8d54089a66d378af610:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200107-1676715/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:205,sqlsmith.go:217,test_runner.go:716: ping: dial tcp 146.148.103.184:26257: connect: connection refused
		previous sql:
		BACKUP TABLE defaultdb.public.customer TO 'http://127.0.0.1:43771/backup_2';

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-08T08:17:47Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@873c377178a140d0e997741646b6c6e4318f7e87:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200108-1678603/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:205,sqlsmith.go:217,test_runner.go:716: ping: dial tcp 34.70.224.77:26257: connect: connection refused
		previous sql:
		BACKUP TABLE defaultdb.public.customer TO 'http://127.0.0.1:42065/backup_1' WITH revision_history;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-09T08:09:24Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@94eeef00ebd472e3ab052a6de07b428059351b8d:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200109-1680681/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:205,sqlsmith.go:217,test_runner.go:716: ping: dial tcp 35.239.98.160:26257: connect: connection refused
		previous sql:
		BACKUP TABLE defaultdb.public.customer TO 'http://127.0.0.1:35315/backup_1' WITH revision_history;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-10T08:00:15Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@486a8ac25e0470211f6f7659b26c82950ed013be:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200110-1683261/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:205,sqlsmith.go:217,test_runner.go:716: ping: dial tcp 34.69.106.229:26257: connect: connection refused
		previous sql:
		BACKUP TABLE defaultdb.public.orders TO 'http://127.0.0.1:43399/backup_1' WITH revision_history;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-14T08:19:58Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on master@3d98dae853edbde083cc23b60ad6696958909849:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200114-1688019/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:212,sqlsmith.go:224,test_runner.go:716: ping: dial tcp 35.232.230.53:26257: connect: connection refused
		previous sql:
		EXPORT INTO CSV 'http://127.0.0.1:38637/exp_1' FROM TABLE defaultdb.public.partsupp;

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-01-14T08:38:49Z

(roachtest).sqlsmith/setup=tpch-sf1/setting=default failed on release-19.2@7f2413b36fe1ea31a08c3ddd0d1e4b1cd006db37:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200114-1688037/sqlsmith/setup=tpch-sf1/setting=default/run_1
	sqlsmith.go:135,sqlsmith.go:224,test_runner.go:716: pq: unrecognized configuration parameter "experimental_enable_primary_key_changes"

Repro

Artifacts: /sqlsmith/setup=tpch-sf1/setting=default

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=default PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

_{powered by pkg/cmd/internal/issues}

cockroach-teamcity added C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. labels Nov 1, 2019

cockroach-teamcity added this to the 19.2 milestone Nov 1, 2019

cockroach-teamcity assigned andreimatei Nov 1, 2019

thoszhang mentioned this issue Nov 20, 2019

release: v19.2.1 #42557

Closed

18 tasks

maddyblue closed this as completed Jan 15, 2020

roachtest: sqlsmith/setup=tpch-sf1/setting=default failed #42107

roachtest: sqlsmith/setup=tpch-sf1/setting=default failed #42107

Comments

cockroach-teamcity commented Nov 1, 2019

cockroach-teamcity commented Nov 8, 2019

cockroach-teamcity commented Nov 8, 2019

cockroach-teamcity commented Nov 8, 2019

cockroach-teamcity commented Nov 14, 2019

cockroach-teamcity commented Nov 14, 2019

cockroach-teamcity commented Nov 19, 2019

cockroach-teamcity commented Nov 20, 2019

cockroach-teamcity commented Nov 20, 2019

cockroach-teamcity commented Nov 21, 2019

cockroach-teamcity commented Nov 21, 2019

cockroach-teamcity commented Nov 21, 2019

cockroach-teamcity commented Nov 22, 2019

cockroach-teamcity commented Nov 22, 2019

cockroach-teamcity commented Nov 22, 2019

cockroach-teamcity commented Nov 23, 2019

cockroach-teamcity commented Nov 23, 2019

cockroach-teamcity commented Nov 24, 2019

cockroach-teamcity commented Nov 25, 2019

cockroach-teamcity commented Nov 26, 2019

cockroach-teamcity commented Nov 26, 2019

cockroach-teamcity commented Nov 26, 2019

cockroach-teamcity commented Nov 27, 2019

cockroach-teamcity commented Nov 27, 2019

cockroach-teamcity commented Nov 27, 2019

cockroach-teamcity commented Dec 16, 2019

cockroach-teamcity commented Dec 17, 2019

cockroach-teamcity commented Dec 17, 2019

cockroach-teamcity commented Dec 19, 2019

cockroach-teamcity commented Dec 19, 2019

cockroach-teamcity commented Dec 20, 2019

cockroach-teamcity commented Dec 21, 2019

cockroach-teamcity commented Dec 22, 2019

cockroach-teamcity commented Dec 24, 2019

cockroach-teamcity commented Dec 25, 2019

cockroach-teamcity commented Dec 26, 2019

cockroach-teamcity commented Dec 27, 2019

cockroach-teamcity commented Dec 27, 2019

cockroach-teamcity commented Dec 28, 2019

cockroach-teamcity commented Dec 28, 2019

cockroach-teamcity commented Dec 31, 2019

cockroach-teamcity commented Jan 2, 2020

cockroach-teamcity commented Jan 3, 2020

cockroach-teamcity commented Jan 3, 2020

cockroach-teamcity commented Jan 4, 2020

cockroach-teamcity commented Jan 6, 2020

cockroach-teamcity commented Jan 6, 2020

cockroach-teamcity commented Jan 7, 2020

cockroach-teamcity commented Jan 7, 2020

cockroach-teamcity commented Jan 8, 2020

cockroach-teamcity commented Jan 9, 2020

cockroach-teamcity commented Jan 10, 2020

cockroach-teamcity commented Jan 14, 2020

cockroach-teamcity commented Jan 14, 2020