On Tue, Jul 24, 2018 at 1:47 PM Simon Slavin <[email protected]> wrote:
> On 24 Jul 2018, at 8:43pm, J Decker <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
