roachtest: backup-restore/online-restore failed

[cockroach-teamcity]

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.backup-restore/online-restore failed with artifacts on release-25.1 @ 9893597b3d339f77fbcb6c59e9881c86cb384396:

(monitor.go:149).Wait: monitor failure: schema change workload failed: full command output in run_074416.609815889_n4_COCKROACHRANDOMSEED4.log: COMMAND_PROBLEM: exit status 1 [owner=sql-foundations]
test artifacts and logs in: /artifacts/backup-restore/online-restore/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-47236

[rafiss]

This is a testing/workload bug

{
 "workerId": 4,
 "clientTimestamp": "07:44:51.801559",
 "ops": [
  "BEGIN",
  {
   "sql": "ALTER TABLE public.table_w0_1 ADD CONSTRAINT \"table_w0_1_col_w0_1_w4_1_unique\" UNIQUE (col_w0_1_w4_1)"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "23505",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: failed to ingest index entries during backfill: duplicate key value violates unique constraint \"table_w0_1_col_w0_1_w4_1_unique\" (SQLSTATE 23505)",
 "errorState": {
  "expectedCommitErrors": [
   "23505"
  ],

[rafiss]

fixed by #140598