Skip to content

roachtest: unoptimized-query-oracle/disable-rules=all failed #90053

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.unoptimized-query-oracle/disable-rules=all failed with artifacts on release-22.2 @ 5bbbb4fefe2cca87aa8dd34c007702bb2faa20ef:

test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/run_1
	query_comparison_util.go:237,query_comparison_util.go:66,unoptimized_query_oracle.go:54,test_runner.go:930: . 21551 statements run: expected unoptimized and optimized results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.(*queryComparisonHelper).makeError
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:345
		  | [...repeated from below...]
		Wraps: (2) . 21551 statements run
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runUnoptimizedQueryOracleImpl
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:168
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1.1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:57
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runOneRoundQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:236
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:66
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:54
		  | main.(*testRunner).runTest.func2
		  | 	main/pkg/cmd/roachtest/test_runner.go:930
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1594
		Wraps: (4) expected unoptimized and optimized results to be equal
		  |   []string{
		  |   	"0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,0000000"...,
		  |   	"0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,1110101"...,
		  |   	"0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,NULL,NU"...,
		  | - 	``0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,NULL,NULL,0,"``,
		  |   }
		  | sql: SELECT
		  | 	0:::OID AS col_88556,
		  | 	tab_27011.tableoid AS col_88557,
		  | 	0.5054834485054016:::FLOAT8 AS col_88558,
		  | 	'1970-04-11 00:08:20':::TIMESTAMP AS col_88559,
		  | 	tab_27011.col2_14 AS col_88560,
		  | 	tab_27011.col2_9 AS col_88561,
		  | 	0:::OID AS col_88562,
		  | 	tab_27011.col2_15 AS col_88563
		  | FROM
		  | 	defaultdb.public.table2@[0] AS tab_27011
		  | WHERE
		  | 	(EXISTS (SELECT ARRAY[32297:::INT8,15358:::INT8] AS col_88555 FROM defaultdb.public.table2@[0] AS tab_27012) AND ('00:01:40.01+09:00:00':::TIMETZ < (tab_27011.col2_8::TIMETZ + '-83 years -1 mons -38 days -10:32:23.707137':::INTERVAL::INTERVAL)::TIMETZ))
		  | ORDER BY
		  | 	tab_27011.col2_10, tab_27011.col2_1, tab_27011.col2_0, tab_27011.col2_5 DESC
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , 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-20572

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-release-22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2

Type

No type

Projects

Status

Done

Relationships

None yet

Development

No branches or pull requests

Issue actions