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

Closed
cockroach-teamcity opened this issue May 22, 2024 · 1 comment
Closed

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

cockroach-teamcity opened this issue May 22, 2024 · 1 comment
Labels
branch-release-24.1.0-rc Used to mark GA and release blockers and technical advisories for 24.1.0-rc 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 May 22, 2024

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on release-24.1.0-rc @ 5e4ca9e26f1a25681de9c944298cfa139c344466:

(sqlsmith.go:272).func3: 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_10985."co""l%q2_4" AS col_17837,
	tab_10985.tableoid AS col_17838,
	tab_10985."c̢o'l2_1" AS col_17839,
	e'\U000B6056\U000E845B\U0007B1F1\U0002B7D9\U000C269B\U0008F108\U000087E8\U000C716D' COLLATE en_US AS col_17840,
	log('Infinity':::DECIMAL::DECIMAL, 990813664.808159305:::DECIMAL::DECIMAL)::DECIMAL AS col_17841,
	tab_10986.col1_1 AS col_17842
FROM
	defaultdb.public.table_2@[0] AS tab_10985, defaultdb.public.table_1@[0] AS tab_10986
ORDER BY
	tab_10985." cọl2_0" ASC NULLS LAST, tab_10985."co""ļ!%p2_3" DESC;
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=gce
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-38949

@cockroach-teamcity cockroach-teamcity added branch-release-24.1.0-rc Used to mark GA and release blockers and technical advisories for 24.1.0-rc 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 labels May 22, 2024
@cockroach-teamcity cockroach-teamcity added this to the 24.1 milestone May 22, 2024
@yuzefovich
Copy link
Member

This seems like #40929 which has been fixed for a while. Unable to reproduce this, closing.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-24.1.0-rc Used to mark GA and release blockers and technical advisories for 24.1.0-rc 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

2 participants