Ok, I probably have to take some words back: SQLite even documents the potential risk of corruption by using WAL & vacuum. http://www.sqlite.org/howtocorrupt.html
> Repeatedly switching an SQLite database in and out of WAL mode and > running the VACUUM command in between switches, in one process or > thread, can cause another process or thread that has the database file > open to miss the fact that the database has changed. That second process > or thread might then try to modify the database using a stale cache and > cause database corruption. > > This problem was discovered during internal testing and has never been > observed in the wild. The problem was fixed on 2011-01-27 and in version > 3.7.5. Though "never seen in the wild" sounds great, I'll probably have to check what we're using... Michael http://www.herger.net/slim-plugins - MusicArtistInfo, MusicInfoSCR, Smart Mix ------------------------------------------------------------------------ mherger's Profile: http://forums.slimdevices.com/member.php?userid=50 View this thread: http://forums.slimdevices.com/showthread.php?t=100277 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
