jezbo wrote: > Can anyone in the know tell me if SQLite still uses WAL journal mode? > My 7.7.2 definitely uses WAL and I suspect 7.8 also use it, if you get the *-shm and *-wal files in the Cache directory you know it's using WAL as far as I've understood.
jezbo wrote: > > I have a (muso) user running LMS 7.7.1 on ReadyNAS and SQLite throws > this error when Muso attempts to connect to the database: > Some kind of disk I/O error occurred > > The limited googling I've done on this error suggests it may be an issue > when journal_mode is set to DELETE, the default, but as far as I > understand it journal_mode=WAL persists so if LMS sets it, it should > stay set, right? > Does muso only read data ? Or does it write also ? I'm asking because I don't think writing from multiple processes are supported even with WAL, at least I had to modify my TrackStat code to ensure it doesn't perform writes while LMS is scanning to avoid issues. Do you get any information in the LMS server.log ? Or is it only in muso you get errors ? Does the user running muso process have write access to the database files ? I guess music is running on a standard computer accessing the NAS where LMS runs over samba, nfs or similar, in that case it's probably the access rights configured in samba/nfs that's of interest. I think write access might be required if WAL is activated so if the muso user only have read access that could maybe be the issue. You will find more information about WAL here http://www.sqlite.org/draft/wal.html but I suppose you have already found this page. ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=89450 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
