cockroachdb / cockroachdb/cockroach

basalt-26.3: roachtest: import/basic/distmerge=false/nodes=4 failed

Open
#174,620 7 comments 0 reactions 0 assignees View on GitHub
basalt-green branch-basalt-26.3 C-test-failure O-roachtest O-robot release-blocker T-sql-foundations
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

roachtest.import/basic/distmerge=false/nodes=4 [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_Roachtests_GreenRoachtestNightlyGcePrivateBasaltBazel/21495809?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_Roachtests_GreenRoachtestNightlyGcePrivateBasaltBazel/21495809?buildTab=artifacts#/import/basic/distmerge=false/nodes=4) on basalt-26.3 @ [5ea90edd30305b19395123de8c1245c94cf163c6](https://github.com/cockroachdb/cockroach/commits/5ea90edd30305b19395123de8c1245c94cf163c6):

Failed with:

```
(test_runner.go:2737).func1: task ``task-2`` returned error: import tpch-parquet/lineitem: IMPORT INTO import_test.lineitem PARQUET DATA ('gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.1?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.2?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.3?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.4?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.5?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.6?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.7?AUTH=implicit', 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/tpch-parquet//sf-100/lineitem.parquet.8?AUTH=implicit'): pq: addsstable [/Table/106/3/17443686/107319751/2/0,/Table/106/3/17763093/107134883/1/0/NULL): batch timestamp 1788354616.276302086,0 must be after replica GC threshold 1788355327.008386650,0 (r125: /Table/106/3/17{443606/7010406/5-763127/468463970/4})
test artifacts and logs in: /artifacts/import/basic/distmerge=false/nodes=4/run_1
```
Cluster Node to Ip Mapping:
| Node | Public IP | Private IP |
| --- | --- | --- |
| teamcity-21495809-1788330657-32-n4cpu4-0001 | | 10.91.97.149 |
| teamcity-21495809-1788330657-32-n4cpu4-0002 | | 10.91.97.129 |
| teamcity-21495809-1788330657-32-n4cpu4-0003 | | 10.91.98.126 |
| teamcity-21495809-1788330657-32-n4cpu4-0004 | | 10.91.97.131 |

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- diskCount=0
- encrypted=true
- fs=ext4
- localSSD=true
- metamorphicLeases=default
- metamorphicWriteBuffering=true
- runtimeAssertionsBuild=false
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-21495809/import-basic-distmerge-false-nodes-4/1788331716905/1788370112833)

_Logs were not uploaded to Datadog_

/cc @cockroachlabs/sql-foundations

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*import/basic/distmerge=false/nodes=4.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Contributor guide

Open the contributing guide

Research direction

Start with the linked TeamCity log and artifacts at /artifacts/import/basic/distmerge=false/nodes=4/run_1, then review the Grafana dashboard and the roachtest README. Investigate the replica GC threshold error during the import/basic/distmerge=false/nodes=4 roachtest. Done means the reported roachtest no longer fails with this import error.

Written by the indexing model from the issue text.

Assessment

Tech stack
go
Domain
databases, distributed-systems, testing-qa
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.