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

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=half failed with artifacts on master @ 3b16435371a43d603d193a1e2b480a23fba3f07a:

test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/run_1
	test_runner.go:1028,test_runner.go:927: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-19109

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=half failed with artifacts on master @ 448352ce4ed71a58e7701e82c786dd5152498310:

		  | [...repeated from below...]
		Wraps: (2) . 16902 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:236
		  | 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:897
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) expected unoptimized and optimized results to be equal
		  |   []string{
		  |   	"000000000000000000000000000000000000000000000,\xff,9.9,8965c7f4-1fc"...,
		  |   	strings.Join({
		  |   		"000000000000000000000000000000000000000000000,\xff,9.9,8f7c0388-855",
		  |   		"0-4a12-87b1-f46d23253be3,1978-02-10 00:00:00 +0000 +0000,540.489",
		  |   		"443357260818422",
		  | + 		"0",
		  |   		",0,111110110001001101110110000101000010010,Infinity,0,0,12211714",
		  |   		"21,-926312227,-5.228870704919736421E+28",
		  |   	}, ""),
		  |   	"000000000000000000000000000000000000000000000,\xff,9.9,d869dbe3-dee"...,
		  |   	"000000000000000000000000000000000000000000000,\xff,9.9,fe5efe5e-fe5"...,
		  |   }
		  | sql: SELECT
		  | 	B'000000000000000000000000000000000000000000000' AS col_62527,
		  | 	'\xff':::BYTES AS col_62528,
		  | 	9.9:::DECIMAL AS col_62529,
		  | 	tab_20849.col1_13 AS col_62530,
		  | 	tab_20849.col1_2 AS col_62531,
		  | 	tab_20849.col1_16 AS col_62532,
		  | 	0:::OID AS col_62533,
		  | 	B'111110110001001101110110000101000010010' AS col_62534,
		  | 	'Infinity':::DECIMAL AS col_62535,
		  | 	tab_20849.col1_3 AS col_62536,
		  | 	tab_20849.col1_15 AS col_62537,
		  | 	tab_20849.col1_0 AS col_62538,
		  | 	tab_20849.col1_12 AS col_62539,
		  | 	(-5.228870704919736421E+28):::DECIMAL AS col_62540
		  | FROM
		  | 	defaultdb.public.table1@[0] AS tab_20849
		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

• roachtest.unoptimized-query-oracle/disable-rules=half failed due to extra precision decimals #86790 roachtest.unoptimized-query-oracle/disable-rules=half failed due to extra precision decimals [C-test-failure T-sql-queries]

This test on roachdash | Improve this report!

[DrewKimball]

The timeout should be fixed now, and the other failure looks like a dup of #86790