Bugzilla – Bug 14853
Can't browse music folder while scan is running
Last modified: 2011-05-09 09:08:54 UTC
[09-10-20 10:27:56.3189] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "INSERT INTO tracks (filesize,titlesort,content_type,timestamp,titlesearch,url,title,remote,year) VALUES (?,?,?,?,?,?,?,?,?)"] [09-10-20 10:27:56.3195] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/Users/mh/Documents/workspace/7.5/server/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/Users/mh/Documents/workspace/7.5/server/CPAN/DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/Users/mh/Documents/workspace/7.5/server/Slim/Schema.pm line 1001) frame 3: Slim::Schema::newTrack (/Users/mh/Documents/workspace/7.5/server/Slim/Schema.pm line 1228) frame 4: Slim::Schema::updateOrCreate (/Users/mh/Documents/workspace/7.5/server/Slim/Schema.pm line 826) frame 5: Slim::Schema::objectForUrl (/Users/mh/Documents/workspace/7.5/server/Slim/Utils/Misc.pm line 866) frame 6: Slim::Utils::Misc::findAndScanDirectoryTree (/Users/mh/Documents/workspace/7.5/server/Slim/Web/Pages/BrowseTree.pm line 44) frame 7: Slim::Web::Pages::BrowseTree::browsetree (/Users/mh/Documents/workspace/7.5/server/Slim/Web/HTTP.pm line 1086) frame 8: Slim::Web::HTTP::generateHTTPResponse (/Users/mh/Documents/workspace/7.5/server/Slim/Web/HTTP.pm line 913) frame 9: Slim::Web::HTTP::processURL (/Users/mh/Documents/workspace/7.5/server/Slim/Web/HTTP.pm line 724) frame 10: Slim::Web::HTTP::processHTTP (/Users/mh/Documents/workspace/7.5/server/Slim/Networking/IO/Select.pm line 139) frame 11: (eval) (/Users/mh/Documents/workspace/7.5/server/Slim/Networking/IO/Select.pm line 123) frame 12: Slim::Networking::IO::Select::__ANON__ (/Users/mh/Documents/workspace/7.5/server/Slim/Networking/IO/Select.pm line 183) frame 13: (eval) (/Users/mh/Documents/workspace/7.5/server/Slim/Networking/IO/Select.pm line 183) frame 14: Slim::Networking::IO::Select::loop (slimserver.pl line 620) frame 15: main::idle (slimserver.pl line 574) frame 16: main::main (slimserver.pl line 1065) [09-10-20 10:27:56.3207] Slim::Networking::IO::Select::__ANON__ (146) Error: Select task failed calling Slim::Web::HTTP::processHTTP: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "INSERT INTO tracks (filesize,titlesort,content_type,timestamp,titlesearch,url,title,remote,year) VALUES (?,?,?,?,?,?,?,?,?)"] at /Users/mh/Documents/workspace/7.5/server/Slim/Schema/Storage.pm line 86 ; fh=Slim::Web::HTTP::ClientConn=GLOB(0x336a8e8)
Do you know if this affects TinySC as well? I think it would be much more important to fix it there.
With in-process scanning this may work now.
Assigning to QA to retest on tinySC
Moving P3 and lower bugs to next release target
This does not seem to affect TinySC. However it is still reproducible on 7.5.1 r30796
If this still happens, it needs to be fixed for 7.6.
I only tested with SQLite but it seems to work just fine.
Cannot reproduce on OSx 10.5.8, 7.6.0 (32302. Was able to explore the music folders via the local Mac SBS and a Fab 4 during a full scan of music.