subject:"\[sqlite\] Magic self\-healing database\!"

Re: [sqlite] Magic self-healing database!

2017-02-22 Thread Richard Hipp

On 2/22/17, Ward WIllats wrote: > sqlite> pragma integrity_check; > *** in database main *** > On tree page 598 cell 2: Offset 65026 out of range 178..1020 > On tree page 598 cell 1: Offset 21743 out of range 178..1020 > > Then I SIGKILL'd my application and restarted it,

[sqlite] Magic self-healing database!

2017-02-21 Thread Ward WIllats

Hello List. Well, here's something I haven't seen before. I've got a DB in WAL mode on an embedded Linux system. My app (which has several threads, each with a connection, with Sqlite running fully serialized) was reporting database corruption in its logs. Sun Feb 19 07:52:45 2017 user.warn