cockroachdb / cockroachdb/cockroach

roachtest: internal error: inner-join-apply RelExpr children have intersecting columns

Open
#155,681 11 comments 0 reactions 1 assignee Claimed by @DrewKimball View on GitHub
B-runtime-assertions-enabled branch-master C-test-failure O-roachtest O-robot O-rsg T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**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-tables [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/20621045?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/20621045?buildTab=artifacts#/unoptimized-query-oracle/disable-rules=half/rand-tables) on master @ [d3e894c7937e255e7472a0b5311b56d82ddd4f43](https://github.com/cockroachdb/cockroach/commits/d3e894c7937e255e7472a0b5311b56d82ddd4f43):

```
(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running unoptimized statement. 2264 statements run: pq: internal error: inner-join-apply RelExpr children have intersecting columns: (75)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- encrypted=false
- metamorphicWriteBuffering=true
- runtimeAssertionsBuild=true
- ssd=0
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md)

See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

See: [Grafana](https://go.crdb.dev/roachtest-grafana/teamcity-20621045/unoptimized-query-oracle-disable-rules-half-rand-tables/1760792558161/1760793297236)

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*unoptimized-query-oracle/disable-rules=half/rand-tables.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-55543

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.