Bugzilla – Bug 3661
Scanner only loads music that is referenced in playlists
Last modified: 2008-09-15 14:39:24 UTC
I recreated my MySQL DB. Upon restarting slimserver SVN (currently 8211), I noticed that I only had a handfull of songs in my DB. Slimserver scanned my music and playlist dirs, but only loaded files that are referenced from the playlists. My logfile contained: 2006-06-29 09:23:58.5336 About to look for files in M:\Music\SlimServer Music 2006-06-29 09:23:58.5348 For files with extensions in: [(?i-xsm:\.(?:ape|wma|shn|wav|wave|mp3|mp2|flc|flac|m4a|mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|cue)$)] 2006-06-29 09:23:58.5456 About to look for files in M:\Music\SlimServer Playlists 2006-06-29 09:23:58.5469 For files with extensions in: [(?i-xsm:\.(?:asf|wax|asx|lnk|wpl|m3u|pls|xspf|cue)$)] 2006-06-29 09:23:58.5525 Found 6 files in M:\Music\SlimServer Playlists 2006-06-29 09:23:58.6407 Slim::Formats::Playlists::M3U::read: WARNING: file:///M:/Music/SlimServer%20Playlists/rtsp:/helix.muhlenberg.edu:554/broadcast/live.rm found in playlist: file:///M:/Music/SlimServer%20Playlists/Afterglow.m3u doesn't exist on disk - skipping! 2006-06-29 09:24:02.8281 Slim::Formats::Playlists::M3U::read: WARNING: file:///M:/Music/SlimServer%20Playlists/rtsp:/rmv8.bbc.net.uk/6music/roundtable.ra found in playlist: file:///M:/Music/SlimServer%20Playlists/BBC%20Roundtable.m3u doesn't exist on disk - skipping! 2006-06-29 09:24:06.6250 Slim::Formats::Playlists::M3U::read: WARNING: file:///M:/Music/SlimServer%20Playlists/rtsp:/helix.muhlenberg.edu:554/broadcast/live.rm found in playlist: file:///M:/Music/SlimServer%20Playlists/Radio%20Stations.m3u doesn't exist on disk - skipping!
odd, considering this section of log shows the server as unable to find the files referenced by a playlist. It doesn't appear to be scanning those tracks at all. running r8200 at home, this morning's scan seems to have all tracks.
Phil - what do you mean by "Recreated"? Are you using the internal copy of MySQL? Everything is working fine for me on Windows.. did anything else change in your config? Thanks
I am using my own MySQL instance. To make sure I had the latest database schema, I dropped the database and recreated it, the same way I have been doing it for a few weeks. I use a script: drop database slimserver; create database slimserver character set utf8; grant all on slimserver.* to slim identified by '**********'; I am not sure that I needed to drop and recreate (I don't think users should need to), but first time the schema definition changed columns to Text, the change wasn't made to my instance.
I just tried removing the dbsource line from my prefs file to make slimserver use its own instance, but I still have the same scanning effect. BTW, I notice that I get a lot of extra SQL trace in the log when running with the internal instance, even though I don't have any debug switches on.
Another observation: after stopping slimserver using an internal instance of MySQL, I noticed that the internal instance of MySQL was still running. I couldn't delete the content of the Cache folder. Shouldn't the instance stop if slimserver is stopped?
Fixed in change 8227