I have run SqueezeCenter for more than two years, and the system was running extremely well. Then at some point a couple of months ago, the update performance of SqueezeCenter on my client became dramatically worse. I am running the Fishbone skin, although I see the same problem with Default. When I enter or delete tracks from the playlist, the update may take more than a minute, and the playlist will be blank for most of the time. Either or both of "CONNECTING..." and "LOADING..." will be displayed at the top of the Playlist pane. The upper data in the Playlist pane is usually delayed by a few minutes, and the Artist displayed is often several tracks behind. Switching pages in the Album or Artist pane can also take 15-60 seconds.
I am running SC on an HP MediaSmart server, which runs Windows Home Server. My main client is a Dell Latitude D610, and everything including the SqueezeBox is connected over a 100MB wired Ethernet network. I have seen the same performance problems from another identical Dell machine, and also running the browser directly on the Server using Remote Desktop. I have had some problems with ports dying on my Ethernet switch, so I replaced it with a new one to no effect. For a few days quite a while ago I noticed that there would occasionally be a 10-20 second delay at the start of a track, which I assume was the buffer of the SB filling, but that went away before I changed anything else. I generally run IE7 on the Client machine and on the Server, but I have also tried Safari on the Client, which is a little faster but still much worse than IE7 used to be. All of this (particularly the poor performance running the browser on the Server itself) leads me to believe that the problem is in the SC software and not the network. I was running SC 7.0 when this started. I have since tried 7.1 and am currently running a Beta of 7.2 - 22343, but none of the software changes have made any difference. Each time I performed a complete removal of the oldversion before installing. When I decided to debug this problem, I looked at the log file. I noticed that I get the following sequence of Error messages every few seconds to every few minutes (the spacing is much greater when music isn't streaming, but the errors still occur every hour or so). There are a large number of "frame" lines with more data after the second of these three error messages, which I believe is the "backtrace". This varies in length, from 17 to 46 lines. [08-08-18 13:29:43.0037] Slim::Schema::Storage::throw_exception (70) 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_7dc_0.MYI' (Errcode: 13) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-08-18 13:29:43.0044] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 3: DBIx::Class::Storage::DBI::_select (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 118) frame 4: DBIx::Class::Storage::DBI::Cursor::all (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/ResultSet.pm line 945) frame 5: DBIx::Class::ResultSet::all (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Track.pm line 415) frame 6: Slim::Schema::Track::displayAsHTML (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Web/Pages/Playlist.pm line 173) frame 7: Slim::Web::Pages::Playlist::playlist (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Web/Pages/Status.pm line 158) frame 8: Slim::Web::Pages::Status::status (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Web/HTTP.pm line 1101) frame 9: Slim::Web::HTTP::generateHTTPResponse (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Web/HTTP.pm line 969) frame 10: Slim::Web::HTTP::processURL (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Web/HTTP.pm line 780) frame 11: Slim::Web::HTTP::processHTTP (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Networking/IO/Select.pm line 248) frame 12: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Networking/IO/Select.pm line 248) frame 13: Slim::Networking::IO::Select::select (slimserver.pl line 514) frame 14: main::idle (slimserver.pl line 464) frame 15: main::main (slimserver.pl line 90) frame 16: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99) frame 17: PerlSvc::_interactive (slimserver.pl line 0) frame 18: (eval) (slimserver.pl line 0) [08-08-18 13:29:43.0063] Slim::Networking::IO::Select::select (250) Error: Select 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_7dc_0.MYI' (Errcode: 13) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. I also get a few similar sets of errors much less frequently. The error in the third message is different but obviously the cause is the same, since the other two lines and the frames look just the same. At some point, which seemed after this began but may not have been, an automatic update to the HP Server installed an add-in called Pvconnect. This device steals port 9000 from SC (there are other threads about this). When SC stopped working, I removed Pvconnect completely, but it may be related to this. Does anyone have any ideas? I have no way to interpret the error messages. Thanks. -- steves4567 ------------------------------------------------------------------------ steves4567's Profile: http://forums.slimdevices.com/member.php?userid=14390 View this thread: http://forums.slimdevices.com/showthread.php?t=51233 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
