Bugzilla – Bug 4960
MySQL timeout error
Last modified: 2015-01-13 16:37:59 UTC
Support has a number of tickets which they attribute to slimserver timing out when trying to talk to MySQL. It's not clear at the moment whether the 'right' solution to this problem is simply to report the error better, or try to do something about the problem, or just increase the timeout. Please use this bug to help QA aggregate information regarding this issue.
Dan if you could add some information about the specific symptoms you have seen, it might help users identify this bug as what they are experiencing. Thanks.
This seems to match my problem scanning my library. I'm running the 12/7/2007 nightly on a linkstation pro with debian freelink. Here's the error I get with the d_scan turned on: 2007-12-07 23:34:56.1470 Setup::rescan - initiating scan of type: [rescan] 2007-12-07 23:35:26.3414 About to look for files in /mnt/disk1/share/music 2007-12-07 23:35:26.4080 For files with extensions in: [(?i-xsm:\.(?:ape|wma|shn|wav|wave|mp3|mp2|flc|flac|fla|m4a|mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|cue)$)] 2007-12-07 23:36:00.6852 Found 1708 files in /mnt/disk1/share/music 2007-12-07 23:39:13.5636 ERROR: Error executing 'INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 773. 2007-12-07 23:39:13.6102 ERROR: Backtrace follows: 2007-12-07 23:39:13.6437 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 775) frame 1: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 790) frame 2: DBIx::Class::Storage::DBI::insert (/usr/share/perl5/DBIx/Class/Row.pm line 78) frame 3: DBIx::Class::Row::insert (/usr/share/perl5/DBIx/Class/PK/Auto.pm line 43) frame 4: DBIx::Class::PK::Auto::insert (/usr/share/perl5/DBIx/Class/ResultSet.pm line 1371) frame 5: DBIx::Class::ResultSet::create (/usr/share/perl5/DBIx/Class/ResultSet.pm line 1417) frame 6: DBIx::Class::ResultSet::find_or_create (/usr/share/perl5/Slim/Schema.pm line 2217) frame 7: Slim::Schema::_postCheckAttributes (/usr/share/perl5/Slim/Schema.pm line 844) frame 8: Slim::Schema::newTrack (/usr/share/perl5/Slim/Schema.pm line 992) frame 9: Slim::Schema::updateOrCreate (/usr/share/perl5/Slim/Utils/Scanner.pm line 322) frame 10: Slim::Utils::Scanner::scanDirectory (/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 72) frame 11: Slim::Music::MusicFolderScan::startScan (/usr/share/perl5/Slim/Music/Import.pm line 422) frame 12: Slim::Music::Import::runImporter (/usr/share/perl5/Slim/Music/Import.pm line 265) frame 13: Slim::Music::Import::runScan (/usr/sbin/slimserver-scanner line 183) frame 14: (eval) (/usr/sbin/slimserver-scanner line 177) frame 15: main::main (/usr/sbin/slimserver-scanner line 314) 2007-12-07 23:39:13.7161 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 773. ] 2007-12-07 23:39:13.7175 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime!
Chris: what's the plan for this?
Chris: please comment
Ping Chris....
Richard, if you're still experiencing this problem, drop me a comment, and I'll see what we can come up with in the exciting new world of Squeezecenter (formerly Slimserver) 7.0. I wasn't able to reproduce this, but perhaps some additional debug information, or the results of running the scanner from the command line, might help us understand what's happening.
Unassigned bugs cannot have a priority.
MySQL is no longer used.