Bugzilla – Bug 12523
Scanner completely fails
Last modified: 2009-10-05 14:29:16 UTC
Current on r27225, but have had this issue for the last few nighties this week - the scanner bombs out after a few of seconds, and sometimes seems like it does not even start, leaving me with a completely empty library. I have performed a complete fresh uninstall and reinstall, any folders left where manually deleted. After installing, the ONLY thing i have done is to set the path to my music. My library is a mix of mp3/flac/wma/ogg, but i have also tried scanning a folder of just MP3's and that failed too. Scanner.log... [09-06-24 14:15:47.7504] main::main (243) Removing artwork cache... [09-06-24 14:15:47.7537] Slim::Music::Import::runImporter (466) Starting Slim::Music::MusicFolderScan scan [09-06-24 14:15:56.2467] Slim::Utils::Scanner::scanDirectory (315) Found 5941 files in C:\Users\Dom\Music\MP3 [09-06-24 14:15:56.2480] Slim::Utils::Scanner::scanDirectory (328) Scanning: C:\Users\Dom\Music\MP3\2 Many DJ's - Hang All DJ's - Volume 1\01 - 2 Many DJ's - Intro.mp3 [09-06-24 14:15:56.3863] Slim::Schema::Storage::throw_exception (87) Error: DBI Exception: DBD::SQLite::st execute failed: database disk image is malformed [for Statement "SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id WHERE ( ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) ) GROUP BY me.id"] [09-06-24 14:15:56.3871] Slim::Schema::Storage::throw_exception (87) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 87) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 722) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 979) frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 415) frame 4: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 408) frame 5: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 989) frame 6: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1201) frame 7: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1403) frame 8: DBIx::Class::Storage::DBI::select_single (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 739) frame 9: DBIx::Class::ResultSet::single (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2622) frame 10: Slim::Schema::_postCheckAttributes (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1160) frame 11: Slim::Schema::newTrack (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 342) frame 12: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79) frame 13: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 468) frame 14: Slim::Music::Import::runImporter (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 284) frame 15: Slim::Music::Import::runScan (scanner.pl line 277) frame 16: (eval) (scanner.pl line 271) frame 17: main::main (scanner.pl line 503) [09-06-24 14:15:56.3879] Slim::Schema::Storage::throw_exception (87) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::st execute failed: database disk image is malformed [for Statement "SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id WHERE ( ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) ) GROUP BY me.id"] at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 91 [09-06-24 14:15:56.3884] Slim::Schema::Storage::throw_exception (87) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 87) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 429) frame 2: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 989) frame 3: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1201) frame 4: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1403) frame 5: DBIx::Class::Storage::DBI::select_single (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 739) frame 6: DBIx::Class::ResultSet::single (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2622) frame 7: Slim::Schema::_postCheckAttributes (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1160) frame 8: Slim::Schema::newTrack (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 342) frame 9: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79) frame 10: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 468) frame 11: Slim::Music::Import::runImporter (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 284) frame 12: Slim::Music::Import::runScan (scanner.pl line 277) frame 13: (eval) (scanner.pl line 271) frame 14: main::main (scanner.pl line 503) [09-06-24 14:15:56.3908] main::main (283) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::st execute failed: database disk image is malformed [for Statement "SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON tracks.album = me.id WHERE ( ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) ) GROUP BY me.id"] at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 91 ] [09-06-24 14:15:56.3912] main::main (284) Error: Skipping post-process & Not updating lastRescanTime!
Looks as if the db file was corrupt. Andy - could we detect such a failure and remove the file?
Just want to add that i thought it looked like a corrupt DB, but i have tried removing the cache/DB files manually with no success. I have do about 20 complete fresh reinstalls with various nighties from the last week or so. Every time i uninstalled SS, i also manually deleted the cache and prefs folder if they had not been removed my the uninstall routine - I completely purged my system of anything SB related.
You get that malformed error every time you scan?
(In reply to comment #3) > You get that malformed error every time you scan? Yes, every time. After a "look for new music", "Clear and rescan" and following the removal of the cache folder. Did a complete fresh install this morning (deleted absolutely every SB related file and folder) with the latest nightly and still get the same. SS wont start now either. Server.log also says something about a malformed DB. Should I start a separate bug...?
Just to add, i am now on 27265 and the scanner does not even appear to start at all. There is no scanner.log in the logs folder either, is not being generated.
As of r27307, the scanner is working for me (bar a few glitches). Feel free to close (or should i?). Many thanks for your work on this.
This bug has been marked as fixed in the 7.4.0 release version of SqueezeBox Server! * SqueezeCenter: 28672 * Squeezebox 2 and 3: 130 * Transporter: 80 * Receiver: 65 * Boom: 50 * Controller: 7790 * Radio: 7790 Please see the Release Notes for all the details: http://wiki.slimdevices.com/index.php/Release_Notes If you haven't already, please download and install the new version from http://www.logitechsqueezebox.com/support/download-squeezebox-server.html If you are still experiencing this problem, feel free to reopen the bug with your new comments and we'll have another look.