Re: [sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread Simon Slavin
On 4 Jun 2018, at 11:21pm, Rael Bauer 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 expe

Re: [sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread Rael Bauer
@david: I am not corrupting the database myself. Users of my application have sent in corrupted databases (on very rare occassion). I do not have permission to send you corrupted database at this time. I can tell you the following: This problem starts with v3.18. It works ok with v3.17 Databa

Re: [sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread David Raymond
users-boun...@mailinglists.sqlite.org] On Behalf Of Rael Bauer Sent: Monday, June 04, 2018 1:33 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Repair corrupt database results in 0KB file @Simon: I did not mention any sqlite3.dll. I am only talking about sqlite3.exe command line tool. T

Re: [sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread Simon Slavin
On 4 Jun 2018, at 6:32pm, Rael Bauer wrote: > The last line in the dump using the latest version (3.23.1) is: > > ROLLBACK; -- due to errors Then there are errors, and the data in your database may be corrupt, and the information you're getting from it can be wrong. Use the command-line tool

Re: [sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread Rael Bauer
@Simon: I did not mention any sqlite3.dll. I am only talking about sqlite3.exe command line tool. The problem occurs using the command line. Yes, I tried your idea. The last line in the dump using the old version is: COMMIT; The last line in the dump using the latest version (3.23.1) is: ROL

Re: [sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread Simon Slavin
On 4 Jun 2018, at 6:00pm, Rael Bauer wrote: > Now I updated to the latest version (3.23.1), Which did you update ? The command-line tool you call as sqlite3, or the library used in the program which uses the database file ? Or both ? > and using the above method results in a 0 KB file. Brea

[sqlite] Repair corrupt database results in 0KB file

2018-06-04 Thread Rael Bauer
Hello, I having been using the following method to repair corrupt databases using sqlite3.exe: Simply call: sqlite3 mydata.db ".dump" | sqlite3 new.db (source: https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database) I have been using an old version of sqlite3