PDA

View Full Version : slimserver keep dieing (Debian)



KeyzerSuze
2007-12-10, 14:45
Hi

I have slimserver installed on a debian box 6.5.5, running mysql 5.0.45-1+lenny1.

I leave the server running and playing music on the squeeze box, then after a while the squeezebox can't connect to slimserver, I have to restart the server !

logs below, any ideas ? I am guessing the db has gone but any reason why ?

from the slimlogs (from a restart)


2007-12-09 21:05:09 slimserver_safe started.
2007-12-09 21:05:10.7696 ERROR: forceCommit: Trying to commit transactions before DB is initialized!

2007-12-09 21:05:10.8011 ERROR: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver:mysql_socket=/var/cache/slimserver/slimserver-mysq
l.sock','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 839

2007-12-09 21:05:10.8014 ERROR: Backtrace follows:

2007-12-09 21:05:10.8017 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 856)
frame 1: DBIx::Class::Storage::DBI::_connect (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 769)
frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 733)
frame 3: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/Slim/Schema/Storage.pm line 28)
frame 4: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 28)
frame 5: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm line 249)
frame 6: (eval) (/usr/share/perl5/Slim/Schema.pm line 249)
frame 7: Slim::Schema::disconnect (/usr/sbin/slimserver line 1042)
frame 8: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 300)
frame 9: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 331)
frame 10: Slim::bootstrap::END (/usr/sbin/slimserver line 0)
frame 11: (eval) (/usr/sbin/slimserver line 0)

2007-12-09 21:05:40.6582 scanPathOrURL: Finding valid files in: /exports/music/Enigma/Mcmxc_A.D.
2007-12-09 21:05:40.6591 About to look for files in /exports/music/Enigma/Mcmxc_A.D.
2007-12-09 21:05:40.6625 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave| mp3|mp2|m3u|pls|xspf|flc|flac|fla|m4a|mov|m4b|mp4| cue|mp+
|mpc|ogg|aif|aiff)$)]
2007-12-09 21:05:40.6919 Found 7 files in /exports/music/Enigma/Mcmxc_A.D.
2007-12-09 21:05:49.9469 scanPathOrURL: Finding valid files in: /exports/music/Enigma/Mcmxc_A.D.
2007-12-09 21:05:49.9476 About to look for files in /exports/music/Enigma/Mcmxc_A.D.
2007-12-09 21:05:49.9511 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave| mp3|mp2|m3u|pls|xspf|flc|flac|fla|m4a|mov|m4b|mp4| cue|mp+
|mpc|ogg|aif|aiff)$)]
2007-12-09 21:05:49.9573 Found 7 files in /exports/music/Enigma/Mcmxc_A.D.
2007-12-10 00:30:02.5028 About to look for files in /exports/music
2007-12-10 00:30:02.5048 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-10 00:30:11.9817 About to look for files in /exports/music/Playlists
2007-12-10 00:30:11.9827 For files with extensions in: [(?i-xsm:\.(?:asf|wax|asx|lnk|wpl|m3u|pls|xspf|cue)$)]
2007-12-10 11:42:52.3210 ERROR: DBI Exception: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT me.id, me.url, me.content_type, me.titl
e, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.
secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixabl
e, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? )" with ParamValues
: 0='file:///exports/music']
2007-12-10 11:42:52.3343 ERROR: Backtrace follows:

2007-12-10 11:42:52.3351 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 846)
frame 1: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1003)
frame 2: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 582)
frame 3: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1013)
frame 4: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1128)
frame 5: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1165)
frame 6: DBIx::Class::Storage::DBI::select_single (/usr/share/perl5/Slim/Schema/Storage.pm line 94)
frame 7: Slim::Schema::Storage::select_single (/usr/share/perl5/DBIx/Class/ResultSet.pm line 552)
frame 8: DBIx::Class::ResultSet::single (/usr/share/perl5/Slim/Schema.pm line 1410)
frame 9: Slim::Schema::_retrieveTrack (/usr/share/perl5/Slim/Schema.pm line 680)
frame 10: Slim::Schema::objectForUrl (/usr/share/perl5/Slim/Schema/ResultSet/Track.pm line 100)
frame 11: Slim::Schema::ResultSet::Track::objectForUrl (/usr/share/perl5/Slim/Utils/Misc.pm line 873)
frame 12: Slim::Utils::Misc::findAndScanDirectoryTree (/usr/share/perl5/Slim/Buttons/BrowseTree.pm line 374)
frame 13: Slim::Buttons::BrowseTree::setMode (/usr/share/perl5/Slim/Buttons/Common.pm line 1604)
frame 14: (eval) (/usr/share/perl5/Slim/Buttons/Common.pm line 1604)
frame 15: Slim::Buttons::Common::pushMode (/usr/share/perl5/Slim/Buttons/Common.pm line 1744)
frame 16: Slim::Buttons::Common::pushModeLeft (/usr/share/perl5/Slim/Buttons/Home.pm line 463)
frame 17: Slim::Buttons::Home::homeExitHandler (/usr/share/perl5/Slim/Buttons/Input/List.pm line 486)
frame 18: Slim::Buttons::Input::List::exitInput (/usr/share/perl5/Slim/Buttons/Input/List.pm line 133)
frame 19: Slim::Buttons::Input::List::__ANON__ (/usr/share/perl5/Slim/Hardware/IR.pm line 830)
frame 20: Slim::Hardware::IR::executeButton (/usr/share/perl5/Slim/Control/Commands.pm line 148)
frame 21: Slim::Control::Commands::buttonCommand (/usr/share/perl5/Slim/Control/Request.pm line 1483)
frame 22: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1483)
frame 23: Slim::Control::Request::execute (/usr/share/perl5/Slim/Control/Request.pm line 772)
frame 24: Slim::Control::Request::executeRequest (/usr/share/perl5/Slim/Player/Client.pm line 467)
frame 25: Slim::Player::Client::execute (/usr/share/perl5/Slim/Hardware/IR.pm line 844)
frame 26: Slim::Hardware::IR::processCode (/usr/share/perl5/Slim/Hardware/IR.pm line 604)
frame 27: Slim::Hardware::IR::processIR (/usr/share/perl5/Slim/Control/Commands.pm line 264)
frame 28: Slim::Control::Commands::irCommand (/usr/share/perl5/Slim/Control/Request.pm line 1483)
frame 29: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1483)
frame 30: Slim::Control::Request::execute (/usr/share/perl5/Slim/Control/Request.pm line 772)
frame 31: Slim::Control::Request::executeRequest (/usr/share/perl5/Slim/Player/Client.pm line 467)
frame 32: Slim::Player::Client::execute (/usr/share/perl5/Slim/Hardware/IR.pm line 120)
frame 33: Slim::Hardware::IR::idle (/usr/sbin/slimserver line 473)
frame 34: main::idle (/usr/sbin/slimserver line 452)
frame 35: main::main (/usr/sbin/slimserver line 1076)

2007-12-10 11:42:52.3357 Couldn't push into new mode: [browsetree] !: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? )" with ParamValues: 0='file:///exports/music'] at /usr/share/perl5/Slim/Schema/Storage.pm line 74

servies
2007-12-11, 07:40
Looking at the logfile I guess the problem lies somewhere in the connection between Perl and Mysql...
Are the plugins you're using for Perl to connect to mysql uptodate compared with the version of mysql?

KeyzerSuze
2007-12-11, 19:29
I believe so, the deb packages come from the slimserver site

servies
2007-12-12, 01:04
Hmmm, I'm not a Perl expert but


2007-12-09 21:05:10.8011 ERROR: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver:mysql_socket=/var/cache/slimserver/slimserver-mysq
l.sock','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 839
and

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 856)
frame 1: DBIx::Class::Storage::DBI::_connect (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 769)
frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 733)
frame 3: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/Slim/Schema/Storage.pm line 28)
this suggests to me that possibly your perl DBI 'module' is incompatible with the mysql provided by slimserver. (If I look at my Fedora system slimserver provides its own DBI module and that one differs from the version that Perl itself provides...

I'm not sure if you were already running an instance of mysql on that server. If so try to use that one, howto setup slimserver to do so, follow this link: http://wiki.slimdevices.com/index.cgi?ExistingMySQLInstance

KeyzerSuze
2007-12-13, 15:14
Hi

I will have a look, but it works for a while, maybe 5-6 hours and then stops and then works for a while not the same period, different periods. Seems like the mysql instance is working.

It seems like the debian install is just the slimserver perl stuff. It relies upon an install of mysql on the server, but running its own my.cnf file so it is sort of running its own instance.