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: unoptimized-query-oracle/disable-rules=half/rand-tables failed #139820

Open
cockroach-teamcity opened this issue Jan 26, 2025 · 0 comments
Labels
branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Jan 26, 2025

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on release-24.3 @ 3bb549350582192ffa091bfecba15527e545e30b:

  	}, ""),
  	strings.Join({
  		"e7b503b6-aa4b-4da7-b9a3-cb64a6608062,",
- 		``e'e\'t\\u0330able_1\''``,
+ 		"104",
  		",0,-5,0",
  	}, ""),
  	strings.Join({
  		"e935f751-f18a-48d1-88f6-eda4d2bfd5d9,",
- 		``e'e\'t\\u0330able_1\''``,
+ 		"104",
  		",0,-5,0",
  	}, ""),
  	strings.Join({
  		"eba1f2cd-fd59-4aca-a1ab-8ed9133d7517,",
- 		``e'e\'t\\u0330able_1\''``,
+ 		"104",
  		",0,-5,0",
  	}, ""),
  	strings.Join({
  		"ee8ccb5f-33c9-423d-a405-5cc8e43bd641,",
- 		``e'e\'t\\u0330able_1\''``,
+ 		"104",
  		",0,-5,0",
  	}, ""),
  }
sql: SELECT
	tab_958."c😉ol2
_0" AS col_2372,
	COALESCE(
		(
			SELECT
				tab_959.col1_1 AS col_2373
			FROM
				defaultdb.public.t̰able_1 AS tab_959
				JOIN defaultdb.public.t̰able_1 AS tab_960 ON (tab_959."
col1_0") = (tab_960."
col1_0")
			ORDER BY
				col_2373 DESC NULLS LAST
			LIMIT
				1:::INT8
		),
		tab_958.tableoid
	)
		AS col_2374,
	0:::OID AS col_2375,
	(-5):::INT8 AS col_2376,
	0:::OID AS col_2377
FROM
	defaultdb.public.table_2 AS tab_958
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

  • arch=amd64
  • cloud=gce
  • coverageBuild=false
  • cpu=4
  • encrypted=false
  • runtimeAssertionsBuild=false
  • ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-46838

@cockroach-teamcity cockroach-teamcity added branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team labels Jan 26, 2025
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Jan 26, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
Projects
Status: Triage
Development

No branches or pull requests

1 participant