View Full Version : Squeezebox hangs during loading music folder

Coen Giesberts
2007-09-15, 00:55
When I turn on my Squeezebox in the morning, it seems like the music database is empty, because it won't play anything. When I go to Browse->Music folder, it will keep displaying "Loading music folder..". In het slimserver.log file the following error occurs at the time I enter the browse menu.

2007-09-15 09:39:39.4821 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:///mp3'] at /usr/share/perl5/Slim/Schema/Storage.pm line 74

I am running Slimserver 6.5.5 on Linux:. Fortunately a restart of the slimserver helps, but don't want to do that every morning. Is this a software bug?


2007-09-15, 13:33
> I am running Slimserver 6.5.5 on Linux:. Fortunately a restart of the
> slimserver helps, but don't want to do that every morning.

Can you see any MySQL related information in /tmp/slimserver.log around the time of the crash?


Coen Giesberts
2007-09-16, 02:05
I don't have a /tmp/slimserver.log, but /var/log/slimserver/slimserver.log. It contains the error message above, with a backtrace referring to perl files. It does not give more mysql details, except perhaps this one:

2007-09-16 10:19:00.2615 ERROR: DBI Exception: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) [for Statement "INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)" with ParamValues: 1=1, 0='658', 2='459']
2007-09-16 10:19:00.2618 ERROR: Backtrace follows:


2007-09-16, 04:03

Same problem here: my squeezebox v1 works OK for at least a few hours and then hangs on "Loading music folder". Going to 'New music', or 'Artists', 'Albums', ... doesn't show anything.
Restarting slimserver brings everything back to normal. I need to do this at least once a day if not more.

I'm running slimserver 6.5.4 under Debian testing. The slimserver package was installed from the http://debian.slimdevices.com APT source.

When the slimserver goes down, /var/log/slimserver/slimserver.log shows a bunch of MySQL exceptions saying that "MySQL server has gone away". I pasted the first one below.

Note that I've ran slimserver on a Debian box for years without any major issue,
until I reinstalled Debian and decided to use the debian.slimdevices.com APT source instead of the tar.gz package.

I'm available for more information if needed.

2007-09-16 12:45:30.5017 ERROR: DBI Exception: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mi
xable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GR
OUP BY contributor.id ORDER BY role desc" with ParamValues: 1='14933', 0=1]
2007-09-16 12:45:30.5155 ERROR: Backtrace follows:

2007-09-16 12:45:30.5158 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 772)
frame 1: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 898)
frame 2: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 542)
frame 3: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 912)
frame 4: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1026)
frame 5: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1063)
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 541)
frame 8: DBIx::Class::ResultSet::single (/usr/share/perl5/Slim/Schema/Track.pm line 95)
frame 9: Slim::Schema::Track::artist (/usr/share/slimserver/Plugins/xPL.pm line 361)
frame 10: Plugins::xPL::sendXplHBeatMsg (/usr/share/slimserver/Plugins/xPL.pm line 644)
frame 11: Plugins::xPL::xplExecuteCallback (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 12: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 13: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 751)
frame 14: Slim::Control::Request::checkNotifications (/usr/sbin/slimserver line 476)
frame 15: main::idle (/usr/sbin/slimserver line 452)
frame 16: main::main (/usr/sbin/slimserver line 1076)