Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

roachtest: sqlsmith/setup=empty/setting=no-mutations failed #80150

Closed
cockroach-teamcity opened this issue Apr 19, 2022 · 4 comments · Fixed by #80207
Closed

roachtest: sqlsmith/setup=empty/setting=no-mutations failed #80150

cockroach-teamcity opened this issue Apr 19, 2022 · 4 comments · Fixed by #80207
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Apr 19, 2022 •
edited by cockroach-jira-scripts
Loading

roachtest.sqlsmith/setup=empty/setting=no-mutations failed with artifacts on release-21.2 @ 4d3e4b459288c1a93837d9f0b7860c4553a1c481:

								('1984-03-30 06:46:08.000098':::TIMESTAMP, 202300828:::OID),
								(statement_timestamp():::TIMESTAMP::TIMESTAMP, 2612838780:::OID)
						)
							AS tab_348025 (col_581871, col_581872)
					INTERSECT ALL
						SELECT
							*
						FROM
							(VALUES ('0001-01-01 00:00:00':::TIMESTAMP, 1539772334:::OID))
								AS tab_348026 (col_581873, col_581874)
				)
		SELECT
			'1992-01-26 13:27:43.000137':::TIMESTAMP AS col_581876,
			1670999711:::OID AS col_581877,
			2575077837:::OID AS col_581878
		FROM
			with_97717 AS cte_ref_28902, (VALUES (NULL), (2588936774:::OID), (320160646:::OID)) AS tab_348027 (col_581875)
		WHERE
			true
		LIMIT
			76:::INT8;

	cluster.go:1296,context.go:91,cluster.go:1284,test_runner.go:866: dead node detection: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod monitor teamcity-4924108-1650348518-03-n4cpu4 --oneshot --ignore-empty-nodes: exit status 1 3: 13327
		4: 12707
		2: 12943
		1: dead (exit status 134)
		Error: UNCLASSIFIED_PROBLEM: 1: dead (exit status 134)
		(1) UNCLASSIFIED_PROBLEM
		Wraps: (2) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/roachprod.Monitor
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/roachprod/roachprod.go:596
		  | main.glob..func14
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:569
		  | main.wrap.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:123
		  | 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:1170
		  | runtime.main
		  | 	/usr/local/go/src/runtime/proc.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (3) 1: dead (exit status 134)
		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!

Jira issue: CRDB-15831
@cockroach-teamcity cockroach-teamcity added branch-release-21.2 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 19, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Apr 19, 2022
@rharding6373
Copy link
Collaborator

I was able to reproduce a crash with this query on an earlier version of 21.2, so removing the release blocker label.

CC @otan, looks like it's segfaulting in the geo package.

Query:

WITH
			with_97715 (col_581868)
				AS (
					SELECT
						(SELECT (-14100):::INT8 AS col_581867 LIMIT 1:::INT8) AS col_581868
					FROM
						(
							VALUES
								(
									st_minimumboundingcircle(st_point((-0.704302610816443):::FLOAT8::FLOAT8, '+Inf':::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY, (-8709325595834897572):::INT8::INT8)::GEOMETRY
								),
								('010300004000000000':::GEOMETRY),
								(NULL),
								('0101000040D704CD1DBBDEFEC1887CE13BAA7EE241B6662C962338FAC1':::GEOMETRY),
								(
									'010200008003000000ECFD4123A684F341B84C5B3E337BFF418E593F46598001420006B9CB81D2D4410882AC4F85C3F54100BC926C1CACA2C1771D206FE8ADF4C1A0B11E9D08AADA4140AE5EC915D2EF41':::GEOMETRY
								),
								(
									'0106000080060000000103000080010000000B0000004A2E681CCB54EBC1B8A65410F81DD2418E98D6BB109BFBC1BF6E274A54A7F4C16CD1E492BC2AF1C1108ED7E876B5CA4178FF1D502FCFE44160DB945E19C6EAC1F0AF280DE021E741E215F44904D8F6414050307F43CFEF41642824B46A57FB41F0C979C0702700420AF6D1609699F44116A09805386F0142240751643149F6410CED288880F1F24178BD6AF4395CD44190DA644A30A6DAC15836FAD9C4BBFB41F8AA7C1E5A69EE41282720D080BFD5C1F2D3C0F17966F441A8E140DE46D7D4416093412646D2CAC1EC0396C5A777E7416EC7DCF913B2FBC18C0D6C15B78CFCC1303F3B1B990AEF412EF02F349F7AF7C14A2E681CCB54EBC1B8A65410F81DD2418E98D6BB109BFBC1010300008001000000090000008C5EFA121CFAF6C180FF7AC9C65DBDC1D0FF90114945DDC19AC74EFCE66DF9C10F87F41B5971FFC14E2F013E8A1EF9C1F4839FAB51F2FF41C0D5577D547AB441266376652040F741385DCBD87920FC41884C4403B3B5DB41ACB9AC10DDA7EF41DAD1D0995ACCF84188B73245DCB0EA4147ED231FECA4F1C1C00D463115AEFF41387F93EB222F0142D2397BDCCD580142888E9AF932DEDE41F4492D27B073E941B0D60F574129CBC100C78F755FEA9E419214066D7830F541FE9CC7DA4C8AFBC18C5EFA121CFAF6C180FF7AC9C65DBDC1D0FF90114945DDC101030000800100000009000000B0F8718CC72F01C224DAEFF70302DCC11284FD474459F741FA656A8641D1E1C1FA45329AE53EE1C14C2DFBBD2484FB41AA61FA8C7EE2E3C1E951DBB85C16FBC140EDDEF68DD6C5C16277851A70ABF5415836BE21FE73D341FCF0CE73B196FB4176E013F2D5AC00423012C7A167D4F6419045942CAF7ADAC14CF49DE9D154014254E0027F76F7F94180DC3F64FAEBDF4167994E0A03C3FFC1F27E793C25B601426FCFC5066A71F0C1FCEE5BBB71CEF9C1F47B79E70FBDE14170850D8A0CD3C441B0F8718CC72F01C224DAEFF70302DCC11284FD474459F74101030000800100000005000000D8B5D81B83D7D2411B12EDD20AB7F3C1787B9B6B42A5F6C1FCE6E0C8710DF44123551AF96ACBF7C18C7480F2260CEA41C81C91B929A8D3412ADEFA996DD5F9411C876FF8B6F5F041C48F31A99986FCC1801F95074BF091C1F3CB60D1911F02C2D8B5D81B83D7D2411B12EDD20AB7F3C1787B9B6B42A5F6C10103000080010000000600000064CF1C446D70E241FFC3D8AEDDE800C2F1BDA6B5A5BEFFC1C4CD9F145D2BF041D09202AF82B3C8C144FD1B46C5D4F74126F9B7280F52F941C0D92ECCFD6CD641982AF5A21AA9D5C16C40626EFC07EA41EC17EADADB09E04162C0C6574F13FAC180F0452CCCF7E0C1401A3B4332B1B9C1F84540C44C37FEC164CF1C446D70E241FFC3D8AEDDE800C2F1BDA6B5A5BEFFC10103000080010000000A00000066FA609A5AD7EAC1006D5CA26AE28DC138E8C7BBF3BFE241246B67911701F2C15E1CEA62E7B6E3C12C3D8ACA3CF2FF41E0063375263FD7411CB91869F71AF1C1616D0B23AA0F01C240E665F214ACFC410627C9B5CC6CF8C15E5E23F248AAF541E6C0B10BF390004280BA348E109AB7C106BAB8426376F4411E5A8698F2CB0042BEBD597B741BFA419A43EB746B210142943508843858E441B0C6523B07FECE41C2C40D9C9ADDF341F00F3D631F73E841009D5B690B3DDF410EBCFBC34023E6C1F2632CC71D00FEC1B6E97DE68369F041A008D2E8233FDF4166FA609A5AD7EAC1006D5CA26AE28DC138E8C7BBF3BFE241':::GEOMETRY
								)
						)
							AS tab_348022 (col_581866)
					WHERE
						NULL
				),
			with_97716 (col_581869)
				AS (
					SELECT * FROM (VALUES (ARRAY[]:::INT2[])) AS tab_348023 (col_581869)
					INTERSECT SELECT * FROM (VALUES (ARRAY[(-25189):::INT8]), (NULL), (NULL)) AS tab_348024 (col_581870)
				),
			with_97717 (col_581871, col_581872)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('1976-03-23 23:44:49.000662':::TIMESTAMP, 1925470693:::OID),
								('2001-08-11 04:48:36.000936':::TIMESTAMP, NULL),
								('1984-03-30 06:46:08.000098':::TIMESTAMP, 202300828:::OID),
								(statement_timestamp():::TIMESTAMP::TIMESTAMP, 2612838780:::OID)
						)
							AS tab_348025 (col_581871, col_581872)
					INTERSECT ALL
						SELECT
							*
						FROM
							(VALUES ('0001-01-01 00:00:00':::TIMESTAMP, 1539772334:::OID))
								AS tab_348026 (col_581873, col_581874)
				)
		SELECT
			'1992-01-26 13:27:43.000137':::TIMESTAMP AS col_581876,
			1670999711:::OID AS col_581877,
			2575077837:::OID AS col_581878
		FROM
			with_97717 AS cte_ref_28902, (VALUES (NULL), (2588936774:::OID), (320160646:::OID)) AS tab_348027 (col_581875)
		WHERE
			true
		LIMIT
			76:::INT8;

SIGSEGV:

runtime.cgocall(0x80952f0, 0xc002a1f6e8, 0x4000001)
	/usr/local/go/src/runtime/cgocall.go:154 +0x5b fp=0xc002a1f6a0 sp=0xc002a1f668 pc=0x400599b
github.com/cockroachdb/cockroach/pkg/geo/geos._Cfunc_CR_GEOS_MinimumBoundingCircle(0x3a223000, 0xc002b28b00, 0x15, 0xc002db8fa0, 0xc00326b960, 0xc00326b970, 0x0, 0x0)
	_cgo_gotypes.go:570 +0x48 fp=0xc002a1f6e8 sp=0xc002a1f6a0 pc=0x5568688
github.com/cockroachdb/cockroach/pkg/geo/geos.MinimumBoundingCircle.func1(0x3a223000, 0xc002b28b00, 0x15, 0x40, 0xc002db8fa0, 0xc00326b960, 0xc00326b970, 0x0, 0xee76200)
	/go/src/github.com/cockroachdb/cockroach/pkg/geo/geos/geos.go:444 +0x118 fp=0xc002a1f748 sp=0xc002a1f6e8 pc=0x5573638
github.com/cockroachdb/cockroach/pkg/geo/geos.MinimumBoundingCircle(0xc002b28b00, 0x15, 0x40, 0xee76200, 0xc0009c2da8, 0xc000337110, 0xc001e90680, 0xc002a1f8f0, 0x4f1e490, 0xee75240, ...)
	/go/src/github.com/cockroachdb/cockroach/pkg/geo/geos/geos.go:444 +0x10d fp=0xc002a1f7e0 sp=0xc002a1f748 pc=0x556c94d
github.com/cockroachdb/cockroach/pkg/geo/geomfn.MinimumBoundingCircle(0x2, 0xc002b28b00, 0x15, 0x40, 0x100000000, 0xc0021d1020, 0x0, 0x0, 0x0, 0x0, ...)

@rharding6373 rharding6373 removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Apr 19, 2022
@yuzefovich
Copy link
Member

Dup of a known issue #71917.

@yuzefovich
Copy link
Member

Hm, so #79374 was supposed to fix this problem, and the SHA in the failure contains that change, so it seems like the fix was incomplete. Reopening.

@yuzefovich yuzefovich reopened this Apr 19, 2022
@yuzefovich
Copy link
Member

cc @otan

@otan otan mentioned this issue Apr 19, 2022
Merged
@craig craig bot closed this as completed in 32da29a Apr 21, 2022
This was referenced Apr 21, 2022
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

builtins: fix panic for ST_MinimumBoundingCircle with num_segments otan-cockroach/cockroach
4 participants
@jlinder @yuzefovich @rharding6373 @cockroach-teamcity