Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-22 Thread jimwillsher 


Reviewing Scanner.log, and looking at the last file listed, gave me an
idea. I've removed that file and the scan now works, so it must be a
corrupted file. The logging didn't really help, other than by listing
the filenames, e.g. no diagnostics.

Thank you anyway Michael, it's always reassuring to know that you're
around.



Jim



jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-22 Thread jimwillsher 


More chatty files attached.

3651636517


+---+
|Filename: scanner.log.zip  |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=36517|
+---+


jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-22 Thread jimwillsher 


3651436515

Thank you, Michael. Both log files attached.

They look pretty lean, though, so I'm going to increase the logging and
upload a couple more.


+---+
|Filename: scanner.log.zip  |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=36515|
+---+


jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-21 Thread Michael Herger 

Can you suggest anything else please Michael? The scan didn't work after
all, and I'm now showing 1100 songs instead of 8000+ songs.


Please provide your log files, in particular the scanner.log.zip
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-21 Thread jimwillsher 


Can you suggest anything else please Michael? The scan didn't work after
all, and I'm now showing 1100 songs instead of 8000+ songs.



jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-21 Thread jimwillsher 


I've restored my VM (hosting LMS) and this time chosen to just look for
new music, rather than clear and rescan, and it's succeeded. I think
I'll avoid that clear function...

Many thanks for your help, Michael, your time is always much appreciated
here.


Jim



jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-21 Thread jimwillsher 


Thanks Michael, but sadly no luck.

root@av01:/var/lib/squeezeboxserver/cache# service logitechmediaserver
stop
root@av01:/var/lib/squeezeboxserver/cache# rm library.*
root@av01:/var/lib/squeezeboxserver/cache# service logitechmediaserver
start

followed by rescan, and failure again.



jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-21 Thread Michael Herger 

[21-12-21 15:01:05.1374] Slim::Control::Request::notify (2060) Error:
Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
selectcol_arrayref failed: no such table: fulltext_terms [for Statement


Shut down LMS, remove library.* from its cache folder, then restart.
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

[SlimDevices: SqueezeCenter] Full scan failing on latest nightly

2021-12-21 Thread jimwillsher 


Hi all

Full scan is failing. I've added a bunch of music and removed some old
music, so I'm doing a full scan and it's failing. Can anyone shed light
on the cause and resolution?

Many thanks

Jim

21-12-21 15:01:05.1372] Slim::Schema::Storage::throw_exception (121)
Backtrace:

frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 121)
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__
(/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 587)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms
(/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 148)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__
(/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 6: Slim::Control::Request::notify
(/usr/share/perl5/Slim/Control/Request.pm line 859)
frame 7: Slim::Control::Request::checkNotifications
(/usr/sbin/squeezeboxserver line 715)
frame 8: main::idle (/usr/sbin/squeezeboxserver line 684)
frame 9: main::main (/usr/sbin/squeezeboxserver line 1228)

[21-12-21 15:01:05.1374] Slim::Control::Request::notify (2060) Error:
Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
selectcol_arrayref failed: no such table: fulltext_terms [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 /usr/share/perl5/Slim/Schema/Storage.pm line 125



Logitech Media Server Version: 8.3.0 - 1639757085 @ Fri 17 Dec 2021
05:25:03 PM CET
Hostname: av01
Server IP Address: 10.10.10.41
Server HTTP Port Number: 9000
Operating system: Debian - EN - utf8
Platform Architecture: x86_64-linux
Perl Version: 5.30.0 - x86_64-linux-gnu-thread-multi
Audio::Scan: 1.02
IO::Socket::SSL: 2.067
Database Version: DBD::SQLite 1.58 (sqlite 3.22.0)
Total Players Recognized: 5



jimwillsher's Profile: http://forums.slimdevices.com/member.php?userid=410
View this thread: http://forums.slimdevices.com/showthread.php?t=115610

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter