Re: [slim] Server crashing randomly near beginninn of Music Magic Playlist
It took a while to be sure since the crash wasn't completely reliable. The exclusions in Mcaffee were a pain in the butt, and didn't seem to work with most settings attempted. Also the damn application has a nasty habit of re-enabling itself some time after being disabled. But it worked in the end. I appreciate the help. Paul -- Paul W Panish Paul W Panish's Profile: http://forums.slimdevices.com/member.php?userid=5295 View this thread: http://forums.slimdevices.com/showthread.php?t=31982 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Server crashing randomly near beginninn of Music Magic Playlist
I'm running SlimServer 6.5.1 - 11059 - Windows XP - EN - cp1252 on Windows XP Pro SP2. I'm seeing crashes at random in different playlists generated using the Music Magic plugin. It usually crashes in the first few minutes, and after restarting the service, and picking up at the same place in the playlist, everything is fine. Contents of the event log are as follows: The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable, 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_73c_0.MYI' (Errcode: 13) at C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. . I've tried turning on different debug modules, but everything seems to get lost in the crash. -- Paul W Panish Paul W Panish's Profile: http://forums.slimdevices.com/member.php?userid=5295 View this thread: http://forums.slimdevices.com/showthread.php?t=31982 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Server crashing since upgrading to 6.1.1/6.1.2
Hi, Since upgrading from 6.0.2 I've suffered regular Slimserver crashes. I've tried the latest 24/7 nightly with no improvement. I think the output logs below shows the cause; the database connection is being lost for some reason (although it was never lost on 6.0.2). I don't think it's MySQL server problems as this hasn't changed. The same pm seems to be used whenever it fails so I guess there may be a common cause To make things worse, whenever I restart the server a full rescan is performed and the slimp3s are unusable for about 1/ hr as the scanning takes about 90% of the CPU. Thanks for any help you can offer. Cheers, James Background info: MySQL status mysql status -- ./mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686) Connection id: 16 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Using delimiter:; Server version: 4.1.10a-standard Protocol version: 10 Connection: Localhost via UNIX socket Server characterset:latin1 Db characterset:latin1 Client characterset:latin1 Conn. characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 81 days 12 hours 34 min 10 sec Threads: 2 Questions: 155084828 Slow queries: 0 Opens: 128 Flush tables: 1 Open tables: 10 Queries per second avg: 22.018 -- Logs: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/SlimServer_v6.1.1/CPAN/DBIx/ContextualFetch.pm line 51. 2005-07-24 13:44:41.8136 Whoops! prepare_cached() or execute() failed on sql: [SELECT DISTINCT albums.id AS id,albums.title AS title,albums.titlesort AS titlesort,albums.contributors AS contributors ,albums.year AS year,albums.artwork_path AS artwork_path,albums.disc AS disc,albums.discc AS discc,albums.musicmagic_mixable AS musicmagic_mixable FROM albums ORDER BY albums.titlesort, albums.disc ] - [DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/SlimServer_v6.1.1/CPAN/DBIx/ContextualFetch.pm line 51. ] 2005-07-24 13:44:41.8146 Backtrace: frame 0: Slim::DataStores::DBI::DataModel::find (/usr/local/SlimServer_v6.1.1/Slim/DataStores/DBI/DBIStore.pm line 237) frame 1: Slim::DataStores::DBI::DBIStore::find (/usr/local/SlimServer_v6.1.1/Slim/Web/Pages.pm line 252) frame 2: Slim::Web::Pages::__ANON__ (/usr/local/SlimServer_v6.1.1/Slim/Buttons/BrowseDB.pm line 499) frame 3: Slim::Buttons::BrowseDB::setMode (/usr/local/SlimServer_v6.1.1/Slim/Buttons/Common.pm line 1079) frame 4: Slim::Buttons::Common::pushMode (/usr/local/SlimServer_v6.1.1/Slim/Buttons/Common.pm line 1136) frame 5: Slim::Buttons::Common::pushModeLeft (/usr/local/SlimServer_v6.1.1/Slim/Buttons/Home.pm line 391) frame 6: Slim::Buttons::Home::homeExitHandler (/usr/local/SlimServer_v6.1.1/Slim/Buttons/Input/List.pm line 307) frame 7: Slim::Buttons::Input::List::exitInput (/usr/local/SlimServer_v6.1.1/Slim/Buttons/Input/List.pm line 65) frame 8: Slim::Buttons::Input::List::__ANON__ (/usr/local/SlimServer_v6.1.1/Slim/Hardware/IR.pm line 662) frame 9: Slim::Hardware::IR::executeButton (/usr/local/SlimServer_v6.1.1/Slim/Control/Command.pm line 603) frame 10: Slim::Control::Command::execute (/usr/local/SlimServer_v6.1.1/Slim/Player/Client.pm line 999) frame 11: Slim::Player::Client::execute (/usr/local/SlimServer_v6.1.1/Slim/Hardware/IR.pm line 675) frame 12: Slim::Hardware::IR::processCode (/usr/local/SlimServer_v6.1.1/Slim/Hardware/IR.pm line 493) frame 13: Slim::Hardware::IR::processIR (/usr/local/SlimServer_v6.1.1/Slim/Control/Command.pm line 603) frame 14: Slim::Control::Command::execute (/usr/local/SlimServer_v6.1.1/Slim/Player/Client.pm line 999) frame 15: Slim::Player::Client::execute (/usr/local/SlimServer_v6.1.1/Slim/Hardware/IR.pm line 88) frame 16: Slim::Hardware::IR::idle (/usr/local/slimserver/slimserver.pl line 613) frame 17: main::idle (/usr/local/slimserver/slimserver.pl line 579) frame 18: main::main (/usr/local/slimserver/slimserver.pl line 1175) DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/SlimServer_v6.1.1/CPAN/DBIx/ContextualFetch.pm line 51. 2005-07-24 13:44:50.9216 Whoops! prepare_cached() or execute() failed on sql: [SELECT DISTINCT contributors.id AS id,contributors.name AS name,contributors.namesort AS namesort,contributors.moodlogi c_id AS moodlogic_id,contributors.moodlogic_mixable AS moodlogic_mixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM contributors ORDER BY contributors.namesort] - [DBD::mysql::st ex ecute failed: MySQL server has gone away at /usr/local/SlimServer_v6.1.1/CPAN/DBIx/ContextualFetch.pm line 51. ] 2005-07-24 13:44:50.9226 Backtrace: frame 0: Slim::DataStores::DBI::DataModel::find (/usr/local/SlimServer_v6.1.1/Slim/DataStores/DBI/DBIStore.pm line 237) frame 1: Slim::DataStores::DBI::DBIStore::find
RE: [slim] Server crashing since upgrading to 6.1.1/6.1.2
Thanks kdf, I've given that a try. It sometimes takes 12+ hrs to crash so I'll see if it's OK tomorrow; it's running fine right now. BTW - it seems very processor light compared to where it used to be with 6.02. I can't remember actual figures but I'd have thought between 10-30% of 6.02 load. With all players active I was hitting about 50-60% sustained load previously - saves me buying that new server platform! :) Thanks, James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kdf Sent: Monday, July 25, 2005 8:50 PM To: Slim Devices Discussion Subject:Re: [slim] Server crashing since upgrading to 6.1.1/6.1.2 Quoting James Dunn [EMAIL PROTECTED]: Hi, Since upgrading from 6.0.2 I've suffered regular Slimserver crashes. I've tried the latest 24/7 nightly with no improvement. I think the output logs below shows the cause; the database connection is being lost for some reason (although it was never lost on 6.0.2). I don't think it's MySQL server problems as this hasn't changed. The same pm seems to be used whenever it fails so I guess there may be a common cause To make things worse, whenever I restart the server a full rescan is performed and the slimp3s are unusable for about 1/ hr as the scanning takes about 90% of the CPU. try erasing your slimserversql.db file. The mysql version number is incorrect for 6.1.1 (being unsupported, it got left out). Erasing the db file will allow the creation scripts 9which should be corect) to build the proper tables. also, changing the db version number in SQL/Mysql/sql.version to add teh line 9 9 will also force a rebuild, and hopefully avoid the crashes that you see. -kdf ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Server crashing ...
Hi guys I've been using the Slimserver and Softsqueeze player combo for quite a while now with no issues, until recently, because now when I fire up Softsqueeze the server crashes/stops. Having had a good look around for the problem I have to admit defeat, so I'm asking on here for your help. I've D/L and installed the latest Server software, plus Softsqueeze too but the problem still remains. I'm running XP2 BTW. Any help would be appreciated. -- CavesOfTQLT ___ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
