Open avinassh opened 1 year ago
If the DB is never snapshotted (and only WAL frames are uploaded to S3), then while restoring integrity_check fails.
integrity_check
To reproduce: create a new database and insert a couple of rows. Try verify from bottomless, it fails with following message:
verify
Verification failed: *** in database main *** Tree 2 page 2: btreeInitPage() returns error code 11
I restored the db and inspected the db from shell, got the same error. All the data seems to be present though:
sqlite> PRAGMA integrity_check; *** in database main *** Page 2: btreeInitPage() returns error code 11 Error: stepping, database disk image is malformed (11)
The very first generation does not contain db.gz. I manually uploaded this from data.sqld and restore worked.
db.gz
data.sqld
internal slack discussion - https://chiselstrike.slack.com/archives/C05V2DRSS3U/p1697097311578049
If the DB is never snapshotted (and only WAL frames are uploaded to S3), then while restoring
integrity_checkfails.To reproduce: create a new database and insert a couple of rows. Try
verifyfrom bottomless, it fails with following message:I restored the db and inspected the db from shell, got the same error. All the data seems to be present though:
The very first generation does not contain
db.gz. I manually uploaded this fromdata.sqldand restore worked.internal slack discussion - https://chiselstrike.slack.com/archives/C05V2DRSS3U/p1697097311578049