PDA

View Full Version : Slimserver keeps trying to restart mysql (without succes)



riemers
2007-12-22, 06:09
I'am running etch debian (unstable) , with slimserver 7.0. It was running fine untill i did a apt-get update (needed some new packages, so just did the whole lot) system itself is not that vital.

So i tried reinstalling slimserver, i get the same messages. I went back to the stable release and it does exactly the same. Also removed everything i could find on the system owned by slimserver... and still have this issue.

Is there a way to see why the mysql server wont start up? Since i think this is the main issue (slimserver.log says it cant connect to the db, so not much info in there)

Thanks for any advice/help.

071222 14:05:03 InnoDB: Started; log sequence number 0 43655
071222 14:05:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.32-Debian_7etch1' socket: '/var/cache/slimserver/slimserver-mysql.sock' port: 9092 Debian etch distribution
071222 14:05:04 [Note] /usr/sbin/mysqld: Normal shutdown

071222 14:05:06 InnoDB: Starting shutdown...
071222 14:05:09 InnoDB: Shutdown completed; log sequence number 0 43655
071222 14:05:09 [Note] /usr/sbin/mysqld: Shutdown complete

071222 14:05:10 InnoDB: Started; log sequence number 0 43655
071222 14:05:10 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.32-Debian_7etch1' socket: '/var/cache/slimserver/slimserver-mysql.sock' port: 9092 Debian etch distribution
071222 14:05:11 [Note] /usr/sbin/mysqld: Normal shutdown

riemers
2008-01-06, 17:01
Still dies here.. did the latest apt-get install on the 7.x branch but still keeps restarting my mysql.

slimserver log does not show much.. keeps repeating and says that db is not there..

2008-01-07 00:59:57 SqueezeCenter died. Restarting.
[08-01-07 00:59:59.7218] Slim::Schema::Storage::throw_exception (67) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver:mysql_socket=/var/cache/slimserver/squeezecenter-mysql.sock','slimserver',...) failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 at /usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 652
[08-01-07 00:59:59.7223] Slim::Schema::Storage::throw_exception (67) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 67)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 2: DBIx::Class::Storage::DBI::_connect (/usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/Slim/Schema/Storage.pm line 27)
frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 27)
frame 6: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm line 121)
frame 7: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 76)
frame 8: Slim::Music::Info::init (/usr/sbin/slimserver line 345)
frame 9: main::init (/usr/sbin/slimserver line 448)
frame 10: main::main (/usr/sbin/slimserver line 1000)

[08-01-07 00:59:59.7229] Slim::Schema::init (124) Error: Couldn't connect to database! Fatal error: [] Exiting!
[08-01-07 00:59:59.7233] Slim::Schema::init (124) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema.pm line 124)
frame 1: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 76)
frame 2: Slim::Music::Info::init (/usr/sbin/slimserver line 345)
frame 3: main::init (/usr/sbin/slimserver line 448)
frame 4: main::main (/usr/sbin/slimserver line 1000)

[08-01-07 00:59:59.7238] Slim::Schema::forceCommit (1358) Warning: Trying to commit transactions before DB is initialized!
[08-01-07 00:59:59.7358] Slim::Schema::Storage::throw_exception (67) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver:mysql_socket=/var/cache/slimserver/squeezecenter-mysql.sock','slimserver',...) failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 at /usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 652
[08-01-07 00:59:59.7363] Slim::Schema::Storage::throw_exception (67) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 67)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 2: DBIx::Class::Storage::DBI::_connect (/usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/Slim/Schema/Storage.pm line 27)
frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 27)
frame 6: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm line 244)
frame 7: (eval) (/usr/share/perl5/Slim/Schema.pm line 244)
frame 8: Slim::Schema::disconnect (/usr/sbin/slimserver line 959)
frame 9: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 368)
frame 10: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 402)
frame 11: Slim::bootstrap::theEND (/usr/sbin/slimserver line 996)
frame 12: main::END (/usr/sbin/slimserver line 0)
frame 13: (eval) (/usr/sbin/slimserver line 0)

2008-01-07 01:00:02 SqueezeCenter died. Restarting.

riemers
2008-01-06, 17:23
Well i think its an issue with debian and mysql. Maybe the latest version doesn't works so well with slimserver. Anyway, i followed http://wiki.slimdevices.com/index.cgi?ExistingMySQLInstance to get mysql working on my current mysql server. After i did this, everything worked fine again. Although i would still wonder why this didn't work anymore.