cockroachdb / cockroachdb/cockroach
release-26.2: roachtest: sqlsmith/setup=tpcc/setting=no-mutations 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.sqlsmith/setup=tpcc/setting=no-mutations [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_Roachtests_RoachtestNightlyGcePrivateBazel/21489899?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_Roachtests_RoachtestNightlyGcePrivateBazel/21489899?buildTab=artifacts#/sqlsmith/setup=tpcc/setting=no-mutations) on release-26.2 @ [1aa4539d39403cfc1db53e71ff9a040bc584d5cc](https://github.com/cockroachdb/cockroach/commits/1aa4539d39403cfc1db53e71ff9a040bc584d5cc):
Failed with:
```
(sqlsmith.go:241).func3: error: pq: internal error: the first bucket should have DistinctRange=0
stmt:
SELECT
NULL AS col_1269
FROM
defaultdb.public.warehouse AS tab_589
JOIN defaultdb.public.item AS tab_590 ON (tab_589.w_id) = (tab_590.i_id)
JOIN defaultdb.public."order" AS tab_591 ON
(tab_589.w_id) = (tab_591.o_id) AND (tab_589.w_id) = (tab_591.o_d_id) AND (tab_589.w_id) = (tab_591.o_c_id)
ORDER BY
tab_591.o_c_id DESC NULLS LAST;
test artifacts and logs in: /artifacts/sqlsmith/setup=tpcc/setting=no-mutations/run_1
```
Cluster Node to Ip Mapping:
| Node | Public IP | Private IP |
| --- | --- | --- |
| teamcity-21489899-1787895964-36-n4cpu4-0001 | | 10.91.96.113 |
| teamcity-21489899-1787895964-36-n4cpu4-0002 | | 10.91.96.114 |
| teamcity-21489899-1787895964-36-n4cpu4-0003 | | 10.91.97.24 |
| teamcity-21489899-1787895964-36-n4cpu4-0004 | | 10.91.97.167 |
Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- diskCount=0
- encrypted=false
- fs=ext4
- localSSD=true
- metamorphicLeases=default
- 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-21489899/sqlsmith-setup-tpcc-setting-no-mutations/1787898185065/1787898488941)
[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*sqlsmith/setup=tpcc/setting=no-mutations.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)
Jira issue: CRDB-67475
Contributor guide
Research direction
Start with pkg/cmd/roachtest/README.md, the failure at sqlsmith.go:241, and the artifacts and logs for run_1. Inspect the reported SQL statement and the internal error about DistinctRange, then determine how to reproduce the assertion-enabled failure. Done means the underlying failure is fixed and the sqlsmith/setup=tpcc/setting=no-mutations roachtest passes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, testing-qa
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100