epoch1970 wrote:
> Have a look at the system log file /var/log/syslog and the server log
> /var/log/squeezeboxserver/server.log
>
> That will tell you what happened near the time SBS stopped responding.
> If you rebooted, a hard drive check is a good suspect. All services were
> not started but sometimes enough are to make things appear normal and
> operational.
> Also, SBS wants to see the network up and running. Perhaps it waited for
> that.
> When memory gets very tight on the machine it will first commit to swap
> the memory pages of inactive processes, and that can turn very bad wrt
> response time. Remember when you had to swap diskettes to use either the
> OS or an application on a PC with 1 drive ??
> When the kernel is not even able to use the swap it will kill processes.
> Just like that. I've seen SBS get evicted from a machine, but then it
> never came back all by itself.
>
> In fact I don't see a reason specific to SBS to behave as you report.
> Have a look at syslog.
Thanks for the response.
I am still having problems, but now they are more concrete.
The server appears to be starting and restarting constantly. There's no
evidence in /var/log/syslog. If I manually stop it (service
squeezeboxserver stop) and restart it, then I see the following in my
SBS server.log:
Code:
--------------------
[13-02-06 13:15:00.9497] Slim::Schema::Storage::throw_exception (82) Error:
DBI Exception: DBD::mysql::st execute failed: MySQL server has gone away [for
Statement "SELECT me.id, me.url, me.musicbrainz_id, me.added, me.playcount,
me.lastplayed, me.rating FROM tracks_persistent me WHERE ( ( rating IS NOT NULL
OR playcount IS NOT NULL OR lastplayed IS NOT NULL ) )"]
2013-02-06 13:15:00 squeezeboxserver_safe stopped.
[13-02-06 13:15:00.9501] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1217)
frame 3: DBIx::Class::Storage::DBI::_dbh_execute
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 532)
frame 4: DBIx::Class::Storage::DBI::dbh_do
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1227)
frame 5: DBIx::Class::Storage::DBI::_execute
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1451)
frame 6: DBIx::Class::Storage::DBI::_select
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 82)
frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 547)
frame 8: (eval) (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm
line 540)
frame 9: DBIx::Class::Storage::DBI::dbh_do
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 10: DBIx::Class::Storage::DBI::Cursor::next
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 949)
frame 11: DBIx::Class::ResultSet::next
(/usr/share/perl5/Slim/Schema/TrackPersistent.pm line 62)
frame 12: Slim::Schema::TrackPersistent::export (/usr/sbin/squeezeboxserver
line 1015)
frame 13: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 451)
frame 14: Slim::bootstrap::sigterm
(/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 476)
frame 15: (eval) (/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 476)
frame 16: Slim::Utils::MySQLHelper::_checkForDeadProcess
(/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 422)
frame 17: Slim::Utils::MySQLHelper::stopServer
(/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 628)
frame 18: Slim::Utils::MySQLHelper::cleanup (/usr/sbin/squeezeboxserver line
1045)
frame 19: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 441)
frame 20: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line
475)
frame 21: Slim::bootstrap::theEND (/usr/sbin/squeezeboxserver line 1068)
frame 22: main::END (/usr/share/squeezeboxserver/lib/Log/Log4perl/Logger.pm
line 868)
frame 23: (eval) (/usr/share/squeezeboxserver/lib/Log/Log4perl/Logger.pm line
868)
[13-02-06 13:15:00.9516] Slim::Schema::Storage::throw_exception (82) Error:
DBI Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Can't connect to MySQL server on '127.0.0.1' (111) at
/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 950
[13-02-06 13:15:00.9521] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 972)
frame 2: DBIx::Class::Storage::DBI::_connect
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 814)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 568)
frame 4: DBIx::Class::Storage::DBI::dbh_do
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 5: DBIx::Class::Storage::DBI::Cursor::next
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 949)
frame 6: DBIx::Class::ResultSet::next
(/usr/share/perl5/Slim/Schema/TrackPersistent.pm line 62)
frame 7: Slim::Schema::TrackPersistent::export (/usr/sbin/squeezeboxserver
line 1015)
frame 8: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 451)
frame 9: Slim::bootstrap::sigterm (/usr/share/perl5/Slim/Utils/MySQLHelper.pm
line 476)
frame 10: (eval) (/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 476)
frame 11: Slim::Utils::MySQLHelper::_checkForDeadProcess
(/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 422)
frame 12: Slim::Utils::MySQLHelper::stopServer
(/usr/share/perl5/Slim/Utils/MySQLHelper.pm line 628)
frame 13: Slim::Utils::MySQLHelper::cleanup (/usr/sbin/squeezeboxserver line
1045)
frame 14: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 441)
frame 15: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line
475)
frame 16: Slim::bootstrap::theEND (/usr/sbin/squeezeboxserver line 1068)
frame 17: main::END (/usr/share/squeezeboxserver/lib/Log/Log4perl/Logger.pm
line 868)
frame 18: (eval) (/usr/share/squeezeboxserver/lib/Log/Log4perl/Logger.pm line
868)
[13-02-06 13:15:00.9526] main:: (868) Warning: Carp::Clan::__ANON__(): DBI
Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Can't connect to MySQL server on '127.0.0.1' (111) at
/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 950
END failed--call queue aborted at /usr/sbin/squeezeboxserver line 868.
2013-02-06 13:15:00 squeezeboxserver_safe started.
[13-02-06 13:15:01.7603] main::init (323) Starting Squeezebox Server (v7.5.1,
r30836, Tue Jun 1 05:57:28 PDT 2010) perl 5.010001
[13-02-06 13:15:01.7781] main::init (340) Squeezebox Server OS Specific
init...
[13-02-06 13:15:01.7785] main::init (387) Squeezebox Server settings
effective user and group if requested...
[13-02-06 13:15:01.7791] Slim::Utils::OS::setPriority (352) Squeezebox Server
changing process priority to -16
[13-02-06 13:15:01.7793] main::init (404) Squeezebox Server binary search
path init...
[13-02-06 13:15:01.7796] main::init (408) Squeezebox Server PluginManager
init...
[13-02-06 13:15:01.7997] main::init (411) Squeezebox Server strings init...
[13-02-06 13:15:01.8013] Slim::Utils::Strings::loadStrings (124) Retrieving
string data from string cache:
/var/lib/squeezeboxserver/cache/stringcache.x86_64-linux.bin
[13-02-06 13:15:01.8055] main::init (415) Squeezebox Server SQL init...
[13-02-06 13:15:02.9254] main::init (419) Async DNS init...
[13-02-06 13:15:02.9257] main::init (422) Async HTTP init...
[13-02-06 13:15:02.9263] main::init (426) Firmware init...
[13-02-06 13:15:02.9269] main::init (429) Squeezebox Server Info init...
[13-02-06 13:15:03.1168] main::init (444) Squeezebox Server IR init...
[13-02-06 13:15:03.1320] main::init (447) Squeezebox Server Request init...
[13-02-06 13:15:03.1401] main::init (450) Squeezebox Server Buttons init...
[13-02-06 13:15:03.1423] main::init (458) UDP init...
[13-02-06 13:15:03.1429] Slim::Networking::UDP::init (39) FATAL: There is
already another copy of the Squeezebox Server running on this machine. (Address
already in use)
[13-02-06 13:15:03.1433] Log::Log4perl::Logger::and_die (868) Warning: FATAL:
There is already another copy of the Squeezebox Server running on this machine.
(Address already in use) at
/usr/share/squeezeboxserver/lib/Log/Log4perl/Logger.pm line 900
[13-02-06 13:15:03.1437] Slim::bootstrap::theEND (473) Got to the END
[13-02-06 13:15:03.1440] Slim::bootstrap::sigint (437) Got sigint
2013-02-06 13:15:08 Squeezebox Server died. Restarting.
--------------------
And then the part between the following line keeps repeating
Code:
--------------------
2013-02-06 13:15:14 Squeezebox Server died. Restarting.
[all the rest of the stuff up there]
2013-02-06 13:15:20 Squeezebox Server died. Restarting.
--------------------
So it seems like my MySQL database is corrupted perhaps? Is there a way
I can wipe it clean and just rebuild it? I have tried deleting
/var/lib/squeezeboxserver/cache but it always comes back (with the large
MySQL data file in it!) when I restart SBS.
Thanks for the help!
------------------------------------------------------------------------
evencoil's Profile: http://forums.slimdevices.com/member.php?userid=19329
View this thread: http://forums.slimdevices.com/showthread.php?t=98038
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/unix
