cockroachdb / cockroachdb/cockroach

release-26.2: roachtest: sqlsmith/setup=tpcc/setting=no-mutations failed

Open
#174,174 2 comments 0 reactions 0 assignees View on GitHub
B-runtime-assertions-enabled branch-release-26.2 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.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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.