cockroachdb / cockroachdb/cockroach

roachtest: unoptimized-query-oracle: lookup paired-join is paired with *memo.ValuesExpr

Open
#144,744 5 comments 0 reactions 0 assignees View on GitHub
B-runtime-assertions-enabled branch-release-24.3 C-test-failure O-roachtest O-robot O-rsg P-3 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/seed-multi-region [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/19476685?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/19476685?buildTab=artifacts#/unoptimized-query-oracle/disable-rules=half/seed-multi-region) on release-24.3 @ [b92d70279b544d3111ee9ad0596646153d929574](https://github.com/cockroachdb/cockroach/commits/b92d70279b544d3111ee9ad0596646153d929574):

```
(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 364 statements run: pq: internal error: lookup paired-join is paired with *memo.ValuesExpr
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/seed-multi-region/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- encrypted=false
- 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-19476685/unoptimized-query-oracle-disable-rules-half-seed-multi-region/1745142985507/1745144186460)

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

Jira issue: CRDB-49517

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.