On 4 Jun 2018, at 11:21pm, Rael Bauer <supp...@bauerapps.com> wrote: > On tree page 51 cell 1: invalid page number 302055426
Erm ... I don't know your pagesize and page count, but that looks like an incorrectly high page number to me. If you have checked that your recovery method does recover all the data you'd expect to see, then perhaps you can continue with a modified version of your pipe. In the middle of the pipe, you could insert a program (or a utility) which replaces the ROLLBACK with a COMMIT. As an alternative you could try VACUUM. This needs testing so, on a testing copy ... 1) Do the integrity check which shows the sort of errors you posted. 2) Execute VACUUM 3) Do another integrity check It might or might not get rid of the corruption. if it works you can modify your recovery procedure accordingly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users