slimserver: doesn't start

[ChrisOboe]

Nixpkgs version

• Unstable (26.05)

Describe the bug

on nixos-unstable slimserver doesn't start anymore. it crashes with the following message:

Carp::Clan::ANON (221) Warning: Carp::Clan::ANON(): DBI Exception: DBD::SQLite::db prepare_cached failed: no such function: ARRAY [for Statement "SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id, me.extid FROM contributors me WHERE ARRAY(0x55c36194a7c8) = ?"] at /nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/Slim/Schema/Storage.pm line 126

Steps to reproduce

try to start the slimserver service via services.slimserver.enable = true
the service won't start.

Expected behaviour

that the server starts

Screenshots

No response

Relevant log output

Jan 05 17:41:24 chump slimserver[2609746]: [26-01-05 17:41:24.4310] Slim::Schema::Storage::throw_exception (122) Backtrace:
Jan 05 17:41:24 chump slimserver[2609746]:    frame 0: Slim::Utils::Log::logBacktrace (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/Slim/Schema/Storage.pm line 122)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 1: Slim::Schema::Storage::throw_exception (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/CPAN/DBIx/Class/Storage/DBI.pm line 598)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 2: DBIx::Class::Storage::DBI::dbh_do (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 105)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 3: DBIx::Class::Storage::DBI::Cursor::next (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/lib/DBIx/Class/ResultSet.pm line 954)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 4: DBIx::Class::ResultSet::next (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/lib/DBIx/Class/ResultSet.pm line 1483)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 5: DBIx::Class::ResultSet::first (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/Slim/Schema.pm line 574)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 6: Slim::Schema::first (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/Slim/Schema.pm line 2055)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 7: Slim::Schema::variousArtistsObject (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/Slim/Schema.pm line 218)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 8: Slim::Schema::init (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/.slimserver.pl-wrapped line 548)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 9: main::init (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/.slimserver.pl-wrapped line 671)
Jan 05 17:41:24 chump slimserver[2609746]:    frame 10: main::main (/nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/.slimserver.pl-wrapped line 1213)
Jan 05 17:41:24 chump slimserver[2609746]: [26-01-05 17:41:24.4310] Carp::Clan::__ANON__ (221) Warning: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare_cached failed: no such function: ARRAY [for Statement "SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id, me.extid FROM contributors me WHERE ARRAY(0x55c36194a7c8) = ?"] at /nix/store/p2r320zhb4hwr7p204v78fjdyvn35cwi-perl5.42.0-slimserver-9.0.3/Slim/Schema/Storage.pm line 126

Additional context

No response

System metadata

• system: "x86_64-linux"
• host os: Linux 6.17.7, NixOS, 26.05 (Yarara), 26.05.20260102.fb7944c
• multi-user?: yes
• sandbox: relaxed
• version: nix-env (Determinate Nix 3.15.1) 2.33.0
• nixpkgs: /nix/store/ri19g370fjy8qwsfvg0fh7p6ziqmda4l-source

Notify maintainers

@adamcstephens @jecaro

---

Note for maintainers: Please tag this issue in your pull request description. (i.e. Resolves #ISSUE.)

I assert that this issue is relevant for Nixpkgs

• I assert that this is a bug and not a support request.
• I assert that this is not a duplicate of an existing issue.
• I assert that I have read the NixOS Code of Conduct and agree to abide by it.

Is this issue important to you?

Add a 👍 reaction to issues you find important.

[adamcstephens]

Could be perl 5.42, or the newer DBD::SQLite, but it is indeed broken. Reproduced in nixos tests nix-build -A slimserver.tests.

I'm not sure the right path forward at this point, since the sqlite module seems to need a compiled loadable object. That may not even fix it.

I'd suggest using the slimserver from the stable release for now.

[adamcstephens]

Actually the SQLite module wasn't updated, so this is likely a perl 5.42 issue.

[adamcstephens]

@ChrisOboe Are you able to test #477286 ?

[ChrisOboe]

@adamcstephens i tested #477286. With this patch slimserver starts again but all plugins that rely on webservices seem not to work anymore (tidal plugin fails, podcasts fail and internet radio fail (even just navigating in the menu, without trying to play anything)).

I don't have debug log enabled yet, on info log i get these messages:

Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:38:49.0016] Slim::Formats::XML::gotErrorViaHTTP (294) Error: getting http://opml.radiotime.com/Index.aspx?partnerId=16
Jan 06 13:46:21 chump slimserver[3115953]: Connect timed out: Inappropriate ioctl for device
Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:38:49.0018] Slim::Plugin::InternetRadio::Plugin::_gotRadioError (71) Unable to retrieve radio directory: Connect timed out: Inappropriate ioctl for device
Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:40:24.0014] Slim::Formats::XML::gotErrorViaHTTP (294) Error: getting http://opml.radiotime.com/Index.aspx?partnerId=16
Jan 06 13:46:21 chump slimserver[3115953]: Connect timed out:
Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:40:24.0015] Slim::Plugin::InternetRadio::Plugin::_gotRadioError (71) Unable to retrieve radio directory: Connect timed out:
Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:40:44.0349] Slim::Plugin::Analytics::Plugin::ANON (99) Failed to report analytics: Connect timed out: Operation now in progress
Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:43:19.0963] Slim::Formats::XML::gotErrorViaHTTP (294) Error: getting http://opml.radiotime.com/Index.aspx?partnerId=16
Jan 06 13:46:21 chump slimserver[3115953]: Connect timed out:
Jan 06 13:46:21 chump slimserver[3115953]: [26-01-06 13:43:19.0964] Slim::Plugin::InternetRadio::Plugin::_gotRadioError (71) Unable to retrieve radio directory: Connect timed out:

playing itself (from local media files) works fine.

I'm not sure if this is related or if it's a different problem. But on nixos-unstable from about a week ago it worked fine.

[adamcstephens]

connect timed out seems suspiciously like network issues. If you're still getting this and you're sure your network is ok, then I guess someone else will need to confirm they have the same issues.

[antonmosich]

I am experiencing the same timeout issues with #477286 applied and I'm pretty sure my network's ok.

[adamcstephens]

Thanks for confirming.