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.

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

roachtest: sqlsmith/setup=tpch-sf1/setting=no-mutations failed #42212

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

Comments

@cockroach-teamcity
Copy link
Member

SHA: https://github.com/cockroachdb/cockroach/commits/239513342a2d23f683bbc1d386f87ff59cc78d10

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

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

The test failed on branch=provisional_201910141814_v19.2.0-rc.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191106-1575479/sqlsmith/setup=tpch-sf1/setting=no-mutations/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_23723.col_40997 AS col_41010, '1364:6993:6ac9:d000:99b5:2fa4:dcd3:b6c8/127':::INET AS col_41011
		FROM
			(VALUES (3108791842:::OID), (CASE WHEN false THEN 3160053219:::OID ELSE NULL END), (NULL), (NULL))
				AS tab_23723 (col_40997)
			JOIN (VALUES (121164983:::OID), (3819446744:::OID), (622086217:::OID), (3926797683:::OID), (NULL))
					AS tab_23724 (col_40998) ON (tab_23723.col_40997) = (tab_23724.col_40998)
			JOIN (
					VALUES
						('218.37.65.115/17':::INET),
						('138.154.252.126/10':::INET),
						('a074:1ffd:39f0:270e:7b02:d097:a4a9:61a9/80':::INET),
						(NULL)
				)
					AS tab_23730 (col_41008)
				CROSS JOIN (VALUES (CASE WHEN true THEN 4100386549:::OID ELSE 4191485224:::OID END)) AS tab_23731 (col_41009) ON
					(tab_23724.col_40998) = (tab_23731.col_41009) AND (tab_23723.col_40997) = (tab_23731.col_41009)
		WHERE
			(NOT false)
		ORDER BY
			tab_23723.col_40997 DESC, tab_23731.col_41009 DESC, tab_23724.col_40998 ASC, tab_23730.col_41008 ASC;

@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 maddyblue assigned yuzefovich and unassigned andreimatei Nov 6, 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=tpch-sf1/setting=no-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:148,sqlsmith.go:159,test_runner.go:697: ping: dial tcp 34.69.108.178:26257: connect: connection refused
		previous sql:
		WITH
			with_3073 (col_16156)
				AS (
					SELECT
						*
					FROM
						(VALUES (B'011100001111001100101'), (B'000000111001100000111'), (NULL)) AS tab_9309 (col_16156)
				)
		SELECT
			tab_9310.col_16157 AS col_16161, tab_9310.col_16158 AS col_16162, tab_9310.col_16159 AS col_16163
		FROM
			(
				VALUES
					(B'01001100100010100001001100101101110100000101', e'\'':::STRING, NULL),
					(B'11011011011101100011000110101110011000000010', '"':::STRING:::NAME, NULL),
					(
						B'10010000110111111010111011000100100001101011',
						COALESCE(e'G0hvoW\x04':::STRING:::NAME, e'\'W/R\x03\x06\t':::STRING:::NAME),
						'03:45:20.241507':::TIME
					),
					(B'00100110101101010101011001000001001011011101', NULL, '23:59:59.999999':::TIME),
					(NULL, ':0<':::STRING:::NAME, ('16:22:26.69154':::TIME::TIME - NULL::INTERVAL)::TIME)
			)
				AS tab_9310 (col_16157, col_16158, col_16159)
		WHERE
			(false >= EXISTS (SELECT (-0.6838976144790649):::FLOAT8 AS col_16160 LIMIT 64:::INT8))
		ORDER BY
			tab_9310.col_16159
		LIMIT
			75:::INT8;

@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=tpch-sf1/setting=no-mutations 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=tpch-sf1/setting=no-mutations

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=tpch-sf1/setting=no-mutations/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 ARRAY['111.119.192.37/28','199.69.228.27/17','56b4:b441:730:c04e:b5ec:74b4:8b79:7e98/25']
		stmt:
		SELECT
			tab_15480.col_26715 AS col_26717, tab_15481.col_26716 AS col_26718
		FROM
			(
				VALUES
					(
						CASE
						WHEN NULL THEN '\x19b25f0fd46d8b95':::BYTES
						ELSE crdb_internal.encode_key((-691086265239209306):::INT8::INT8, (-7133676528805508769):::INT8::INT8, ARRAY['111.119.192.37/28':::INET,'199.69.228.27/17':::INET,'56b4:b441:730:c04e:b5ec:74b4:8b79:7e98/25':::INET])::BYTES
						END
					),
					(NULL),
					(NULL),
					('\x00':::BYTES),
					('\x90690e41ae9a':::BYTES)
			)
				AS tab_15480 (col_26715),
			(VALUES (2887634353226431655:::INT8), ((-4736740496667390361):::INT8), (NULL), ((-836228137963108579):::INT8))
				AS tab_15481 (col_26716)
		WHERE
			true
		LIMIT
			44:::INT8;

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/73bc2032dd5d0ec36cd9577552b3153c3098e238

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

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

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/20191110-1584781/sqlsmith/setup=tpch-sf1/setting=no-mutations/run_1
	sqlsmith.go:122,sqlsmith.go:127,sqlsmith.go:159,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_14257.col_24391 AS col_24431, NULL AS col_24432, tab_14257.col_24391 AS col_24433
		FROM
			(VALUES (NULL)) AS tab_14195 (col_24311)
			RIGHT JOIN (VALUES (NULL), (3978096459:::OID), (3288851999:::OID), (772592863:::OID), (3954253218:::OID))
					AS tab_14220 (col_24344)
				JOIN (
						VALUES
							('d3975bf8-3ebd-4591-a029-5b9e1e5eaf9c':::UUID, 3631572090:::OID),
							(
								'0967ed33-0e47-4964-bcdb-ddde120b01bc':::UUID,
								CASE
								WHEN false THEN 3231586198:::OID
								ELSE 2925564744:::OID
								END
							),
							('998016a1-2be6-4c99-ad35-085751827885':::UUID, 3285658154:::OID)
					)
						AS tab_14228 (col_24355, col_24356)
					JOIN (
							VALUES
								(
									2731187206:::OID,
									(
										SELECT
											e'\x021\x18':::STRING:::NAME AS col_24387
										FROM
											(
												VALUES
													(2682444583:::OID),
													(3932545336:::OID),
													(736794336:::OID),
													(1106196742:::OID)
											)
												AS tab_14255 (col_24386)
										LIMIT
											1:::INT8
									)
								)
						)
							AS tab_14256 (col_24388, col_24389)
						JOIN (
								VALUES
									(1510113649:::OID, 1826894606:::OID),
									(3703361039:::OID, 2056928611:::OID),
									(3264966562:::OID, 1289808994:::OID),
									(1289583900:::OID, 2328770871:::OID)
							)
								AS tab_14257 (col_24390, col_24391) ON
								(tab_14256.col_24388) = (tab_14257.col_24390)
								AND (tab_14256.col_24388) = (tab_14257.col_24391) ON
							(tab_14228.col_24356) = (tab_14257.col_24390)
							AND (tab_14228.col_24356) = (tab_14256.col_24388)
							AND (tab_14228.col_24356) = (tab_14257.col_24391) ON
						(tab_14220.col_24344) = (tab_14256.col_24388)
						AND (tab_14220.col_24344) = (tab_14257.col_24390)
						AND (tab_14220.col_24344) = (tab_14228.col_24356)
				CROSS JOIN (
						VALUES
							('1970-01-05 07:01:57.000441+00:00':::TIMESTAMP),
							(clock_timestamp():::TIMESTAMP::TIMESTAMP),
							('1970-01-08 21:47:29.000363+00:00':::TIMESTAMP)
					)
						AS tab_14258 (col_24392)
				JOIN (
						VALUES
							(1985134492:::OID, B'1100101110111000000110011010001000010010001110'),
							(3722083851:::OID, B'1000101000000000010100101100010010001001111010'),
							(
								846257926:::OID,
								(
									SELECT
										DISTINCT B'0101100000001000000011010100111001100010001111' AS col_24428
									FROM
										(
											VALUES
												(
													e'[{"+,yd$yd": false, "b:{@]sP\\"Dh2z": null, "foo": null}, {"b": true}, {"baz": false}, [1.304378523337807, [], 0.33927126666803886, {}, []]]':::JSONB
												),
												(
													'{"*G;7!?n4LN": {}, "a": [true, {}, [{}], true], "b": null, "b4Rbz}": [], "bar": [["Wu)]chD>wF["]], "c": true, "foo": []}':::JSONB
												),
												(
													'[{"foo": ["foo", []]}, [[[true]]], 0.4999318138253698, [0.5810736384107196, {}, [{}, []]], 0.8505161694460921, 0.016114540968025004]':::JSONB
												)
										)
											AS tab_14259 (col_24393),
										(
											VALUES
												('-10 years -9 mons -543 days -01:44:36.529297':::INTERVAL),
												('-37 years -11 mons -22 days -15:10:40.357559':::INTERVAL),
												(date_trunc('':::STRING::STRING, NULL::TIME)::INTERVAL)
										)
											AS tab_14279 (col_24427)
									LIMIT
										1:::INT8
								)
							),
							(3137134726:::OID, B'0011011011010100001000001010101101101101011101')
					)
						AS tab_14280 (col_24429, col_24430) ON (tab_14257.col_24391) = (tab_14280.col_24429) ON (true OR true)
		ORDER BY
			tab_14257.col_24390 DESC;

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/64162f27783bd59799531ff977f0fd1d0fd5ae86

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

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

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/20191112-1587139/sqlsmith/setup=tpch-sf1/setting=no-mutations/run_1
	sqlsmith.go:122,sqlsmith.go:127,sqlsmith.go:159,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			tab_2868.col_4961 AS col_4962, tab_2867.col_4958 AS col_4963
		FROM
			(VALUES (e'.V}-I}I\x14)':::STRING), ('ci':::STRING), (e'PF#4\x1a':::STRING), (NULL)) AS tab_2861 (col_4952)
			JOIN (
					VALUES
						(NULL),
						(e'\x1fi':::STRING:::NAME),
						(CASE WHEN (false OR true) THEN e'\x07':::STRING:::NAME ELSE '|fV8X':::STRING:::NAME END),
						(e'Z\x14\x12\x17\r':::STRING:::NAME),
						(e'"ElD\x11\x18':::STRING:::NAME)
				)
					AS tab_2866 (col_4957)
				JOIN (VALUES ('#':::STRING, now():::DATE::DATE)) AS tab_2867 (col_4958, col_4959)
					JOIN (VALUES (3327829220:::OID, e'\x1ee':::STRING), (1002443342:::OID, NULL))
							AS tab_2868 (col_4960, col_4961) ON (tab_2867.col_4958) = (tab_2868.col_4961) ON
						(tab_2866.col_4957) = (tab_2867.col_4958) ON
					(tab_2861.col_4952) = (tab_2868.col_4961) AND (tab_2861.col_4952) = (tab_2867.col_4958)
		ORDER BY
			tab_2866.col_4957 ASC
		LIMIT
			85:::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=tpch-sf1/setting=no-mutations 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-mutations

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-mutations/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-mutations 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-mutations

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-mutations/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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		WITH
			with_2 (col_12) AS (SELECT * FROM (VALUES (NULL), (2625423248:::OID)) AS tab_4 (col_12))
		SELECT
			max(tab_6.c_custkey::INT8) OVER (PARTITION BY tab_6.c_custkey)::INT8 AS col_13
		FROM
			defaultdb.public.customer AS tab_5, defaultdb.public.customer AS tab_6
		WHERE
			true
		GROUP BY
			tab_6.c_custkey
		LIMIT
			82:::INT8;

@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-mutations 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-mutations

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-mutations/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_16.p_mfgr AS col_37, tab_17.p_mfgr AS col_38, tab_17.p_retailprice AS col_39
		FROM
			defaultdb.public.part AS tab_16, defaultdb.public.part AS tab_17
		ORDER BY
			tab_17.p_brand ASC, tab_17.p_brand, tab_17.p_type
		LIMIT
			13:::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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			'om+$XbTm':::STRING AS col_185
		FROM
			defaultdb.public.lineitem AS tab_77, defaultdb.public.supplier AS tab_78
		GROUP BY
			tab_78.s_phone, tab_78.s_acctbal;

@thoszhang thoszhang mentioned this issue Nov 20, 2019
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-mutations 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-mutations

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-mutations/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_73.l_partkey AS col_153, NULL AS col_154, e'"iXeIkE\x07G':::STRING AS col_155
		FROM
			defaultdb.public.nation AS tab_72, defaultdb.public.lineitem AS tab_73
		WHERE
			true;

@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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			3760566636769300805:::INT8 AS col_335,
			tab_155.ps_suppkey AS col_336,
			(-764472074685207926):::INT8 AS col_337,
			tab_154.s_name AS col_338
		FROM
			defaultdb.public.supplier AS tab_154, defaultdb.public.partsupp AS tab_155;

@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-mutations 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-mutations

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-mutations/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_87.o_orderkey AS col_167,
			NULL AS col_168,
			'1992-09-05':::DATE AS col_169,
			'"':::STRING AS col_170,
			tab_87.o_custkey AS col_171,
			tab_87.o_orderpriority AS col_172
		FROM
			defaultdb.public.nation AS tab_86, defaultdb.public.orders AS tab_87;

@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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			0.22064471121125706:::FLOAT8 AS col_120,
			tab_63.ps_comment AS col_121,
			5524488870302474505:::INT8 AS col_122,
			7548748657626843918:::INT8 AS col_123,
			0.44438865854384585:::FLOAT8 AS col_124,
			tab_64.s_name AS col_125,
			tab_63.ps_availqty AS col_126,
			'Ej%Y?6I':::STRING AS col_127,
			(-5178346164554714306):::INT8 AS col_128,
			tab_64.s_nationkey AS col_129,
			tab_63.ps_comment AS col_130,
			e'T$^V!#\x0e':::STRING AS col_131
		FROM
			defaultdb.public.partsupp AS tab_63, defaultdb.public.supplier AS tab_64
		WHERE
			'9aee9ade-38e5-47da-bbcb-0ede8887f7ac':::UUID::UUID
			NOT IN ('7a12be1f-33df-4fde-9db4-c70438c0e143':::UUID, '894c4a1c-24fc-4208-8b19-3a92e98fafa0':::UUID)
		ORDER BY
			tab_63.ps_partkey DESC, tab_64.s_address, tab_64.s_comment
		LIMIT
			92:::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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			DISTINCT tab_118.s_address AS col_268, e'\x7fFi\x17fld':::STRING AS col_269
		FROM
			defaultdb.public.customer AS tab_117, defaultdb.public.supplier AS tab_118;

@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-mutations 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-mutations

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-mutations/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_50.ps_suppkey AS col_133,
			tab_47.ps_availqty AS col_134,
			1.4438327304676077:::FLOAT8 AS col_135,
			tab_47.ps_comment AS col_136,
			tab_50.ps_supplycost AS col_137,
			tab_50.ps_availqty AS col_138,
			NULL AS col_139,
			tab_47.ps_availqty AS col_140,
			NULL AS col_141,
			218021060415465186:::INT8 AS col_142,
			tab_50.ps_partkey AS col_143,
			6795192150926538225:::INT8 AS col_144
		FROM
			defaultdb.public.partsupp AS tab_47,
			defaultdb.public.customer AS tab_48
			JOIN defaultdb.public.partsupp AS tab_49 ON (tab_48.c_custkey) = (tab_49.ps_partkey),
			defaultdb.public.partsupp AS tab_50
		ORDER BY
			tab_47.ps_comment, tab_50.ps_partkey ASC
		LIMIT
			22:::INT8;

@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-mutations 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-mutations

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-mutations/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_73.o_orderstatus AS col_124,
			tab_73.o_totalprice AS col_125,
			tab_73.o_shippriority AS col_126,
			(
				SELECT
					tab_73.o_orderstatus AS col_127
				FROM
					defaultdb.public.supplier AS tab_74
				WHERE
					true
				ORDER BY
					tab_74.s_suppkey DESC, tab_74.s_address, tab_74.s_suppkey, tab_74.s_comment ASC
				LIMIT
					1:::INT8
			)
				AS col_128,
			'1990-11-29':::DATE AS col_129,
			(-3314654877657873293):::INT8 AS col_130,
			tab_73.o_orderpriority AS col_131,
			tab_73.o_orderstatus AS col_132,
			tab_73.o_shippriority AS col_133
		FROM
			defaultdb.public.orders AS tab_73
		ORDER BY
			tab_73.o_comment DESC, tab_73.o_clerk ASC;

@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-mutations 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-mutations

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-mutations/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_10 (col_56, col_57)
				AS (
					SELECT
						tab_34.n_comment AS col_56, NULL AS col_57
					FROM
						defaultdb.public.supplier AS tab_31,
						defaultdb.public.partsupp AS tab_32
						JOIN defaultdb.public.nation AS tab_33 ON (tab_32.ps_partkey) = (tab_33.n_nationkey),
						defaultdb.public.nation AS tab_34
					WHERE
						true
				)
		SELECT
			(-5844043071812330078):::INT8 AS col_58,
			tab_35.l_shipdate AS col_59,
			(-0.4946965687690851):::FLOAT8 AS col_60,
			1.647025599537848:::FLOAT8 AS col_61,
			477841006265773160:::INT8 AS col_62,
			NULL AS col_63,
			tab_35.l_discount AS col_64,
			NULL AS col_65,
			tab_35.l_linestatus AS col_66,
			tab_35.l_partkey AS col_67
		FROM
			with_10, defaultdb.public.lineitem AS tab_35
		ORDER BY
			tab_35.l_partkey ASC;

@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-mutations 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-mutations

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-mutations/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_27.l_orderkey AS col_45, '1974-12-03':::DATE AS col_46
		FROM
			defaultdb.public.orders AS tab_25,
			defaultdb.public.partsupp AS tab_26
			JOIN defaultdb.public.lineitem AS tab_27 ON (tab_26.ps_partkey) = (tab_27.l_partkey);

@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-mutations 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-mutations

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-mutations/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_65.ps_partkey AS col_145, tab_64.p_type AS col_146
		FROM
			defaultdb.public.part AS tab_64, defaultdb.public.partsupp AS tab_65
		ORDER BY
			tab_64.p_container
		LIMIT
			77:::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=tpch-sf1/setting=no-mutations 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-mutations

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-mutations/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_13 (col_50)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									e'{"?sG$3[c/pq@|": {"a": 0.5845516272323571, "baz": "foo"}, "Bx(xBqmL": [], "UIGOslO(Uq": [{"tvb khz\\\\g/SR": {}}, false, null], "Ylm|^!D": [[[], {}], false], "b": "bar"}':::JSONB
								),
								('[[[false, {}, [[]], []], false, true], [], null, {}, {}]':::JSONB),
								(
									'{"baz": {">f>]eo": {"foo": {}}, "c": [{}, {"mCvf": []}], "foobar": [], "g^I<3": {}}, "g1&$6k;^": [{"b": {}}, [], []], "kI^{)[=pt[X": {}}':::JSONB
								),
								('{"&--gh_fA/~ry": {}, "a": [false], "bar": [], "c": {"b": false}, "rYRb": null}':::JSONB),
								(
									'[[{"%}6qpmeP+lW$": true, "a": null, "b": false, "bar": {}}, {"a": null}, []], "a", []]':::JSONB
								)
						)
							AS tab_40 (col_50)
				),
			with_14 (col_51)
				AS (
					SELECT
						*
					FROM
						(VALUES (1862711706:::OID), (395820229:::OID), (NULL), (1354788681:::OID), (2462038447:::OID))
							AS tab_41 (col_51)
					INTERSECT SELECT * FROM (VALUES (1692696858:::OID), (4012309416:::OID), (NULL)) AS tab_42 (col_52)
				),
			with_15 (col_53)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								((-0.02985791303217411):::FLOAT8),
								((-2.506166458129883):::FLOAT8),
								(1.7767651081085205:::FLOAT8),
								((-1.1051280498504639):::FLOAT8)
						)
							AS tab_43 (col_53)
				)
		SELECT
			tab_47.l_suppkey AS col_54
		FROM
			defaultdb.public.customer AS tab_44
			JOIN defaultdb.public.partsupp AS tab_45 ON (tab_44.c_custkey) = (tab_45.ps_suppkey),
			defaultdb.public.region AS tab_46,
			defaultdb.public.lineitem AS tab_47;

@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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			(-296382075639588152):::INT8 AS col_171,
			tab_104.o_orderpriority AS col_172,
			(339421202575888364:::INT8::INT8 + tab_103.n_nationkey::INT8)::INT8 AS col_173,
			NULL AS col_174,
			tab_104.o_orderpriority AS col_175,
			tab_104.o_custkey AS col_176,
			NULL AS col_177,
			tab_104.o_orderpriority AS col_178,
			1.2257794048433457:::FLOAT8 AS col_179
		FROM
			defaultdb.public.nation AS tab_103, defaultdb.public.orders AS tab_104;

@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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			'oczS;V':::STRING AS col_22, tab_14.c_address AS col_23
		FROM
			defaultdb.public.partsupp AS tab_12, defaultdb.public.supplier AS tab_13, defaultdb.public.customer AS tab_14
		WHERE
			true;

@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-mutations 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-mutations

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-mutations/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.(*hashJoiner).Next
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/hashjoiner.go:256
		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_40.s_comment AS col_105,
			tab_41.o_orderstatus AS col_106,
			tab_40.s_name AS col_107,
			tab_41.o_comment AS col_108,
			tab_41.o_shippriority AS col_109,
			e'B\n\x15I':::STRING AS col_110,
			tab_41.o_orderdate AS col_111,
			tab_40.s_suppkey AS col_112,
			(-1862716970207431777):::INT8 AS col_113,
			e'\x1ebMX\x0ej+':::STRING AS col_114,
			(crc32c(e'\'':::STRING::STRING)::INT8::INT8 ^ (-6311559836343074478):::INT8::INT8)::INT8 AS col_115,
			tab_40.s_acctbal AS col_116,
			tab_41.o_custkey AS col_117,
			0.9085488125316715:::FLOAT8 AS col_118,
			tab_41.o_orderpriority AS col_119,
			tab_40.s_comment AS col_120
		FROM
			defaultdb.public.supplier AS tab_40, defaultdb.public.orders AS tab_41
		LIMIT
			23:::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-mutations 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-mutations

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-mutations/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_83.s_name AS col_170,
			tab_84.c_comment AS col_171,
			tab_84.c_custkey AS col_172,
			tab_84.c_nationkey AS col_173,
			'}{':::STRING AS col_174,
			'J$!"r':::STRING AS col_175,
			CASE
			WHEN similar_to_escape('':::STRING::STRING, tab_84.c_phone::STRING, tab_83.s_address::STRING)::BOOL
			THEN e'\b':::STRING
			ELSE tab_84.c_phone
			END
				AS col_176,
			e'bi\'e':::STRING AS col_177,
			tab_83.s_nationkey AS col_178,
			tab_84.c_comment AS col_179,
			'C':::STRING AS col_180,
			tab_84.c_acctbal AS col_181,
			538695190492710468:::INT8 AS col_182,
			e'#rF\x16LA':::STRING AS col_183,
			(-1.1496832909174923):::FLOAT8 AS col_184
		FROM
			defaultdb.public.supplier AS tab_83, defaultdb.public.customer AS tab_84
		WHERE
			EXISTS(SELECT NULL AS col_169 FROM defaultdb.public.supplier AS tab_85 WHERE true ORDER BY tab_85.s_comment DESC)
		ORDER BY
			tab_84.c_acctbal DESC,
			tab_83.s_nationkey DESC,
			tab_84.c_name,
			tab_84.c_acctbal DESC,
			tab_83.s_acctbal DESC,
			tab_83.s_phone,
			tab_83.s_comment DESC,
			tab_84.c_phone DESC,
			tab_84.c_name DESC,
			tab_83.s_acctbal,
			tab_83.s_nationkey ASC,
			tab_83.s_phone ASC,
			tab_84.c_name DESC,
			tab_83.s_acctbal ASC,
			tab_83.s_name ASC
		LIMIT
			93:::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=tpch-sf1/setting=no-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			'1977-12-15':::DATE AS col_12
		FROM
			defaultdb.public.lineitem AS tab_10, defaultdb.public.customer AS tab_11, defaultdb.public.lineitem AS tab_12
		ORDER BY
			tab_11.c_acctbal DESC, tab_10.l_comment;

@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-mutations 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-mutations

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-mutations/run_1
	sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
		SELECT
			(-1):::INT8 AS col_1,
			e'R\x0e0-kNi':::STRING AS col_2,
			tab_1.l_commitdate AS col_3,
			tab_1.l_commitdate AS col_4,
			tab_1.l_quantity AS col_5,
			(
				SELECT
					tab_1.l_suppkey AS col_6
				FROM
					defaultdb.public.orders AS tab_2
					JOIN defaultdb.public.partsupp AS tab_3 ON (tab_2.o_custkey) = (tab_3.ps_suppkey)
				LIMIT
					1:::INT8
			)
				AS col_7,
			0.5579966244157717:::FLOAT8 AS col_8,
			tab_1.l_orderkey AS col_9,
			tab_1.l_returnflag AS col_10
		FROM
			defaultdb.public.lineitem AS tab_1
		WHERE
			true;

craig bot pushed a commit that referenced this issue Nov 27, 2019

Verified

This commit was created on GitHub.com and signed with GitHub’s verified signature.
42805: roachtest: force timeout differently in sqlsmith test r=yuzefovich a=yuzefovich

Previously, sqlsmith roachtest would use a context with timeout to
force the query cancellation. However, CockroachDB currently doesn't
implement pgwire cancellation protocol, so canceling a context would not
actually propagate to the database. Instead, we will use
'statement_timeout' session variable to specify the timeout.

Addresses: #42212.
Addresses: #42217.

Release note: None

Co-authored-by: Yahor Yuzefovich <yahor@cockroachlabs.com>
@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=tpch-sf1/setting=no-mutations 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=tpch-sf1/setting=no-mutations

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/20191128-1616574/sqlsmith/setup=tpch-sf1/setting=no-mutations/run_1
	sqlsmith.go:162,sqlsmith.go:189,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:1014
		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.(*tableReader).Next
			/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/tablereader.go:307
		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
			0.08573261448082142:::FLOAT8 AS col_119,
			tab_76.s_name AS col_120,
			tab_76.s_comment AS col_121,
			'':::STRING AS col_122,
			tab_76.s_suppkey AS col_123,
			tab_76.s_address AS col_124,
			(octet_length(tab_76.s_comment::STRING)::INT8::INT8 ^ 2883298445706069185:::INT8::INT8)::INT8 AS col_125
		FROM
			defaultdb.public.supplier AS tab_76
		LIMIT
			20:::INT8;

@cockroach-teamcity
Copy link
Member Author

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

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=no-mutations 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-mutations 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-mutations/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-mutations

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

powered by pkg/cmd/internal/issues

craig bot pushed a commit that referenced this issue Dec 12, 2019
43131: roachtest: fix node option in sqlsmith test r=yuzefovich a=yuzefovich

Addresses: #42212 (comment)

Release note: None

Co-authored-by: Yahor Yuzefovich <yahor@cockroachlabs.com>
@cockroach-teamcity
Copy link
Member Author

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

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=no-mutations 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-mutations 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-mutations/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-mutations

make stressrace TESTS=sqlsmith/setup=tpch-sf1/setting=no-mutations 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
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.
Projects
None yet
Development

No branches or pull requests

4 participants