[SOLVED] Problems with Erland Isaksson plugins – Squeezebox Server 7.9

Max2Play Home 2016 (en) Forums Max2Play as Squeezebox (Player / Server) [SOLVED] Problems with Erland Isaksson plugins – Squeezebox Server 7.9

This topic contains 3 replies, has 2 voices, and was last updated by  Mbydeen 9 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • 16. February 2017 at 12:53 #26952

    Hi – adding in Erland’s great plugins causes LMS to misbehave severely. Something along these lines

    [17-02-16 11:28:05.6187] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement “CREATE TABLE multilibrary_track (library int(10) not null,track int(10) not null,primary key (library,track));”]
    [17-02-16 11:28:05.6207] Slim::Schema::Storage::throw_exception (122) Backtrace:

    frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
    frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
    frame 2: DBIx::Class::Storage::DBI::__ANON__ (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
    frame 3: (eval) (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
    frame 4: Plugins::MultiLibrary::Plugin::executeSQLFile (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1283)
    frame 5: Plugins::MultiLibrary::Plugin::initDatabase (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 857)
    frame 6: Plugins::MultiLibrary::Plugin::initPlugin (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
    frame 7: (eval) (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
    frame 8: Slim::Utils::PluginManager::load (/usr/sbin/squeezeboxserver line 598)
    frame 9: main::init (/usr/sbin/squeezeboxserver line 676)
    frame 10: main::main (/usr/sbin/squeezeboxserver line 1214)

    [17-02-16 11:28:05.6227] Slim::Utils::Misc::msg (1244) Warning: [11:28:05.6215] Couldn’t execute SQL statement: [CREATE TABLE multilibrary_track (library int(10) not null,track int(10) not null,primary key (library,track));] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement “CREATE TABLE multilibrary_track (library int(10) not null,track int(10) not null,primary key (library,track));”] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
    ]
    [17-02-16 11:28:09.5127] Slim::Utils::PluginManager::shutdownPlugins (410) Warning: error running Slim::Plugin::UPnP::Plugin->shutdownPlugin: Can’t locate object method “shutdown” via package “Slim::Plugin::UPnP::MediaServer” at /usr/share/perl5/Slim/Plugin/UPnP/Plugin.pm line 57, <$fh> line 35.
    2017-02-16 11:28:09 squeezeboxserver_safe started.
    [17-02-16 11:28:20.9533] main::init (388) Starting Logitech Media Server (v7.9.0, 1487144914, Wed Feb 15 08:29:20 UTC 2017) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
    [17-02-16 11:28:38.7958] Slim::Utils::Misc::msg (1244) Warning: [11:28:38.7941] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 1877
    [17-02-16 11:28:56.7190] Slim::Utils::Misc::msg (1244) Warning: [11:28:56.7173] MultiLibrary: Creating database tables
    [17-02-16 11:28:56.7405] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: table multilibrary_libraries already exists [for Statement “CREATE TABLE multilibrary_libraries (id INTEGER PRIMARY KEY AUTOINCREMENT,libraryid varchar(255) not null,name varchar(255) not null);”]
    [17-02-16 11:28:56.7430] Slim::Schema::Storage::throw_exception (122) Backtrace:

    frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
    frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
    frame 2: DBIx::Class::Storage::DBI::__ANON__ (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
    frame 3: (eval) (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
    frame 4: Plugins::MultiLibrary::Plugin::executeSQLFile (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1283)
    frame 5: Plugins::MultiLibrary::Plugin::initDatabase (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 857)
    frame 6: Plugins::MultiLibrary::Plugin::initPlugin (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
    frame 7: (eval) (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
    frame 8: Slim::Utils::PluginManager::load (/usr/sbin/squeezeboxserver line 598)
    frame 9: main::init (/usr/sbin/squeezeboxserver line 676)
    frame 10: main::main (/usr/sbin/squeezeboxserver line 1214)

    [17-02-16 11:28:56.7456] Slim::Utils::Misc::msg (1244) Warning: [11:28:56.7441] Couldn’t execute SQL statement: [CREATE TABLE multilibrary_libraries (id INTEGER PRIMARY KEY AUTOINCREMENT,libraryid varchar(255) not null,name varchar(255) not null);] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: table multilibrary_libraries already exists [for Statement “CREATE TABLE multilibrary_libraries (id INTEGER PRIMARY KEY AUTOINCREMENT,libraryid varchar(255) not null,name varchar(255) not null);”] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
    ]
    2017-02-16 11:34:11 squeezeboxserver_safe stopped.
    2017-02-16 11:34:11 squeezeboxserver_safe started.
    [17-02-16 11:34:18.2769] main::init (388) Starting Logitech Media Server (v7.9.0, 1487144914, Wed Feb 15 08:29:20 UTC 2017) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
    [17-02-16 11:34:20.6946] Slim::Utils::Misc::msg (1244) Warning: [11:34:20.6933] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 1877
    2017-02-16 11:35:26 squeezeboxserver_safe stopped.
    2017-02-16 11:35:26 squeezeboxserver_safe started.
    [17-02-16 11:35:33.9145] main::init (388) Starting Logitech Media Server (v7.9.0, 1487144914, Wed Feb 15 08:29:20 UTC 2017) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
    [17-02-16 11:35:37.4482] Slim::Utils::Misc::msg (1244) Warning: [11:35:37.4468] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 1877

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

    latest max2play and latest 7.9 nightly build

    16. February 2017 at 15:19 #26957

    Dear snaillybob,

    Please can you specify which Erland Isaksson plugin exactly you are trying to add to Squeezebox server ?

    Best Regards,
    Mohammad Mbydeen

    16. February 2017 at 21:14 #26998

    Custom browse and multi library. Would like to use trackstat and the associated dynamic playlist, but they are SQL based as well.

    20. February 2017 at 13:02 #27035

    Hi snaillybob,

    Please make sure that the plugins are up to date and compatible with the latest version of SBS, and if you have any problem, you can contact the developer on:

    erland’s Profile: http://forums.slimdevices.com/member.php?userid=3124
    Erland Isaksson: http://erland.isaksson.info

    Regards,
    Mohammad

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

Register here