Skip to content

roachtest: unoptimized-query-oracle/disable-rules=half failed #87779

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.unoptimized-query-oracle/disable-rules=half failed with artifacts on release-22.2 @ 1bfe9bcda653f55ed3b4216610433b51b2ef0d8f:

		(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:348
		  | [...repeated from below...]
		Wraps: (2) . 10651 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:165
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1.1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:54
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runOneRoundQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:239
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:69
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:51
		  | main.(*testRunner).runTest.func2
		  | 	main/pkg/cmd/roachtest/test_runner.go:908
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1594
		Wraps: (4) expected unoptimized and optimized results to be equal
		  |   []string(
		  | - 	{"0000-01-01 13:37:23.572795 +0000 UTC,-1.01E-9"},
		  | + 	nil,
		  |   )
		  | sql: SELECT
		  | 	'13:37:23.572795':::TIME AS col_38235, (-1.01E-9):::DECIMAL AS col_38236
		  | FROM
		  | 	(
		  | 		SELECT
		  | 			0.01978192160410784856:::DECIMAL AS col_38226,
		  | 			0:::OID AS col_38227,
		  | 			tab_13166.col5_1 AS col_38228,
		  | 			'05:47:10.341532':::TIME AS col_38229
		  | 		FROM
		  | 			defaultdb.public.table5@[0] AS tab_13166
		  | 		ORDER BY
		  | 			tab_13166.col5_0 ASC,
		  | 			tab_13166.crdb_internal_mvcc_timestamp ASC,
		  | 			tab_13166.col5_0 DESC,
		  | 			tab_13166.tableoid DESC
		  | 	)
		  | 		AS tab_13167 (col_38230, col_38231, col_38232, col_38233)
		  | GROUP BY
		  | 	tab_13167.col_38230, tab_13167.col_38233
		  | HAVING
		  | 	(NOT EXISTS (SELECT ('21:55:04.56629-05:36:00':::TIMETZ::TIMETZ - '1 mon 5 days 00:00:00.000001':::INTERVAL::INTERVAL)::TIMETZ AS col_38234 FROM defaultdb.public.table1@[0] AS tab_13168 WHERE ('254.239.239.254/0':::INET::INET << '160.177.167.224/30':::INET::INET)::BOOL))
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError

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

Metadata

Metadata

Assignees

No one assigned

    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.2release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

    Type

    No type

    Projects

    Status

    Done

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions