Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

roachtest: sqlsmith/setup=tpch-sf1/setting=no-ddl failed #42218

Closed
cockroach-teamcity opened this issue Nov 6, 2019 · 28 comments
Closed

roachtest: sqlsmith/setup=tpch-sf1/setting=no-ddl failed #42218

cockroach-teamcity opened this issue Nov 6, 2019 · 28 comments
Assignees
@andreimatei
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.
Milestone
19.2

Comments

@cockroach-teamcity
Copy link
Member

SHA: https://github.com/cockroachdb/cockroach/commits/2535f0363b5d9b1e466ca3144fe5bcf7ff17e63c

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=no-ddl PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

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

The test failed on branch=provisional_201911052027_v19.2.0-rc.4, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191106-1577529/sqlsmith/setup=tpch-sf1/setting=no-ddl/run_1
	sqlsmith.go:95,sqlsmith.go:100,sqlsmith.go:129,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_10962.col_18978 AS col_18979,
			'_gjc':::STRING:::NAME AS col_18980,
			tab_10962.col_18978 AS col_18981,
			2804316022:::OID AS col_18982
		FROM
			(VALUES ('\x30ac64367f':::BYTES, 365086495:::OID)) AS tab_10957 (col_18971, col_18972)
			JOIN (VALUES (e'6.\'Q";\rnF':::STRING:::NAME), (e'LR\x1f':::STRING:::NAME), (e'L<\x11\x1dh':::STRING:::NAME))
					AS tab_10960 (col_18975)
				INNER JOIN (
						VALUES
							(559143504:::OID),
							(1147595777:::OID),
							(2468816480:::OID),
							(1591664695:::OID),
							((SELECT 827846161:::OID AS col_18976 LIMIT 1:::INT8))
					)
						AS tab_10961 (col_18977) ON true ON (tab_10957.col_18972) = (tab_10961.col_18977)
			JOIN (VALUES (334619568:::OID), (2448669401:::OID), (1539548664:::OID)) AS tab_10962 (col_18978) ON
					(tab_10961.col_18977) = (tab_10962.col_18978) AND (tab_10957.col_18972) = (tab_10962.col_18978);
@cockroach-teamcity cockroach-teamcity added C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. labels Nov 6, 2019
@cockroach-teamcity cockroach-teamcity added this to the 19.2 milestone Nov 6, 2019
@maddyblue
Copy link
Contributor

I was not able to repro this.

@RaduBerinde RaduBerinde mentioned this issue Nov 7, 2019
Closed
18 tasks
@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:148,sqlsmith.go:159,test_runner.go:697: ping: dial tcp 34.66.16.205:26257: connect: connection refused
		previous sql:
		WITH
			with_240 (col_1179, col_1180)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('1987-06-02':::DATE, ARRAY[2716356361:::OID,3782575219:::OID]),
								('1970-03-08':::DATE, ARRAY[3988598630:::OID,2663591476:::OID,3323221311:::OID]),
								(
									'1976-12-06':::DATE,
									ARRAY[1760099561:::OID,1002117542:::OID,171717903:::OID,1020655556:::OID,637823208:::OID,3890612998:::OID,2431035343:::OID]
								),
								(
									'1989-09-15':::DATE,
									ARRAY[3529021044:::OID,1792235673:::OID,4079266662:::OID,2613388875:::OID]
								),
								('1972-07-12':::DATE, ARRAY[]:::OID[])
						)
							AS tab_643 (col_1179, col_1180)
				)
		SELECT
			3078579123:::OID AS col_1198, tab_657.col_1196 AS col_1199
		FROM
			(
				VALUES
					(ARRAY[1553:::INT8]),
					(ARRAY[1:::INT8,(-27741):::INT8]),
					(ARRAY[21478:::INT8,(-6753):::INT8,0:::INT8,27120:::INT8,(-1):::INT8]),
					(ARRAY[(-14500):::INT8,(-6465):::INT8,6376:::INT8]),
					(ARRAY[(-12667):::INT8,32767:::INT8,(-15144):::INT8,(-19840):::INT8]),
					(ARRAY[]:::INT2[])
			)
				AS tab_657 (col_1196)
			CROSS JOIN (VALUES (66361421:::OID), (4009851480:::OID), (3159512047:::OID), (NULL), (805453280:::OID))
					AS tab_658 (col_1197)
		WHERE
			true;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:102,sqlsmith.go:177,test_runner.go:697: pq: cannot use "into_db" option when restoring database(s)

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:102,sqlsmith.go:177,test_runner.go:697: pq: cannot use "into_db" option when restoring database(s)

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			(-5680409041406721359):::INT8 AS col_397,
			tab_169.l_orderkey AS col_398,
			'1982-10-09':::DATE AS col_399,
			tab_169.l_linenumber AS col_400,
			NULL AS col_401,
			tab_170.p_retailprice AS col_402
		FROM
			defaultdb.public.lineitem AS tab_169, defaultdb.public.part AS tab_170;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_7 (col_35)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('21:54:54.786298':::TIME),
								(NULL),
								(NULL),
								(CASE WHEN true THEN NULL ELSE '23:13:11.275566':::TIME END),
								('06:49:24.912943':::TIME),
								('11:35:07.355655':::TIME)
						)
							AS tab_25 (col_35)
				),
			with_8 (col_36) AS (SELECT * FROM (VALUES (e'\x1f':::STRING), ('':::STRING)) AS tab_26 (col_36))
		SELECT
			tab_29.l_linestatus AS col_37, tab_28.s_suppkey AS col_38, tab_29.l_comment AS col_39
		FROM
			defaultdb.public.partsupp AS tab_27
			JOIN defaultdb.public.supplier AS tab_28 ON (tab_27.ps_suppkey) = (tab_28.s_suppkey),
			defaultdb.public.lineitem AS tab_29
		ORDER BY
			tab_29.l_extendedprice DESC
		LIMIT
			76:::INT8;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_65 (col_363)
				AS (SELECT * FROM (VALUES (ARRAY[7605:::INT8,(-12940):::INT8,(-459):::INT8])) AS tab_190 (col_363)),
			with_66 (col_364) AS (SELECT 6986365369041354108:::INT8 AS col_364 FROM with_65, defaultdb.public.part AS tab_191)
		SELECT
			tab_192.ps_supplycost AS col_365,
			with_66.col_364 AS col_366,
			NULL AS col_367,
			(-3689324390165260658):::INT8 AS col_368,
			3895383030540645725:::INT8 AS col_369,
			tab_192.ps_comment AS col_370
		FROM
			with_66, defaultdb.public.partsupp AS tab_192;

@thoszhang thoszhang mentioned this issue Nov 20, 2019
Closed
18 tasks
@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			(-7518737297513863685):::INT8 AS col_204,
			'G+@M':::STRING AS col_205,
			127:::INT8 AS col_206,
			tab_111.ps_suppkey AS col_207
		FROM
			defaultdb.public.supplier AS tab_109, defaultdb.public.partsupp AS tab_110, defaultdb.public.partsupp AS tab_111
		ORDER BY
			tab_110.ps_supplycost
		LIMIT
			9:::INT8;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_9 (col_27)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								((-9223372036854775807):::INT8),
								(8192822838099353702:::INT8),
								((-8761793361591078829):::INT8),
								((-32768):::INT8),
								((-6261140507478043644):::INT8)
						)
							AS tab_16 (col_27)
				),
			with_10 (col_28)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(0.320427121583172:::FLOAT8),
								(mod((-0.6085070485048814):::FLOAT8::FLOAT8, NULL::FLOAT8)::FLOAT8),
								(0.2756723261275512:::FLOAT8),
								('-Inf':::FLOAT8),
								(1.0:::FLOAT8),
								((-0.4756152393165611):::FLOAT8)
						)
							AS tab_17 (col_28)
				)
		SELECT
			e'nK\x1ft\x1d\x177':::STRING AS col_29, (-9223372036854775807):::INT8 AS col_30, '':::STRING AS col_31
		FROM
			defaultdb.public.region AS tab_18, defaultdb.public.lineitem AS tab_19, with_10
		WHERE
			true
		ORDER BY
			tab_18.r_comment, tab_19.l_discount DESC;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			'O':::STRING AS col_141, tab_50.s_comment AS col_142, tab_51.c_acctbal AS col_143
		FROM
			defaultdb.public.supplier AS tab_50, defaultdb.public.customer AS tab_51, defaultdb.public.orders AS tab_52;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_49 (col_301)
				AS (
					SELECT
						*
					FROM
						(VALUES (1273971671:::INT8), (911572571:::INT8), (471098938:::INT8), (NULL), (NULL))
							AS tab_160 (col_301)
				),
			with_50 (col_302)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('':::STRING),
								(e'8\x1bC)bGW':::STRING),
								(CASE WHEN false THEN '#D}#':::STRING ELSE e'C\x0f,':::STRING END),
								(e'\x17\x04fF\x7f\x06':::STRING),
								('':::STRING),
								(e'P\x10Cb8':::STRING)
						)
							AS tab_161 (col_302)
				)
		SELECT
			'1970-01-01':::DATE AS col_303,
			(-0.5332958893970873):::FLOAT8 AS col_304,
			tab_162.l_orderkey AS col_305,
			'':::STRING AS col_306,
			tab_162.l_returnflag AS col_307,
			0.28628423485923066:::FLOAT8 AS col_308,
			(-1.0):::FLOAT8 AS col_309,
			'pf':::STRING AS col_310,
			tab_164.l_quantity AS col_311,
			tab_164.l_returnflag AS col_312,
			'1992-07-23':::DATE AS col_313,
			NULL AS col_314,
			NULL AS col_315,
			tab_162.l_receiptdate AS col_316,
			tab_164.l_shipmode AS col_317,
			array_position(ARRAY['10:18:30.773208+02:19:00':::TIMETZ,'11:30:24.26326+03:51:00':::TIMETZ,'10:48:16.176018+02:42:00':::TIMETZ]::TIMETZ[], '13:17:43.842297-04:46:00':::TIMETZ::TIMETZ)::INT8
				AS col_318
		FROM
			defaultdb.public.lineitem AS tab_162, defaultdb.public.region AS tab_163, defaultdb.public.lineitem AS tab_164
		ORDER BY
			tab_164.l_shipmode ASC, tab_164.l_discount, tab_162.l_suppkey, tab_164.l_linestatus DESC
		LIMIT
			13:::INT8;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_49.l_comment AS col_125,
			NULL AS col_126,
			tab_49.l_extendedprice AS col_127,
			e'[\x1a~':::STRING AS col_128,
			COALESCE(1.408140890343644:::FLOAT8, tab_49.l_extendedprice) AS col_129,
			tab_49.l_linenumber AS col_130,
			(-6100545058687958965):::INT8 AS col_131,
			tab_49.l_shipinstruct AS col_132,
			NULL AS col_133,
			4649146724907584277:::INT8 AS col_134,
			0.26447654832285394:::FLOAT8 AS col_135,
			e',P\x07g\x03i':::STRING AS col_136,
			tab_49.l_quantity AS col_137,
			'1976-10-09':::DATE AS col_138,
			((-7132871932794979131):::INT8::INT8 + tab_49.l_commitdate::DATE)::DATE AS col_139,
			tab_49.l_returnflag AS col_140
		FROM
			defaultdb.public.lineitem AS tab_49
		ORDER BY
			tab_49.l_commitdate ASC, tab_49.l_shipdate ASC, tab_49.l_shipinstruct ASC;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			'1975-03-31':::DATE AS col_101
		FROM
			defaultdb.public.lineitem AS tab_57
		WHERE
			tab_57.l_commitdate::DATE
			NOT IN (
					SELECT
						tab_57.l_shipdate::DATE AS col_100
					FROM
						defaultdb.public.nation AS tab_58, defaultdb.public.customer AS tab_59
				)
		ORDER BY
			tab_57.l_returnflag DESC;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_63.l_returnflag AS col_108,
			tab_63.l_commitdate AS col_109,
			7849849111485359338:::INT8 AS col_110,
			0.6626694438030913:::FLOAT8 AS col_111,
			tab_63.l_linenumber AS col_112,
			tab_63.l_shipdate AS col_113
		FROM
			defaultdb.public.lineitem AS tab_63, defaultdb.public.region AS tab_64
		WHERE
			true
		ORDER BY
			tab_63.l_receiptdate;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_13.p_brand AS col_21,
			tab_13.p_brand AS col_22,
			tab_13.p_mfgr AS col_23,
			tab_14.p_name AS col_24,
			tab_13.p_mfgr AS col_25,
			e'\x10/[':::STRING AS col_26,
			tab_13.p_partkey AS col_27,
			e';Q,h\nmC':::STRING AS col_28,
			tab_14.p_partkey AS col_29,
			tab_14.p_size AS col_30,
			tab_13.p_container AS col_31,
			tab_14.p_partkey AS col_32,
			(-1.9499461877971265):::FLOAT8 AS col_33,
			tab_14.p_retailprice AS col_34,
			e'm\x12[~':::STRING AS col_35,
			tab_13.p_container AS col_36,
			'+H(mJoE':::STRING AS col_37,
			e't\x07:Vl':::STRING AS col_38
		FROM
			defaultdb.public.part AS tab_13, defaultdb.public.part AS tab_14
		ORDER BY
			tab_13.p_partkey DESC;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_126;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_23.l_commitdate AS col_53, tab_24.c_custkey AS col_54
		FROM
			defaultdb.public.lineitem AS tab_23, defaultdb.public.customer AS tab_24
		ORDER BY
			tab_23.l_linestatus ASC;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			e'm\x064]':::STRING AS col_42,
			tab_24.o_orderkey AS col_43,
			tab_24.o_orderdate AS col_44,
			'TdswR%%':::STRING AS col_45,
			tab_23.ps_availqty AS col_46
		FROM
			defaultdb.public.partsupp AS tab_23, defaultdb.public.orders AS tab_24
		ORDER BY
			tab_24.o_orderpriority DESC
		LIMIT
			76:::INT8;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_shipdate = tab_1.l_commitdate;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			e'N\fIY*)1\x1f.':::STRING AS col_407, tab_204.o_totalprice AS col_408
		FROM
			defaultdb.public.orders AS tab_204, defaultdb.public.orders AS tab_205
		ORDER BY
			tab_205.o_comment, tab_205.o_orderstatus DESC
		LIMIT
			12:::INT8;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/run_1
	sqlsmith.go:150,sqlsmith.go:177,test_runner.go:697: error: pq: internal error: uncaught error: exponent out of range
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.Condition.GoError
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/condition.go:107
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*Context).goError
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/context.go:83
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*Context).Mul
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/context.go:211
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*Context).Mul-fm
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/error.go:114
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*ErrDecimal).op3
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/error.go:61
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*ErrDecimal).Mul
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/error.go:114
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*Context).integerPower
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/context.go:1007
		github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd.(*Context).Pow
			/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/context.go:1105
		github.com/cockroachdb/cockroach/pkg/sql/sem/tree.IntPow
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/eval.go:4927
		github.com/cockroachdb/cockroach/pkg/sql/sem/tree.glob..func98
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/eval.go:1417
		github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).Eval
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/eval.go:2818
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*exprHelper).eval
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/expr.go:194
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*ProcOutputHelper).ProcessRow
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/processors.go:375
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*ProcessorBase).ProcessRowHelper
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/processors.go:778
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*sorterBase).Next
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/sorter.go:132
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.Run
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/base.go:174
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*ProcessorBase).Run
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/processors.go:801
		github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*Flow).startInternal.func1
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/flow.go:566
		runtime.goexit
			/usr/local/go/src/runtime/asm_amd64.s:1333
		stmt:
		SELECT
			tab_21.c_mktsegment AS col_62,
			tab_21.c_comment AS col_63,
			tab_21.c_custkey AS col_64,
			'L':::STRING AS col_65,
			((-5278541660114485864):::INT8::INT8 ^ 2147483647:::INT8::INT8)::INT8 AS col_66,
			tab_21.c_address AS col_67,
			e'f1\\\f9*':::STRING AS col_68,
			tab_21.c_acctbal AS col_69
		FROM
			defaultdb.public.customer AS tab_21
		ORDER BY
			tab_21.c_address ASC
		LIMIT
			92:::INT8;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_4.c_comment AS col_3, tab_3.c_mktsegment AS col_4, tab_4.c_address AS col_5, tab_3.c_custkey AS col_6
		FROM
			defaultdb.public.customer AS tab_3, defaultdb.public.customer AS tab_4
		WHERE
			true;

@cockroach-teamcity
Copy link
Member Author

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=no-ddl 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=no-ddl

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=no-ddl/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_21 SET o_orderdate = '1977-11-12':::DATE WHERE true;

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/0da08d85deeafe859345c6898e0aadd0c24236fa

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=no-ddl PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

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

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/20191127-1613988/sqlsmith/setup=tpch-sf1/setting=no-ddl/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_27 (col_111, col_112)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									(
										SELECT
											797260481:::OID AS col_110
										FROM
											defaultdb.public.lineitem AS tab_70
										ORDER BY
											tab_70.l_shipdate
										LIMIT
											1:::INT8
									),
									'14:31:34.551829':::TIME
								),
								(NULL, '07:56:13.433853':::TIME),
								(3396449436:::OID, '01:49:23.893675':::TIME),
								(890509012:::OID, '04:47:39.622634':::TIME),
								(3251166630:::OID, '11:12:58.575058':::TIME),
								(134974825:::OID, '05:31:29.336068':::TIME)
						)
							AS tab_71 (col_111, col_112)
				),
			with_31 (col_117)
				AS (
					SELECT
						false AS col_117
					FROM
						defaultdb.public.supplier AS tab_72
					WHERE
						EXISTS(
							WITH
								with_28 (col_113) AS (SELECT * FROM (VALUES (()), (())) AS tab_73 (col_113)),
								with_29 (col_114)
									AS (
										SELECT
											*
										FROM
											(
												VALUES
													(397136991:::OID),
													(2211584181:::OID),
													(3916394337:::OID),
													(3349159635:::OID),
													(3634937310:::OID),
													(2965747030:::OID)
											)
												AS tab_74 (col_114)
									),
								with_30 (col_115)
									AS (
										SELECT
											*
										FROM
											(
												VALUES
													('1970-01-08 07:19:28.000342+00:00':::TIMESTAMPTZ),
													('1970-01-09 08:53:30.000519+00:00':::TIMESTAMPTZ),
													('1970-01-07 20:34:43.000501+00:00':::TIMESTAMPTZ),
													('1970-01-03 15:40:36.000966+00:00':::TIMESTAMPTZ)
											)
												AS tab_75 (col_115)
									)
							SELECT
								1441473355:::OID AS col_116
							FROM
								defaultdb.public.customer AS tab_76
								JOIN defaultdb.public.orders AS tab_77 ON (tab_76.c_custkey) = (tab_77.o_orderkey)
							LIMIT
								11:::INT8
						)
				)
		SELECT
			NULL AS col_118,
			tab_78.p_container AS col_119,
			(-2147483648):::INT8 AS col_120,
			tab_79.s_phone AS col_121,
			tab_78.p_comment AS col_122,
			tab_78.p_comment AS col_123,
			tab_79.s_suppkey AS col_124,
			e'\x02\t\x1cI3\\lw\f':::STRING AS col_125,
			(-1):::INT8 AS col_126,
			0.37417142275854265:::FLOAT8 AS col_127,
			tab_78.p_retailprice AS col_128
		FROM
			defaultdb.public.part AS tab_78, defaultdb.public.supplier AS tab_79
		ORDER BY
			tab_78.p_partkey DESC;

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=tpch-sf1/setting=no-ddl failed on release-19.2@3441d86e83a2c2a5f3f473e480854658ca631d4f:

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/20191212-1640179/sqlsmith/setup=tpch-sf1/setting=no-ddl/run_1
	cluster.go:1152,cluster.go:1163,sqlsmith.go:98,sqlsmith.go:217,test_runner.go:700: invalid node range: 0-0 (1-4)
details

Artifacts: /sqlsmith/setup=tpch-sf1/setting=no-ddl

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

powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=tpch-sf1/setting=no-ddl failed on master@e81faed54ee90bdfed1dddc63bb13d1ecf8806da:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191212-1640161/sqlsmith/setup=tpch-sf1/setting=no-ddl/run_1
	cluster.go:1152,cluster.go:1163,sqlsmith.go:98,sqlsmith.go:217,test_runner.go:700: invalid node range: 0-0 (1-4)
details

Artifacts: /sqlsmith/setup=tpch-sf1/setting=no-ddl

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

powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=tpch-sf1/setting=no-ddl 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=no-ddl/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=no-ddl

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

powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=tpch-sf1/setting=no-ddl 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=no-ddl/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=no-ddl

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

powered by pkg/cmd/internal/issues

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andreimatei andreimatei

Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.
Projects
None yet
Milestone
19.2
Development

No branches or pull requests
3 participants
@maddyblue @andreimatei @cockroach-teamcity