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

Closed
cockroach-teamcity opened this issue Feb 28, 2021 · 2 comments
Closed

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

cockroach-teamcity opened this issue Feb 28, 2021 · 2 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.

Comments

@cockroach-teamcity
Copy link
Member

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

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:198,sqlsmith.go:228,test_runner.go:767: error: pq: internal error: unable to vectorize execution plan: 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_7490._int8 AS col_18046,
			tab_7490._date AS col_18047,
			tab_7490.tableoid AS col_18048,
			tab_7490._jsonb AS col_18049,
			false AS col_18050,
			tab_7490._inet AS col_18051,
			'\x':::BYTES AS col_18052,
			tab_7490._interval AS col_18053,
			log('Infinity':::DECIMAL::DECIMAL, 5.919033125047674329E+35:::DECIMAL::DECIMAL)::DECIMAL AS col_18054,
			(-4947546012761805672):::INT8 AS col_18055,
			e'\x00':::STRING AS col_18056,
			tab_7490._timestamptz AS col_18057,
			tab_7490._int2 AS col_18058,
			tab_7490._enum AS col_18059,
			'-4713-11-24 00:00:00':::TIMESTAMP AS col_18060,
			(-0.0758073627948761):::FLOAT8 AS col_18061,
			tab_7490._float8 AS col_18062,
			2.124783831416981526E+35:::DECIMAL AS col_18063
		FROM
			defaultdb.public.seed@[0] AS tab_7490;

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 Feb 28, 2021
@cockroach-teamcity
Copy link
Member Author

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

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:198,sqlsmith.go:228,test_runner.go:767: error: pq: internal error: crdb_internal.complete_stream_ingestion_job(): get-stream-ingestion-job-metadata: UpdateDeadlineMaybe() called on leaf txn
		stmt:
		WITH
			with_4631 (col_26304) AS (SELECT * FROM (VALUES (true), (false), (NULL), (false)) AS tab_10934 (col_26304)),
			with_4632 (col_26305) AS (SELECT * FROM (VALUES ('\x39416a59':::BYTES), (NULL)) AS tab_10935 (col_26305))
		SELECT
			(crdb_internal.complete_stream_ingestion_job((-8612027580230038151):::INT8::INT8, tab_10936._timestamptz::TIMESTAMPTZ)::INT8::INT8 # (-7861885823671284481):::INT8::INT8)::INT8
				AS col_26306,
			ceil(tab_10936._int4::INT8)::FLOAT8 AS col_26307,
			tab_10936._int2 AS col_26308,
			cte_ref_1331.col_26304 AS col_26309,
			tab_10936._interval AS col_26310,
			tab_10936._bytes AS col_26311,
			'2022-08-27 09:08:28.000725+00:00':::TIMESTAMPTZ AS col_26312,
			'64f26135-20ea-41a2-b57a-ffd57a441414':::UUID AS col_26313,
			tab_10936._int2 AS col_26314
		FROM
			with_4631 AS cte_ref_1331, defaultdb.public.seed@seed__int8__float8__date_idx AS tab_10936
		ORDER BY
			tab_10936.crdb_internal_mvcc_timestamp ASC
		LIMIT
			63:::INT8;

More

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

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

@asubiotto
Copy link
Contributor

Dup of #40929 latest failure is tracked in #61050

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. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Projects
None yet
Development

No branches or pull requests

2 participants