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=rand-tables/setting=no-ddl failed #70477

Closed
cockroach-teamcity opened this issue Sep 21, 2021 · 6 comments · Fixed by #70606
Closed

roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #70477

cockroach-teamcity opened this issue Sep 21, 2021 · 6 comments · Fixed by #70606
Assignees
@rafiss
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. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 676dc076dc6a137d88eac9217764bbb63beae86f:

			with_1189 (col_7059)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									CASE
									WHEN false
									THEN ARRAY[(2498598801:::OID, '\x':::BYTES, 'BOX(-1.473549306724302 -1.3600410344013085,0.23926956800717214 0.8180963348960345)':::BOX2D)]
									ELSE ARRAY[]:::RECORD[]
									END
								),
								(
									ARRAY[(2744992465:::OID, '\xfe':::BYTES, 'BOX(0.545468405248748 -0.9431645714585375,0.5635750195823661 -0.4446846801174844)':::BOX2D),(1920508521:::OID, NULL, 'BOX(-1.6320405588326239 -2.7235542450942307,1.580224575524476 1.0509215072592037)':::BOX2D),(4176104366:::OID, NULL, 'BOX(-1.0791788396134159 -0.5683784035565729,0.22911363649496352 0.06660776683378988)':::BOX2D),(936593898:::OID, '\x4c':::BYTES, 'BOX(0.38572015570367824 0.06600980533862477,0.7350638495975028 0.636032225362754)':::BOX2D),(3966419895:::OID, NULL, 'BOX(-10 -10,10 10)':::BOX2D)]
								),
								(
									ARRAY[(209636487:::OID, '\x368044':::BYTES, NULL),(1569974628:::OID, '\x6af68547642d5e95e6':::BYTES, 'BOX(-0.36487022223640864 -0.16444712171311313,0.8493663182844707 1.8182103803843979)':::BOX2D)]
								),
								(
									ARRAY[(2975694003:::OID, '\x22':::BYTES, 'BOX(-0.3485663832426801 -0.8544256669872184,0.5944111285915109 0.6101885378360927)':::BOX2D),(3669526711:::OID, '\x474b725a07':::BYTES, 'BOX(0.3505346936549236 -1.1186423048501075,0.4106421376096584 0.5871813566098203)':::BOX2D),(986739408:::OID, '\x86bbcd614a89f4':::BYTES, 'BOX(-10 -10,10 10)':::BOX2D),(397688687:::OID, '\xb04e':::BYTES, 'BOX(-0.9316307544003903 -0.8348736482597704,0.5494110968839473 1.0894104755156842)':::BOX2D)]
								)
						)
							AS tab_3477 (col_7059)
					EXCEPT ALL
						SELECT
							*
						FROM
							(
								VALUES
									(ARRAY[]:::RECORD[]),
									(NULL),
									(
										ARRAY[(3135613574:::OID, '\xafd8458a2b34a0':::BYTES, 'BOX(0.2831964323498861 -0.5353622726900271,0.5594993099538235 1.213409163649324)':::BOX2D),(160078674:::OID, '\x3932fe':::BYTES, 'BOX(0.23208330216451478 -0.48268581503464275,0.9676324327606974 0.27993347712692973)':::BOX2D),(2118718584:::OID, '\x30':::BYTES, 'BOX(-1.1618342849754377 -0.44730213233472216,-0.049716782872001763 0.9414706895771634)':::BOX2D)]
									),
									(
										ARRAY[(742831845:::OID, NULL, 'BOX(-2.1510834786106874 0.8912499822304156,0.13493658301585068 1.583184003270404)':::BOX2D)]
									)
							)
								AS tab_3478 (col_7060)
				)
		SELECT
			cte_ref_361.col_7059 AS col_7061
		FROM
			with_1189 AS cte_ref_361
		WHERE
			true
		LIMIT
			57:::INT8;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!
@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 Sep 21, 2021
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Sep 21, 2021
@otan
Copy link
Contributor

otan commented Sep 21, 2021 

[email protected]:26257/movr>
                                        SELECT
                                                array_position(ARRAY[(NULL,),(595566764653944.8473:::DECIMAL,)], (B'0000000000000000000000000000000000000000000000',))::INT8;
ERROR: internal error: unsupported comparison: decimal to varbit

@rafiss
Copy link
Collaborator

rafiss commented Sep 21, 2021

This is only on master so i'll remove the release-blocker label so it doesn't interfere with the 21.2 release

@rafiss rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Sep 21, 2021
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Sep 21, 2021
@cockroach-teamcity
Copy link
Member Author

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 1dbea6a3e4c93ba7c4a43ad34369c438558eba8a:

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=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:242,sqlsmith.go:256,test_runner.go:777: ping node 1: dial tcp 35.231.136.53:26257: connect: connection refused
		previous sql:
		SELECT
			'31 years 9 mons 540 days 05:05:27.319285':::INTERVAL AS col_184470,
			4196:::INT8 AS col_184471,
			tab_91605.tableoid AS col_184472,
			0:::DECIMAL AS col_184473,
			tab_91606.col4_1 AS col_184474,
			tab_91605.col4_3 AS col_184475
		FROM
			defaultdb.public.table4@[0] AS tab_91605, defaultdb.public.table4@[0] AS tab_91606
		ORDER BY
			tab_91605.col4_4 DESC, tab_91605.col4_4;

	cluster.go:1300,context.go:91,cluster.go:1288,test_runner.go:866: dead node detection: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod monitor teamcity-3479918-1632291457-09-n4cpu4 --oneshot --ignore-empty-nodes: exit status 1 4: 11733
		3: 13424
		2: 12429
		1: dead (exit status 137)
		Error: UNCLASSIFIED_PROBLEM: 1: dead (exit status 137)
		(1) UNCLASSIFIED_PROBLEM
		Wraps: (2) attached stack trace
		  -- stack trace:
		  | main.glob..func14
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1173
		  | main.wrap.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:281
		  | github.com/spf13/cobra.(*Command).execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:856
		  | github.com/spf13/cobra.(*Command).ExecuteC
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:960
		  | github.com/spf13/cobra.(*Command).Execute
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:897
		  | main.main
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:2107
		  | runtime.main
		  | 	/usr/local/go/src/runtime/proc.go:225
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
		Wraps: (3) 1: dead (exit status 137)
		Error types: (1) errors.Unclassified (2) *withstack.withStack (3) *errutil.leafError
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

@rafiss rafiss mentioned this issue Sep 23, 2021
Merged
@cockroach-teamcity
Copy link
Member Author

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ a465b0d5d51a6534d39e0683fd037d132bcbd576:

		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*panicInjector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/panic_injector.go:70
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:99
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoiner).consumeInputs
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/crossjoiner.go:172
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoiner).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/crossjoiner.go:92
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*panicInjector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/panic_injector.go:70
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:99
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoiner).consumeInputs
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/crossjoiner.go:172
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoiner).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/crossjoiner.go:92
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*panicInjector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/panic_injector.go:70
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:99
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.spool_false
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/sorttopk.eg.go:310
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*topKSorter).spool
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/sorttopk.eg.go:67
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*topKSorter).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/sorttopk.go:169
		Wraps: (2) non-nullable column "table4:col4_6" with no value! Index scanned was "primary" with the index key columns (rowid) and the values (?)
		Error types: (1) *withstack.withStack (2) *errutil.leafError
		stmt:
		SELECT
			tab_2234.col2_12 AS col_4082,
			tab_2236.col4_6 AS col_4083,
			NULL AS col_4084,
			NULL AS col_4085,
			'00:00:00':::INTERVAL AS col_4086
		FROM
			defaultdb.public.table5@[0] AS tab_2233,
			defaultdb.public.table2@table2_expr_expr1_col2_4_col2_13_col2_16_col2_0_idx AS tab_2234,
			defaultdb.public.table4@[0] AS tab_2235
			JOIN defaultdb.public.table4@[0] AS tab_2236 ON
					(tab_2235.tableoid) = (tab_2236.col4_4)
					AND (tab_2235.col4_12) = (tab_2236.col4_9)
					AND (tab_2235.col4_5) = (tab_2236.col4_5)
					AND (tab_2235.col4_7) = (tab_2236.col4_7)
					AND (tab_2235.col4_11) = (tab_2236.col4_13),
			defaultdb.public.table2@[0] AS tab_2237
		ORDER BY
			tab_2236.col4_10
		LIMIT
			68:::INT8;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

@yuzefovich
Copy link
Member

Bingo! The last occurrence is reproducible - I'm currently reducing it and will file a separate issue.

@yuzefovich
Copy link
Member

Filed #70628 for the last occurrence.

@craig craig bot closed this as completed in 55ef033 Sep 23, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rafiss rafiss

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. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) T-sql-queries SQL Queries Team
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

builtins: array builtins handle mismatched tuple types rafiss/cockroach
4 participants
@rafiss @otan @yuzefovich @cockroach-teamcity