roachtest: backup-restore/online-restore failed [relation: depends-on relation is dropped during DROP SCHEMA CASCADE]

[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 master @ e06215694b60bf35747034f5e376b911838b3b33:

Failed with:

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

Cluster Node to Ip Mapping:

Node	Public IP	Private IP
teamcity-20862236-1765783655-12-n4cpu4-0001	34.73.119.199	10.142.2.247
teamcity-20862236-1765783655-12-n4cpu4-0002	35.231.18.101	10.142.2.252
teamcity-20862236-1765783655-12-n4cpu4-0003	34.73.125.15	10.142.2.246
teamcity-20862236-1765783655-12-n4cpu4-0004	34.148.198.179	10.142.3.62

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• fs=ext4
• localSSD=true
• metamorphicWriteBuffering=true
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: backup-restore/online-restore failed #158255 roachtest: backup-restore/online-restore failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-25.4]
• roachtest: backup-restore/online-restore failed #157099 roachtest: backup-restore/online-restore failed [A-disaster-recovery B-runtime-assertions-enabled C-test-failure O-roachtest O-robot P-2 T-disaster-recovery branch-release-25.2.9-rc]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-57893

[rafiss]

{
 "workerId": 0,
 "clientTimestamp": "07:43:07.921647",
 "ops": [
  "BEGIN",
  {
   "sql": "DROP SCHEMA \"schema_w3_379\" CASCADE",
   "potentialExecErr": "0A000"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: internal error: executing declarative schema change StatementPhase stage 1 of 1 with 903 MutationType ops (rollback=false) for DROP SCHEMA: error executing StatementPhase stage 1 of 1 with 903 MutationType ops: relation \"table_w4_69\" (171): depends-on relation \"table_w1_701\" (395) is dropped (SQLSTATE XX000)",