slimserver
slimserver copied to clipboard
FTS is being used before the index is available, throwing errors (LMS9)
Hi all
I upgraded toLyrion Music Server (v9.0.0, 1729751785)
from 8.5.3
and I see these errors in the logfile. Is there a command to start migration so that the table will be created?
Thanks
[24-10-24 16:35:13.7991] Slim::Web::Cometd::handler (437) errorNeedsClient: 172.30.0.1, 00:04:20:26:c3:1b, status, -, 10, menu:menu, useContextMenu:1, subscribe:600
[24-10-24 16:35:18.8437] Slim::Web::Cometd::handler (437) errorNeedsClient: 172.30.0.1, 00:04:20:26:c3:1b, displaystatus, subscribe:showbriefly
[24-10-24 16:38:14.3307] Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (637) Fulltext index missing or outdated - re-building
[24-10-24 16:38:14.3314] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement "
SELECT term FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN ('*', 1, 0) AND LENGTH(term) > 1
GROUP BY term
)
WHERE d > 500
"]
[24-10-24 16:38:14.3317] Slim::Schema::Storage::throw_exception (122) Backtrace:
frame 0: Slim::Utils::Log::logBacktrace (/lms/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/lms/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/lms/Slim/Plugin/FullTextSearch/Plugin.pm line 644)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (/lms/Slim/Plugin/FullTextSearch/Plugin.pm line 183)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__ (/lms/Slim/Control/Request.pm line 2053)
frame 5: (eval) (/lms/Slim/Control/Request.pm line 2053)
frame 6: Slim::Control::Request::notify (/lms/Slim/Control/Request.pm line 858)
frame 7: Slim::Control::Request::checkNotifications (/lms/slimserver.pl line 708)
frame 8: main::idle (/lms/slimserver.pl line 676)
frame 9: main::main (/lms/slimserver.pl line 1215)
[24-10-24 16:38:14.3320] Slim::Control::Request::notify (2055) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement "
SELECT term FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN ('*', 1, 0) AND LENGTH(term) > 1
GROUP BY term
)
WHERE d > 500
"] at /lms/Slim/Schema/Storage.pm line 126