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)
Code:
--------------------
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=slimserver: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
--------------------
--
KeyzerSuze
------------------------------------------------------------------------
KeyzerSuze's Profile: http://forums.slimdevices.com/member.php?userid=14026
View this thread: http://forums.slimdevices.com/showthread.php?t=40969
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
