Bug 9224 - MySQL is shut down before SqueezeCenter on ReadyNAS
: MySQL is shut down before SqueezeCenter on ReadyNAS
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Misc
: 7.2
: Infrant ReadyNAS Other
: -- minor (vote)
: ---
Assigned To: Justin Maggard
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-08-20 03:50 UTC by Michael Herger
Modified: 2009-09-08 09:12 UTC (History)
2 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Herger 2008-08-20 03:50:37 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)
Comment 1 Blackketter Dean 2008-08-20 12:23:51 UTC
Justin: What's the right thing to do here?
Comment 2 Justin Maggard 2008-08-20 12:49:03 UTC
I just fixed that in our release.  So starting with 4.1.3, squeezecenter will be stopped before mysqld.
Comment 3 Michael Herger 2008-08-20 13:41:56 UTC
Justin - is this a change on the system side of your firmware which will also work when running our 7.2+ builds of SC?
Comment 4 Justin Maggard 2008-08-20 17:40:22 UTC
Yes, this is independent of SqueezeCenter.
Comment 5 Blackketter Dean 2008-08-20 18:27:59 UTC
Ok, so you can fix this on the ReadyNAS side?  What release?
Comment 6 Justin Maggard 2008-08-20 18:37:58 UTC
The fix is already checked in for our release.  It'll be in 4.1.3, which should be available in a few days.