Bugzilla – Bug 9224
MySQL is shut down before SqueezeCenter on ReadyNAS
Last modified: 2009-09-08 09:12:05 UTC
This might be a reason why we see too many complaints about corrupted databases on ReadyNAS. MySQL is shut down before squeezecenter has stopped: [08-08-20 00:05:16.7130] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.name, me.value FROM metainformation me WHERE ( name = ? )': DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-08-20 00:05:16.7234] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 70) 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 826) frame 3: DBIx::Class::Storage::DBI::_select (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 852) frame 4: DBIx::Class::Storage::DBI::select_single (/usr/share/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 509) frame 5: DBIx::Class::ResultSet::single (/usr/share/perl5/Slim/Schema.pm line 539) frame 6: Slim::Schema::single (/usr/share/perl5/Slim/Music/Import.pm line 629) frame 7: Slim::Music::Import::stillScanning (/usr/share/perl5/Slim/Control/Queries.pm line 3292) frame 8: Slim::Control::Queries::statusQuery (/usr/share/perl5/Slim/Control/Request.pm line 1798) frame 9: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1798) frame 10: Slim::Control::Request::execute (/usr/share/perl5/Slim/Control/Request.pm line 2552) frame 11: Slim::Control::Request::__autoexecute (/usr/share/perl5/Slim/Utils/Timers.pm line 198) frame 12: (eval) (/usr/share/perl5/Slim/Utils/Timers.pm line 198) frame 13: Slim::Utils::Timers::checkTimers (/usr/sbin/squeezecenter-server line 534) frame 14: main::idle (/usr/sbin/squeezecenter-server line 481) frame 15: main::main (/usr/sbin/squeezecenter-server line 1043) [08-08-20 00:05:16.7350] Slim::Control::Request::execute (1802) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.name, me.value FROM metainformation me WHERE ( name = ? )': DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. ] 2008-08-20 00:05:18 squeezecenter_safe stopped. 2008-08-20 07:01:36 squeezecenter_safe started. (my ReadyNAS is shut down at midnight and started again at 7am every night)
Justin: What's the right thing to do here?
I just fixed that in our release. So starting with 4.1.3, squeezecenter will be stopped before mysqld.
Justin - is this a change on the system side of your firmware which will also work when running our 7.2+ builds of SC?
Yes, this is independent of SqueezeCenter.
Ok, so you can fix this on the ReadyNAS side? What release?
The fix is already checked in for our release. It'll be in 4.1.3, which should be available in a few days.