mherger wrote: > 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 > > Edit: we are using 3.7.8, which should not have this issue. What about > the client you were using?
Hi Michael, since this is my standalone lms only Server - after i remember that "bug" i removed it. So i cant tell the "old" version, but i am a "apt-get update && apt-get update" guy, cause computers are my daily buisiness. ok i did give them a try and reinstall sqlite3just a "demo" before i do something special. > root@muzzigbox:/var/lib/squeezeboxserver/cache# sqlite3 --version > 3.7.9 2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e Note - there is no artwork.db-shm or artwork.db-wal but a cache.db imgproxy.db library.db and persist.db have a -shm and -wal that even "normal" (on my box) > > root@muzzigbox:/var/lib/squeezeboxserver/cache# ls -l *db* > insgesamt 436664 > -rw-r--r-- 1 squeezeboxserver nogroup 320818176 Nov 1 05:00 artwork.db > -rw-r--r-- 1 squeezeboxserver nogroup 847872 Nov 1 07:45 cache.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 07:45 > cache.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 149896 Nov 1 07:45 > cache.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 3072 Okt 21 20:13 > imgproxy.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 07:45 > imgproxy.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 0 Nov 1 07:45 > imgproxy.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 93164544 Nov 1 05:00 library.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 07:45 > library.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 0 Nov 1 07:45 > library.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 31816704 Nov 1 05:00 persist.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 08:19 > persist.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 20992 Nov 1 08:19 > persist.db-wal > Now i do a vacuum > root@muzzigbox:/var/lib/squeezeboxserver/cache# service > logitechmediaserver stopStopping Logitech Media Server. > root@muzzigbox:/var/lib/squeezeboxserver/cache# sqlite3 artwork.db > "vacuum"; > root@muzzigbox:/var/lib/squeezeboxserver/cache# ls -l *.db* > insgesamt 264132 > -rw-r--r-- 1 squeezeboxserver nogroup 144398336 Nov 1 19:07 artwork.db > -rw-r--r-- 1 squeezeboxserver nogroup 847872 Nov 1 19:04 cache.db > -rw-r--r-- 1 squeezeboxserver nogroup 3072 Okt 21 20:13 > imgproxy.db > -rw-r--r-- 1 squeezeboxserver nogroup 93164544 Nov 1 05:00 library.db > -rw-r--r-- 1 squeezeboxserver nogroup 31816704 Nov 1 19:04 persist.db > root@muzzigbox:/var/lib/squeezeboxserver/cache# > Note the -shm and -wal are gone (i only vacuum artwork.db) > root@muzzigbox:/var/lib/squeezeboxserver/cache# service > logitechmediaserver start > Making sure that Logitech Media Server is not running first: > start-stop-daemon: warning: failed to kill 27677: No such process > No process in pidfile '/var/run/logitechmediaserver.pid' found running; > none killed. > Starting Logitech Media Server. > And now big surprise - it really seems ok? Strange but thanks for asking me back. After browsing in lms and put some tracks to the playersplaylist i do another: > root@muzzigbox:/var/lib/squeezeboxserver/cache# ls -l *.db* > -rw-r--r-- 1 squeezeboxserver nogroup 144517120 Nov 1 19:15 artwork.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 19:27 > artwork.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 14704 Nov 1 19:27 > artwork.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 847872 Nov 1 19:15 cache.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 19:15 > cache.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 0 Nov 1 19:15 > cache.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 3072 Okt 21 20:13 > imgproxy.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 19:15 > imgproxy.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 0 Nov 1 19:15 > imgproxy.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 93164544 Nov 1 05:00 library.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 19:15 > library.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 0 Nov 1 19:15 > library.db-wal > -rw-r--r-- 1 squeezeboxserver nogroup 31816704 Nov 1 19:04 persist.db > -rw-r--r-- 1 squeezeboxserver nogroup 32768 Nov 1 19:15 > persist.db-shm > -rw-r--r-- 1 squeezeboxserver nogroup 0 Nov 1 19:15 > persist.db-wal > root@muzzigbox:/var/lib/squeezeboxserver/cache# > surprose surprise the artwork.db gots an .shm and .wal file? btw. i didnt do rescans i always clean and wipe. Does anyone have this "feature" with the artwork.db-* files as well? Gruss Jan ------------------------------------------------------------------------ DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=100277 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
