PDA

View Full Version : Slimserver 6.1.1 crashing



montel
2005-07-29, 09:14
I'm running slimserver 6.1.1 on my mac G5, running OSX 10.4.2. Everyday, I find the squeezebox active, but unable to play any songs until I stop and restart slimserver. This seems to happen when the server has been idle for several hours. I do a nightly rescan, which may or may not affect this situation.

Today I found the same situation--squeezebox active, but unable to play any songs. I tried to stop the server using the preference pane, but it hung. I found the following info in the slimserver log. I'm seeing a lot of database errors in the log--mostly commit errors. Can anyone help me make sense of this?

Monte

2005-07-29 09:00:50.6601 Got sigterm.
2005-07-29 09:00:50.6892 SlimServer cleaning up.
DBD::SQLite::db commit failed: cannot commit transaction - SQL statements in progress(1) at dbdimp.c line 217 at /Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/DataStores/DBI/DBIStore.pm line 780.
2005-07-29 09:00:50.7671 Whoops! prepare_cached() or execute() failed on sql: [SELECT DISTINCT tracks.id AS id,tracks.album AS album,tracks.url AS url,tracks.multialbumsortkey AS multialbumsortkey,tracks.ct AS ct FROM tracks WHERE ( tracks.url like ? ) ORDER BY tracks.titlesort] - [DBD::SQLite::db commit failed: cannot commit transaction - SQL statements in progress(1) at dbdimp.c line 217 at /Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/DataStores/DBI/DBIStore.pm line 780.
]
2005-07-29 09:00:50.7676 Backtrace:

frame 0: Slim::DataStores::DBI::DataModel::find (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/DataStores/DBI/DBIStore.pm line 237)
frame 1: Slim::DataStores::DBI::DBIStore::find (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/DataStores/DBI/DBIStore.pm line 839)
frame 2: Slim::DataStores::DBI::DBIStore::getInternalPlayli sts (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Web/Pages.pm line 548)
frame 3: Slim::Web::Pages::__ANON__ (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Buttons/BrowseDB.pm line 499)
frame 4: Slim::Buttons::BrowseDB::setMode (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Buttons/Common.pm line 1079)
frame 5: Slim::Buttons::Common::pushMode (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Buttons/Common.pm line 1136)
frame 6: Slim::Buttons::Common::pushModeLeft (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Buttons/Home.pm line 391)
frame 7: Slim::Buttons::Home::homeExitHandler (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Buttons/Input/List.pm line 307)
frame 8: Slim::Buttons::Input::List::exitInput (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Buttons/Input/List.pm line 65)
frame 9: Slim::Buttons::Input::List::__ANON__ (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Hardware/IR.pm line 662)
frame 10: Slim::Hardware::IR::executeButton (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Control/Command.pm line 603)
frame 11: Slim::Control::Command::execute (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Player/Client.pm line 999)
frame 12: Slim::Player::Client::execute (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Hardware/IR.pm line 675)
frame 13: Slim::Hardware::IR::processCode (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Hardware/IR.pm line 493)
frame 14: Slim::Hardware::IR::processIR (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Control/Command.pm line 603)
frame 15: Slim::Control::Command::execute (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Player/Client.pm line 999)
frame 16: Slim::Player::Client::execute (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Hardware/IR.pm line 88)
frame 17: Slim::Hardware::IR::idle (./slimserver.pl line 613)
frame 18: main::idle (./slimserver.pl line 579)
frame 19: main::main (./slimserver.pl line 1175)

prepare_cached(SELECT DISTINCT tracks.id AS id,tracks.album AS album,tracks.url AS url,tracks.multialbumsortkey AS multialbumsortkey,tracks.ct AS ct FROM tracks WHERE ( tracks.url like ? ) ORDER BY tracks.titlesort) statement handle DBIx::ContextualFetch::st=HASH(0x48516a0) still Active at /Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/DataStores/DBI/DataModel.pm line 639