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

cockroach-teamcity · 2021-09-24T06:26:57Z

roachtest.sqlsmith/setup=empty/setting=no-ddl failed with artifacts on master @ 85b1e92455eb2795043d71e5766b1b56dab308f2:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=empty/setting=no-ddl/run_1
	sqlsmith.go:223,sqlsmith.go:256,test_runner.go:777: error: pq: internal error: no volatility for cast tuple[]::tuple{bool, oid}[]
		stmt:
		WITH
			with_3812 (col_21047)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									CASE
									WHEN (NOT EXISTS (WITH with_3810 (col_21041, col_21042) AS (SELECT * FROM (VALUES (false, ARRAY[(false, 2877430437:::OID),(true, 4098811020:::OID),(false, 4085324570:::OID),(NULL, 2703524746:::OID),(true, 1836754810:::OID)]), (NULL, ARRAY[(true, 3574494101:::OID),(true, NULL)]), (true, ARRAY[(false, 0:::OID),(false, 1583278185:::OID),(true, 3335872398:::OID),(false, 2450990297:::OID),(NULL, 484929524:::OID),(false, NULL)]), (false, ARRAY[(true, NULL),(false, 1568156154:::OID),(false, 0:::OID),(false, 3923047891:::OID)])) AS tab_12183 (col_21041, col_21042) EXCEPT ALL SELECT * FROM (VALUES (true, ARRAY[]:::RECORD[])) AS tab_12184 (col_21043, col_21044)), with_3811 (col_21045) AS (SELECT * FROM (VALUES (NULL), ('<':::STRING)) AS tab_12185 (col_21045)) SELECT () AS col_21046 LIMIT 20:::INT8))
									THEN '-Infinity':::DECIMAL
									ELSE 653163848397567.3901:::DECIMAL
									END
								),
								(2.610413118241426851E+20:::DECIMAL),
								((-2214979573024621380):::DECIMAL),
								(231522579491.0706537:::DECIMAL),
								(NULL)
						)
							AS tab_12186 (col_21047)
					UNION
						SELECT
							*
						FROM
							(
								VALUES
									(4.082881729782187691E+21:::DECIMAL),
									(2.380684802253673780E+32:::DECIMAL),
									('-Infinity':::DECIMAL),
									((7.727257793041500160:::DECIMAL::DECIMAL * 1811330438472895214:::INT8::INT8)::DECIMAL),
									(NULL),
									('-Infinity':::DECIMAL)
							)
								AS tab_12187 (col_21048)
				)
		SELECT
			NULL AS col_21049;

Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries _{This test on roachdash | Improve this report!}

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

rafiss · 2021-09-24T20:15:31Z

Same as #70663

rafiss · 2021-09-25T07:11:39Z

Caused by 4037bd8

See #70663 (comment)

cockroach-teamcity · 2021-09-27T06:28:21Z

roachtest.sqlsmith/setup=empty/setting=no-ddl failed with artifacts on master @ 37d9f72a28a8e009bc6ba3c4d3c5780af554b92d:

							VALUES
								(
									'E':::STRING,
									ARRAY[(e'@F\x1c$':::STRING, e';\x0f\b':::STRING),(e'Ix\x02\tF\x18%\rL':::STRING, '"':::STRING),(e'\x03:G~Gx\x03hy':::STRING, 's':::STRING)]
								),
								(
									NULL,
									ARRAY[(e'nLh\x1e+':::STRING, e'\x12fKe\x12:\x1c':::STRING),('@w1':::STRING, e'.\bTW:@[':::STRING),(e'\x0eL\x0f&':::STRING, e'\x06\t\\\x1cDi\n\x14':::STRING),('':::STRING, NULL),('x':::STRING, e'[[\x06KI#J':::STRING)]
								),
								(NULL, ARRAY[(e'*d\x11':::STRING, e'W\x1d]~58':::STRING)]),
								(e'\'':::STRING, ARRAY[]:::RECORD[]),
								(
									'z':::STRING,
									ARRAY[('"':::STRING, 'X':::STRING),(e'\x02A':::STRING, e'8i%g\x1b':::STRING),(e'\x03v\x1e\x18\x19\x17\x13':::STRING, e'=\x14':::STRING),(NULL, e'5\x15mA':::STRING)]
								),
								(e'\x05':::STRING, NULL)
						)
							AS tab_137038 (col_236783, col_236784)
					INTERSECT
						SELECT
							*
						FROM
							(
								VALUES
									(NULL, NULL),
									(NULL, ARRAY[]:::RECORD[]),
									('B':::STRING, ARRAY[('X':::STRING, e'\n/\x1dH\tc':::STRING)]),
									(
										NULL,
										ARRAY[(e'6.\n1\t':::STRING, '|pw':::STRING),(NULL, NULL),(e'kR\x1dvo':::STRING, e'Q#\x0bh!\x11c.':::STRING)]
									),
									(
										'9':::STRING,
										ARRAY[(e'\x12':::STRING, '':::STRING),(e'$y\x12\x0e[\x0f\x07\x05\'':::STRING, '':::STRING),(e';d(wN?\x11<':::STRING, 'im!HN':::STRING),('id3G5|_jB':::STRING, 'i':::STRING),('y':::STRING, e'\x02Q':::STRING)]
									),
									(
										'_':::STRING,
										ARRAY[(NULL, NULL),(e's)O\f e4\x18':::STRING, e'|B\x1al':::STRING),('':::STRING, e'\x11^2\x03R\x1a.v3':::STRING),('XhuWn+Y':::STRING, e'F\x15':::STRING)]
									)
							)
								AS tab_137039 (col_236785, col_236786)
				)
		SELECT
			ARRAY[(NULL, NULL),(e'X\x15':::STRING, e';\x01@V!{X':::STRING)] AS col_236787, e'\x1b':::STRING AS col_236788
		FROM
			with_43201 AS cte_ref_12456
		WHERE
			false
		ORDER BY
			cte_ref_12456.col_236783;

Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries _{This test on roachdash | Improve this report!}

cockroach-teamcity · 2021-09-28T06:38:50Z

roachtest.sqlsmith/setup=empty/setting=no-ddl failed with artifacts on master @ 80844e44f4f9d0e565c6e810bd4c782be61899bf:

											)
												AS tab_124217 (col_214707)
										WHERE
											true
										GROUP BY
											tab_124217.col_214707
										ORDER BY
											tab_124217.col_214707 ASC, tab_124217.col_214707, tab_124217.col_214707 ASC
										LIMIT
											1:::INT8
									),
									NULL
								),
								(
									ARRAY[('00:00:00+15:59:00':::TIMETZ,),('00:00:00+15:59:00':::TIMETZ,),(NULL,),('22:22:45.338976-05:07:00':::TIMETZ,)],
									'\xe02a43ba':::BYTES
								),
								(
									ARRAY[('00:00:00+15:59:00':::TIMETZ,),('19:41:15.619234+05:33:00':::TIMETZ,),('07:14:11.349852+07:46:00':::TIMETZ,)],
									'\x2bf9cc':::BYTES
								),
								(
									ARRAY[('13:28:57.048138-00:47:00':::TIMETZ,),(NULL,),('23:52:41.623854-00:13:00':::TIMETZ,)],
									NULL
								),
								(ARRAY[('06:03:11.771284+04:07:00':::TIMETZ,)], '\x7f79e298eb':::BYTES)
						)
							AS tab_124218 (col_214709, col_214710)
				),
			with_38696 (col_214711)
				AS (SELECT * FROM (VALUES (NULL), (e'\x1a}q\x1bA\nQ\x1eW':::STRING)) AS tab_124219 (col_214711)),
			with_38697 (col_214712)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('21:06:51.78039+13:08:00':::TIMETZ),
								(
									('02:58:54.238339-05:24:00':::TIMETZ::TIMETZ + '-36 years -5 mons -378 days -00:32:21.358479':::INTERVAL::INTERVAL)::TIMETZ
								),
								(NULL)
						)
							AS tab_124220 (col_214712)
				)
		SELECT
			cte_ref_11399.col_214711 AS col_214713, e'\x1dD4_':::STRING AS col_214714
		FROM
			with_38696 AS cte_ref_11399, with_38696 AS cte_ref_11400;

Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries _{This test on roachdash | Improve this report!}

rafiss · 2021-09-28T16:22:07Z

Filed #70831 to track the bug separately from this test.

cockroach-teamcity · 2021-09-30T06:32:28Z

roachtest.sqlsmith/setup=empty/setting=no-ddl failed with artifacts on master @ ac885449c1fe74de23ea5d82858b3aa3674496f9:

										ARRAY[((2086587837:::OID, '0.0.0.0/0':::INET), (-0.06438451304361512323):::DECIMAL),((302216295:::OID, '136.206.14.118/25':::INET), 2.556090056695427178E+26:::DECIMAL)]
									),
									(
										ARRAY[((3158020670:::OID, '87.239.177.24/6':::INET), 8.876223930506388379E+34:::DECIMAL),((833980554:::OID, 'a37f:47ca:6e74:4cf0:83f0:d1e8:71d:5985':::INET), NULL),((0:::OID, '161.100.252.180/13':::INET), 0:::DECIMAL),((NULL, 'a9b2:97d5:e15:fd59:6c65:c75d:a1a4:1f7c/95':::INET), '-Infinity':::DECIMAL)]
									),
									(
										ARRAY[((1136722130:::OID, '26.137.239.255/11':::INET), (-82892.51090234126763):::DECIMAL),((2668239304:::OID, NULL), NULL),((2030071188:::OID, '164.179.55.62/13':::INET), (-6.651361259928760202E+20):::DECIMAL)]
									)
							)
								AS tab_135551 (col_234951)
				)
		SELECT
			tab_135555.col_234956 AS col_234959, cte_ref_12695.col_234920 AS col_234960
		FROM
			(
				WITH
					with_42843 (col_234952) AS (SELECT * FROM (VALUES (1:::INT8)) AS tab_135552 (col_234952)),
					with_42844 (col_234953) AS (SELECT * FROM (VALUES (NULL), (())) AS tab_135553 (col_234953)),
					with_42845 (col_234954) AS (SELECT * FROM (VALUES (858903179:::INT8)) AS tab_135554 (col_234954))
				SELECT
					cte_ref_12694.col_234953 AS col_234955
				FROM
					with_42844 AS cte_ref_12694
				LIMIT
					25:::INT8
			)
				AS tab_135555 (col_234956),
			with_42839 AS cte_ref_12695
		WHERE
			EXISTS(
				WITH
					with_42846 (col_234957)
						AS (
							SELECT
								*
							FROM
								(VALUES (3493112857:::OID), (NULL), (4245127333:::OID), (0:::OID), (245632744:::OID))
									AS tab_135556 (col_234957)
						)
				SELECT
					cte_ref_12696.col_234957 AS col_234958
				FROM
					with_42846 AS cte_ref_12696
				WHERE
					false
				ORDER BY
					cte_ref_12696.col_234957 DESC, cte_ref_12696.col_234957 DESC, cte_ref_12696.col_234957 DESC
			)
		LIMIT
			4:::INT8;

Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries _{This test on roachdash | Improve this report!}

yuzefovich · 2021-10-01T17:26:44Z

Closing in favor of #70831 (all issues here are dups except for one which I filed #71001 for).

rafiss · 2021-10-01T17:28:26Z

Won't roachtest just open a new one in the next nightly though?

yuzefovich · 2021-10-01T17:29:58Z

That's true, but in #71000 we're swallowing this particular error to not fail the test.

rafiss · 2021-10-01T17:32:19Z

ah missed that, thanks!

blathers-crl bot added the T-sql-queries SQL Queries Team label Sep 24, 2021

yuzefovich assigned rafiss Sep 24, 2021

yuzefovich removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Sep 24, 2021

This comment has been minimized.

Sign in to view

rafiss removed their assignment Sep 25, 2021

This comment has been minimized.

Sign in to view

yuzefovich mentioned this issue Sep 27, 2021

roachtest/sqlsmith: error decoding 10 bytes: empty array #70767

Closed

rafiss mentioned this issue Sep 28, 2021

opt: internal error because optbuilder addCasts adds a tuple[] cast that we don't support #70831

Closed

rytaft assigned mgartner Sep 28, 2021

yuzefovich mentioned this issue Oct 1, 2021

roachtest: sqlsmith: nil pointer when parsing null json into geo #71001

Closed

yuzefovich closed this as completed Oct 1, 2021

mgartner added this to SQL Queries Jul 24, 2023

mgartner moved this to Done in SQL Queries Jul 24, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

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

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

cockroach-teamcity commented Sep 24, 2021

rafiss commented Sep 24, 2021

This comment has been minimized.

rafiss commented Sep 25, 2021

This comment has been minimized.

cockroach-teamcity commented Sep 27, 2021

cockroach-teamcity commented Sep 28, 2021

rafiss commented Sep 28, 2021

cockroach-teamcity commented Sep 30, 2021

yuzefovich commented Oct 1, 2021 •

edited

Loading

rafiss commented Oct 1, 2021

yuzefovich commented Oct 1, 2021 •

edited

Loading

rafiss commented Oct 1, 2021

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

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

Comments

cockroach-teamcity commented Sep 24, 2021

rafiss commented Sep 24, 2021

This comment has been minimized.

rafiss commented Sep 25, 2021

This comment has been minimized.

cockroach-teamcity commented Sep 27, 2021

cockroach-teamcity commented Sep 28, 2021

rafiss commented Sep 28, 2021

cockroach-teamcity commented Sep 30, 2021

yuzefovich commented Oct 1, 2021 • edited Loading

rafiss commented Oct 1, 2021

yuzefovich commented Oct 1, 2021 • edited Loading

rafiss commented Oct 1, 2021

yuzefovich commented Oct 1, 2021 •

edited

Loading

yuzefovich commented Oct 1, 2021 •

edited

Loading