Versions: Logitech Media Server Version: 7.7.5 - 1416570306 @ Thu Nov 27 07:38:09 CUT 2014 Operating system: Windows 8 - NB - cp1252 Platform Architecture: 8664 Perl Version: 5.14.1 - MSWin32-x86-multi-thread Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Starting yesterday, LMS started failing for me. The web page opens but nothing plays: - Clicking on the current songs in the active playlist, nothing happens - The TIDAL plugin doesn't open - In the triode spotify plugin, only the top level opens - The iTunes library is empty Below are the LMS log messages from the time LMS started failing. If I'm to guess I would say that it looks like a database corruption. Is this repairable? Or is the only fix to move away the current database and do a new media scan and re-add the spotify and tidal configuration? Or is the latter stored on mysqueezebox.com so that all I have to do after regenerating the database, is to reconnect to mysqueezebox.com? All comments and hints and tips are appreciated! Thanks! - Steinar Log fragment from the LMS server.log follows: [16-12-24 17:48:28.3935] Slim::Control::XMLBrowser::_cliQuery_error (1666) Error: While retrieving [http://www.mysqueezebox.com/api/wimp/v1/opml]: [A mysqueezebox.com account is required for this service. Please access Logitech Media Server Settings -> mysqueezebox.com with a web browser to configure.] [16-12-24 17:49:40.8497] Slim::Control::XMLBrowser::_cliQuery_error (1666) Error: While retrieving [http://www.mysqueezebox.com/api/wimp/v1/opml]: [A mysqueezebox.com account is required for this service. Please access Logitech Media Server Settings -> mysqueezebox.com with a web browser to configure.] [16-12-24 17:51:23.8035] Slim::Web::JSONRPC::requestWrite (472) Context not found in requestWrite!!!! [16-12-24 17:51:49.3072] Slim::Web::JSONRPC::requestWrite (472) Context not found in requestWrite!!!! [16-12-25 08:10:32.8251] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectrow_array failed: near ")": syntax error [for Statement " SELECT COUNT(*) FROM ( SELECT videos.titlesearch AS 'videos.titlesearch', videos.hash AS 'videos.hash', videos.title AS 'videos.title', videos.titlesort AS 'videos.titlesort' FROM videos GROUP BY videos.hash ORDER BY videos.titlesort COLLATE ) AS t1 "] [16-12-25 08:10:32.8256] Slim::Schema::Storage::throw_exception (122) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/Storage.pm line 122) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Queries.pm line 5181) frame 3: Slim::Control::Queries::videoTitlesQuery (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Request.pm line 1884) frame 4: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Request.pm line 1884) frame 5: Slim::Control::Request::execute (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Request.pm line 881) frame 6: Slim::Control::Request::executeRequest (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/SystemInfo.pm line 278) frame 7: Slim::Menu::SystemInfo::infoLibrary (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/Base.pm line 172) frame 8: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/Base.pm line 172) frame 9: Slim::Menu::Base::addItem (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/Base.pm line 142) frame 10: Slim::Menu::Base::menu (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/Settings/Server/Status.pm line 33) frame 11: Slim::Web::Settings::Server::Status::handler (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 1128) frame 12: Slim::Web::HTTP::generateHTTPResponse (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 930) frame 13: Slim::Web::HTTP::processURL (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 734) frame 14: Slim::Web::HTTP::processHTTP (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 139) frame 15: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 123) frame 16: Slim::Networking::IO::Select::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 184) frame 17: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 184) frame 18: Slim::Networking::IO::Select::loop (slimserver.pl line 694) frame 19: main::idle (slimserver.pl line 59) frame 20: PerlSvc::Startup (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>PerlSvc.pm line 95) frame 21: PerlSvc::_startup (slimserver.pl line 0) frame 22: (eval) (slimserver.pl line 0) [16-12-25 08:10:32.8619] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::videoTitlesQuery]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectrow_array failed: near ")": syntax error [for Statement " SELECT COUNT(*) FROM ( SELECT videos.titlesearch AS 'videos.titlesearch', videos.hash AS 'videos.hash', videos.title AS 'videos.title', videos.titlesort AS 'videos.titlesort' FROM videos GROUP BY videos.hash ORDER BY videos.titlesort COLLATE ) AS t1 "] at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/Storage.pm line 126 ] [16-12-25 08:10:32.8628] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectrow_array failed: near ")": syntax error [for Statement " SELECT COUNT(*) FROM ( SELECT images.hash AS 'images.hash', images.title AS 'images.title', images.titlesearch AS 'images.titlesearch', images.titlesort AS 'images.titlesort' FROM images GROUP BY images.hash ORDER BY images.titlesort COLLATE ) AS t1 "] [16-12-25 08:10:32.8631] Slim::Schema::Storage::throw_exception (122) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/Storage.pm line 122) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Queries.pm line 5437) frame 3: Slim::Control::Queries::imageTitlesQuery (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Request.pm line 1884) frame 4: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Request.pm line 1884) frame 5: Slim::Control::Request::execute (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Control/Request.pm line 881) frame 6: Slim::Control::Request::executeRequest (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/SystemInfo.pm line 289) frame 7: Slim::Menu::SystemInfo::infoLibrary (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/Base.pm line 172) frame 8: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/Base.pm line 172) frame 9: Slim::Menu::Base::addItem (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Menu/Base.pm line 142) frame 10: Slim::Menu::Base::menu (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/Settings/Server/Status.pm line 33) frame 11: Slim::Web::Settings::Server::Status::handler (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 1128) frame 12: Slim::Web::HTTP::generateHTTPResponse (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 930) frame 13: Slim::Web::HTTP::processURL (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Web/HTTP.pm line 734) frame 14: Slim::Web::HTTP::processHTTP (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 139) frame 15: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 123) frame 16: Slim::Networking::IO::Select::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 184) frame 17: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Networking/IO/Select.pm line 184) frame 18: Slim::Networking::IO::Select::loop (slimserver.pl line 694) frame 19: main::idle (slimserver.pl line 59) frame 20: PerlSvc::Startup (/<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>PerlSvc.pm line 95) frame 21: PerlSvc::_startup (slimserver.pl line 0) frame 22: (eval) (slimserver.pl line 0) ... _______________________________________________ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter