Skip to content
This repository has been archived by the owner on Oct 18, 2023. It is now read-only.

bug: bottomless restore fails with the very first generation #766

Open
avinassh opened this issue Oct 12, 2023 · 0 comments
Open

bug: bottomless restore fails with the very first generation #766

avinassh opened this issue Oct 12, 2023 · 0 comments

Comments

@avinassh
Copy link
Member

If the DB is never snapshotted (and only WAL frames are uploaded to S3), then while restoring integrity_check fails.

To reproduce: create a new database and insert a couple of rows. Try verify from bottomless, it fails with following message:

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.

internal slack discussion - https://chiselstrike.slack.com/archives/C05V2DRSS3U/p1697097311578049

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant