cardano-db-sync icon indicating copy to clipboard operation
cardano-db-sync copied to clipboard

pg_restore: error: could not open input file "/tmp/db-sync-snapshot-5HgA9eEGTS/db//toc.dat"

Open tedbear2012 opened this issue 2 months ago • 2 comments

OS Ubuntu 24.04.2 LTS (docker)

Versions The db-sync version (eg cardano-db-sync --version): ghcr.io/intersectmbo/cardano-db-sync:13.6.0.5 PostgreSQL version: docker postgres:17.2-alpine

Build/Install Method The method you use to build or install cardano-db-sync:

Run method The method you used to run cardano-db-sync (eg Nix/Docker/systemd/none): docker run \ --rm \ --name wwt-cardano-db-sync \ --network shared-network \ --env NETWORK=mainnet \ --env POSTGRES_DB=cexplorer \ --env POSTGRES_HOST=wwt-cardano-node-postgres \ --env POSTGRES_USER=postgres \ --env POSTGRES_PASSWORD=<POSTGRES_PASSWORD> \ --env POSTGRES_PORT=5432 \ --env RESTORE_RECREATE_DB=N \ --env RESTORE_SNAPSHOT=/data/db-sync-snapshot-schema-13.6-block-12399050-x86_64.tgz \ --volume wwt-cardano-node-postgres-data:/var/lib/cexplorer \ --volume $(pwd):/data \ --volume wwt-cardano-node-ipc:/node-ipc \ ghcr.io/intersectmbo/cardano-db-sync:13.6.0.5

Problem Report Error for db-sync-snapshot-schema-13.6-block-12399050-x86_64.tgz

db/4232.dat.gz pg_restore: error: could not open input file "/tmp/db-sync-snapshot-5HgA9eEGTS/db//toc.dat": No such file or directory

tedbear2012 avatar Sep 22 '25 06:09 tedbear2012

Does the downloaded snapshot match it's expected sha256? Actually not sure what's the best way to test this through docker, maybe @sgillespie knows?

kderme avatar Sep 29 '25 14:09 kderme

@kderme - Docker's restore snapshot function was broken at 13.6.0.5, it is fixed on main but we dont have a tag since

rdlrt avatar Sep 29 '25 15:09 rdlrt