roachtest: tlp failed

[cockroach-teamcity]

roachtest.tlp failed with artifacts on release-22.1.0 @ 3abc7eeade10df4b59b0fb24236992f95bf46d9b:

	tlp.go:172,tlp.go:76,test_runner.go:875: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:245
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:270
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	... // 2 identical elements
		  |   	``",-87.26961636053824804,NULL``,
		  |   	"#,573449930506.938828,xx%R(\x0f",
		  | - 	"$,-813395758359754084.0,NULL",
		  | + 	"$,-813395758359754084,NULL",
		  |   	"1,885104586358297639000000001,038wVhC7",
		  |   	"<,2,NULL",
		  | - 	">,1653558821366873528.0000000000,NULL",
		  | + 	">,1.65355882845990308E+18,NULL",
		  | - 	">,1653558821521291788.0000000000,NULL",
		  | + 	">,1653558821366873528,NULL",
		  | - 	">,1653558828459903080.0000000000,NULL",
		  | + 	">,1653558821521291788,NULL",
		  | - 	">,1653558829674116661.0000000000,NULL",
		  | + 	">,1653558829674116661,NULL",
		  | - 	">,1653558830264864043.0000000000,NULL",
		  | + 	">,1653558830264864043,NULL",
		  | - 	">,1653558832701828942.0000000000,NULL",
		  | + 	">,1653558832701828942,NULL",
		  | - 	">,1653558835258162036.0000000000,NULL",
		  | + 	">,1653558835258162036,NULL",
		  | - 	">,1653558836732205953.0000000000,NULL",
		  | + 	">,1653558836732205953,NULL",
		  |   	"C,-19770.00405777114979,NULL",
		  | - 	"E,1653558832416455503.0000000000,E",
		  | + 	"E,1653558832416455503,E",
		  |   	"X,-25949007741543276099999999999999,",
		  |   	"^,-4786811.185189746818,Lfpz\rs&\x05",
		  | - 	"^,1653558830710384026.0000000000,^",
		  | + 	"^,1653558830710384026,^",
		  | - 	"^,1653558837190223338.0000000000,^",
		  | + 	"^,1653558837190223338,^",
		  |   	"c,452934882191671351.7,Y\x03o\v!9eYM",
		  |   	"p,7509603482499.300049,\x0fd=2nN",
		  |   }
		  | sql: SELECT DISTINCT tab_36199.col1_8,tab_36199.col1_11,tab_36199.col1_10 FROM defaultdb.public.table1 AS tab_36199
		  | (SELECT DISTINCT tab_36199.col1_8,tab_36199.col1_11,tab_36199.col1_10 FROM defaultdb.public.table1 AS tab_36199 WHERE tab_36199.col1_4) UNION (SELECT DISTINCT tab_36199.col1_8,tab_36199.col1_11,tab_36199.col1_10 FROM defaultdb.public.table1 AS tab_36199 WHERE NOT (tab_36199.col1_4)) UNION (SELECT DISTINCT tab_36199.col1_8,tab_36199.col1_11,tab_36199.col1_10 FROM defaultdb.public.table1 AS tab_36199 WHERE (tab_36199.col1_4) IS NULL)
		  | with args: []
		Error types: (1) *withstack.withStack (2) *errutil.leafError

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

• roachtest: tlp failed #80047 roachtest: tlp failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-22.1]

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-16109

[rharding6373]

Decimal comparisons in TLP is not a release blocker.

[mgartner]

I think we just need to backport #79551 to release-22.1.0, or stop running nightlies on that branch. I've created the backport: #82135. I'll await confirmation about the future of nightlies on this branch before merging.

[mgartner]

Nightlies for release-22.1.0 have been disabled, so this failure should no longer occur. Closing.