PDA

View Full Version : SqueezeCenter Performance Suddenly Got Worse



steves4567
2008-08-18, 13:14
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.

andyg
2008-08-18, 13:22
Disable your virus scanner and I bet your problems will go away. Then work out how to configure your scanner to ignore the MySQL database files.

http://wiki.slimdevices.com/index.php/Firewalls_and_Antivirus_Software

Ben Sandee
2008-08-18, 13:24
On Mon, Aug 18, 2008 at 3:14 PM, steves4567 <
steves4567.3ecumz1219090501 (AT) no-mx (DOT) forums.slimdevices.com> wrote:

>
> Does anyone have any ideas? I have no way to interpret the error
> messages. Thanks.


Try disabling your virus scanner or set it to exclude MySQL files. It looks
like SqueezeCenter cannot write to the files in the tmp directory. See this
page:

http://wiki.slimdevices.com/index.php/Firewalls_and_Antivirus_Software

Ben

steves4567
2008-08-19, 19:15
Disabling McAfee's On-Access Scanning makes a huge improvement, so that is definitely the source of the problem. Unfortunately, in the MediaSmart I have to have McAfee "Total Protection" asa Virus Scanner, and bizarrely I cannot exclude the filename extension .my* (it won't accept the *). Excluding only .my, .myi and .myd (the only extensions I can find reference to) helps a little, but I assume there are other extensions that doesn't cover. Is there a list somewhere of all the MySQL extensions (if this isn't all of them)? Or could there be other files which are also contributing to this problem?

Thanks so much for your help!!

radish
2008-08-19, 20:53
The ones you listed are the only ones I know of, but there may be others. Personally, I'd also disable scanning for whatever your music files are (*.flac, *.mp3, etc) and maybe even things like *.jpg. I'd also replace a virus scanner which didn't let me set it up the way I wanted :)

steves4567
2008-08-19, 22:41
Excluding *.mp3 and *.jpg seems to get me to about the same place as disabling the scanning completely (I would gess it is primarily the MP3 files). I would get rid of McAfee, but the MediaSmart is a weird system with that built in.

Thanks again - this really helped!!

MeSue
2008-08-20, 06:37
You can uninstall McAfee from the MSS. It is only a 7 month trial anyway. It took only one day of horrible performance before I uninstalled that beast. Even HP admits it causes problems.
http://www.engadget.com/2008/07/29/hp-responds-to-mediasmart-issues-offers-no-real-solution-at-all/

You can remove it through the add-ins part of the console, then put the MSI for it in a subfolder so you won't keep getting nagged to install it.