evencoil;531076 Wrote: > This problem started happening very suddenly and for no reason that I > can discern. On my dedicated squeezecenter box I do a daily full > library rescan. Recently my "Playlists" started coming up empty (not a > permissions problem). Curiously, if I reboot the machine and then > immediately do a full rescan everything is fine. But the daily rescans > give me this set of errors in scanner.log: > > > Code: -------------------- > > > [10-04-07 05:59:20.5090] Slim::Schema::Storage::throw_exception (81) Error: Error executing 'UPDATE tracks_persistent SET track = ? WHERE ( id = ? )': DBD::mysql::st execute failed: Duplicate entry '38172' for key 2 at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. > [10-04-07 05:59:20.5288] Slim::Schema::Storage::throw_exception (81) Backtrace: > > frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 81) > frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 773) > frame 2: DBIx::Class::Storage::DBI::_execute (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 797) > frame 3: DBIx::Class::Storage::DBI::update (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 115) > frame 4: DBIx::Class::Row::update (/usr/share/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30) > frame 5: DBIx::Class::Relationship::CascadeActions::update (/usr/share/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222) > frame 6: DBIx::Class::InflateColumn::update (/usr/share/perl5/Slim/Schema/DBI.pm line 35) > frame 7: Slim::Schema::DBI::update (/usr/share/perl5/Slim/Schema.pm line 1040) > frame 8: Slim::Schema::newTrack (/usr/share/perl5/Slim/Utils/Scanner.pm line 340) > frame 9: Slim::Utils::Scanner::scanDirectory (/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 79) > frame 10: Slim::Music::MusicFolderScan::startScan (/usr/share/perl5/Slim/Music/Import.pm line 494) > frame 11: Slim::Music::Import::runImporter (/usr/share/perl5/Slim/Music/Import.pm line 323) > frame 12: Slim::Music::Import::runScan (/usr/sbin/squeezecenter-scanner line 231) > frame 13: (eval) (/usr/sbin/squeezecenter-scanner line 225) > frame 14: main::main (/usr/sbin/squeezecenter-scanner line 371) > > [10-04-07 05:59:20.5545] main::main (237) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'UPDATE tracks_persistent SET track = ? WHERE ( id = ? )': DBD::mysql::st execute failed: Duplicate entry '38172' for key 2 at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. > ] > [10-04-07 05:59:20.5551] main::main (238) Error: Skipping post-process & Not updating lastRescanTime! > -------------------- > > > > I don't know what that means but my guess is that something to messed > up in the mySQL database (the "Duplicate entry" part...)? Any ideas > for troubleshooting or fixing this? This is on Ubuntu 8.04 and > Squeezecenter 7.3.3 and I've turned off all plugins and it still > happens. Thanks!
Here's an old thread referencing a similar problem: http://www.mail-archive.com/discuss@lists.slimdevices.com/msg46706.html http://www.mail-archive.com/discuss@lists.slimdevices.com/msg46768.html See if any files you've added recently have tags named "ID" or other unusual tags. -- pfink ------------------------------------------------------------------------ pfink's Profile: http://forums.slimdevices.com/member.php?userid=20021 View this thread: http://forums.slimdevices.com/showthread.php?t=76916 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss