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.

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

roachtest: sqlsmith/setup=tpcc/setting=no-ddl failed #108981

Closed
cockroach-teamcity opened this issue Aug 18, 2023 · 1 comment
Closed

roachtest: sqlsmith/setup=tpcc/setting=no-ddl failed #108981

cockroach-teamcity opened this issue Aug 18, 2023 · 1 comment
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. O-rsg Random Syntax Generator T-sql-queries SQL Queries Team
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Aug 18, 2023

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

				(
					VALUES
						((-5309503658644341505):::INT8),
						(1313219013396569515:::INT8),
						((-1522045942834882869):::INT8),
						(
							octet_length(bitmask_and(B'011001000011001110111001111110001110101011101'::VARBIT, experimental_strftime('1983-11-19 07:51:47.000896+00':::TIMESTAMPTZ::TIMESTAMPTZ, e'L\x171Vu"f':::STRING::STRING)::STRING::STRING)::VARBIT::VARBIT)::INT8
						)
				)
					AS tab1711 ("c ol2968")
		),
	with537 (col2969, col2970)
		AS (
			SELECT
				*
			FROM
				(
					VALUES
						(NULL, ARRAY[false,true]),
						(
							'BOX(0.06623172608213629 1.1243940834355257,0.17364217906486584 1.5252298989750046)':::BOX2D,
							ARRAY[false]
						),
						(
							'BOX(-0.34253115936036593 -0.5663929270607837,-0.15433396968655289 -0.06328385939331438)':::BOX2D,
							ARRAY[true,false,true]
						),
						(
							'BOX(-0.059850088935753054 0.06744953840114803,0.18696728231088072 0.1824220331709946)':::BOX2D,
							ARRAY[false,true,true,true,true]
						),
						(
							NULL,
							func532((-273928663):::INT8::INT4, false::BOOL, ((-8616747582240145552):::INT8,)::RECORD)::BOOL[]
						)
				)
					AS tab1712 (col2969, col2970)
		)
SELECT
	NULL AS col2971, 989:::INT8 AS col2972
FROM
	with535 AS "😾cte%f6_ref151"
ORDER BY
	"😾cte%f6_ref151".col2967 ASC NULLS LAST,
	"😾cte%f6_ref151".col2967,
	"😾cte%f6_ref151".col2967 DESC NULLS FIRST,
	"😾cte%f6_ref151".col2967 NULLS LAST
LIMIT
	66:::INT8;
test artifacts and logs in: /artifacts/sqlsmith/setup=tpcc/setting=no-ddl/run_1

Parameters: ROACHTEST_arch=amd64 , ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-30732

@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. T-sql-queries SQL Queries Team labels Aug 18, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.2 milestone Aug 18, 2023
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Aug 18, 2023
@yuzefovich
Copy link
Member

dup of #108980

@github-project-automation github-project-automation bot moved this from Triage to Done in SQL Queries Aug 18, 2023
@michae2 michae2 added the O-rsg Random Syntax Generator label Sep 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
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. O-rsg Random Syntax Generator T-sql-queries SQL Queries Team
Projects
Archived in project
Development

No branches or pull requests

3 participants