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 #82973

Closed
cockroach-teamcity opened this issue Jun 16, 2022 · 4 comments · Fixed by #83140
Closed

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

cockroach-teamcity opened this issue Jun 16, 2022 · 4 comments · Fixed by #83140
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-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Jun 16, 2022 •
edited by cockroach-jira-scripts
Loading

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

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:265,sqlsmith.go:305,test_runner.go:884: error: pq: internal error: crdb_internal.request_statement_bundle(): malformed input: expected sampling probability in range [0.0, 1.0], got 179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368.000000
		stmt:
		WITH
			with_8221 (col_48719, col_48720)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(NULL, B'01110'),
								(B'010010101111011111110100101100110001', B'11010'),
								(B'100010010010100011011010010111001010', B'11101'),
								(B'011111111111111111111111111111111111', NULL)
						)
							AS tab_25025 (col_48719, col_48720)
				)
		SELECT
			crdb_internal.request_statement_bundle(tab_25026.col5_4::STRING, 1.7976931348623157e+308:::FLOAT8::FLOAT8, '-77 years -5 mons -263 days -15:45:29.262527':::INTERVAL::INTERVAL, '00:00:00':::INTERVAL::INTERVAL)::BOOL
				AS col_48721,
			tab_25026.col5_1 AS col_48722,
			tab_25026.col5_4 AS col_48723,
			tab_25026.crdb_internal_mvcc_timestamp AS col_48724,
			1844520442:::OID AS col_48725
		FROM
			defaultdb.public.table5@[0] AS tab_25026
		ORDER BY
			tab_25026.col5_2
		LIMIT
			53:::INT8;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-16764
@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 Jun 16, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Jun 16, 2022
@cockroach-teamcity
Copy link
Member Author

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

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:265,sqlsmith.go:305,test_runner.go:897: error: pq: internal error: crdb_internal.request_statement_bundle(): malformed input: expected sampling probability in range [0.0, 1.0], got -0.960286
		stmt:
		INSERT
		INTO
			defaultdb.public.table2 AS tab_127697 (col2_0, col2_1, col2_2, col2_3)
		SELECT
			4219688156:::OID AS col_215475,
			'\x9ee8c47f':::BYTES AS col_215476,
			'1975-06-27':::DATE AS col_215477,
			e'\x1b':::STRING AS col_215478
		FROM
			defaultdb.public.table1@[0] AS tab_127698
		WHERE
			crdb_internal.request_statement_bundle('':::STRING::STRING, (-0.9602856929635223):::FLOAT8::FLOAT8, age('2001-05-18 06:26:59.000156+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL::INTERVAL, '-49 years -10 mons -621 days -00:18:30.97364':::INTERVAL::INTERVAL)::BOOL
		LIMIT
			59:::INT8;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:265,sqlsmith.go:305,test_runner.go:897: error: pq: internal error: crdb_internal.request_statement_bundle(): malformed input: expected sampling probability in range [0.0, 1.0], got -0.100810
		stmt:
		WITH
			with_17139 (col_99251)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								((-3954951921371898654):::INT8),
								((-1057094519548245114):::INT8),
								(NULL),
								(2735721599530840637:::INT8),
								(1954028893053421937:::INT8)
						)
							AS tab_52679 (col_99251)
				)
		SELECT
			tab_52680.col2_4 AS col_99252,
			CASE
			WHEN (crdb_internal.request_statement_bundle(e't\x18M,':::STRING::STRING, (-0.10081018196170866):::FLOAT8::FLOAT8, tab_52682.col1_1::INTERVAL, tab_52682.col1_1::INTERVAL)::BOOL AND true)
			THEN tab_52680.col2_4
			ELSE true
			END
				AS col_99253,
			tab_52682.tableoid AS col_99254,
			tab_52682.col1_2 AS col_99255,
			tab_52681.col2_4 AS col_99256,
			tab_52682.col1_1 AS col_99257,
			tab_52682.crdb_internal_mvcc_timestamp AS col_99258,
			B'1' AS col_99259,
			tab_52681.col2_4 AS col_99260
		FROM
			defaultdb.public.table2 AS tab_52680
			JOIN defaultdb.public.table2 AS tab_52681 ON
					(tab_52680.col2_8) = (tab_52681.col2_8) AND (tab_52680.col2_4) = (tab_52681.col2_4),
			defaultdb.public.table1@[0] AS tab_52682;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

														*
													FROM
														(
															VALUES
																((-2861468266424751579):::INT8, '19:18:16.411183':::TIME),
																(5193259123768727787:::INT8, '07:56:30.754038':::TIME)
														)
															AS tab_101502 (col_199965, col_199966)
												)
										SELECT
											B'010010101101111101111011100000' AS col_199967
										FROM
											defaultdb.public.table1@[0] AS tab_101503
										WHERE
											true
										ORDER BY
											tab_101503.col1_0, tab_101503.col1_2
										LIMIT
											51:::INT8
									),
									((-0.3071851294402155):::FLOAT8::FLOAT8 / sind((-1.4826304826218257):::FLOAT8::FLOAT8)::FLOAT8::FLOAT8)::FLOAT8
								),
								(
									crdb_internal.request_statement_bundle(e'\n\x16|\r.|\x03kh':::STRING::STRING, '+Inf':::FLOAT8::FLOAT8, '44 years 829 days 15:32:30.382163':::INTERVAL::INTERVAL, '-47 years -8 mons -826 days -24:17:18.9113':::INTERVAL::INTERVAL)::BOOL,
									0.8660710638894635:::FLOAT8
								)
						)
							AS tab_101504 (col_199968, col_199969)
				),
			with_32579 (col_199970)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('a11a27aa-1106-463a-818d-6774cc9f4f8a':::UUID),
								('ad7fa2c2-7ae7-4887-a71e-4405c4faa3a4':::UUID),
								('7231b8c1-7ecc-4c5a-92b1-8d5d4c123da9':::UUID),
								('b6abbfe9-07d9-4310-9530-699e33587bcf':::UUID),
								(uuid_ns_oid()::UUID)
						)
							AS tab_101505 (col_199970)
				)
		SELECT
			cte_ref_9530.col_199969 AS col_199971, true AS col_199972
		FROM
			with_32578 AS cte_ref_9530
		LIMIT
			58:::INT8;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:265,sqlsmith.go:305,test_runner.go:897: error: pq: internal error: crdb_internal.request_statement_bundle(): malformed input: expected sampling probability in range [0.0, 1.0], got 1.200638
		stmt:
		WITH
			with_8950 (col_57498)
				AS (SELECT 812506808:::OID AS col_57498 FROM defaultdb.public.table4@[0] AS tab_28223 WHERE true),
			with_8951 (col_57499)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(true),
								(
									crdb_internal.request_statement_bundle(e'rA8P\x18;':::STRING::STRING, 1.2006377417596017:::FLOAT8::FLOAT8, '18 years 1 mon 441 days 17:31:23.127664':::INTERVAL::INTERVAL, '1 mon 1 day':::INTERVAL::INTERVAL)::BOOL
								),
								(false),
								((false AND (NOT true))),
								(false),
								(
									(NULL OR crdb_internal.set_trace_verbose((-7233730458859385724):::INT8::INT8, true::BOOL)::BOOL)
								)
						)
							AS tab_28224 (col_57499)
				)
		SELECT
			cte_ref_2645.col_57498 AS col_57500
		FROM
			with_8950 AS cte_ref_2645;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@yuzefovich yuzefovich removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Jun 21, 2022
@yuzefovich yuzefovich mentioned this issue Jun 21, 2022
Merged
@craig craig bot closed this as completed in a8f7ed7 Jun 22, 2022
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
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. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sqlsmith: skip crdb_internal.request_statement_bundle yuzefovich/cockroach
2 participants
@yuzefovich @cockroach-teamcity