cockroachdb / cockroachdb/cockroach

roachtest: restore/large-schema-100000-tables/gce/nodes=4/cpus=8 failed

Open
#173,738 3 comments 0 reactions 1 assignee Claimed by @andrew-r-thomas View on GitHub
A-disaster-recovery branch-master C-test-failure O-roachtest O-robot P-3 T-disaster-recovery
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

roachtest.restore/large-schema-100000-tables/gce/nodes=4/cpus=8 [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestWeeklyBazel/21478396?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestWeeklyBazel/21478396?buildTab=artifacts#/restore/large-schema-100000-tables/gce/nodes=4/cpus=8) on master @ [100fc3f842c1d0fcfd3e791ed1cb0e39aaf7b73d](https://github.com/cockroachdb/cockroach/commits/100fc3f842c1d0fcfd3e791ed1cb0e39aaf7b73d):

Failed with:

```
(monitor.go:329).Wait: monitor failure: pq: have retried transaction: system-restore-txn (id: 073ee09a-555b-4ba2-ab44-174620da105d) 101 times, most recently because of the retryable error: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh - unknown error: can't refresh txn spans; not valid): "system-restore-txn" meta={id=073ee09a key=/Table/79/2 iso=Serializable pri=0.12827637 epo=100 ts=1787406660.980755878,2 min=1787405736.035356263,0 seq=246030} lock=true stat=PENDING rts=1787406652.113885699,0 gul=1787405736.535356263,0 obs={n1@1787405736.035356263,0 n2@1787405736.086804347,0 n3@1787405776.673717852,0 n4@1787405736.035966711,0}. Terminating retry loop and returning error due to max retry limit (100). Rollback error: .
test artifacts and logs in: /artifacts/restore/large-schema-100000-tables/gce/nodes=4/cpus=8/run_1
```
Cluster Node to Ip Mapping:
| Node | Public IP | Private IP |
| --- | --- | --- |
| teamcity-21478396-1787378515-96-n4cpu8-0001 | | 10.91.98.79 |
| teamcity-21478396-1787378515-96-n4cpu8-0002 | | 10.91.98.82 |
| teamcity-21478396-1787378515-96-n4cpu8-0003 | | 10.91.98.78 |
| teamcity-21478396-1787378515-96-n4cpu8-0004 | | 10.91.98.80 |

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=8
- diskCount=0
- encrypted=false
- fs=ext4
- localSSD=false
- 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-21478396/restore-large-schema-100000-tables-gce-nodes-4-cpus-8/1787405350186/1787406943584)

See: [Datadog Logs](https://us5.datadoghq.com/logs?query=service%3Aroachtest+%40cluster%3Ateamcity-21478396-1787378515-96-n4cpu8&from_ts=1787405350186&to_ts=1787406943584&live=false&storage=flex_tier)

/cc @cockroachlabs/disaster-recovery

[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-67044

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.