[09-11-11 01:55:32.9828] Slim::Music::Import::runScanPostProcessing (484) Starting Database optimization. [09-11-11 01:55:33.4413] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_album`, CONSTRAINT `contributor_album_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE CASCADE) [09-11-11 01:55:33.4417] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Utils/SQLHelper.pm line 83) frame 3: (eval) (/usr/share/perl5/Slim/Utils/SQLHelper.pm line 83) frame 4: Slim::Utils::SQLHelper::executeSQLFile (/usr/share/perl5/Slim/Schema.pm line 434) frame 5: (eval) (/usr/share/perl5/Slim/Schema.pm line 433) frame 6: Slim::Schema::optimizeDB (/usr/share/perl5/Slim/Music/Import.pm line 488) frame 7: Slim::Music::Import::runScanPostProcessing (/usr/sbin/squeezeboxserver-scanner line 306) frame 8: (eval) (/usr/sbin/squeezeboxserver-scanner line 306) frame 9: main::main (/usr/sbin/squeezeboxserver-scanner line 439) [09-11-11 01:55:33.4420] Slim::Utils::SQLHelper::executeSQLFile (85) Error: Couldn't execute SQL statement: [INSERT INTO contributor_album (role,contributor,album) SELECT DISTINCT role,contributor,album FROM contributor_track,tracks where tracks.id=contributor_track.track;] : [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_album`, CONSTRAINT `contributor_album_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE CASCADE) at /usr/share/perl5/Slim/Schema/Storage.pm line 86 ] [09-11-11 01:55:47.4340] Slim::Music::Import::endImporter (701) Completed dbOptimize Scan in 14 seconds.