It seems that the playlist issue also applies to CUE files.
Can you elaborate?
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Michael, I'm wondering if something changed in 7.9.3 as well? After all
the issues I went through with Catalina on Mac MINI, I reverted back to
High Sierra from a TimeMachine backup, but installed 7.9.3 and did a
complete rescan. NO iTUNES, just my audio drives. There's a little
over 40,000
It seems that the playlist issue also applies to CUE files.
Logitech Media Server Version: 8.0.0 - 1600144351 @ Tue Sep 15 06:55:13
CEST 2020
Carsten
carp's Profile: http://forums.slimdevices.com/member.php?userid=3584
mherger wrote:
>
> I thought I had that fixed... would you mind sharing your library.db
> with me?
>
yes, will send over.
Looking at the error, anything to do with possibly saving youtube in a
playlist?
Code:
youtube://
I notice there's a
[20-09-30 15:43:10.7835] Slim::Schema::Storage::throw_exception (121) Error:
DBI Exception: DBD::SQLite::db do failed: SQL logic error or missing database
unable to use function MATCH in the requested context [for Statement "
I thought I had that fixed... would you mind sharing your
mherger wrote:
>
> Just post your scanner.log and we'll know...
>
Code:
Logitech Media Server Version: 8.0.0 - 1601380107 @ Tue Sep 29 14:20:56 CEST
2020
Hostname: odroid
Server IP Address: xx
Server HTTP Port Number: 9000
Operating system: Debian -
I'm pretty sure I'm up to date, there's nothing screaming at me that it
needs to be. and the scans are still stopping unexpectedly.
Just post your scanner.log and we'll know...
--
Michael
___
Squeezecenter mailing list
mherger wrote:
> Did you see these failures with the latest build? Other reporters of
> this issue have confirmed it was fixed (for them...).
I'm pretty sure I'm up to date, there's nothing screaming at me that it
needs to be. and the scans are still stopping unexpectedly.
kbeast wrote:
> I know this quote wasn't for me directly (and its also taken out of
> context a little), but I still owe you a db file -- I'm still getting an
> error when scanning. I finally had time to copy the library.db file
> over, but I'm a little hesitant to upload it to dropbox--
>
>
mherger wrote:
> >
> It's hard to give advice when I lack any information...
>
I know this quote wasn't for me directly (and its also taken out of
context a little), but I still owe you a db file -- I'm still getting an
error when scanning. I finally had time to copy the library.db file
mherger wrote:
> > Still taking a long time for me:
>
> Thanks for your file! So... you have 10 playlists with 10k+ tracks? One
>
> with close to 30k tracks. Do you really use those? They seem to be
> imported from iTunes. Unless you're serious about using them I suggest
> you add them to
Still taking a long time for me:
Thanks for your file! So... you have 10 playlists with 10k+ tracks? One
with close to 30k tracks. Do you really use those? They seem to be
imported from iTunes. Unless you're serious about using them I suggest
you add them to the ignore list in the iTunes
Still taking a long time for me:
The please answer my questions about library size, number of playlists,
number of tracks in those playlists, and share library.db and full
scanner.log.zip with me.
https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a
It's hard to give advice when I lack any
Still taking a long time for me:
Code:
[20-09-26 08:09:47.0649] main::main (206) Starting Logitech Media Server
scanner (v8.0.0, 1601033329, Fri Sep 25 13:53:32 CEST 2020) perl 5.018004
[20-09-26 08:27:31.4928] Slim::Music::Import::runImporter (577) Starting
mherger wrote:
> > Success! :cool:
>
> Ok, 15s for the playlist FTS index look much more reasonable :-). Does
> it work? Can you search for tracks in a playlist?l
Searching from the top search box doesn't bring up anything in
playlists. (top pic below)
Searching by clicking on the spyglass
Success! :cool:
Ok, 15s for the playlist FTS index look much more reasonable :-). Does
it work? Can you search for tracks in a playlist?
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
mherger wrote:
> I think I finally nailed the issue with the help of kidstypike's
> library.db. Please give the next build another try...
Success! :cool:
31686
+---+
|Filename: scanner.log.zip
I think I finally nailed the issue with the help of kidstypike's
library.db. Please give the next build another try...
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
[20-09-25 17:56:17.1967] main::main (206) Starting Logitech Media Server
scanner (v8.0.0, 1600976618, Thu Sep 24 22:15:54 CEST 2020) perl 5.018004
[20-09-25 17:56:17.3779] Slim::Schema::forceCommit (2157) Warning: Trying to
commit transactions before DB is
mherger wrote:
> > [20-09-25 18:29:07.5107]
> Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (479) Create
> fulltext index for playlists
> >[20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception
> (121) Error: DBI Exception: DBD::SQLite::db do failed: malformed MATCH
>
[20-09-25 18:29:07.5107]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (479) Create fulltext index
for playlists
[20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception (121) Error: DBI
Exception: DBD::SQLite::db do failed: malformed MATCH expression:
Code:
[20-09-25 18:29:07.5107]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (479) Create fulltext index
for playlists
[20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception (121) Error:
DBI Exception: DBD::SQLite::db do failed: malformed MATCH
Media scan terminated unexpectedly (Scanning Progress)
Please share your scanner.log. Thanks!
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Code:
Discovering files/directories: /mnt/mother/mp3 (173263 of 173263)
Complete 00:07:59
Scanning new music files: /mnt/mother/mp3 (1 of 1) Complete 00:00:00
Discovering playlists: /mnt/mother/! Playlists (130 of 130) Complete
00:00:01
No better I'm afraid.
This sucks. I'm using the same SQLite version as you, and I can run
those queries on your library just fine. I'll give it another try in a
build later today. I'm wondering whether I'm missing something here. The
log file seems to indicate there's a problem with a string
mherger wrote:
> > Not so good, logs attached :(
>
> Thanks. Stupid mistake of mine (hopefully). There should be new builds
> out in a bit. Thanks for testing!
No better I'm afraid.
31678
+---+
|Filename: server.log (2).zip
Not so good, logs attached :(
Thanks. Stupid mistake of mine (hopefully). There should be new builds
out in a bit. Thanks for testing!
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
mherger wrote:
> > There's nothing unusual in either the scanner or sever logs
> (attached).
>
> Ok, figured something out: I was looking up stuff in the FTS index by
> the track ID. But in some library versions this value would NOT be
> indexed. Which means, that in those case the database
There's nothing unusual in either the scanner or sever logs (attached).
Ok, figured something out: I was looking up stuff in the FTS index by
the track ID. But in some library versions this value would NOT be
indexed. Which means, that in those case the database had to do a slow
scan instead
Mine's a bit over 700MB so not so sure about that.
Feel free to upload it to
https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a
Largest playlist file is 583K -- i'm sure some of the lists are pointing
I assume that's 583KB, not 583'000 tracks?...
to files that may no longer exist. As
mherger wrote:
> > Building full text index (7 of 7) Complete 08:20:15
>
> See? It's not broken :-)
>
lol!
mherger wrote:
>
> Would you mind sharing your library.db with me?
>
Mine's a bit over 700MB so not so sure about that.
mherger wrote:
>
> Are you using iTunes
One minor problem - practically all of my artists have had face
transplants. :(
The Corrs never looked that funky before!
I'll look into the data later tonight/tomorrow. Thanks!
--
--
Michael
___
Squeezecenter mailing list
mherger wrote:
> > It's actually finished a complete scan. A normal clear & rescan
> usually
> > takes about 44 minutes, this scan took 85 minutes.
>
> But only 27 minutes for the FTS index.
>
> > I need to go out now, let me know if you want me to supply any logs or
> > other and I'll upload
It's actually finished a complete scan. A normal clear & rescan usually
takes about 44 minutes, this scan took 85 minutes.
But only 27 minutes for the FTS index.
I need to go out now, let me know if you want me to supply any logs or
other and I'll upload them when I get back.
Sure,
Would you believe it!
It's actually finished a complete scan. A normal clear & rescan usually
takes about 44 minutes, this scan took 85 minutes.
I need to go out now, let me know if you want me to supply any logs or
other and I'll upload them when I get back.
31652
Building full text index (7 of 7) Complete 08:20:15
See? It's not broken :-)
Would you mind sharing your library.db with me?
Are you using iTunes integration? How many playlists? How large are the
longer among them?
--
Michael
___
kbeast wrote:
> I'm up to 3 hours and 38 minutes, something tells me this isn't going to
> finish :)
Scanner Information
Code:
Building full text index (7 of 7) Complete 08:20:15
Scanner Log File
Code:
kidstypike wrote:
> As nothing has advanced after 20 minutes, I'm not prepared to wait hours
> to see if the FTS scan finishes, I'm going to stop LMS and remove the
> library.db.
OK, restarted LMS a new scan is running with FST enabled and scan
logging enabled.
*Server - LMS 8.0.0 *Pi4B
kidstypike wrote:
> Try again :)
>
> >
Code:
> > [20-09-23 12:37:54.1236] main::init (388) Starting Logitech Media
Server (v8.0.0, 1600604030, Sun Sep 20 14:55:17 CEST 2020) perl 5.028000 -
arm-linux-gnueabihf-thread-multi-64int[20-09-23 12:37:56.7072]
[20-09-23 12:38:40.4496] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(488) Create fulltext index for playlists]
So yeah, it's stuck at the same place again. Hmm... and I wouldn't know
of a simple way to change the logging on pCP.
In order to disable FTS again find
Try again :)
Code:
[20-09-23 12:37:54.1236] main::init (388) Starting Logitech Media Server
(v8.0.0, 1600604030, Sun Sep 20 14:55:17 CEST 2020) perl 5.028000 -
arm-linux-gnueabihf-thread-multi-64int[20-09-23 12:37:56.7072]
Plugins::LazySearch2::Plugin::initPlugin
OK, found it I think using SCP. This is all I see.
Code:
[20-09-23 12:37:54.1236 main::init (388) Starting Logitech Media Server
(v8.0.0, 1600604030, Sun Sep 20 14:55:17 CEST 2020) perl 5.028000 -
arm-linux-gnueabihf-thread-multi-64int[20-09-23 12:37:56.7072]
mherger wrote:
> > Restarted LMS a couple of times from the pCP ui, rebooted the Pi,
> still
> > can't get into LMS or it's settings.
>
> As always: check the server.log. It might give you a hint. Eg. LMS might
>
> be trying to re-build the FTS as it didn't get created in the previous
> scan.
Restarted LMS a couple of times from the pCP ui, rebooted the Pi, still
can't get into LMS or it's settings.
As always: check the server.log. It might give you a hint. Eg. LMS might
be trying to re-build the FTS as it didn't get created in the previous scan.
--
Michael
mherger wrote:
> > Please note, I've not had this issue up to the last week or so.
>
> Would there be anything in server.log? Could you please run a FTS
> enabled scan with logging for scan enabled?
>
> And please share a library.db with the FTS enabled with me.
>
> From what I can see your
mherger wrote:
> > Please note, I've not had this issue up to the last week or so.
>
> Would there be anything in server.log? Could you please run a FTS
> enabled scan with logging for scan enabled?
>
> And please share a library.db with the FTS enabled with me.
>
> From what I can see your
Please note, I've not had this issue up to the last week or so.
Would there be anything in server.log? Could you please run a FTS
enabled scan with logging for scan enabled?
And please share a library.db with the FTS enabled with me.
From what I can see your playlists don't look crazy
Please note, I've not had this issue up to the last week or so.
That's because the playlist indexing was broken before that. Broken as
in not working at all. Now it's broken as in "too slow under certain
circumstances"...
Thanks for the file. I'll look into it.
--
Michael
mherger wrote:
> Who's willing to share his library.db with me?
>
> https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6al
Done.
Please note, I've not had this issue up to the last week or so.
*Server - LMS 8.0.0 *Pi4B 4GB/Flirc case/pCP 6.1.0 - 74K library,
playlists & LMS cache on SSD
Who's willing to share his library.db with me?
https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
kbeast wrote:
> I'm up to 3 hours and 38 minutes, something tells me this isn't going to
> finish :)So how many and what size are the playlists?
Sent from my Pixel 3a using Tapatalk
slartibartfast's Profile:
kidstypike wrote:
> Same here with the playlists, it got so bad I uninstalled the
> FullTextSearch plugin.
I'm up to 3 hours and 38 minutes, something tells me this isn't going to
finish :)
kbeast's Profile:
Logitech Media Server Version: 8.0.0 - 1600604030 @ Sun Sep 20 14:55:17
CEST 2020
Hostname: musicbox5
Server IP Address: 192.168.1.4
Server HTTP Port Number: 9000
Operating system: piCore - EN - utf8
Platform Architecture: armv7l-linux
Perl Version: 5.28.0 -
I'm getting stuck at the playlists one. at times over an hour and a
half
What exact LMS version are you using? How many playlists? How large? How
many tracks overall in playlists?
--
Michael
___
Squeezecenter mailing list
kbeast wrote:
> >
Code:
> >
> [20-09-22 10:55:51.5580]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (442) Starting fulltext
index build
> [20-09-22 10:55:51.5583]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (446) Initialize fulltext
table
>
Code:
[20-09-22 10:55:51.5580] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(442) Starting fulltext index build
[20-09-22 10:55:51.5583] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(446) Initialize fulltext table
[20-09-22 10:56:00.1459]
mherger wrote:
>
>
> Yes, FTS is all I'm interested in at this point. Thanks!
>
>
OK. There's nothing about FTS in the server.log, but the scanner.log
has:
Code:
[20-09-15 09:56:32.0525] Slim::Music::Import::runImporter (577) Starting
Sure Michael. What logging levels would you like? Just debug for
plugin.fulltext? Or anything else?
Yes, FTS is all I'm interested in at this point. Thanks!
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
mherger wrote:
>
> That sounds like a decent improvement :-). Could you please post the
> server.log content?
>
Sure Michael. What logging levels would you like? Just debug for
plugin.fulltext? Or anything else?
John
That brings the scan time down to 50 minutes.
That sounds like a decent improvement :-). Could you please post the
server.log content?
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
mherger wrote:
> Ok, maybe the solution is quite simple: in the iTunes settings in LMS,
> please add "Downloaded" to the list of "Ignored playlists". Then re-run
>
> a scan. This should skip the playlist with the 40k tracks, considerably
>
> speeding up the Fulltext Index creation.
>
Ok, maybe the solution is quite simple: in the iTunes settings in LMS,
please add "Downloaded" to the list of "Ignored playlists". Then re-run
a scan. This should skip the playlist with the 40k tracks, considerably
speeding up the Fulltext Index creation.
--
Michael
mherger wrote:
> Would you mind sharing your iTunes
> Library.xml file (or similar) with me?
>
> https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a
> [color=blue]
>
Done. I've added the library.db file as well in case it's important they
both match, as I added some more music yesterday.
Actually, I've found the playlist with the entire library in it. It's
the one titled 'Downloaded :iTunes' which isn't visible in iTunes and
I've never noticed before as I mainly use the 'Not Played For Ages' and
'Never Played' ones. Should I delete it in LMS and see what happens?
It'll be
mherger wrote:
> > Now I check, I see 23 in the playlists menu. LMS library stats say:
>
> Could you please send me a list of the playlists shown in the Playlists
>
> menu of My Music?
>
Here they are:
Blue Note :iTunes
Chill :iTunes
Classical Music :iTunes
Cooder :iTunes
Davis Monk
Now I check, I see 23 in the playlists menu. LMS library stats say:
Could you please send me a list of the playlists shown in the Playlists
menu of My Music?
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
mherger wrote:
> >> There's a 40k tracks playlist imported from iTunes?/QUOTE]
> >>
> >> That's the entire library, held in iTunes. I use iTunes because I
> always
> >> have. The 31 playlists are 'smart' ones set up in iTunes.
>
> Would these lists show up in the Playlists menu, too?
>
Now I
There's a 40k tracks playlist imported from iTunes?/QUOTE]
That's the entire library, held in iTunes. I use iTunes because I always
have. The 31 playlists are 'smart' ones set up in iTunes.
Would these lists show up in the Playlists menu, too?
--
Michael
mherger wrote:
>
>
> There's a 40k tracks playlist imported from iTunes?/QUOTE]
>
> That's the entire library, held in iTunes. I use iTunes because I always
> have. The 31 playlists are 'smart' ones set up in iTunes.
>
> John
Done.
There's a 40k tracks playlist imported from iTunes?... I'll keep
investigating.
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
testmatch wrote:
> Mildly technical from a software perspective - what would I need to do?
I've found where the full text search plugin lives and am happy to edit
the .pm file if there are changes you'd like me to make. I've done that
with several of the third party plugins to update them, so
mherger wrote:
> Could you please share your library.db with me?
>
> https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a
>
>
Done.
John
testmatch's Profile: http://forums.slimdevices.com/member.php?userid=30954
Could you please share your library.db with me?
https://www.dropbox.com/request/T3RctyzGgNg0oFDubq6a
--
Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
mherger wrote:
>
> How technical would you be? I don't have playlists that large to test
> with. If I posted a change, would you be able to apply the code change
> to re-test with your collection (probably won't happen over the
> weekend)?
>
Mildly technical from a software perspective -
I've done that, Michael, but don't see much in the scanner log (below)
I see this:
[20-09-12 07:52:49.4831]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (488) Create
fulltext index for playlists
[20-09-12 11:10:59.3181]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (503) Optimize
mherger wrote:
>
>
> I've indeed applied a change to the FTS plugin a few days ago. Could you
>
> please enable logging for plugin.fulltext and re-run a scan?
>
>
I've done that, Michael, but don't see much in the scanner log (below)
or server log. Should I have enabled anything else in
I'd normally see the full text index taking less than a minute to
complete, and the whole scan just over four minutes.
I've indeed applied a change to the FTS plugin a few days ago. Could you
please enable logging for plugin.fulltext and re-run a scan?
--
Michael
mherger wrote:
> >
> But does it finish successfully? Would you have many playlists, or large
>
> playlists?
>
Thanks Michael,
Yes - it finishes successfully. I ran the scan a second time in case it
was one of those things that takes ages the first time and then is
faster subsequently, but
I'm seeing a consistent change in scanning in the most recent nightlies.
LogitechMediaServer-8.0.0-1599321733 (from September 6th) completes
scans within minutes as normal, but all the nightlies after that take
several hours to scan. The logjam is in the Albums section (2 of 7) of
the 'Building
79 matches
Mail list logo
