On Tue, Jul 24, 2018 at 1:47 PM Simon Slavin <slav...@bigfraud.org> wrote:
> On 24 Jul 2018, at 8:43pm, J Decker <d3c...@gmail.com> wrote: > > > I have a database that got corrupted; was working on implementing > automatic > > recovery.... > > It would be a million times better to figure out how the corruption occurs > and prevent it. > Well...I've been considering that. that database is written to when the window moves (so I restore the position); and during startup. It's just a database for program options, which are loaded at the start, created if they don't exist, given defaults, and can be updated during startup with a script that gets loaded. If the system rebooted; did a screen size change, and terminated the program, it's possible it coild cause corruption. On tree page 41 cell 37: Rowid 45783 out of order ... 37 to 0 On tree page 41 cell 0: Rowid 45787 out of order On tree page 6 cell 166: Rowid 45787 out of order On tree page 42 cell 40: Rowid 45787 out of order ... 40-0 On tree page 42 cell 0: Rowid 45787 out of order On tree page 6 cell 165: Rowid 45787 out > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
