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

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=half/rand-multi-region failed with artifacts on release-24.2 @ fe9c8f89f85e28a1b4dd4bd0bff925198b887eb3:

  		... // 3452 identical bytes
  	}, ""),
  	strings.Join({
- 		"11111111111111111",
  		``1,-,NULL,a	,01030000A0E6100000010000000D0000002DB0DCD6399E56C0A0``,
  		"DF9FB3B9912FC07788EDEF763D00C27FE9856D367B66C092DBF535E73151C03E",
  		... // 3453 identical bytes
  	}, ""),
  	strings.Join({
- 		"11111111111111111",
  		``1,-,NULL,a	,01030000A0E6100000010000000D0000002DB0DCD6399E56C0A0``,
  		"DF9FB3B9912FC07788EDEF763D00C27FE9856D367B66C092DBF535E73151C03E",
  		... // 3453 identical bytes
  	}, ""),
  	strings.Join({
- 		"11111111111111111",
  		``1,-,NULL,a	,01030000A0E6100000010000000D0000002DB0DCD6399E56C0A0``,
  		"DF9FB3B9912FC07788EDEF763D00C27FE9856D367B66C092DBF535E73151C03E",
  		... // 3453 identical bytes
  	}, ""),
  	strings.Join({
- 		"11111111111111111",
  		"1,-,g\x1aq&^wx\"\x15,a\t,01030000A0E6100000010000000D0000002DB0DCD6399E5",
  		"6C0A0DF9FB3B9912FC07788EDEF763D00C27FE9856D367B66C092DBF535E7315",
  		... // 3458 identical bytes
  	}, ""),
  	"NULL,-,!3x\bf\x1c1\x02,a\t,01030000A0E6100000010000000D0000002DB0DCD6399"...,
  	``NULL,-,,a	,01030000A0E6100000010000000D0000002DB0DCD6399E56C0A0D``...,
  	... // 5 identical elements
  }
sql: SELECT
	COALESCE(tab_406.col3_5, tab_406.col3_5) AS col_1095,
	tab_406."%pcol3_3" AS col_1096,
	tab_406."col|3_9" AS col_1097,
	e'a\t':::REFCURSOR AS col_1098,
	'01030000A0E6100000010000000D0000002DB0DCD6399E56C0A0DF9FB3B9912FC07788EDEF763D00C27FE9856D367B66C092DBF535E73151C03E1B61DD32EAF9C180A638AB0F5C44C03F18655C5B304BC046BF80D8ACB4F7414815DAABC6B7354029AF509DEA2F4AC02CB9A3974795F3C1B0B29F8EC3622E40086AE916D84329C0A870D07517EDFB41E459210C8A934940781C513B3BAA2040D64AE0D1AB20004228D1890AF98261408025F9C12B8E47409065E019936DC5C1162F8A390B1150405C5C3C6694205440283FAFF51C89FE410073FCBD45A61DC05C24BFBA5EAD4C402E0E8F32B341FCC1E83949381CFD43C0B8D6C04902E6524090D265EECFBCD4C1493FB0CECF2457C0606475C5367A39401A954C036B390042E24C33D37EBF62C028A90D4CCD8E2B404437FAC02EF2F3C12DB0DCD6399E56C0A0DF9FB3B9912FC07788EDEF763D00C2':::GEOGRAPHY
		AS col_1099,
	tab_406.tableoid AS col_1100,
	e'LF-p/\x02':::STRING AS col_1101,
	'\x58':::BYTES AS col_1102,
	tab_406.col3_6 AS col_1103,
	tab_406.col3_2 AS col_1104,
	']G:rG,6*':::STRING AS col_1105,
	B'000000000000000000' AS col_1106,
	e'\u00C01                \u00E0\n':::STRING AS col_1107
FROM
	defaultdb.public."tabl-e_3" AS tab_406
ORDER BY
	tab_406."%pcol3_3" DESC
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-multi-region/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_coverageBuild=false
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_fs=ext4
• ROACHTEST_localSSD=true
• ROACHTEST_runtimeAssertionsBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: unoptimized-query-oracle/disable-rules=half/rand-multi-region failed [BIT(0) type needed for distSQL] #131346 roachtest: unoptimized-query-oracle/disable-rules=half/rand-multi-region failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-master release-blocker]

This test on roachdash | Improve this report!

Jira issue: CRDB-43259

[mgartner]

Duplicate of #131346.