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=seed/setting=no-mutations failed #47397

Closed
cockroach-teamcity opened this issue Apr 12, 2020 · 20 comments
Closed

roachtest: sqlsmith/setup=seed/setting=no-mutations failed #47397

cockroach-teamcity opened this issue Apr 12, 2020 · 20 comments
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Milestone
20.1

Comments

@cockroach-teamcity
Copy link
Member

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@7b0f60fe2034ba8677242dbcdad86d3e5587c0d4:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200412-1869957/sqlsmith/setup=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: decoding unset EncDatum
		stmt:
		WITH
			with_295 (col_1836)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(NULL),
								(2965452239:::OID),
								(2769594519:::OID),
								(3259123759:::OID),
								(3639726254:::OID),
								(0:::OID)
						)
							AS tab_751 (col_1836)
				)
		SELECT
			tab_752._jsonb AS col_1837,
			tab_752._timestamptz AS col_1838,
			tab_752._string AS col_1839,
			(-128):::INT8 AS col_1840,
			tab_752._bool AS col_1841,
			(-0.7583410143852234):::FLOAT8 AS col_1842,
			tab_752._timestamp AS col_1843,
			tab_752._float8 AS col_1844,
			tab_752._decimal AS col_1845,
			(tab_752._interval::INTERVAL * 4303653882.345377363:::DECIMAL::DECIMAL)::INTERVAL AS col_1846,
			'\x3fc8bb9a4042':::BYTES AS col_1847,
			tab_752._int2 AS col_1848,
			NULL AS col_1849,
			NULL AS col_1850
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_752
		LIMIT
			14:::INT8;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Apr 12, 2020
@cockroach-teamcity cockroach-teamcity added this to the 20.1 milestone Apr 12, 2020
@yuzefovich
Copy link
Member

Hm, when running on 3 node local cluster I'm getting ERROR: overflow during Encode on this query (when trying to serialize an interval). I tried scattering the table and then running the query, and I got this:

  col_1837 | col_1838 | col_1839 | col_1840 | col_1841 |      col_1842       | col_1843 | col_1844 | col_1845 | col_1846 |    col_1847     | col_1848 | col_1849 | col_1850
-----------+----------+----------+----------+----------+---------------------+----------+----------+----------+----------+-----------------+----------+----------+-----------
  NULL     | NULL     | NULL     |     -128 |   NULL   | -0.7583410143852234 | NULL     | NULL     | NULL     | NULL     | ?\310\273\232@B | NULL     | NULL     | NULL
(1 row)
(error encountered after some results were delivered)
ERROR: overflow during Encode

I guess it seems like a "network race" between error propagation and data propagation which might cause decoding unset EncDatum assertion failure. @asubiotto @jordanlewis thoughts?

@jordanlewis
Copy link
Member

What is a "network race"? And what error would be causing this problem in the first place, and how come it doesn't get propagated up in the end?

@yuzefovich
Copy link
Member

I don't know, I'm just speculating that ERROR: overflow during Encode occurs on remote node which sends to the gateway the error and a row with the interval EncDatum not set correctly. I've no idea whether this is plausible.

I couldn't reproduce the assertion failure though.

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@056e32e84831f13b286fceb7681dd0cd2b00b4b4:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:185,sqlsmith.go:199,test_runner.go:753: ping: dial tcp 34.69.21.22:26257: connect: connection refused
		previous sql:
		WITH
			with_25 (col_88) AS (SELECT * FROM (VALUES (()), (()), (NULL), (()), (())) AS tab_49 (col_88))
		SELECT
			count(*) AS col_89
		FROM
			defaultdb.public.seed@[0] AS tab_50
		GROUP BY
			tab_50._int8, tab_50._float8
		HAVING
			st_intersects('0101000000000000000000F03F000000000000F03F':::GEOMETRY::GEOMETRY, '0101000000000000000000F03F000000000000F03F':::GEOMETRY::GEOMETRY)::BOOL
		ORDER BY
			tab_50._float8 DESC;

	cluster.go:1481,context.go:135,cluster.go:1470,test_runner.go:825: dead node detection: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod monitor teamcity-1891353-1587540974-02-n4cpu4 --oneshot --ignore-empty-nodes: exit status 1 3: 8241
		2: 8312
		4: 5089
		1: dead
		Error: UNCLASSIFIED_PROBLEM: 1: dead
		(1) UNCLASSIFIED_PROBLEM
		Wraps: (2) 1: dead
		  | main.glob..func13
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1129
		  | main.wrap.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:272
		  | github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra.(*Command).execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:766
		  | github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra.(*Command).ExecuteC
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:852
		  | github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra.(*Command).Execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:800
		  | main.main
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1793
		  | runtime.main
		  | 	/usr/local/go/src/runtime/proc.go:203
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1357
		Error types: (1) errors.Unclassified (2) *errors.fundamental
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@yuzefovich
Copy link
Member 

fatal error: unexpected signal during runtime execution
[signal SIGSEGV: segmentation violation code=0x1 addr=0x90 pc=0x3347f08]

runtime stack:
runtime.throw(0x443467f, 0x2a)
	/usr/local/go/src/runtime/panic.go:774 +0x72 fp=0x7fff789fcc20 sp=0x7fff789fcbf0 pc=0x79c002
runtime.sigpanic()
	/usr/local/go/src/runtime/signal_unix.go:378 +0x47c fp=0x7fff789fcc50 sp=0x7fff789fcc20 pc=0x7b18fc

goroutine 2976 [syscall]:
non-Go function
	pc=0x3347f08
non-Go function
	pc=0x33472d0
non-Go function
	pc=0x7cba3f
runtime.cgocall(0x33472a0, 0xc004d80f40, 0x1007fd8d1c90100)
	/usr/local/go/src/runtime/cgocall.go:128 +0x5b fp=0xc004d80ef8 sp=0xc004d80ec0 pc=0x76f66b
github.com/cockroachdb/cockroach/pkg/geo/geos._Cfunc_CR_GEOS_Intersects(0x0, 0xc0053009c0, 0x15, 0xc0053009c0, 0x15, 0xc00556a5d6, 0x0, 0x0)
	_cgo_gotypes.go:181 +0x4d fp=0xc004d80f40 sp=0xc004d80ef8 pc=0x136ac0d
github.com/cockroachdb/cockroach/pkg/geo/geos.Intersects.func1(0x0, 0xc0053009c0, 0x15, 0x40, 0xc0053009c0, 0x15, 0x40, 0xc00556a5d6, 0x42dd301, 0xc004d81058)
	/go/src/github.com/cockroachdb/cockroach/pkg/geo/geos/geos_unix.go:274 +0xcd fp=0xc004d80fb0 sp=0xc004d80f40 pc=0x136d97d
github.com/cockroachdb/cockroach/pkg/geo/geos.Intersects(0xc0053009c0, 0x15, 0x40, 0xc0053009c0, 0x15, 0x40, 0x3f9e460, 0x42dd340, 0xc0004a5500)
	/go/src/github.com/cockroachdb/cockroach/pkg/geo/geos/geos_unix.go:274 +0xd4 fp=0xc004d81040 sp=0xc004d80fb0 pc=0x136c774
github.com/cockroachdb/cockroach/pkg/geo/geomfn.Intersects(0xc00530c200, 0xc00530c200, 0xc0043194b0, 0x4d134a0, 0xc0004a55a8)
	/go/src/github.com/cockroachdb/cockroach/pkg/geo/geomfn/binary_predicates.go:45 +0x5f fp=0xc004d81098 sp=0xc004d81040 pc=0x170ce8f
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.geometryOverload2BinaryPredicate.func1(0xc0043194b0, 0xc0004a55a8, 0xc0004a55a8, 0x2, 0x4c4f620, 0xc00530c990, 0xc00530c9a0)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/geo_builtins.go:179 +0x43 fp=0xc004d810d0 sp=0xc004d81098 pc=0x175dc53
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.geometryOverload2.func1(0xc0043194b0, 0xc00530c9a0, 0x2, 0x2, 0x2, 0x2, 0x0, 0x0)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/geo_builtins.go:166 +0x7a fp=0xc004d81118 sp=0xc004d810d0 pc=0x175db7a
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).Eval(0xc00503b300, 0xc0043194b0, 0xc00503b300, 0x4cb0001, 0xc00503b300, 0xc00503b300)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/eval.go:4104 +0xb5 fp=0xc004d81278 sp=0xc004d81118 pc=0x1403d25
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar(0xc00519e630, 0xc005310300, 0x4cda640, 0xc0050b7d60, 0xc0050b7d60, 0x0, 0x0, 0xc004d823f8)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/scalar.go:96 +0xef fp=0xc004d81300 sp=0xc004d81278 pc=0x2c7901f
...

cc @otan

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@c73fb589e223d21b7f5cf51e6fc8620b47b95de4:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: 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:
		SELECT
			tab_5665._float8 AS col_13541,
			tab_5663._float8 AS col_13542,
			(2584024399044710539:::INT8::INT8 / 'Infinity':::DECIMAL::DECIMAL)::DECIMAL AS col_13543,
			'1970-01-01 16:12:43.000965+00:00':::TIMESTAMP AS col_13544,
			(-778753667717467482):::INT8 AS col_13545,
			'1970-01-06 18:47:17.000797+00:00':::TIMESTAMPTZ AS col_13546,
			tab_5664._float4 AS col_13547
		FROM
			defaultdb.public.seed@[0] AS tab_5663, defaultdb.public.seed@[0] AS tab_5664, defaultdb.public.seed@[0] AS tab_5665
		WHERE
			tab_5664._bool
		ORDER BY
			tab_5664._int8;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@yuzefovich
Copy link
Member

Same as #40929.

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@96f8f33dceeec0ad6168e2dffa98b952892bdf7b:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: (("$8" IS DISTINCT FROM CAST(NULL AS INET)) OR CAST(NULL AS INET)) IS NOT false: incompatible OR argument type: inet
		stmt:
		SELECT
			substring(tab_681._bytes::BYTES, tab_681._int4::INT8)::BYTES AS col_1631,
			tab_681._decimal AS col_1632,
			tab_681._float8 AS col_1633,
			tab_681._date AS col_1634,
			(-8087656253239372102):::INT8 AS col_1635,
			(-1.1926112174987793):::FLOAT8 AS col_1636,
			'{"test": "json"}':::JSONB AS col_1637,
			tab_681._int4 AS col_1638,
			tab_681._timestamptz AS col_1639,
			'1970-01-08 02:17:13.000664+00:00':::TIMESTAMP AS col_1640,
			tab_681._int4 AS col_1641,
			tab_681._bool AS col_1642
		FROM
			defaultdb.public.seed@[0] AS tab_681
		WHERE
			tab_681._inet::INET
			NOT IN (
					SELECT
						tab_681._inet::INET AS col_1630
					FROM
						defaultdb.public.seed@seed__int8__float8__date_idx AS tab_682
					WHERE
						tab_682._bool
					LIMIT
						55:::INT8
				)
		ORDER BY
			tab_681._int2 ASC
		LIMIT
			31:::INT8;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@asubiotto
Copy link
Contributor

Latest failure looks like a sqlsmith issue where it generates an inet datum in an OR expression.

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@f66ff29e25bc546ee239867e316485528e11e3dc:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: 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_5895 (col_35171)
				AS (SELECT * FROM (VALUES (e'{Gai&Q\x07&V':::STRING), (e'[\x14>[\r\x10oc':::STRING)) AS tab_14548 (col_35171))
		SELECT
			(ln(4.827802620639634162E+31:::DECIMAL::DECIMAL)::DECIMAL::DECIMAL / '-Infinity':::DECIMAL::DECIMAL)::DECIMAL
				AS col_35172,
			tab_14550._int8 AS col_35173,
			true AS col_35174,
			NULL AS col_35175
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_14549,
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_14550;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@5156843cc23adecb6a70fabf19f51f46de1241ec:

																(
																	VALUES
																		(
																			ARRAY[639654842:::INT8,(-1):::INT8,(-1804972777):::INT8,32767:::INT8,(-1223441585):::INT8]
																		),
																		(ARRAY[278461355:::INT8]),
																		(
																			ARRAY[1768430669:::INT8,(-1836734427):::INT8,1083502478:::INT8,492922031:::INT8]
																		),
																		(ARRAY[625162680:::INT8,(-1178401245):::INT8]),
																		(
																			ARRAY[(-2069242950):::INT8,350662644:::INT8,1002809733:::INT8]
																		)
																)
																	AS tab_612 (col_1422)
														)
												SELECT
													322609472:::OID AS col_1423
												FROM
													defaultdb.public.seed@seed__int8__float8__date_idx AS tab_613
												ORDER BY
													tab_613._inet
												LIMIT
													1:::INT8
											)
												AS col_1424
										FROM
											defaultdb.public.seed@seed__int8__float8__date_idx AS tab_609
										ORDER BY
											tab_609._uuid DESC, tab_609._interval ASC
										LIMIT
											1:::INT8
									)
								),
								(2412689272:::OID)
						)
							AS tab_614 (col_1425)
				)
		SELECT
			tab_615._float4 AS col_1426,
			tab_615._bytes AS col_1427,
			'6c69:d929:5052:7bb7:10d3:bd86:a51:162d/117':::INET AS col_1428,
			'1970-01-02 03:55:53.000657+00:00':::TIMESTAMPTZ AS col_1429,
			tab_615._int8 AS col_1430,
			tab_615._uuid AS col_1431,
			tab_615._decimal AS col_1432
		FROM
			with_271 AS cte_ref_85, defaultdb.public.seed@[0] AS tab_615
		WHERE
			true;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@otan
Copy link
Contributor

otan commented May 16, 2020 •
edited
Loading 

select 																		
(st_dwithin('0101000020E6100000000000000000F03F000000000000F03F':::GEOGRAPHY(GEOMETRY,4326)::GEOGRAPHY(GEOMETRY,4326), '0102000020E610000000000000':::GEOGRAPHY(GEOMETRY,4326)::GEOGRAPHY(GEOMETRY,4326), 0.8728158239032474:::FLOAT8::FLOAT8)::BOOL AND false)

this is me, i will fix it soon.

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@7ab7fb86f0634df1f5a0b04460e1f3a1d6bead1f:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: runtime error: index out of range [0] with length 0
		stmt:
		WITH
			with_415 (col_2351)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('9a61c55b-f746-4284-8bdc-c5e09a22385f':::UUID),
								(crdb_internal.cluster_id()::UUID),
								('00000000-0000-0000-0000-000000000000':::UUID),
								('00000000-0000-0000-0000-000000000000':::UUID),
								('bf536146-18c5-4fa9-a8c4-d8ce042139a9':::UUID)
						)
							AS tab_1010 (col_2351)
				)
		SELECT
			json_agg(tab_1012._float8)::JSONB AS col_2352,
			max(tab_1011._timestamptz::TIMESTAMPTZ)::TIMESTAMPTZ AS col_2353,
			percentile_cont(tab_1012._float8::FLOAT8)::FLOAT8 AS col_2354,
			min(tab_1012._date::DATE)::DATE AS col_2355,
			max(tab_1012._bytes::BYTES) OVER (PARTITION BY tab_1012._bytes ORDER BY tab_1012._bytes, tab_1012._jsonb ASC GROUPS BETWEEN (-5654078047671080934):::INT8 FOLLOWING AND UNBOUNDED FOLLOWING)::BYTES
				AS col_2356,
			power(tab_1012._decimal::DECIMAL, (-1.234E+401):::DECIMAL::DECIMAL)::DECIMAL AS col_2357
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_1011
			JOIN defaultdb.public.seed@seed__int8__float8__date_idx AS tab_1012 ON
					(tab_1011._int4) = (tab_1012._int8)
					AND (tab_1011._int8) = (tab_1012._int2)
					AND (tab_1011._timestamp) = (tab_1012._timestamp)
					AND (tab_1011._float8) = (tab_1012._float4)
		GROUP BY
			tab_1012._float8, tab_1012._decimal, tab_1011._timestamptz, tab_1012._jsonb, tab_1012._date, tab_1012._bytes
		HAVING
			bool_and(tab_1012._bool::BOOL)::BOOL
		ORDER BY
			tab_1012._date DESC;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@yuzefovich
Copy link
Member

The latest one is reproducible internal error in the optimizer, will file a separate issue.

@yuzefovich yuzefovich mentioned this issue May 19, 2020
Closed
@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@73631089c58554c289d0fb1b26cad62667388335:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: runtime error: index out of range [0] with length 0
		stmt:
		WITH
			with_1682 (col_10774, col_10775)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								((-6539659111618421522):::INT8, (-0.6669025256091663):::FLOAT8),
								((-512990832475937807):::INT8, 0.02282151524027587:::FLOAT8),
								((-2321034248324486550):::INT8, (-1.426380683008457):::FLOAT8)
						)
							AS tab_4280 (col_10774, col_10775)
				)
		SELECT
			percentile_cont(cte_ref_512.col_10775::FLOAT8)::FLOAT8 AS col_10776
		FROM
			with_1682 AS cte_ref_512
		WHERE
			true
		GROUP BY
			cte_ref_512.col_10775
		ORDER BY
			cte_ref_512.col_10775 ASC
		LIMIT
			76:::INT8;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity cockroach-teamcity mentioned this issue May 19, 2020
Closed
@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@8fec3f4c6d136a86f472c975edd36b75e5ab9a8c:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: runtime error: index out of range [0] with length 0
		stmt:
		WITH
			with_4246 (col_25205)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									('-57 years -10 mons -652 days -11:00:51.425177':::INTERVAL, e'%\x03*6.':::STRING:::NAME, '\x27':::BYTES)
								)
						)
							AS tab_10321 (col_25205)
				)
		SELECT
			min(tab_10322._timestamptz::TIMESTAMPTZ)::TIMESTAMPTZ AS col_25206,
			percentile_cont(tab_10322._float8::FLOAT8)::FLOAT8 AS col_25207
		FROM
			defaultdb.public.seed@[0] AS tab_10322
		WHERE
			tab_10322._string ~* e'\x13\n~(2\x1dT':::STRING
		GROUP BY
			tab_10322._timestamptz, tab_10322._float8, tab_10322._int4
		HAVING
			every(tab_10322._bool::BOOL)::BOOL;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations
Related:

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@1520ad2ba7c926f8043de8b6e044ab35c2f67b13:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: runtime error: index out of range [0] with length 0
		stmt:
		WITH
			with_26 (col_193)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(NULL),
								(
									(
										SELECT
											ARRAY[1013013239:::OID,3772677998:::OID,855831734:::OID,3334606838:::OID,1154616737:::OID]
												AS col_192
										FROM
											defaultdb.public.seed@seed__int8__float8__date_idx AS tab_72
										WHERE
											true
										ORDER BY
											tab_72._int4 DESC
										LIMIT
											1:::INT8
									)
								)
						)
							AS tab_73 (col_193)
				)
		SELECT
			count(*) AS col_194
		FROM
			defaultdb.public.seed@[0] AS tab_74
		WHERE
			tab_74._bool
		GROUP BY
			tab_74._int8
		HAVING
			st_dwithin('0101000020E6100000000000000000F03F000000000000F03F':::GEOGRAPHY::GEOGRAPHY, '0103000020E610000000000000':::GEOGRAPHY::GEOGRAPHY, 0.6530763271718113:::FLOAT8::FLOAT8)::BOOL
		LIMIT
			6:::INT8;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations
Related:

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@809829bfe7ff27a610fa78f409fae658b9f2d9d9:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:174,sqlsmith.go:199,test_runner.go:753: error: pq: communication error: rpc error: code = Canceled desc = context canceled
		stmt:
		SELECT
			count(*) AS col_9649
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_4043
		WHERE
			tab_4043._bool
		GROUP BY
			tab_4043._int8, tab_4043._float8, tab_4043._date
		HAVING
			st_dfullywithin('0101000000000000000000F03F000000000000F03F':::GEOMETRY::GEOMETRY, '010300000000000000':::GEOMETRY::GEOMETRY, tab_4043._float8::FLOAT8)::BOOL
		ORDER BY
			tab_4043._float8 ASC, tab_4043._date, tab_4043._float8;

	cluster.go:1481,context.go:135,cluster.go:1470,test_runner.go:825: dead node detection: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod monitor teamcity-1964552-1590305390-02-n4cpu4 --oneshot --ignore-empty-nodes: exit status 1 3: 5846
		4: 5138
		2: dead
		1: 6575
		Error: UNCLASSIFIED_PROBLEM: 2: dead
		(1) UNCLASSIFIED_PROBLEM
		Wraps: (2) attached stack trace
		  | main.glob..func13
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1129
		  | main.wrap.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:272
		  | github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra.(*Command).execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:766
		  | github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra.(*Command).ExecuteC
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:852
		  | github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra.(*Command).Execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:800
		  | main.main
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1799
		  | runtime.main
		  | 	/usr/local/go/src/runtime/proc.go:203
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1357
		Wraps: (3) 2: dead
		Error types: (1) errors.Unclassified (2) *withstack.withStack (3) *errors.errorString
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations
Related:

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).sqlsmith/setup=seed/setting=no-mutations failed on master@9eea0be192499fa7d29b5eca5ed14173982b25f0:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:169,sqlsmith.go:199,test_runner.go:753: error: pq: internal error: no volatility for cast unknown::tuple
		stmt:
		WITH
			with_3116 (col_18505)
				AS (SELECT * FROM (VALUES (B'101001011010'), (B'010111001001'), (B'000011100111')) AS tab_7687 (col_18505)),
			with_3117 (col_18506)
				AS (
					SELECT * FROM (VALUES (NULL)) AS tab_7688 (col_18506)
					INTERSECT ALL SELECT * FROM (VALUES (()), (()), (()), (NULL), (()), (())) AS tab_7689 (col_18507)
				),
			with_3118 (col_18508)
				AS (
					SELECT
						*
					FROM
						(VALUES (e'*|\x05}2':::STRING:::NAME), (NULL), (']':::STRING:::NAME), ('':::STRING:::NAME))
							AS tab_7690 (col_18508)
				)
		SELECT
			'c926:903:6892:1218:9e91:a802:fae4:eb71/73':::INET AS col_18509
		LIMIT
			52:::INT8;
More

Artifacts: /sqlsmith/setup=seed/setting=no-mutations
Related:

See this test on roachdash
powered by pkg/cmd/internal/issues

@asubiotto
Copy link
Contributor

Latest is an optimizer issue, tracked in at least #50261. Will close this issue because it's pointlessly noisy.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Projects
None yet
Milestone
20.1
Development

No branches or pull requests
6 participants
@jordanlewis @andreimatei @otan @yuzefovich @asubiotto @cockroach-teamcity