roachtest: sqlsmith/setup=tpcc/setting=ddl-nodrop failed

roachtest.sqlsmith/setup=tpcc/setting=ddl-nodrop [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_Roachtests_RoachtestNightlyGcePrivateBazel/21506130?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_Roachtests_RoachtestNightlyGcePrivateBazel/21506130?buildTab=artifacts#/sqlsmith/setup=tpcc/setting=ddl-nodrop) on master @ [f3d9dd8405adad545c70b300675fef9e5e12e0cb](https://github.com/cockroachdb/cockroach/commits/f3d9dd8405adad545c70b300675fef9e5e12e0cb):

Failed with:

```
(sqlsmith.go:137).func3: error: pq: no backup index found for /2025/10/09-185620.39; the backup may predate the supported restore window
statement:
RESTORE TABLE tpcc.* FROM LATEST IN 'gs://cockroach-fixtures-us-east1-crl-e2e-infra/workload/tpcc/version=25.3,fks=true,seed=1,warehouses=1?AUTH=implicit'
WITH into_db = 'defaultdb', unsafe_restore_incompatible_version;
test artifacts and logs in: /artifacts/sqlsmith/setup=tpcc/setting=ddl-nodrop/run_1
```
Cluster Node to Ip Mapping:
| Node | Public IP | Private IP |
| --- | --- | --- |
| teamcity-21506130-1788933294-05-n4cpu4-0001 | | 10.91.97.127 |
| teamcity-21506130-1788933294-05-n4cpu4-0002 | | 10.91.97.125 |
| teamcity-21506130-1788933294-05-n4cpu4-0003 | | 10.91.96.218 |
| teamcity-21506130-1788933294-05-n4cpu4-0004 | | 10.91.97.126 |

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- diskCount=0
- encrypted=false
- metamorphicDRPC=true
- metamorphicLeases=default
- 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-21506130/sqlsmith-setup-tpcc-setting-ddl-nodrop/1788950344077/1788950549355)

See: [Datadog Logs](https://us5.datadoghq.com/logs?query=service%3Aroachtest+%40cluster%3Ateamcity-21506130-1788933294-05-n4cpu4&from_ts=1788950344077&to_ts=1788950549355&live=false&storage=flex_tier)

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

Jira issue: CRDB-68085

Start with the failure at pkg/cmd/roachtest/sqlsmith.go:137, then inspect the linked test artifacts and logs for the RESTORE TABLE statement and backup fixture. Compare the failure with the roachtest README and determine why the tpcc ddl-nodrop run cannot find a backup index. Done means the test completes successfully against the fixture without this error.

Written by the indexing model from the issue text.