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!
--
evencoil
------------------------------------------------------------------------
evencoil's Profile: http://forums.slimdevices.com/member.php?userid=19329
View this thread: http://forums.slimdevices.com/showthread.php?t=76916
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
