Server crashing since upgrading to 6.1.1/6.1.2

[James Dunn]

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: root@localhost
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
(/usr/local/SlimServer_v6.1.1/Slim/Web/Pages.pm line 429)
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:53.6454 Whoops! prepare_cached() or execute() failed on
sql: [SELECT DISTINCT genres.id AS id,genres.name AS name,genres.namesort AS
namesort,genres.moodlogic_id AS moodlogic_id,gen
res.moodlogic_mixable AS moodlogic_mixable,genres.musicmagic_mixable AS
musicmagic_mixable FROM genres ORDER BY genres.namesort] - [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:53.6465 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 186)
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.
Slim::DataStores::DBI::LightWeightTrack can't SELECT id, album, url,
multialbumsortkey, ct
FROM tracks
WHERE url = ?
: DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/SlimServer_v6.1.1/CPAN/DBIx/ContextualFetch.pm line 51.
at /usr/local/SlimServer_v6.1.1/Slim/DataStores/DBI/DBIStore.pm line 987
DBD::mysql::db do failed: MySQL server has gone away at
/usr/local/SlimServer_v6.1.1/Slim/DataStores/DBI/DataModel.pm line 235.
DBD::mysql::db do failed: MySQL server has gone away at
/usr/local/SlimServer_v6.1.1/Slim/DataStores/DBI/DataModel.pm line 235.
END failed--call queue aborted.
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/SlimServer_6_1_x_v2005-07-24/CPAN/DBIx/ContextualFetch.pm line
51.
2005-07-25 10:25:21.2619 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_6_1_x_v2005-07-24/CPAN/DBIx/ContextualFetch.pm line
51.
]
2005-07-25 10:25:21.2633 Backtrace:

frame 0: Slim::DataStores::DBI::DataModel::find
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/DataStores/DBI/DBIStore.pm
line 237)
frame 1: Slim::DataStores::DBI::DBIStore::find
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Web/Pages.pm line 252)
frame 2: Slim::Web::Pages::__ANON__
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Buttons/BrowseDB.pm line 499)
frame 3: Slim::Buttons::BrowseDB::setMode
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Buttons/Common.pm line 1079)
frame 4: Slim::Buttons::Common::pushMode
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Buttons/Common.pm line 1136)
frame 5: Slim::Buttons::Common::pushModeLeft
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Buttons/Home.pm line 391)
frame 6: Slim::Buttons::Home::homeExitHandler
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Buttons/Input/List.pm line
307)
frame 7: Slim::Buttons::Input::List::exitInput
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Buttons/Input/List.pm line 65)
frame 8: Slim::Buttons::Input::List::__ANON__
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Hardware/IR.pm line 662)
frame 9: Slim::Hardware::IR::executeButton
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Control/Command.pm line 603)
frame 10: Slim::Control::Command::execute
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Player/Client.pm line 999)
frame 11: Slim::Player::Client::execute
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Hardware/IR.pm line 675)
frame 12: Slim::Hardware::IR::processCode
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Hardware/IR.pm line 493)
frame 13: Slim::Hardware::IR::processIR
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Control/Command.pm line 603)
frame 14: Slim::Control::Command::execute
(/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/Player/Client.pm line 999)
frame 15: Slim::Player::Client::execute
(/usr/local/SlimServer_6_1_x_v2005-07-24/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_6_1_x_v2005-07-24/CPAN/DBIx/ContextualFetch.pm line
51.
Slim::DataStores::DBI::LightWeightTrack can't SELECT id, album, url,
multialbumsortkey, ct
FROM tracks
WHERE url = ?
: DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/SlimServer_6_1_x_v2005-07-24/CPAN/DBIx/ContextualFetch.pm line
51.
at /usr/local/SlimServer_6_1_x_v2005-07-24/Slim/DataStores/DBI/DBIStore.pm
line 987
DBD::mysql::db do failed: MySQL server has gone away at
/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/DataStores/DBI/DataModel.pm
line 235.
DBD::mysql::db do failed: MySQL server has gone away at
/usr/local/SlimServer_6_1_x_v2005-07-24/Slim/DataStores/DBI/DataModel.pm
line 235.
END failed--call queue aborted.
[root@herbie tmp]#

[kdf]

Quoting James Dunn <james.dunn (AT) hedgehog-house (DOT) co.uk>:

> 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
99999 will also force a rebuild, and hopefully avoid the crashes that you see.

-kdf

[James Dunn]

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: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com] 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 <james.dunn (AT) hedgehog-house (DOT) co.uk>:

> 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
99999 will also force a rebuild, and hopefully avoid the crashes that you
see.

-kdf

[James Dunn]

Hi kdf,

I'm afraid that hasn't worked either. Whilst it worked at first the database
still drops and the server shows "Empty" for all non-directory browsing
before eventually crashing at the same code point as before.

I know MySQL isn't properly supported so I can live with 6.02 for now unless
I'm offered any other suggestions.

Cheers,

James

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
99999 will also force a rebuild, and hopefully avoid the crashes that you
see.

-kdf

[Dan Sully]

* James Dunn shaped the electrons to say...

>I'm afraid that hasn't worked either. Whilst it worked at first the database
>still drops and the server shows "Empty" for all non-directory browsing
>before eventually crashing at the same code point as before.
>
>I know MySQL isn't properly supported so I can live with 6.02 for now unless
>I'm offered any other suggestions.

This is bug http://bugs.slimdevices.com/show_bug.cgi?id=947

-D
--
vacation (n) : an extended trip away from home in search of inconvenient ways to connect to the Internet.