Bugzilla – Bug 17538
Scanner failes with DB constraint errorr
Last modified: 2011-09-04 08:15:12 UTC
After aborting a scan and restarting a full scan the following errors is reported and scanning is stopped: frame 24: Slim::Networking::IO::Select::loop (./slimserver.pl line 691) frame 25: main::idle (./slimserver.pl line 641) frame 26: main::main (./slimserver.pl line 1136) [11-09-04 16:58:39.6233] Slim::Control::Request::execute (1883) Error: While trying to run function coderef [Slim::Control::Commands::playlistXitemCommand]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::st execute failed: constraint failed foreign key constraint failed [for Statement "INSERT INTO tracks (bitrate,audio_offset,drm,audio_size,vbr_scale,remote,samplesize,audio,titlesort,coverid,cover,timestamp,url,lossless,urlmd5,channels,primary_artist,samplerate,secs,filesize,album,tracknum,content_type,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at /opt/squeezebox-server/Slim/Schema/Storage.pm line 123 ] [11-09-04 17:00:06.1008] Slim::Utils::Scanner::Local::rescan (166) Discovering files in /srv/media/music [11-09-04 17:00:23.9687] Slim::Utils::Scanner::Local::__ANON__ (246) Removing deleted files (0) [11-09-04 17:00:23.9697] Slim::Utils::Scanner::Local::__ANON__ (321) Scanning new files (20) [11-09-04 17:00:23.9706] Slim::Utils::Scanner::Local::__ANON__ (396) Rescanning changed files (0) [11-09-04 17:00:24.0815] Slim::Utils::AutoRescan::Linux::watch (85) Enabling inotify watcher [11-09-04 17:07:52.3193] Slim::Utils::AutoRescan::Linux::shutdown (157) Disabling inotify watcher [11-09-04 17:07:52.3276] Slim::Utils::Scanner::Local::rescan (166) Discovering files in /srv/media/music [11-09-04 17:08:10.6926] Slim::Utils::Scanner::Local::__ANON__ (246) Removing deleted files (0) [11-09-04 17:08:10.6937] Slim::Utils::Scanner::Local::__ANON__ (321) Scanning new files (20) [11-09-04 17:08:10.6961] Slim::Utils::Scanner::Local::__ANON__ (396) Rescanning changed files (0) [11-09-04 17:08:10.8949] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/01%20Some%20Loud%20Thunder.wma: Track is DRM-protected [11-09-04 17:08:10.9034] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/02%20Emily%20Jean%20Stock.wma: Track is DRM-protected [11-09-04 17:08:10.9114] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/03%20Mama,%20Won%27t%20You%20Keep%20Them%20Castles%20In%20The%20Air%20Burning-.wma: Track is DRM-protected [11-09-04 17:08:10.9179] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/04%20Love%20Song%20No.%207.wma: Track is DRM-protected [11-09-04 17:08:10.9236] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/05%20Satan%20Said%20Dance.wma: Track is DRM-protected [11-09-04 17:08:10.9294] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/06%20Upon%20Encountering%20The%20Crippled%20Elephant.wma: Track is DRM-protected [11-09-04 17:08:10.9347] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/07%20Goodbye%20To%20Mother%20And%20The%20Cove.wma: Track is DRM-protected [11-09-04 17:08:10.9398] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/08%20Arm%20And%20Hammer.wma: Track is DRM-protected [11-09-04 17:08:10.9446] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/09%20Yankee%20Go%20Home.wma: Track is DRM-protected [11-09-04 17:08:10.9570] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/10%20Underwater%20(You%20And%20Me)%20(You%20and%20Me).wma: Track is DRM-protected [11-09-04 17:08:10.9748] Slim::Utils::Scanner::Local::__ANON__ (765) ERROR SCANNING file:///srv/media/music/Clap%20Your%20Hands%20Say%20Yeah/Some%20Loud%20Thunder/11%20Five%20Easy%20Pieces.wma: Track is DRM-protected [11-09-04 17:08:10.9955] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::st execute failed: constraint failed foreign key constraint failed [for Statement "INSERT INTO tracks (bitrate,audio_offset,drm,audio_size,vbr_scale,remote,samplesize,audio,titlesort,coverid,cover,timestamp,url,lossless,urlmd5,channels,primary_artist,samplerate,secs,filesize,album,tracknum,content_type,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] [11-09-04 17:08:10.9969] Slim::Schema::Storage::throw_exception (119) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/opt/squeezebox-server/Slim/Schema/Storage.pm line 119) frame 1: Slim::Schema::Storage::throw_exception (/opt/squeezebox-server/CPAN/DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/opt/squeezebox-server/Slim/Schema.pm line 2970) frame 3: Slim::Schema::_insertHash (/opt/squeezebox-server/Slim/Schema.pm line 1353) frame 4: Slim::Schema::_createTrack (/opt/squeezebox-server/Slim/Schema.pm line 1612) frame 5: Slim::Schema::_newTrack (/opt/squeezebox-server/Slim/Schema.pm line 1810) frame 6: Slim::Schema::updateOrCreateBase (/opt/squeezebox-server/Slim/Utils/Scanner/Local.pm line 756) frame 7: Slim::Utils::Scanner::Local::__ANON__ (/opt/squeezebox-server/Slim/Utils/Scanner/Local.pm line 821) frame 8: Slim::Utils::Scanner::Local::new (/opt/squeezebox-server/Slim/Utils/Scanner/Local.pm line 361) frame 9: Slim::Utils::Scanner::Local::__ANON__ (/opt/squeezebox-server/Slim/Utils/Scheduler.pm line 150) frame 10: (eval) (/opt/squeezebox-server/Slim/Utils/Scheduler.pm line 150) frame 11: Slim::Utils::Scheduler::run_tasks (./slimserver.pl line 674) frame 12: main::idle (./slimserver.pl line 641) frame 13: main::main (./slimserver.pl line 1136) [11-09-04 17:08:10.9983] Slim::Utils::Scheduler::run_tasks (157) Error: Scheduler task failed: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::st execute failed: constraint failed foreign key constraint failed [for Statement "INSERT INTO tracks (bitrate,audio_offset,drm,audio_size,vbr_scale,remote,samplesize,audio,titlesort,coverid,cover,timestamp,url,lossless,urlmd5,channels,primary_artist,samplerate,secs,filesize,album,tracknum,content_type,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at /opt/squeezebox-server/Slim/Schema/Storage.pm line 123