SQL Erros, JSON Errors, Please help debug.

[rhd premium]

rhd premium

25. Juni 2019 at 18:06 #45939

Hi Guys,
I am having issues that generally appear once I select Spotify in LMS. I am running 7.9.1 as well. The entire LMS application seems to slow to a crawl and become unresponsive. I have posted the log below as I have no idea where to start to debug the various issues. Can you please assist in helping me to debug all this?
Thanks,
Ross

2019-06-24 18:26:59 squeezeboxserver_safe stopped.
2019-06-24 18:27:06 squeezeboxserver_safe started.
[19-06-24 18:27:10.6084] main::init (387) Starting Logitech Media Server (v7.9.1, 1522157629, Fri Mar 30 12:27:11 CEST 2018) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
[19-06-24 18:27:12.5531] Slim::Utils::IPDetect::_init (140) Warning: Couldn’t call connect() – falling back to 127.0.0.1
[19-06-24 18:27:16.7958] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuesort.sql : No such file or directory
[19-06-24 18:27:16.7974] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_extravalue.sql : No such file or directory
[19-06-24 18:27:16.7992] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuetype.sql : No such file or directory
[19-06-24 18:27:17.9305] Slim::Web::JSONRPC::requestMethod (455) b8:27:eb:cc:e6:91: request not dispatchable!
[19-06-24 18:27:28.1854] Slim::Web::JSONRPC::requestMethod (455) b8:27:eb:cc:e6:91: request not dispatchable!
2019-06-24 18:32:45 squeezeboxserver_safe stopped.
2019-06-24 18:33:36 squeezeboxserver_safe started.
[19-06-24 18:33:40.2191] main::init (387) Starting Logitech Media Server (v7.9.1, 1522157629, Fri Mar 30 12:27:11 CEST 2018) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
[19-06-24 18:33:44.1291] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuesort.sql : No such file or directory
[19-06-24 18:33:44.1305] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_extravalue.sql : No such file or directory
[19-06-24 18:33:44.1318] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuetype.sql : No such file or directory
[19-06-24 18:33:45.1629] Slim::Control::Request::renderAsArray (2233) Error: request should set useIxHashes in Slim::Control::Request->new()
[19-06-24 18:33:45.1640] Slim::Control::Request::renderAsArray (2233) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Control/Request.pm line 2233)
frame 1: Slim::Control::Request::renderAsArray (/usr/share/perl5/Slim/Plugin/CLI/Plugin.pm line 697)
frame 2: Slim::Plugin::CLI::Plugin::cli_request_write (/usr/share/perl5/Slim/Plugin/CLI/Plugin.pm line 1010)
frame 3: Slim::Plugin::CLI::Plugin::cli_subscribe_notification (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 4: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 5: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 859)
frame 6: Slim::Control::Request::checkNotifications (/usr/sbin/squeezeboxserver line 708)
frame 7: main::idle (/usr/sbin/squeezeboxserver line 677)
frame 8: main::main (/usr/sbin/squeezeboxserver line 1213)

2019-06-24 18:33:48 squeezeboxserver_safe stopped.
2019-06-24 18:33:49 squeezeboxserver_safe started.
[19-06-24 18:33:52.5653] main::init (387) Starting Logitech Media Server (v7.9.1, 1522157629, Fri Mar 30 12:27:11 CEST 2018) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
[19-06-24 18:33:55.0059] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuesort.sql : No such file or directory
[19-06-24 18:33:55.0073] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_extravalue.sql : No such file or directory
[19-06-24 18:33:55.0086] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn’t open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuetype.sql : No such file or directory
[19-06-24 18:41:09.3310] Plugins::Spotty::API::__ANON__ (1482) API call: browse/featured-playlists?country=US&limit=50&locale=en_US×tamp=2019-06-24T18%3A40%3A00
[19-06-24 18:41:09.3324] Plugins::Spotty::API::__ANON__ (1486) error: Connect timed out:
[19-06-24 18:41:09.3694] Slim::Web::Template::SkinManager::_fillTemplate (337) Error: file error – recursion into ‚/usr/share/squeezeboxserver/HTML/Default/xmlbrowser.html‘

#### PERL VERSION ####
v5.20.2

[rhd premium]

rhd premium

25. Juni 2019 at 18:18 #45940

Lets hold off debugging this until I remove the various plug-ins indicated as having errors. I dont need them and I assume it will make things easier to remove first.
Thanks you,
RHD

[Heiner premium]

Heiner premium

27. Juni 2019 at 10:18 #45949

Hi RHD,

Most of theses errors are negligible as they refer to missing connections when a service is still starting or restarting. Deactivating plugins should not be necessary, so make sure you do not deactivate anything vital. Check your Max2Play’s Health Checker, it might be that the LMS was just indexing your library which takes some time and a lot of load off the Pi’s CPU. But once it’s done, this should go down.