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

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

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

(query_comparison_util.go:421).runOneRoundQueryComparison: internal error while running unoptimized statement. 111 statements run: pq: internal error: inner-join-apply RelExpr children have intersecting columns: (19)
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=true
• 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-42751

[mgartner]

Duplicate of #129956.