cockroachdb / cockroachdb/cockroach

roachtest: unoptimized-query-oracle: "cannot overwrite" internal error

Open
#116,022 22 comments 2 reactions 1 assignee Claimed by @DrewKimball View on GitHub
branch-release-23.2 O-roachtest O-robot O-rsg O-support P-2 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/13074411?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/13074411?buildTab=artifacts#/unoptimized-query-oracle/disable-rules=half/rand-tables) on release-23.2 @ [43a2532550ca7abfc3c5682df31b0cc20da934b0](https://github.com/cockroachdb/cockroach/commits/43a2532550ca7abfc3c5682df31b0cc20da934b0):

```
(query_comparison_util.go:386).runOneRoundQueryComparison: internal error while running unoptimized statement. 1017 statements run: pq: internal error: cannot overwrite [] / (1.20981239e+19) with [limit hint: 3.00] / (1.20981239e+19)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1
```

Parameters: ROACHTEST_arch=amd64
, ROACHTEST_cloud=gce
, ROACHTEST_cpu=4
, ROACHTEST_encrypted=false
, ROACHTEST_metamorphicBuild=false
, ROACHTEST_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-13074411/unoptimized-query-oracle-disable-rules-half-rand-tables/1702300765566/1702302352154)

/cc @cockroachdb/sql-queries

[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/internal/issues)

Jira issue: CRDB-34386

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.