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=empty/setting=no-ddl failed #42101

Closed
cockroach-teamcity opened this issue Nov 1, 2019 · 22 comments
Closed

roachtest: sqlsmith/setup=empty/setting=no-ddl failed #42101

cockroach-teamcity opened this issue Nov 1, 2019 · 22 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/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=empty/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=1568299&tab=artifacts#/sqlsmith/setup=empty/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/20191101-1568299/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:118,sqlsmith.go:129,test_runner.go:697: ping: dial tcp 34.70.236.139:26257: connect: connection refused
		previous sql:
		WITH
			with_2113 (col_12172)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(2.8543545039633536:::FLOAT8),
								((-1.7401366187771554):::FLOAT8),
								((-0.9570753948080214):::FLOAT8),
								(NULL)
						)
							AS tab_6950 (col_12172)
					EXCEPT ALL
						SELECT
							*
						FROM
							(
								VALUES
									(1.3564199105617627:::FLOAT8),
									((0.4287109473120861:::FLOAT8::FLOAT8 - (-0.30969453605188935):::FLOAT8::FLOAT8)::FLOAT8)
							)
								AS tab_6951 (col_12173)
					UNION ALL
						SELECT
							*
						FROM
							(
								VALUES
									(0.21445102662176307:::FLOAT8),
									((-1.3186107096044428):::FLOAT8),
									(0.9921671957486959:::FLOAT8)
							)
								AS tab_6952 (col_12174)
				)
		SELECT
			'+Inf':::FLOAT8 AS col_12176, tab_6953.col_12175 AS col_12177
		FROM
			(
				VALUES
					('1970-01-05 11:54:24.000559+00:00':::TIMESTAMPTZ),
					(NULL),
					(NULL),
					('1970-01-05 00:52:41.000664+00:00':::TIMESTAMPTZ),
					('1970-01-11 10:48:19.000727+00:00':::TIMESTAMPTZ),
					('1970-01-09 07:37:35.000804+00:00':::TIMESTAMPTZ)
			)
				AS tab_6953 (col_12175),
			with_2113
		WHERE
			true;
@cockroach-teamcity 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 cockroach-teamcity added this to the 19.2 milestone Nov 1, 2019
@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=empty/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=empty/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=empty/setting=no-ddl/run_1
	sqlsmith.go:148,sqlsmith.go:159,test_runner.go:697: ping: dial tcp 104.197.102.13:26257: connect: connection refused
		previous sql:
		SELECT
			tab_8862.col_15228 AS col_15229, tab_8862.col_15227 AS col_15230
		FROM
			(
				VALUES
					(B'1011001000010000011010100', e'\'':::STRING),
					(B'1100001101011010100100001', NULL),
					(B'1100001010101000011100110', e'k]g<G4\x1cDz':::STRING),
					(
						(
							SELECT
								B'0111100011000100001000010' AS col_15226
							FROM
								(
									VALUES
										(ARRAY[e'\'':::STRING,'':::STRING,'"':::STRING,'5':::STRING]),
										(ARRAY['':::STRING,e'#\r\x0b':::STRING,'':::STRING]),
										(ARRAY['Xj':::STRING,'':::STRING,e'\x033G\x16p\x01"':::STRING]),
										(ARRAY[e'e\x05':::STRING]),
										(ARRAY[]:::"char"[])
								)
									AS tab_8860 (col_15224),
								(
									VALUES
										(ARRAY[]:::INT2[]),
										(ARRAY[]:::INT2[]),
										(ARRAY[(-368):::INT8,(-31726):::INT8]),
										(ARRAY[8081:::INT8,561:::INT8]),
										(ARRAY[]:::INT2[])
								)
									AS tab_8861 (col_15225)
							GROUP BY
								tab_8860.col_15224, tab_8861.col_15225
							LIMIT
								1:::INT8
						),
						NULL
					),
					(B'1100101011101000001000110', e'\'':::STRING),
					(B'1011111110110001100111000', e'\b\bsw0g\x02Y\'':::STRING)
			)
				AS tab_8862 (col_15227, col_15228)
		ORDER BY
			tab_8862.col_15228, tab_8862.col_15228
		LIMIT
			1:::INT8;

@maddyblue maddyblue mentioned this issue Nov 8, 2019
Closed
@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/33b96613ae532b25a1b6b716453bece9b60ba2d6

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=empty/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=1583742&tab=artifacts#/sqlsmith/setup=empty/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/20191109-1583742/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:132,sqlsmith.go:159,test_runner.go:697: error: pq: internal error: crdb_internal.encode_key(): expected tuple argument for row_tuple, found '\xd03302efbe7056'
		stmt:
		WITH
			with_979 (col_5166) AS (SELECT * FROM (VALUES ('\xd03302efbe7056':::BYTES)) AS tab_2934 (col_5166)),
			with_980 (col_5167)
				AS (
					SELECT
						*
					FROM
						(VALUES (CASE WHEN true THEN NULL ELSE NULL END), (31259:::INT8), (18124:::INT8)) AS tab_2935 (col_5167)
				)
		SELECT
			11660:::INT8 AS col_5168,
			(crdb_internal.encode_key((-716422598150295300):::INT8::INT8, with_980.col_5167::INT8, with_979.col_5166)::BYTES::BYTES || '\x76':::BYTES::BYTES)::BYTES
				AS col_5169
		FROM
			with_980, with_979
		ORDER BY
			with_980.col_5167 DESC
		LIMIT
			87:::INT8;

@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=empty/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=empty/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=empty/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_15726.col_27487 AS col_27493
		FROM
			(
				VALUES
					('1977-07-15':::DATE, '':::STRING),
					('1977-05-30':::DATE, e'+\x0b':::STRING),
					('1971-09-27':::DATE, NULL),
					((NULL::INT8 + NULL::DATE)::DATE, e'\x06uP\f':::STRING)
			)
				AS tab_15726 (col_27487, col_27488)
			JOIN (VALUES ('Pd':::STRING)) AS tab_15727 (col_27489)
				JOIN (VALUES (COALESCE('':::STRING, 'Xb<.t':::STRING)), (NULL), ('uRI60f':::STRING)) AS tab_15728 (col_27490) ON
						(tab_15727.col_27489) = (tab_15728.col_27490) ON
					(tab_15726.col_27488) = (tab_15727.col_27489) AND (tab_15726.col_27488) = (tab_15728.col_27490)
			JOIN (
					VALUES
						(
							CASE
							WHEN (false AND NULL) THEN COALESCE(1352626648:::INT8, 1380980135:::INT8)
							ELSE (-32768):::INT8
							END,
							e';\tM7':::STRING
						),
						((-583539709):::INT8, right('X':::STRING::STRING, 8532587358320321370:::INT8::INT8)::STRING),
						(NULL, NULL),
						(NULL, e'a\x13+]\x139':::STRING)
				)
					AS tab_15729 (col_27491, col_27492) ON
					(tab_15726.col_27488) = (tab_15729.col_27492) AND (tab_15728.col_27490) = (tab_15729.col_27492)
		WHERE
			true
		ORDER BY
			tab_15727.col_27489,
			tab_15726.col_27488,
			tab_15728.col_27490,
			tab_15728.col_27490 DESC,
			tab_15729.col_27492 ASC,
			tab_15726.col_27488 DESC
		LIMIT
			1:::INT8;

@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=empty/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=empty/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=empty/setting=no-ddl/run_1
	sqlsmith.go:150,sqlsmith.go:177,test_runner.go:697: error: pq: internal error: top-level relational expression cannot have outer columns: (5)
		stmt:
		SELECT
			tab_13647.col_23607 AS col_23610, tab_13647.col_23605 AS col_23611
		FROM
			(
				VALUES
					(3993090658:::OID, (), 180718094:::OID, 1.8757636547088623:::FLOAT8),
					(
						1039371249:::OID,
						(),
						65459834:::OID,
						CASE
						WHEN (NOT false) THEN 0.2649086117744446:::FLOAT8
						ELSE COALESCE(0.7156126499176025:::FLOAT8, 0.5060129165649414:::FLOAT8)
						END
					),
					(3014944698:::OID, (), 2895066633:::OID, (-0.050350382924079895):::FLOAT8),
					(
						(
							SELECT
								4058723513:::OID AS col_23603
							FROM
								(VALUES ((-49817.70828458345335):::DECIMAL), (NULL)) AS tab_13646 (col_23602)
							WHERE
								true
							ORDER BY
								tab_13646.col_23602 DESC, tab_13646.col_23602, tab_13646.col_23602 ASC
							LIMIT
								1:::INT8
						),
						(),
						2389117641:::OID,
						0.4915364384651184:::FLOAT8
					)
			)
				AS tab_13647 (col_23604, col_23605, col_23606, col_23607)
		GROUP BY
			tab_13647.col_23605, tab_13647.col_23607
		HAVING
			inet_same_family('213.81.203.234/19':::INET::INET, (SELECT '242.165.4.176/12':::INET AS col_23609 FROM (VALUES (tab_13647.col_23606), (3526970802:::OID), (3037227860:::OID), (955924165:::OID), (4163345588:::OID)) AS tab_13648 (col_23608) ORDER BY tab_13648.col_23608, tab_13648.col_23608 LIMIT 1:::INT8)::INET)::BOOL
		ORDER BY
			tab_13647.col_23605 DESC;

@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=empty/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=empty/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=empty/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_9519 (col_52077) AS (SELECT * FROM (VALUES (23063:::INT8), (24635:::INT8)) AS tab_30310 (col_52077))
		SELECT
			ARRAY[16503:::INT8,14381:::INT8,7617:::INT8] AS col_52097,
			NULL AS col_52098,
			tab_30324.col_52095 AS col_52099,
			tab_30324.col_52095 AS col_52100,
			tab_30324.col_52095 AS col_52101,
			tab_30322.col_52092 AS col_52102
		FROM
			(VALUES (1771631561:::OID), (NULL), (3584711306:::OID), (2858002643:::OID)) AS tab_30313 (col_52080)
			JOIN (
					VALUES
						(ARRAY[]:::INT2[]),
						(ARRAY[13439:::INT8,(-13370):::INT8,13853:::INT8]),
						(ARRAY[(-10525):::INT8,(-1454):::INT8,17402:::INT8,(-16699):::INT8]),
						(NULL),
						(ARRAY[(-3273):::INT8,25568:::INT8]),
						(ARRAY[29551:::INT8])
				)
					AS tab_30322 (col_52092)
				JOIN (VALUES (69865622:::OID, ARRAY[18579:::INT8,27382:::INT8,(-20245):::INT8]))
						AS tab_30323 (col_52093, col_52094) ON (tab_30322.col_52092) = (tab_30323.col_52094) ON
					(tab_30313.col_52080) = (tab_30323.col_52093)
			JOIN (
					VALUES
						(85930154:::OID), (3783806888:::OID), (1490639716:::OID), (COALESCE(3889393953:::OID, 3798568630:::OID))
				)
					AS tab_30324 (col_52095) ON
					(tab_30313.col_52080) = (tab_30324.col_52095) AND (tab_30323.col_52093) = (tab_30324.col_52095),
			(VALUES (ARRAY[(-23613):::INT8,(-8717):::INT8,9995:::INT8,17886:::INT8,283:::INT8])) AS tab_30325 (col_52096)
		WHERE
			true
		ORDER BY
			tab_30324.col_52095 ASC
		LIMIT
			42:::INT8;

@thoszhang thoszhang mentioned this issue Nov 20, 2019
Closed
18 tasks
@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=empty/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=empty/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=empty/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_562 (col_3017)
				AS (
					SELECT
						*
					FROM
						(VALUES (NULL), (ARRAY['1982-09-19':::DATE,'1997-04-04':::DATE,'1982-07-14':::DATE]))
							AS tab_1694 (col_3017)
				)
		SELECT
			tab_1699.col_3024 AS col_3026,
			e'(\bH':::STRING:::NAME AS col_3027,
			tab_1698.col_3023 AS col_3028,
			tab_1697.col_3022 AS col_3029
		FROM
			(
				VALUES
					(e'Qi\x04L':::STRING:::NAME),
					('':::STRING:::NAME),
					(
						(
							WITH
								with_563 (col_3018)
									AS (
										SELECT
											*
										FROM
											(
												VALUES
													(e'&(m,tyo\\':::STRING),
													(e'1[\x17.qy':::STRING),
													(
														CASE
														WHEN true THEN e'-\x14\x15\x0f\x1az_':::STRING
														ELSE '[Uay-':::STRING
														END
													),
													(e'\x0eb\b<4\rS':::STRING),
													(e'\b\x7f':::STRING),
													('W':::STRING)
											)
												AS tab_1695 (col_3018)
									)
							SELECT
								with_563.col_3018 AS col_3019
							FROM
								with_563
							WHERE
								true
							LIMIT
								1:::INT8
						)
					),
					(
						(
							SELECT
								e'vD\x0e3\x01':::STRING:::NAME AS col_3021
							FROM
								(
									VALUES
										('fb9c5d7b-018d-4212-a5e6-c6342ade3068':::UUID),
										('85872a0d-81f6-4fc1-8ba4-b702d7e06301':::UUID),
										('a0585144-a489-488c-b548-49e72246b8ce':::UUID),
										(NULL),
										(NULL),
										('7af50456-f6fa-4bc2-8a55-6b51a68a368d':::UUID)
								)
									AS tab_1696 (col_3020)
							LIMIT
								1:::INT8
						)
					),
					(e'e\x11':::STRING:::NAME),
					(e'"\x03\x05&\x11\x10\x179[':::STRING:::NAME)
			)
				AS tab_1697 (col_3022)
			RIGHT JOIN (
					VALUES
						(ARRAY[928450447:::OID,82581513:::OID,2918774970:::OID]),
						(ARRAY[1008107047:::OID]),
						(ARRAY[3717070596:::OID,1932654800:::OID])
				)
					AS tab_1698 (col_3023) ON true
			JOIN (VALUES (COALESCE(e'\U00002603':::STRING, NULL))) AS tab_1699 (col_3024) ON
					(tab_1697.col_3022) = (tab_1699.col_3024)
			JOIN (VALUES (e'X\x12`':::STRING), (NULL)) AS tab_1700 (col_3025) ON
					(tab_1697.col_3022) = (tab_1700.col_3025) AND (tab_1699.col_3024) = (tab_1700.col_3025)
		LIMIT
			50:::INT8;

@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=empty/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=empty/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=empty/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_3328 (col_18791, col_18792)
				AS (
					SELECT
						*
					FROM
						(VALUES (1108837355:::INT8, (-1.2847784757614136):::FLOAT8)) AS tab_10966 (col_18791, col_18792)
				),
			with_3336 (col_18876)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('':::STRING),
								(e'\x16':::STRING),
								('X':::STRING),
								(
									(
										SELECT
											e'[}\x1b_g':::STRING AS col_18794
										FROM
											(VALUES (B'011000110100111011010100110011'), (B'101100011100100111011111000101'))
												AS tab_10967 (col_18793)
										ORDER BY
											tab_10967.col_18793 ASC,
											tab_10967.col_18793,
											tab_10967.col_18793,
											tab_10967.col_18793 ASC,
											tab_10967.col_18793 DESC,
											tab_10967.col_18793 DESC,
											tab_10967.col_18793 ASC
										LIMIT
											1:::INT8
									)
								),
								(
									(
										SELECT
											e'n\x14':::STRING AS col_18875
										FROM
											(
												VALUES
													(NULL),
													('09:07:06.851803':::TIME),
													('14:00:31.295435':::TIME),
													('00:00:00':::TIME),
													('15:59:20.99539':::TIME)
											)
												AS tab_11029 (col_18874)
										LIMIT
											1:::INT8
									)
								),
								(e'Fx\x17[\x03\x1a"':::STRING)
						)
							AS tab_11030 (col_18876)
				)
		SELECT
			2676732170:::OID AS col_18939
		FROM
			(
				VALUES
					(2221938922:::OID),
					(NULL),
					(3155903891:::OID),
					(806959329:::OID),
					(2503895814:::OID),
					(
						CASE
						WHEN inet_contained_by_or_equals('93.86.69.73/16':::INET::INET, '1f7c:ca58:ed57:14b3:412a:b62b:beee:1f6d/70':::INET::INET)::BOOL
						THEN NULL
						ELSE 1657038523:::OID
						END
					)
			)
				AS tab_11033 (col_18879)
			JOIN (
					VALUES
						(1941139710:::OID, 1731532388:::OID),
						(3840237597:::OID, 397066038:::OID),
						(NULL, 3429507079:::OID),
						(1280744338:::OID, NULL)
				)
					AS tab_11069 (col_18930, col_18931)
				JOIN (
						VALUES
							(
								581407821:::OID,
								e'2Fx\x06.':::STRING,
								'1970-01-03 14:47:56.000951+00:00':::TIMESTAMPTZ,
								'11:07:12.667649':::TIME,
								(e'{"a": {}, "b": {"bar": {"c": [], "foobar": []}, "foo": "(U.?-}@oAl<"}, "bar": [], "foo": {"Ed5x": {"baz": {}}, "L\\"]": [["4TG"], "c"], "bar": false}, "foobar": "`Sgt"}':::JSONB::JSONB->>2539784068052494907:::INT8::INT8)::STRING
							)
					)
						AS tab_11070 (col_18932, col_18933, col_18934, col_18935, col_18936) ON
						(tab_11069.col_18930) = (tab_11070.col_18932)
				LEFT JOIN (VALUES (15351:::INT8), (26107:::INT8), ((-6004):::INT8), (21067:::INT8), (3876:::INT8))
						AS tab_11071 (col_18937) ON (NOT false)
				JOIN (
						VALUES
							(1302125024:::OID),
							(1116518118:::OID),
							(NULL),
							(2461842840:::OID),
							(2700106066:::OID),
							(CASE WHEN false THEN 477128359:::OID ELSE NULL END)
					)
						AS tab_11072 (col_18938) ON
						(tab_11070.col_18932) = (tab_11072.col_18938)
						AND (tab_11069.col_18930) = (tab_11072.col_18938)
						AND (tab_11069.col_18931) = (tab_11072.col_18938) ON (tab_11033.col_18879) = (tab_11070.col_18932)
		ORDER BY
			tab_11070.col_18934
		LIMIT
			40:::INT8;

@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=empty/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=empty/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=empty/setting=no-ddl/run_1
	sqlsmith.go:166,sqlsmith.go:177,test_runner.go:697: ping: dial tcp 35.222.221.199:26257: connect: connection refused
		previous sql:
		WITH
			with_2250 (col_11915)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(CASE WHEN NULL THEN 1950067591:::OID ELSE 1503679433:::OID END),
								(963587612:::OID),
								(4064225789:::OID)
						)
							AS tab_6770 (col_11915)
				),
			with_2251 (col_11916)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(NULL),
								(3260239628:::OID),
								(1099713290:::OID),
								(COALESCE(NULL, 663382682:::OID)),
								(NULL),
								(1568356528:::OID)
						)
							AS tab_6771 (col_11916)
				),
			with_2252 (col_11917, col_11918, col_11919)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(ARRAY[]:::FLOAT8[], e'\x02nI\x14':::STRING, '1970-01-01 08:38:24.00025+00:00':::TIMESTAMPTZ),
								(
									ARRAY[(-0.5695168920336442):::FLOAT8,0.37058760999192003:::FLOAT8],
									e'\x03SZ':::STRING,
									'1970-01-04 13:07:20.00057+00:00':::TIMESTAMPTZ
								),
								(
									ARRAY['+Inf':::FLOAT8,0.9318961722364667:::FLOAT8,'NaN':::FLOAT8,1.1880651260457618:::FLOAT8],
									NULL,
									'1970-01-09 17:29:26.000008+00:00':::TIMESTAMPTZ
								)
						)
							AS tab_6772 (col_11917, col_11918, col_11919)
				)
		SELECT
			tab_6773.col_11922 AS col_11923, NULL AS col_11924, tab_6773.col_11920 AS col_11925
		FROM
			(
				VALUES
					(ARRAY[30811:::INT8,(-21387):::INT8,24449:::INT8,(-25084):::INT8], 1902318023:::OID, NULL),
					(ARRAY[]:::INT2[], 232232892:::OID, ARRAY[29018:::INT8,16043:::INT8,(-14879):::INT8,2273:::INT8]),
					(ARRAY[2731:::INT8,148:::INT8,(-20189):::INT8,31136:::INT8], 3604923035:::OID, NULL)
			)
				AS tab_6773 (col_11920, col_11921, col_11922);

@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=empty/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=empty/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=empty/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_8761.col_15033 AS col_15056,
			(e'{"foobar": {"AmXy93Yzg\\"O/": {}, "Fhny": 1.678228912601524, "X:qpy:pg\\"\\"W": [], "a": {"Ea[eAN*`": [], "bar": {}}, "bar": [], "c": [[]], "foo": {"ZXk\'": 1.0263037700259172}}, "m%~8": [null]}':::JSONB::JSONB->>(-3958366952979374262):::INT8::INT8)::STRING
				AS col_15057,
			NULL AS col_15058
		FROM
			(VALUES (1019666668:::OID, '6*J|f10':::STRING), (NULL, e'#Kl}p\fJ%':::STRING)) AS tab_8761 (col_15033, col_15034)
			JOIN (VALUES (3319707983:::OID), (2053111695:::OID), (488789293:::OID)) AS tab_8767 (col_15043)
				JOIN (VALUES (3859208705:::OID, (), '1970-01-04 03:12:33.000734+00:00':::TIMESTAMP))
						AS tab_8773 (col_15051, col_15052, col_15053)
					JOIN (VALUES (282024704:::OID), (2008285481:::OID), (NULL), (1801348973:::OID), (3591225564:::OID))
							AS tab_8774 (col_15054) ON (tab_8773.col_15051) = (tab_8774.col_15054) ON
						(tab_8767.col_15043) = (tab_8773.col_15051) AND (tab_8767.col_15043) = (tab_8774.col_15054) ON
					(tab_8761.col_15033) = (tab_8774.col_15054)
					AND (tab_8761.col_15033) = (tab_8773.col_15051)
					AND (tab_8761.col_15033) = (tab_8767.col_15043)
			JOIN (VALUES (2332800032:::OID), (1073631885:::OID), (3984913520:::OID)) AS tab_8775 (col_15055) ON
					(tab_8773.col_15051) = (tab_8775.col_15055)
		WHERE
			not_like_escape(tab_8761.col_15034::STRING, e'\n\x10X8I ':::STRING::STRING, tab_8761.col_15034::STRING)::BOOL
		ORDER BY
			tab_8761.col_15033, tab_8773.col_15052 ASC
		LIMIT
			46:::INT8;

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/549d5bb865eaf9f5233cf8a068034637587b4373

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=empty/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=1616574&tab=artifacts#/sqlsmith/setup=empty/setting=no-ddl

								('60 years 7 mons 57 days 22:17:11.96873':::INTERVAL)
						)
							AS tab_17703 (col_30483)
				),
			with_5492 (col_30485)
				AS (SELECT 32767:::INT8 AS col_30485 FROM (VALUES (NULL), (763942023:::OID)) AS tab_17704 (col_30484)),
			with_5495 (col_30492)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(e'\\7<=x\x1d':::STRING),
								(
									(
										WITH
											with_5493 (col_30486)
												AS (
													SELECT
														*
													FROM
														(
															VALUES
																(e'uqixr\x7fZ':::STRING),
																(e'\x02\x145b(\x07':::STRING),
																(NULL),
																(e'$\x13':::STRING)
														)
															AS tab_17705 (col_30486)
												)
										SELECT
											e'i?Z,\x0f':::STRING AS col_30491
										FROM
											(
												VALUES
													(NULL),
													('1970-01-11 09:38:48.000746+00:00':::TIMESTAMPTZ),
													(
														(
															WITH
																with_5494 (col_30487)
																	AS (
																		SELECT
																			*
																		FROM
																			(
																				VALUES
																					(NULL),
																					(NULL),
																					(
																						'-10 years -3 mons -825 days -06:08:10.609571':::INTERVAL
																					)
																			)
																				AS tab_17706 (col_30487)
																	)
															SELECT
																'1970-01-04 18:01:11.000238+00:00':::TIMESTAMPTZ AS col_30489
															FROM
																(
																	VALUES
																		(e'p\x1e4L':::STRING),
																		('OSP cDN':::STRING),
																		(e'\x12>W\x10?\t\x19X':::STRING),
																		('fI':::STRING),
																		('w3':::STRING)
																)
																	AS tab_17707 (col_30488)
															WHERE
																NULL::JSONB NOT IN (NULL,)
															LIMIT
																1:::INT8
														)
													),
													(NULL),
													('1970-01-02 16:11:05.000199+00:00':::TIMESTAMPTZ),
													('1970-01-10 05:19:15.000257+00:00':::TIMESTAMPTZ)
											)
												AS tab_17708 (col_30490)
										ORDER BY
											tab_17708.col_30490 DESC
										LIMIT
											1:::INT8
									)
								),
								(NULL),
								(e'\\7':::STRING),
								(e'\t9P\x17w\r':::STRING),
								(e'|F^j\x10\x19':::STRING)
						)
							AS tab_17709 (col_30492)
					EXCEPT
						SELECT
							*
						FROM
							(
								VALUES
									(e'Q\x7f\x02]$0-I[':::STRING),
									(e'6r18\x1a~hCC':::STRING),
									(e'\x00':::STRING),
									(e'p=85\x1d\x18_f':::STRING),
									(
										(
											SELECT
												e'\x13p1X':::STRING AS col_30494
											FROM
												(VALUES ('201.52.206.108/10':::INET)) AS tab_17710 (col_30493)
											WHERE
												true
											ORDER BY
												tab_17710.col_30493 DESC
											LIMIT
												1:::INT8
										)
									)
							)
								AS tab_17711 (col_30495)
				)
		SELECT
			tab_17715.col_30499 AS col_30503,
			tab_17717.col_30502 AS col_30504,
			tab_17714.col_30498 AS col_30505,
			tab_17716.col_30500 AS col_30506,
			e'\x0f;\txq\x12':::STRING AS col_30507
		FROM
			(
				VALUES
					(e'y@\x0e{\x1e32':::STRING),
					('kbf':::STRING),
					(COALESCE(e'*M(V\x1dNM,;':::STRING, e'\fs8':::STRING)),
					(e'aNPGM\tp\t':::STRING),
					(NULL)
			)
				AS tab_17714 (col_30498)
			JOIN (
					VALUES
						('7A':::STRING),
						(NULL),
						(e'`nn\x10\x17':::STRING),
						('g':::STRING),
						(e'z\x1ds\x02*(:':::STRING),
						(e':\x15<P@=':::STRING)
				)
					AS tab_17715 (col_30499) ON (tab_17714.col_30498) = (tab_17715.col_30499)
			JOIN (VALUES (e'sgs-\b':::STRING)) AS tab_17716 (col_30500) ON (tab_17715.col_30499) = (tab_17716.col_30500)
			JOIN (
					VALUES
						(NULL, NULL), (NULL, 3740733787:::OID), (e'nD\x06':::STRING, 2341299201:::OID), (NULL, 1377606903:::OID)
				)
					AS tab_17717 (col_30501, col_30502) ON
					(tab_17714.col_30498) = (tab_17717.col_30501) AND (tab_17716.col_30500) = (tab_17717.col_30501)
		ORDER BY
			tab_17716.col_30500;

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/39bf64d28ee5a0ab79081b8b0b29230749ea0fff

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=empty/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=1616610&tab=artifacts#/sqlsmith/setup=empty/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/20191128-1616610/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:178,sqlsmith.go:189,test_runner.go:697: ping: dial tcp 35.184.133.231:26257: connect: connection refused
		previous sql:
		WITH
			with_908 (col_5360)
				AS (
					SELECT
						ARRAY[(-19834):::INT8,(-5557):::INT8,6808:::INT8,9805:::INT8,20752:::INT8] AS col_5360
					FROM
						(VALUES ('1970-01-01':::DATE), ('1995-06-23':::DATE), ('1987-04-22':::DATE), ('1995-11-03':::DATE))
							AS tab_3094 (col_5350),
						(
							VALUES
								(
									(
										SELECT
											ARRAY[2154549219:::OID,3613984390:::OID] AS col_5358
										FROM
											(VALUES (e'\x14U\x17!X\x13{':::STRING:::NAME)) AS tab_3095 (col_5351),
											(
												VALUES
													(NULL),
													(extract('':::STRING::STRING, '08:42:34.807722':::TIME::TIME)::FLOAT8),
													((-0.7176472678360781):::FLOAT8),
													(0.4678662286729204:::FLOAT8),
													((-0.41115018988423047):::FLOAT8),
													((-0.15861186651939296):::FLOAT8)
											)
												AS tab_3096 (col_5352),
											(
												VALUES
													(NULL),
													(1067567698:::OID),
													(865042459:::OID),
													(1237139245:::OID),
													(4130959960:::OID),
													(NULL)
											)
												AS tab_3099 (col_5357)
										GROUP BY
											tab_3095.col_5351
										HAVING
											inet_same_family('8509:2720:6ac6:fe3e:b07d:74ed:8249:1ba3/56':::INET::INET, '206.200.9.43/5':::INET::INET)::BOOL
										ORDER BY
											tab_3095.col_5351 DESC, tab_3095.col_5351
										LIMIT
											1:::INT8
									)
								),
								(ARRAY[3593585164:::OID,2490090244:::OID,4147014173:::OID,670740504:::OID]),
								(ARRAY[]:::OID[]),
								(ARRAY[2993712621:::OID]),
								(ARRAY[3558125134:::OID,1773934888:::OID,1416588919:::OID,3665677574:::OID,2048882178:::OID])
						)
							AS tab_3100 (col_5359)
					UNION
						SELECT
							*
						FROM
							(
								VALUES
									(ARRAY[(-27617):::INT8,30136:::INT8,(-24442):::INT8]),
									(ARRAY[(-28455):::INT8,(-16057):::INT8]),
									(ARRAY[]:::INT2[])
							)
								AS tab_3101 (col_5361)
				),
			with_909 (col_5362)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(105312659:::OID),
								(1087613793:::OID),
								(3020452982:::OID),
								(4176192760:::OID),
								(3339413200:::OID),
								(3054758697:::OID)
						)
							AS tab_3102 (col_5362)
				)
		SELECT
			ARRAY[(-5160):::INT8,21509:::INT8,(-23845):::INT8] AS col_5363
		FROM
			with_908;

@cockroach-teamcity
Copy link
Member Author

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

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=empty/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=1622074&tab=artifacts#/sqlsmith/setup=empty/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/20191203-1622074/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:162,sqlsmith.go:190,test_runner.go:697: error: pq: internal error: couldn't find With expression with ID 3
		stmt:
		SELECT
			NULL AS col_11031, tab_6333.col_11025 AS col_11032, tab_6332.col_11024 AS col_11033
		FROM
			(VALUES (e'Ri3F\\':::STRING), (e'\x181\nc]':::STRING)) AS tab_6332 (col_11024)
			LEFT JOIN (VALUES (NULL)) AS tab_6333 (col_11025) ON false,
			(
				VALUES
					('186.186.51.99/11':::INET),
					('118.175.143.244/9':::INET),
					(broadcast('190.28.252.205/23':::INET::INET)::INET),
					('113.101.174.47/23':::INET)
			)
				AS tab_6334 (col_11026)
		WHERE
			tab_6333.col_11025::FLOAT8
			NOT IN (
					WITH
						with_2101 (col_11027)
							AS (
								SELECT
									*
								FROM
									(
										VALUES
											(NULL),
											(ARRAY[224141378:::OID,1238577884:::OID,3050323267:::OID]),
											(ARRAY[4223276119:::OID,840056446:::OID,3164391012:::OID]),
											(ARRAY[4268606640:::OID,3524782823:::OID,2127721321:::OID])
									)
										AS tab_6335 (col_11027)
							),
						with_2102 (col_11028)
							AS (
								SELECT
									*
								FROM
									(
										VALUES
											(ARRAY[2319351013:::OID,1468291451:::OID]),
											(ARRAY[542580400:::OID]),
											(ARRAY[1269254130:::OID,546254960:::OID]),
											(ARRAY[2927772515:::OID,3288837387:::OID,412085905:::OID,2375358407:::OID]),
											(NULL),
											(ARRAY[1355080135:::OID])
									)
										AS tab_6336 (col_11028)
							),
						with_2103 (col_11029)
							AS (
								SELECT
									*
								FROM
									(
										VALUES
											(
												('1981-10-06':::DATE::DATE + age('1970-01-11 09:03:17.000261+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL::INTERVAL)::TIMESTAMP
											)
									)
										AS tab_6337 (col_11029)
							)
					SELECT
						tab_6333.col_11025::FLOAT8 AS col_11030
					FROM
						with_2103
					ORDER BY
						with_2103.col_11029 ASC, with_2103.col_11029 ASC, with_2103.col_11029 DESC, with_2103.col_11029
				)
		LIMIT
			27:::INT8;

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=empty/setting=no-ddl failed on provisional_201912092102_v19.2.2@c85d435c2caa7a3066b1affdcc34b7ed6a6f3653:

The test failed on branch=provisional_201912092102_v19.2.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191209-1634692/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:153,sqlsmith.go:158,sqlsmith.go:191,test_runner.go:700: query timed out, but did not cancel execution:
		SELECT
			sha1('\x847b':::BYTES::BYTES)::STRING AS col_6407,
			e'zp|&\f':::STRING AS col_6408,
			0.8016126389930045:::FLOAT8 AS col_6409,
			tab_3651.col_6402 AS col_6410,
			'MW)o!Is':::STRING:::NAME AS col_6411,
			tab_3653.col_6405 AS col_6412
		FROM
			(
				VALUES
					(0.013145047396657256:::FLOAT8, 'X':::STRING),
					(NULL, e'\x00':::STRING),
					('NaN':::FLOAT8, COALESCE('':::STRING:::NAME, 'xw':::STRING:::NAME)),
					((-1.9883442925077763):::FLOAT8, ';Qdk':::STRING:::NAME),
					(
						(1.3663809054956113:::FLOAT8::FLOAT8 // (-0.7725723048637168):::FLOAT8::FLOAT8)::FLOAT8,
						e'&bu\t\x07j\x1e':::STRING:::NAME
					),
					(1.5784056562638735:::FLOAT8, e'|$P\x1e-':::STRING:::NAME)
			)
				AS tab_3651 (col_6401, col_6402)
			INNER JOIN (
					VALUES
						(e'\x0e;\x1e':::STRING),
						((e'_\x1eKp`UD':::STRING::STRING || e'\x10':::STRING::STRING)::STRING),
						(
							(e'{"2H+9V}R,\'I0": [[]], "Hpl?,;v4=s": {"c": {"8>COjA}D": []}}, "XLwP": {"(;>a": false}, "b": {}, "bar": {"X|]7": {}, "bar": {"a": false, "foobar": []}, "vSLU": "f,4?n^\'$b )"}, "~cy": {}}':::JSONB::JSONB->>746654939041373451:::INT8::INT8)::STRING
						),
						(e'z\x03':::STRING),
						(
							('[{"c": {"8[by&5d>-Kc": "PIC6g75S`", "SRXHH{UJ^/S": {}}, "j*+[*O_>.`%": [], "xR#>": false}, {"b": {">D{Qj]op=": {}}, "baz": {"N{PN1DK@Szd": []}, "foo": true}]':::JSONB::JSONB->>NULL::INT8)::STRING
						),
						('ibw:OCE}':::STRING)
				)
					AS tab_3652 (col_6403) ON true
			JOIN (VALUES ('?h':::STRING, 28966:::INT8)) AS tab_3653 (col_6404, col_6405) ON
					(tab_3651.col_6402) = (tab_3653.col_6404)
			JOIN (
					VALUES
						(e'h\x04A%o=':::STRING),
						('':::STRING),
						(NULL),
						((NULL::JSONB->>e'\nGp':::STRING::STRING)::STRING),
						(NULL)
				)
					AS tab_3654 (col_6406) ON
					(tab_3651.col_6402) = (tab_3654.col_6406)
					AND (tab_3653.col_6404) = (tab_3654.col_6406)
					AND (tab_3652.col_6403) = (tab_3654.col_6406)
		ORDER BY
			tab_3653.col_6404;
details

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/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=empty/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=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/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=empty/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=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/setting=no-ddl failed on master@bf8d6db2ef9b66d301996cbb8ebbb15b7c978d1a:

										)
											AS tab_8525 (col_15217)
								)
						SELECT
							cte_ref_847.col_15215 AS col_15223,
							tab_8530.col_15222 AS col_15224,
							cte_ref_848.col_15217 AS col_15225
						FROM
							with_2853 AS cte_ref_848,
							with_2853 AS cte_ref_849,
							(
								VALUES
									(
										CASE
										WHEN NULL
										THEN age((current_timestamp(4209073291749741694:::INT8::INT8):::DATE::DATE::DATE + '17:58:45.176617-01:47:00':::TIMETZ::TIMETZ)::TIMESTAMPTZ::TIMESTAMPTZ, '1970-01-03 01:21:31.000629+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL
										ELSE '-20 years -9 mons -133 days -19:16:09.98402':::INTERVAL
										END
									),
									('66 years 1 mon 144 days 08:44:55.952151':::INTERVAL),
									(
										('1970-01-06 20:40:06.000372+00:00':::TIMESTAMPTZ::TIMESTAMPTZ - ('1982-05-20':::DATE::DATE + '11:38:16.21499-01:26:00':::TIMETZ::TIMETZ)::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL
									),
									(age(NULL::TIMESTAMPTZ)::INTERVAL),
									('42 years 11 mons 143 days 07:14:38.997008':::INTERVAL),
									('-51 years -844 days -15:44:57.073506':::INTERVAL)
							)
								AS tab_8530 (col_15222)
						WHERE
							true
						ORDER BY
							tab_8530.col_15222 DESC
						LIMIT
							15:::INT8
					)
						AS tab_8531 (col_15226, col_15227, col_15228),
					(VALUES (tab_8524.col_15216), (3681078718:::OID)) AS tab_8532 (col_15229)
				ORDER BY
					tab_8532.col_15229 ASC
				LIMIT
					1:::INT8
			)
				AS col_15231
		FROM
			(VALUES (2392765322:::OID), (531279430:::OID), (2173196212:::OID), (1532691528:::OID)) AS tab_8524 (col_15216),
			with_2852 AS cte_ref_847
		WHERE
			true
		LIMIT
			67:::INT8;
Repro

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/setting=no-ddl failed on master@f1f15250871d124178f40bf340ef48719b50e7e5:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191231-1668189/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: expected constant FD to be strict: lax-key(); ()-->(2)
		stmt:
		SELECT
			CASE WHEN NULL THEN B'0101001' ELSE tab_1009.col_1751 END AS col_1752, tab_1008.col_1750 AS col_1753
		FROM
			(VALUES (NULL)) AS tab_1008 (col_1750) FULL JOIN (VALUES (NULL)) AS tab_1009 (col_1751) ON false
		ORDER BY
			tab_1008.col_1750;
Repro

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/setting=no-ddl failed on master@a99740bb34c03ab3af7558129edce9c17c88d4f9:

test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200102-1670273/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: expected constant FD to be strict: lax-key(); ()-->(18)
		stmt:
		WITH
			with_10216 (col_55529)
				AS (
					SELECT
						NULL AS col_55529
					FROM
						(
							VALUES
								('{"a": [true, [[true, [], []]]]}':::JSONB, 'f$FM':::STRING),
								(
									e'{"#/P\\";`|": null, "237!=ULEx8": [[true], {"foo": []}], "b": null, "foo": {"&K0enF\\\\": [], "I4b^qs+rl": true}}':::JSONB,
									NULL
								),
								(
									e'{"+@<?=H@U": [[], [{}], 0.7465494481582174], ">uH9M": {"&^iK6E": {}}, "b": "!<il>>", "rt{Mu.N@A)": {"foobar": [[]]}, "u8[dpg": {"#s_}xvM5#": {}, "Y9\\\\90;n": false, "foo": [[]]}}':::JSONB,
									'.':::STRING
								)
						)
							AS tab_32062 (col_55526, col_55527)
						JOIN (VALUES (NULL)) AS tab_32063 (col_55528) ON true
				),
			with_10217 (col_55530)
				AS (SELECT * FROM (VALUES ('44.78.58.128/25':::INET), ('179.18.221.141/7':::INET)) AS tab_32064 (col_55530)),
			with_10218 (col_55531, col_55532)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('139.66.123.83/19':::INET, 'dE':::STRING),
								(set_masklen('110.225.106.204/27':::INET::INET, (-2147483648):::INT8::INT8)::INET, '':::STRING),
								('110.212.35.93/3':::INET, e'\x15e\rCJu':::STRING),
								('175.26.25.213/11':::INET, NULL),
								(
									('84a7:aa21:69cd:4839:7aff:1a89:188b:fdbd/65':::INET::INET - 1:::INT8::INT8)::INET,
									e'\x10\x02\f':::STRING
								)
						)
							AS tab_32065 (col_55531, col_55532)
				)
		SELECT
			tab_32066.col_55533 AS col_55564
		FROM
			(VALUES (NULL), (e'I\x1c\nY\x7f=d':::STRING)) AS tab_32066 (col_55533)
		WHERE
			((tab_32066.col_55533::STRING IN (tab_32066.col_55533, 'pS"0':::STRING)) OR EXISTS (SELECT tab_32066.col_55533 AS col_55563 FROM (VALUES (31819:::INT8, 0:::INT8), (5635:::INT8, 13176:::INT8), ((-13551):::INT8, 15469:::INT8), ((SELECT 19323:::INT8 AS col_55535 FROM (VALUES (B'110110101010101110111'), (B'011101111001000100100')) AS tab_32067 (col_55534) WHERE ilike_escape('':::STRING::STRING, from_ip('\x':::BYTES::BYTES)::STRING::STRING, e'"q}\x13\x07':::STRING::STRING)::BOOL ORDER BY tab_32067.col_55534 ASC LIMIT 1:::INT8), 1:::INT8), ((SELECT (-28642):::INT8 AS col_55539 FROM (VALUES (ilike_escape(e'\rzU\x1a\x16\x03dp':::STRING::STRING, e'\x15\x15c_l':::STRING::STRING, tab_32066.col_55533::STRING)::BOOL, (-2717400176638196534):::DECIMAL, 1516108903:::OID)) AS tab_32068 (col_55536, col_55537, col_55538) ORDER BY tab_32068.col_55537 ASC, tab_32068.col_55537, tab_32068.col_55537 ASC LIMIT 1:::INT8), 18293:::INT8)) AS tab_32069 (col_55540, col_55541), (VALUES (tab_32066.col_55533)) AS tab_32087 (col_55561) FULL JOIN (VALUES ((ARRAY[(-6319):::INT8,(-29610):::INT8,20481:::INT8,9057:::INT8,962:::INT8], 'aa11ab61-f10c-4233-aaae-480a56f38eac':::UUID, '1970-01-08 16:00:19.00059+00:00':::TIMESTAMP, '1995-04-14':::DATE))) AS tab_32088 (col_55562) ON false WHERE NULL));
Repro

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/setting=no-ddl 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=empty/setting=no-ddl/run_1
	sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: expected constant FD to be strict: lax-key()
		stmt:
		SELECT
			tab_24479.col_42146 AS col_42147, tab_24478.col_42145 AS col_42148
		FROM
			(VALUES (275147218:::OID)) AS tab_24477 (col_42144)
			FULL JOIN (
					VALUES
						(
							('05ea7a56-7c8b-4f5c-b273-86acc969bb85':::UUID, 296083953:::OID, e'\U00002603':::STRING, '-1 years -31 days -18:49:59.418626':::INTERVAL)
						)
				)
					AS tab_24478 (col_42145) ON false,
			(VALUES (683841987:::OID), (4117395353:::OID), (NULL), (3712828725:::OID), (3463088254:::OID))
				AS tab_24479 (col_42146)
		ORDER BY
			tab_24479.col_42146, tab_24478.col_42145 DESC, tab_24479.col_42146
		LIMIT
			89:::INT8;
Repro

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/setting=no-ddl failed on master@413fd1e46c2936029458db495efa242acb1b7d52:

												e'Pr.zW92\x7f':::STRING
											),
											(
												213917936:::OID,
												(ARRAY['1970-01-11 09:57:14.000854+00:00':::TIMESTAMPTZ,'1970-01-01 18:16:40.000128+00:00':::TIMESTAMPTZ,'1970-01-06 03:05:25.000058+00:00':::TIMESTAMPTZ]::TIMESTAMPTZ[] || NULL::TIMESTAMPTZ[])::TIMESTAMPTZ[],
												e'\x0e\x1aA':::STRING
											),
											(
												3953164338:::OID,
												('1970-01-06 01:21:44.000736+00:00':::TIMESTAMPTZ::TIMESTAMPTZ || ARRAY['1970-01-04 07:30:15.000222+00:00':::TIMESTAMPTZ,'1970-01-06 16:00:06.000761+00:00':::TIMESTAMPTZ]::TIMESTAMPTZ[])::TIMESTAMPTZ[],
												NULL
											),
											(
												NULL,
												ARRAY['0001-01-01 00:00:00+00:00':::TIMESTAMPTZ,'1970-01-09 08:56:36.00054+00:00':::TIMESTAMPTZ],
												e'\x00':::STRING
											),
											(989130671:::OID, ARRAY[]:::TIMESTAMPTZ[], '':::STRING),
											(4037341229:::OID, ARRAY['1970-01-05 23:34:41.000447+00:00':::TIMESTAMPTZ], NULL)
									)
										AS tab_18922 (col_32974, col_32975, col_32976)
									JOIN (VALUES (2127604798:::OID), (157429146:::OID), (2929525678:::OID))
											AS tab_18923 (col_32977) ON (tab_18922.col_32974) = (tab_18923.col_32977) ON
										(tab_18921.col_32973) = (tab_18922.col_32974)
										AND (tab_18921.col_32973) = (tab_18923.col_32977)
						)
				SELECT
					tab_18920.col_32972 AS col_32979
				FROM
					with_6050 AS cte_ref_1797, with_6050 AS cte_ref_1798
				ORDER BY
					cte_ref_1797.col_32978 DESC
				LIMIT
					1:::INT8
			)
				AS col_32980
		FROM
			(
				VALUES
					('1970-01-11 16:18:32.000705+00:00':::TIMESTAMPTZ),
					('1970-01-01 18:44:39.000991+00:00':::TIMESTAMPTZ),
					(
						('1970-01-12 06:37:06.000632+00:00':::TIMESTAMPTZ::TIMESTAMPTZ + '-74 years -11 mons -782 days -17:57:57.264436':::INTERVAL::INTERVAL)::TIMESTAMPTZ
					)
			)
				AS tab_18920 (col_32972)
		ORDER BY
			tab_18920.col_32972 DESC
		LIMIT
			80:::INT8;
Repro

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/setting=no-ddl failed on release-19.2@07057cf68ec19eb0777f611fedaaefde72fe673a:

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/20200111-1684749/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: (-0E-2019):::DECIMAL: could not evaluate -0E-2019 as Datum type DDecimal from string "0E-2019": could not parse "0E-2019" as type decimal
		stmt:
		WITH
			with_3926 (col_21422)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(0.4240960173899057444:::DECIMAL),
								((-1.257307067165449531E+27):::DECIMAL),
								((-413867994737632.6426):::DECIMAL),
								(3.034548956935674982E+28:::DECIMAL),
								((-18329587.61906633305):::DECIMAL),
								((-5.047069074478534636E+20):::DECIMAL)
						)
							AS tab_12392 (col_21422)
				)
		SELECT
			((-3.071496858540236297E+20):::DECIMAL::DECIMAL / 'Infinity':::DECIMAL::DECIMAL)::DECIMAL AS col_21423
		FROM
			with_3926 AS cte_ref_1127
		WHERE
			true
		ORDER BY
			cte_ref_1127.col_21422 DESC, cte_ref_1127.col_21422 ASC
		LIMIT
			71:::INT8;
Repro

Artifacts: /sqlsmith/setup=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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=empty/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=empty/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=empty/setting=no-ddl

make stressrace TESTS=sqlsmith/setup=empty/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