One of our document files has become corrupt. It continues to work fine, but it can no longer be duplicated or downloaded/imported without an integrity error.
I’ve opened the document with DB Browser and can see the errors using PRAGMA integrity check. Running VACUUM fixes some of the errors, but there is a long list of errors like:
On tree page 100720 cell 368: Rowid 4022 out of order
On tree page 100720 cell 367: Rowid 4034 out of order
…
I’ve tried rebuilding the database by exporting to SQL and reimporting. When I import the resulting database into grist, every table has “keyerror” for each of the columns and no data is shown.
- Is there a recommended way to fix the rowid errors?
- Is there a way to rebuild a grist sqlite document such that it can import successfully?