I understand that the Mysql back-end is not top priority at the moment and may
never be but thought I would post this bug. I am running 6.0 with Mysql 4.1.10a,
the server runs fine but if you leave it for a while (not sure how long,
certainly overnight) when you go to the web interface it crashes the server. It
looks like a problem with the database - reconnect code. Below is the extract
from the log file.

Hope it helps

Scott

~~~~~~~~~~~~~
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/custom/src/SlimServer_v6.0/CPAN/DBIx/ContextualFetch.pm line 51.
2005-04-02 10:43:14.3788 Whoops! prepare_cached() or execute() failed on sql:
[SELECT DISTINCT contributors.id AS id,contributors.na
me AS name,contributors.namesort AS namesort,contributors.moodlogic_id AS
moodlogic_id,contributors.moodlogic_mixable AS moodlogic_m
ixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM
contributor_track, contributors WHERE contributors.id = contributo
r_track.contributor  AND ( contributor_track.role = ? )] - [DBD::mysql::st
execute failed: MySQL server has gone away at /usr/custom
/src/SlimServer_v6.0/CPAN/DBIx/ContextualFetch.pm line 51.
]
2005-04-02 10:43:14.3794 Backtrace:

   frame 0: Slim::DataStores::DBI::DataModel::find
(/usr/custom/src/SlimServer_v6.0/Slim/DataStores/DBI/DBIStore.pm line 244)
   frame 1: Slim::DataStores::DBI::DBIStore::find
(/usr/custom/src/SlimServer_v6.0/Slim/DataStores/DBI/DBIStore.pm line 306)
   frame 2: Slim::DataStores::DBI::DBIStore::count
(/usr/custom/src/SlimServer_v6.0/Slim/Web/Pages.pm line 548)
   frame 3: Slim::Web::Pages::addLibraryStats
(/usr/custom/src/SlimServer_v6.0/Slim/Web/Pages.pm line 497)
   frame 4: Slim::Web::Pages::home
(/usr/custom/src/SlimServer_v6.0/Slim/Web/HTTP.pm line 744)
   frame 5: Slim::Web::HTTP::generateHTTPResponse
(/usr/custom/src/SlimServer_v6.0/Slim/Web/HTTP.pm line 665)
   frame 6: Slim::Web::HTTP::processURL
(/usr/custom/src/SlimServer_v6.0/Slim/Web/HTTP.pm line 529)
   frame 7: Slim::Web::HTTP::processHTTP
(/usr/custom/src/SlimServer_v6.0/Slim/Networking/Select.pm line 115)
   frame 8: Slim::Networking::Select::select
(/usr/local/slimserver/slimserver.pl line 606)
   frame 9: main::idle (/usr/local/slimserver/slimserver.pl line 549)
   frame 10: main::main (/usr/local/slimserver/slimserver.pl line 1111)

DBD::mysql::st execute failed: MySQL server has gone away at
/usr/custom/src/SlimServer_v6.0/CPAN/DBIx/ContextualFetch.pm line 51.
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/custom/src/SlimServer_v6.0/CPAN/DBIx/ContextualFetch.pm line 51.
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/custom/src/SlimServer_v6.0/CPAN/DBIx/ContextualFetch.pm line 51.
2005-04-03 18:46:04.1045 Whoops! prepare_cached() or execute() failed on sql:
[SELECT DISTINCT contributors.id AS id,contributors.na
me AS name,contributors.namesort AS namesort,contributors.moodlogic_id AS
moodlogic_id,contributors.moodlogic_mixable AS moodlogic_m
ixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM
contributor_track, contributors WHERE contributors.id = contributo
r_track.contributor  AND ( contributor_track.role = ? )] - [DBD::mysql::st
execute failed: MySQL server has gone away at /usr/custom
/src/SlimServer_v6.0/CPAN/DBIx/ContextualFetch.pm line 51.
]
2005-04-03 18:46:04.1052 Backtrace:

   frame 0: Slim::DataStores::DBI::DataModel::find
(/usr/custom/src/SlimServer_v6.0/Slim/DataStores/DBI/DBIStore.pm line 244)
   frame 1: Slim::DataStores::DBI::DBIStore::find
(/usr/custom/src/SlimServer_v6.0/Slim/DataStores/DBI/DBIStore.pm line 306)
   frame 2: Slim::DataStores::DBI::DBIStore::count
(/usr/custom/src/SlimServer_v6.0/Slim/Web/Pages.pm line 548)
   frame 3: Slim::Web::Pages::addLibraryStats
(/usr/custom/src/SlimServer_v6.0/Slim/Web/Pages.pm line 497)
   frame 4: Slim::Web::Pages::home
(/usr/custom/src/SlimServer_v6.0/Slim/Web/HTTP.pm line 744)
   frame 5: Slim::Web::HTTP::generateHTTPResponse
(/usr/custom/src/SlimServer_v6.0/Slim/Web/HTTP.pm line 665)
   frame 6: Slim::Web::HTTP::processURL
(/usr/custom/src/SlimServer_v6.0/Slim/Web/HTTP.pm line 529)
   frame 7: Slim::Web::HTTP::processHTTP
(/usr/custom/src/SlimServer_v6.0/Slim/Networking/Select.pm line 115)
   frame 8: Slim::Networking::Select::select
(/usr/local/slimserver/slimserver.pl line 606)
   frame 9: main::idle (/usr/local/slimserver/slimserver.pl line 549)
   frame 10: main::main (/usr/local/slimserver/slimserver.pl line 1111)
~~~~~~~~~~~~~