PDA

View Full Version : webinterface not responding, needs to restart slimserver



seerdekens
2007-08-16, 01:57
Hi,

I currently experience problems with Slimserver on my Debian machine, more particularly with the webinterface.
Every 2 or 3 days the when accessing the webinterface, I get to response (after entering the password), the page just keeps loading in my browser window. Restarting slimserver resolves the problem.

I see this in /var/log/slimserver/slimserver.log
2007-08-16 10:47:27.2052 Select task failed: Carp::Clan::__ANON__(): DBI Excepti on: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SE LECT me.name, me.value FROM metainformation me WHERE ( name = ? )" with ParamVal ues: 0='isScanning'] at /usr/share/perl5/Slim/Schema/Storage.pm line 74

VERSION INFO

SlimServer Version: 6.5.4 - 12382 - Debian - EN - iso-8859-1
Server IP address: 192.168.1.200
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.45-Debian_1


Thanks for your input!
Steven

bpa
2007-08-16, 02:42
Check the MySql error log which should give more info as it look like MySQL stopped. For example, MySql may have run out of tmp disk space.

seerdekens
2007-08-21, 01:07
I also see this:


2007-08-20 23:13:54.5548 ERROR: DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction
2007-08-20 23:13:54.6058 ERROR: Backtrace follows:

2007-08-20 23:13:54.6066 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 798)
frame 2: DBIx::Class::Storage::DBI::txn_begin (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 596)
frame 3: (eval) (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 592)
frame 4: DBIx::Class::Storage::DBI::txn_do (/usr/share/perl5/DBIx/Class/Schema.pm line 728)
frame 5: DBIx::Class::Schema::txn_do (/usr/share/perl5/Slim/Schema/Playlist.pm line 46)
frame 6: (eval) (/usr/share/perl5/Slim/Schema/Playlist.pm line 39)
frame 7: Slim::Schema::Playlist::setTracks (/usr/share/perl5/Slim/Player/Playlist.pm line 757)
frame 8: Slim::Player::Playlist::modifyPlaylistCallback (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 9: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 10: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 751)
frame 11: Slim::Control::Request::checkNotifications (/usr/sbin/slimserver line 476)
frame 12: main::idle (/usr/sbin/slimserver line 452)
frame 13: main::main (/usr/sbin/slimserver line 1076)

2007-08-20 23:13:54.6081 ERROR: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/share/perl5/Slim/Schema/Storage.pm line 74

2007-08-20 23:13:54.6084 ERROR: Backtrace follows:

2007-08-20 23:13:54.6090 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 625)
frame 1: DBIx::Class::Storage::DBI::txn_do (/usr/share/perl5/DBIx/Class/Schema.pm line 728)
frame 2: DBIx::Class::Schema::txn_do (/usr/share/perl5/Slim/Schema/Playlist.pm line 46)
frame 3: (eval) (/usr/share/perl5/Slim/Schema/Playlist.pm line 39)
frame 4: Slim::Schema::Playlist::setTracks (/usr/share/perl5/Slim/Player/Playlist.pm line 757)
frame 5: Slim::Player::Playlist::modifyPlaylistCallback (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 6: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1645)
frame 7: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 751)
frame 8: Slim::Control::Request::checkNotifications (/usr/sbin/slimserver line 476)
frame 9: main::idle (/usr/sbin/slimserver line 452)
frame 10: main::main (/usr/sbin/slimserver line 1076)

2007-08-20 23:13:54.6095 ERROR: setTracks: Failed to add tracks to playlist: [Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db begin_work failed: Already in a transaction at /usr/share/perl5/Slim/Schema/Storage.pm line 74
]


already replaced mysql server with the "stable" version.
I have some other webpages running on that same machine, which also use mysql as the database backend, and they all keep running.

mrfantasy
2007-09-13, 07:12
A "me too" on this one. I've seen either the web interface just hang (and the Squeezebox interface keep working) or the Squeezebox interface fail--with weird things like hitting the right arrow on "Now Playing" shows a black screen (not just "Nothing") and going to "Browse" and right-arrowing brings up "Browse" again like some sort of loop.

I too am running Debian--testing, with a nightly SS build from a few days ago:

SlimServer Version: 6.5.5 - 12923 - Debian - EN - utf8
Server IP address: 192.168.11.9
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.45-Debian_1

Doing an /etc/init.d/slimserver restart seems to clear it up. The system mysql server has been starting up on startup as well as the slimserver-specific instance. I've stopped the system instance and I'll see if that changes the behavior.

There was nothing unusual in the SlimServer's MySQL log files. I'm also seeing "MySQL server has gone away" messages in the SlimServer logs. Next time I will try making a socket connection to the MySQL instance manually and see what happens.

seerdekens
2007-09-13, 13:06
Yes, these are exactly the same symptoms I'm facing.
Also some kind of loop when browsing artists, albums, ...

I kind of 'worked around'this by restarting slimserver via cron, but sometimes the server crashes more than once a day :(

SlimServer Version: 6.5.5 - 12607 - Debian - EN - iso-8859-1
Server IP address: 192.168.1.200
Perl Version: 5.8.8 i486-linux-gnu-thread-multi
MySQL Version: 5.0.32-Debian_7etch1

I also had this problem with the previous Debian release 6.5.4 - 12382 .
Did you recently upgrade some debian packaged via apt-get upgrade?

pedalvet
2007-09-23, 15:31
I'm having some similar problems (I think).

When trying to load the web interface, my browser (Firefox) just says "loading". The page never fully loads.

sql log says this (it's all Greek to me):

2007-09-23 18:24:29.7880 ERROR: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_fc4_0.MYI' (Errcode: 17) at C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-09-23 18:24:29.7882 ERROR: Backtrace follows:

2007-09-23 18:24:29.7886 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 4: DBIx::Class::ResultSet::next (C:\PROGRA~1\SLIMSE~1\server/Plugins/LazySearch2.pm line 2404)
frame 5: Plugins::LazySearch2::encodeTask (/<C:\PROGRA~1\SLIMSE~1\server\slim.exe>Slim/Utils/Scheduler.pm line 137)
frame 6: (eval) (/<C:\PROGRA~1\SLIMSE~1\server\slim.exe>Slim/Utils/Scheduler.pm line 137)
frame 7: Slim::Utils::Scheduler::run_tasks (slimserver.pl line 483)
frame 8: main::idle (slimserver.pl line 452)
frame 9: main::main (slimserver.pl line 65)
frame 10: PerlSvc::Interactive (perlsvc line 854)
frame 11: PerlSvc::_interactive (slimserver.pl line 0)
frame 12: (eval) (slimserver.pl line 0)

2007-09-23 18:24:29.7890 Scheduled task failed: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_fc4_0.MYI' (Errcode: 17) at C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

mherger
2007-09-24, 00:32
> failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_fc4_0.MYI'
> (Errcode: 17) at

There's a known issue with McAfee antivirus which is blocking access to this file type. If you happen to use it (or any other antivirus program) make it ignore *.my* extensions and restart slimserver.

Michael

seerdekens
2007-09-24, 01:13
See my solution at http://forums.slimdevices.com/showthread.php?t=37932

I suffered from the issue described at this post, ass well from the issue described at http://forums.slimdevices.com/showthread.php?t=37932.
My solution solved both of the problems.

Regards,
Steven
please leave a note if successful.

pedalvet
2007-09-24, 04:19
> failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_fc4_0.MYI'
> (Errcode: 17) at

There's a known issue with McAfee antivirus which is blocking access to this file type. If you happen to use it (or any other antivirus program) make it ignore *.my* extensions and restart slimserver.

Michael

That sounds promising. Will try tonight and let you know how it works.

seerdekens
2007-09-24, 04:23
I had exactly the same symptoms, but deffenitely not caused by mcafee.
Try restarting slimserver, and see if the page loads. If yes, try my solution.

mherger
2007-09-24, 04:31
> I had exactly the same symptoms, but deffenitely not caused by mcafee.

It's not about the symptoms, but about the very specific error message.

Michael

bpa
2007-09-24, 04:47
Aren't there two problems
- seerdekens on Debian has a Perl issue
- pedalvet on Windows has a virus checker issue.

pedalvet
2007-09-25, 05:47
> failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_fc4_0.MYI'
> (Errcode: 17) at

There's a known issue with McAfee antivirus which is blocking access to this file type. If you happen to use it (or any other antivirus program) make it ignore *.my* extensions and restart slimserver.

Michael

Well, I completely uninstalled my antivirus (which I hated anyway) and still get the same error:

execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_154_0.MYD' (Errcode: 17)

The web interface doesn't respond normally (just hangs at "loading"). Any other ideas?

I do think this is different than the Debian issue Seerdekans is talking about, as I'm not running debian (thanks for the help though, Seerdekans!)

mherger
2007-09-25, 06:24
> execute failed: Can't create/write to file
> 'C:\WINDOWS\TEMP\#sql_154_0.MYD' (Errcode: 17)

Please make sure c:\window\temp does exist. That's a temporary folder - try to clean it up. Pretty often you can find hundreds of orphaned files in there.

> The web interface doesn't respond normally (just hangs at "loading").
> Any other ideas?

As long as you get the above error message don't even expect it to work.

Michael