cockroachdb / cockroachdb/cockroach
roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed
- 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_RoachtestNightlyAzureBazel/21513552?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyAzureBazel/21513552?buildTab=artifacts#/unoptimized-query-oracle/disable-rules=half/rand-tables) on master @ [2bf53f5e2960d67b69a8d3576c03e3e9fc3dae2a](https://github.com/cockroachdb/cockroach/commits/2bf53f5e2960d67b69a8d3576c03e3e9fc3dae2a):
Failed with:
```
(query_comparison_util.go:501).runOneRoundQueryComparison: failed to set random seed. 1942 statements run: dial tcp 74.235.138.186:26257: connect: connection refused
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1
```
Cluster Node to Ip Mapping:
| Node | Public IP | Private IP |
| --- | --- | --- |
| teamcity-21513552-1789192537-52-n1cpu4-0001 | 74.235.138.186 | 10.1.0.13 |
Parameters:
- arch=amd64
- cloud=azure
- coverageBuild=false
- cpu=4
- diskCount=0
- encrypted=false
- metamorphicWriteBuffering=true
- runtimeAssertionsBuild=true
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-21513552/unoptimized-query-oracle-disable-rules-half-rand-tables/1789198197935/1789199347221)
See: [Datadog Logs](https://us5.datadoghq.com/logs?query=service%3Aroachtest+%40cluster%3Ateamcity-21513552-1789192537-52-n1cpu4&from_ts=1789198197935&to_ts=1789199347221&live=false&storage=flex_tier)
Same failure on other branches
- #166802 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-25.2]
[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)
Jira issue: CRDB-68299
Contributor guide
Research direction
Start at query_comparison_util.go:501 and inspect the roachtest README for how unoptimized-query-oracle runs. Review the linked build artifacts, logs, Grafana, and Datadog data around the connection-refused error after 1,942 statements. Done means identifying the cause of the node disconnect or failed seed setup, addressing it, and confirming the roachtest passes on rerun.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, distributed-systems, testing
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100