r1644703639 looks good again.
The changes I checked worked fine! :)
One thing only:
At the end of the scan (or I even guess AFTER the end of the scan)
server STOPPED.
Can't imagine a memory issue, my machine hast 16 GB (I know, LMS is 32
bit, so it can't use all of it) and the use of scanner/server is usually
about 300-500 MB... (and no other app was running only "usual"
background action)
If I restarted it showed:
Database Optimize (2 of 2) Complete 00:00:42
The server has finished scanning your media library.
Total Time: 00:56:18 (Sunday, 13. February 2022 / 11.01.15)
so it looks, the server DIDN'T crash but stopped afterwards?
I give You the last entries from server.log - maybe You can see any
reason?
[22-02-13 10:05:15.9106] Slim::Utils::SQLiteHelper::_notifyFromScanner
(581) Notify from scanner:
progress:1644743057.79672||importer||M:|discovering_directory||206||0||
[22-02-13 10:49:32.7410] Slim::Plugin::UPnP::Events::error (326)
Subscribe/unsubscribe error: 412 Precondition Failed
[22-02-13 10:49:32.8843] Slim::Plugin::UPnP::Events::error (326)
Subscribe/unsubscribe error: 412 Precondition Failed
*** At This Point [22-02-13 11:01:15] server obviously had finished
scan***
[22-02-13 11:01:16.9242] Slim::Schema::wipeCaches (2130) Wiped all
in-memory caches.
[22-02-13 11:01:16.9247] Slim::Schema::wipeCaches (2130) Wiped all
in-memory caches.
[22-02-13 11:01:16.9254] Slim::Utils::Misc::msg (1343) Warning:
[11:01:16.9253] DBIx::Class::ResultSet::update_or_create(): Query
returned more than one row. SQL that returns multiple rows is
DEPRECATED for ->find and ->single at
/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema.pm line 1905
[22-02-13 11:01:17.0761] Slim::Schema::Storage::throw_exception (121)
Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: out of
memory [for Statement "
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN ('*', 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
"]
[22-02-13 11:01:17.0763] Slim::Schema::Storage::throw_exception (121)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line
121)
frame 1: Slim::Schema::Storage::throw_exception
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm
line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(C:/PROGRA~2/SQUEEZ~1/server/Slim/Plugin/FullTextSearch/Plugin.pm line
587)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms
(C:/PROGRA~2/SQUEEZ~1/server/Slim/Plugin/FullTextSearch/Plugin.pm line
148)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line
2058)
frame 5: (eval)
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line
2058)
frame 6: Slim::Control::Request::notify
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line
859)
frame 7: Slim::Control::Request::checkNotifications (slimserver.pl
line 715)
frame 8: main::idle (slimserver.pl line 684)
frame 9: main::main (slimserver.pl line 131)
frame 10: PerlSvc::Interactive
(/<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>PerlSvc.pm line 99)
frame 11: PerlSvc::_interactive (slimserver.pl line 0)
frame 12: (eval) (slimserver.pl line 0)
[22-02-13 11:01:17.0765] Slim::Control::Request::notify (2060) Error:
Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
selectcol_arrayref failed: out of memory [for Statement "
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN ('*', 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
"] at /<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm
line 125
[22-02-13 11:01:17.0771] Slim::Music::Import::nextScanTask (801)
remaining scans in queue:()
------------------------------------------------------------------------
frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156
View this thread: http://forums.slimdevices.com/showthread.php?t=115919
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
