Re: [SlimDevices: Beta] After change to winter time every file is discovered as changed
Work around (tested): - Stop LMS while scanning (by task manager) - Restart LMS ... I don't know why, but it works - may it be there has to be more than 12 hours or so after the "time change"? Rem.: Between stop and restart I installed today's nightly - but I don't guess there is already any fix for this in it... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116989 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] After change to winter time every file is discovered as changed
No, the time change was at 3:00AM in the night, at this time my pc was off and Out. I started the PC around 10:00AM and the scan (I always do it manually) about 7:00 PM I guess so there should be no connection. I'm running Windows 11 latest official build (22H2). Thanks for caring :) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116989 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] After change to winter time every file is discovered as changed
Guess I found the somewhen fixed bug #18078 https://github.com/Logitech/slimserver/search?q=18078 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116989 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] After change to winter time every file is discovered as changed
>> Music stored on a FAT file system ? No, on NTFS >> If so, file time stamps are by definition/convention interpreted as local time. So UTC value of time stamp changes when winter/summer time changes. Yes, I know all of this. It happened constantly (every summer / winter time change) until maybe 5 or 6 years ago. Then Michael added a line that fixed it! I guess, this line became "cancelled" for some reason in between the last 6 months (for in march 2022 i guess it worked fine). I hope he remembers this "line" so it could be a quick fix... ;-) >> On a Linux system, one can mount a FAT volume and specify that file time stamps always be interpreted as UTC. But of no help on a Windows system. As You say, this is not a solution for windows systems :( ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116989 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] After change to winter time every file is discovered as changed
An old windows devil seems to be Back: After change to winter time every file is discovered as changed... (so LMS just tries to update 1.100 k entries in my DB...) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116989 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
mherger wrote: > > I guess changing the album title of all tracks, rescan, change back, > rescan, would "fix" your database without the need for a full wipe & > rescan. > Yes, I'm quite sure, too. This is the usual way I fix those issues if I see them - changing and changing back (or moving the whole album to a folder I call "quarantine" (even before covid was there ;)) scan, move them back, scan again). So my reports are not about fixing my database but making the scanner even better for all (and I hope I can contribute a little as "power user"). (To be honest, this is a little selfish, too, for I can only fix issues by "changing - changeback" that I recognize. And in my database I guess I only recognize 10-20 % of the album that are affected by an issue ;)) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
OK, a few "new & changed" later: ;-) mherger wrote: > > Please note that the change would _not_ "fix" an already broken > database. It would only prevent the splitting. Yes, I am aware, I thought "touching" (change timestamp) / changing them would lead scanner to scan them and see them as "equal" to the others - I was wrong. mherger wrote: > > Did that join all tracks on one album again? I would expect this to > "fix" the database. And thereafter touch some tracks should no longer > cause splitting the album. > I expected this, too - but it didn't. Scanner recognized all (13) tracks as scanned but still kept them in 2 different albums as before mherger wrote: > Can you confirm that touching a few tracks of an album would no longer > cause that album to show up twice? Yes, I can - but I had to move the whole album to another direction. Only then scanner saw it as 1 album - and after touching a few files it kept them in 1 (!) album :) Thanks for fixing! frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
mherger wrote: > Thanks a lot Frank! I think we're one more bug down... new builds are in > > the pipeline. Unfortunately it (r1648757675) did not fix the issue I guess. I did the "reversion" like the day before: a) add the " (Radio Edit)" to track 3 b) "save" track 6 to get a new timestamp c) new & changed Result: - scanner recognized both files as "changed" - scanner pre-cached the artwork [22-04-01 12:01:28.4198] Slim::Music::Artwork::__ANON__ (767) Pre-caching artwork for Det här är platsen from M:\P\Peter Joeback\2004 - Det haer aer platsen\03 - Peter Joeback - Sommarens sista sang (Radio Edit).mp3 (unexpected to me it once again only pre-cached artwork for track 03, not for track 06) - library.db was "unchanged" (one album with 11 tracks, one album with 2 tracks - 2 different values in tracks.coverid (one or 2 tracks, one for 11 tracks), same tracks.cover for all 13 tracks.) Then I tried to "harmonize" it again by - pressing "save" on all 13 tracks so they ALL got new time stamps. Result: - scanner recognizeed all 13 tracks as scanned - scanner once again pre-cached the artwork only for track 03! [22-04-01 20:56:45.9778] Slim::Music::Artwork::__ANON__ (767) Pre-caching artwork for Det här är platsen from M:\P\Peter Joeback\2004 - Det haer aer platsen\03 - Peter Joeback - Sommarens sista sang (Radio Edit).mp3 (very unexpected for this time, I did the same to all tracks (setting a new timestamp, this time i did not do any tag changes to any file). The only thing that is "special" with this track as far as I can see, it gets "brackets" "()" in the #title tag and file name... Maybe You can reproduce again? Next thing I could try is to "repair" the album by moving it to another path (so it gets deleted and added as new) and then again - try to change this "Track 03" and/or - try to change another track (only). But for this takes a few run it may last 1 or 2 days... frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
mherger wrote: > Thanks a lot Frank! I think we're one more bug down... new builds are in > > the pipeline. Thanks to YOU! frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
mherger wrote: > > Never mind: I'm able to reproduce the issue. This must be a bad > > regression... it's enough to change a file's filestamp to make it end > up > > in a new album :-(. > > Might be yet another !@#?! Umlaut problem... I only see it if the album > > title has an umlaut (or probably some other accented character) in its > name. Yes, - I can confess, I can't reproduce it with ANY album - but I can reproduce it with this album any time. So this is why I gave You as much information as possibke about the album as I saw the umlaut in the scanner.log entry so maybe You have an idea why the umlaut influences scanner's behaviour... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
slartibartfast wrote: > After seeing that your tracks have embedded artwork I tried changing a > track title of a track containing embedded artwork. I still can't > reproduce the split album issue. OK, but I can - and I can reproduce and as You see from my database excerpt, the issue happens. I have e.g. no explanation why scanner recognized the artwork change if artwork isn't changed at all... I remember "my" last bug if it took weeks to find the explanation, that it happens depending on the total number of changes in my database. I am sure that there is a logical explanation for this issue - log files tell me I don't have any hallucinations ;))) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
racks.coverid = 7a015949 So it looks to me, scanner saw the cover art on the file with the changed #title as new and therefore created a new album? To explain: - I have a "folder.jpg" in the albums folder - I have the folder.jpg embedded in the mp3-file (usually with mp3.tag) - I did NO changes to the artwork - before and after it is the same folder.jpg lying in the folder and the same folder.jpg embedded into the files. Web interface shows it on all (13) files still as " APIC: [ image/jpeg, 3, , 66910, 216 ] " mherger wrote: > [color=blue]Can you export from SQLite to > some text file (with delimiters)? Please no Excel or other format which > might have its own ideas about formatting. Just the raw text > content.[/COVER] I'll attach it to this post directly PS: I can't see anything relating in artwork.db - maybe You could tell me if You need some information from there. +---+ |Filename: after scan - scanned_files.txt | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=37596| +---+ frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
slartibartfast wrote: > I thought the album title was the album tag. Am I wrong? An album > doesn't have tags of its own, the tracks in the album have the album > title in the album tag. Of course You're right, I only wanted to explain why I misunderstood Michael. Meanwhile I've seen what causes the bug (seems to be artwork and/or a german umlaut, will write later when I analyzed / exported the artwork.db frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
mherger wrote: > > - I have an existing album > > - I change the title tag (in this case adding "(Radio Edit)" to the > > existing track #3 - no other changes, no renaming > > - I do a "new & changed"-scan > > - I have 2 albums by the same artist with the same name in my db - > one > > containing only track #3, and one containing tracks #1-2 and #4-12 > > You have changed the _track_ title, and it created a new album? That > would definitely be a new issue. Previously we dealt with changing the > album titles. A track title change should really not change the album > attribution etc. unless editing/saving the metadata at the same time > changed other album or artist related data in the file, eg. by replacing > > some characters in a name. > > I know, you can't grant me access to your database. But would you be > able to export all the track, contributor, album related data for this > one particular album from the database? Can you export from SQLite to > some text file (with delimiters)? Please no Excel or other format which > > might have its own ideas about formatting. Just the raw text content. Ah, this was the one I thought about https://github.com/Logitech/slimserver/commit/4039a43607f2168bca4cf9da4875fd2aca5ca6f8 I overlooked, it's about album title (eg. though You meant #title tags from an album, not the #album tag) - thought it was about changing (track) titles for I had this issue with track titles often before myself and thought it was fixed. Unfortunately this time I can't "give You anything", for after recognizing the issue I renamed the filename of the changed file and did a rescan, so it is already fixed and I can't see anything in the db. But from now one I will once again keep a copy of library and log-files so I have it "at my hand" if it happens again. frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
garym wrote: > title is song title. track is track number. Be sure and look at > "extended tags" in mp3tag, in order to see all tag fields that might > exist. I think you probably are looking at extended tags, but just in > case. Yes, I was looking at extended tags. The way I work is the following: I have defined a set of - I guess 12 - tags I only use ALBUM;ALBUMARTIST;ARTIST;COMPOSER;COPYRIGHT;GENRE;LYRICIST;MEDIATYPE;PICTURE;TITLE;TRACK;YEAR When I add a new file to the database I use a predefined action that removes all tags except ALBUM;ALBUMARTIST;ARTIST;COMPOSER;COPYRIGHT;GENRE;LYRICIST;MEDIATYPE;PICTURE;TITLE;TRACK;YEAR . So there should no user tag in db (except i made a mistake). When I try to find errors, first thing is to call "extended tags" in mp3tag to see, if there is (for any reason) any other tag than the 12 defined. This wasn't the case. So next step is to see, what tags have different values (mp3tag shows this in one glance). This usually should only be ARTIST;COMPOSER;LYRICIST;TITLE;TRACK . So I double checked is with this album - there are no duets, and I didn't add the composers and lyricsts, so ARTIST was identical and COMPOSER and LYRICST was empty. So TITLE and TRACK were the only tags with different values... But once again: I remember Michael found this bug a few weeks ago and fixed it and I could confess it was fixed. So I hope it is only a "little regression"... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
garym wrote: > In the past, this would happen to me, when everything appeared the same, > but one file had a "disc total" tag field, or something similar that > made that track different. (this might happen if I re-ripped just one > track at the time of ripping the disk) Yes, I know this constellation so I take care of "what I Do". The proof is, that all other files still show "last changes" on 2022-03-09, only the changed one has 2022-03-26. Double-checked it using mp3tag - there are only 2 tags that are different in this album/folder, what are "title" and "track". All other files show the same (or no) value(s)... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
slartibartfast wrote: > Which LMS version are you running? Some work was done on "new and > changed" scans in recent 8.3 versions. Always the latest nightly (checking before every scan), so those scans were done with 8.3.0 r1647754697 I remember Michael fixed this issue some weeks ago - now it seems to be back... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] An old "friend" is back: Album split in 2 albums
An old bug seems to be back - unfortunately I recognized it only 2 scans afterwards so I didn't save the actual log files, but maybe You still know what was the problem: - I have an existing album - I change the title tag (in this case adding "(Radio Edit)" to the existing track #3 - no other changes, no renaming - I do a "new & changed"-scan - I have 2 albums by the same artist with the same name in my db - one containing only track #3, and one containing tracks #1-2 and #4-12 Do You remember the issue (and maybe the solution) and/or can You reproduce it or should I try (will start to keep logs with my next scans again)? Thanks, Frank ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=116170 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > > Not surprisingly that's a lot. Does the fulltext search still provide > some value to you? All those 7k popular terms would only be searched for > > in titles, but eg. not in comments. > > I'm not saying "turn off FTS" to work around that crash. But I believe > some of the FTS plugin implementation doesn't scale well with larger > libraries. Yes. I'll keep this in mind and watch this closely. Till 3 or 4 months ago I had FTS deactivated, but it's really of use for it's more comfortable to type "beatles need love" if I'm looking for albums with "All You Need Is Love" by the Beatles than to call extended search and type "need is love" (need love wouldn't work) in "tyle" field and artist "beatles" in artist field. So FTS is especially more practical if you don't know the exact title but only two words (but maybe not as an exact combination). 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > OTOH: could you please check how many lines you have in > Prefs/plugin/fulltext.prefs? It's 7.317 (so for the first 4 seem to be headlines (see below), it makes sense): --- _ts_popularTerms: 1644766442 _version: 1 popularTerms: Anyway, I keep it as "incidentally" too and watch it... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
Just did another scan (same beta) that ended (seemingly) regularly: [22-02-13 16:32:58.8166] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644766286||importer||updateStandaloneArtwork||16104||16104||1644766378.81439 [22-02-13 16:33:00.3092] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644766379.52718||importer||precacheArtwork||1||159|| [22-02-13 16:33:03.5565] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644766379||importer||precacheArtwork||159||159||1644766383.55449 [22-02-13 16:33:09.4125] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644766383.61973||importer||dboptimize||1||2|| [22-02-13 16:33:46.5057] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644766383||importer||dboptimize||2||2||1644766426.47187 [22-02-13 16:33:46.5113] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: end [22-02-13 16:33:46.5183] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: exit [22-02-13 16:33:46.8074] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:33:46.8078] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:33:46.8094] Slim::Utils::Misc::msg (1343) Warning: [16:33:46.8093] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /Slim/Schema.pm line 1905 [22-02-13 16:33:46.8250] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:33:50.8535] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:33:50.8545] Slim::Music::Import::nextScanTask (801) remaining scans in queue:() [22-02-13 16:33:58.8082] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:33:58.8085] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:33:58.8092] Slim::Utils::Misc::msg (1343) Warning: [16:33:58.8092] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /Slim/Schema.pm line 1905 [22-02-13 16:33:58.8208] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:34:02.5976] Slim::Schema::wipeCaches (2130) Wiped all in-memory caches. [22-02-13 16:34:02.5979] Slim::Music::Import::nextScanTask (801) remaining scans in queue:() [22-02-13 16:37:43.8553] Slim::Utils::Misc::msg (1343) Warning: [16:37:43.8553] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /Slim/Schema.pm line 1905 ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > Argh... how much free disk space would you have, in > particular on the > drive where your TEMP folder lives? Free space on "temp"-device is 136 GB (temp folder right now uses about 300 MB) mherger wrote: > Could you please run the inner SELECT in the above statement in SQLite > directly, to get the total number of rows for that query? Execution finished without errors. Result: 7313 rows returned in 13175ms ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
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 /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 (/Slim/Schema/Storage.pm line 121) frame 1: Slim::Schema::Storage::throw_exception (/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__ (/Slim/Control/Request.pm line 2058) frame 5: (eval) (/Slim/Control/Request.pm line 2058) frame 6: Slim::Control::Request::notify (/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 (/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 /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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > > Argh... that's likely due to my attempt at not running a last, > unnecessary request over the tracks table. I've now committed an > alternative approach, which might actually be slightly faster. But I > preferred the first approach for its simplicity. So... more testing to > do. A new build is on its way. Thanks! Scan ran through r1644672553 Will do some tests later and try r1644678709 so it looks it's about other issues... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||157||298|| [22-02-12 12:52:07.6585] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||247||298|| [22-02-12 12:52:12.6596] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||293||298|| [22-02-12 12:52:17.8212] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||304||298|| [22-02-12 12:52:23.4643] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||318||298|| [22-02-12 12:52:28.6027] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||322||298|| [...] [22-02-12 13:04:24.7709] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||879||298|| [22-02-12 13:04:29.9774] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||883||298|| [22-02-12 13:04:35.2212] Slim::Utils::SQLiteHelper::_notifyFromScanner (581) Notify from scanner: progress:1644666701.99379||importer||M:|directory_changed||887||298|| ... and so on for once again 15 minutes now... 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > It should certainly not take that much longer. Yes! It became quicker till the end and now I started the "2nd try" and it's "as quick as it always was". Guess there were some windows update in the background this morning, didn't check task manager, sry! I will report if it "runs through" this time... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
Ok, one quick feedback cause scanner "hangs". Logfile says: [22-02-12 11:26:38.0681] Slim::Utils::Scanner::Local::updateTracks (531) Rescanning changed audio files (298) 298 tracks sounds reasonable. Then it starts scanning the changed files (I looked into scanner.log and recognized those are the files I changed today, files I changed yesterday or eben the day(s) before and it does some more updates on files, I changed a few days before and today again (for example: On the following tracked I changed the year from "0" to "1967" some days ago - today I changed the artists name (from "The Temptations" to "Temptations") now it sees the files as new and updates the year-change from some days ago. [22-02-12 11:26:41.7569] Slim::Utils::Scanner::Local::changed (967) Handling changed audio track file:///M:/_Various/M/Motown%20Unreleased%201967/21%20%20-%20The%20Temptations%20-%20Since%20I%20Don%27t%20Have%20You.mp3 [22-02-12 11:26:41.7844] Slim::Utils::Scanner::Local::__ANON__ (1077) Rescanning changed year 0 -> 1967 That all looks good. But now for more than 20 minutes - nothing happens. Web-interface says "Help Rescanning Media Library... Geänderte Dateien werden durchsucht (1487 of 298)" (and the number increases, now it is (a few seconds later) "(1515 of 298)") Last log-entry ist: [22-02-12 11:27:15.0623] Slim::Utils::Scanner::Local::changed (967) Handling changed audio track file:///M:/S/Sonny%20+%20Cher/1965%20-%20Baby%20Don%27t%20Go/12%20-%20Caesar%20+%20Cleo%3B%20Sonny%20+%20Cher%20-%20Let%20The%20Good%20Times%20Roll.mp3 [22-02-12 11:27:15.0675] Slim::Schema::Contributor::rescan (244) Removing unused contributor: 127316 which is 20 minutes ago now. I exported log file to excel and scanner already did "Handling changed audio track" on all 298 tracks (ok, to be honest, excel says 294 but this might be an error in exporting or "counting" - as far as I can see, this "Sonny + Cher" track is the last (in alphabetical order) I changed". Server.log is unchanged since 11:11 - scanner.log since 11:27 ... - scanner seemingly doesn't know what to do after handling changed tracks and "goes on counting" ... I will now abort and set db back to "yesterday evening" and start to scan anew... 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
OK, MANY MANY thanks, I've just installed, made sure I changed more than 50 files and started a "new" (which takes a little longer due to the changes, I guess - till now it was about 45 min. for a new & changed, now it is after 45 min. halfways through the database so I guess it will be "times 3" - but that's worth it, if You found and fixed the bug. And it's a little "fun" or thrill to find it - what makes me crazy is (or was) that I didn't find what caused the behavior. I did the same things to my files and "sometimes it worked" (= the scanner found the files and corrected the db-entries) and "sometimes it didn't" (= the scanner didn't change entries in the db) - and I didn't came to the idea it depends on the number of changes I do (as Your remember, if I especially tested a new beta, I just did 1-3 files so I could see the effect easily - and mostly it worked. But in "normal work" (when I change a lot of entries) the bug appeared again. So the "> 50" thing sound reasonable... :) ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
So, I finally collected all the data - I watched the "0 scan" (the last scan before the change), 1st scan (after the change) and 2nd scan (after the change) "0 scan": (Last scan BEFORE changes) tracks.timestamp 1624895572 - Montag, 28. Juni 2021 17:52:52 GMT+02:00 DST (ctime?) tracks.filesize 5898100 tracks.added_time 1643710345 - Dienstag, 1. Februar 2022 11:12:25 GMT+01:00 tracks.updates_time 1643710345 - Dienstag, 1. Februar 2022 11:12:25 GMT+01:00 scanned_files.timestamp 1624895572 - Montag, 28. Juni 2021 17:52:52 GMT+02:00 DST (ctime = mtime at that point) scanned_files.filesize 5898100 1st scan (after changes): tracks.timestamp 1624895572 - Montag, 28. Juni 2021 17:52:52 GMT+02:00 DST (ctime?) tracks.filesize 5898100 tracks.added_time 1643710345 - Dienstag, 1. Februar 2022 11:12:25 GMT+01:00 tracks.updates_time 1643710345 - Dienstag, 1. Februar 2022 11:12:25 GMT+01:00 scanned_files.timestamp 164840 - Mittwoch, 9. Februar 2022 23:14:00 GMT+01:00 (mtime) scanned_files.filesize 5890048 After this (1st) scan, the track and album had been (on contributor_track.contributor and contributor_track.album) still be linked to the OLD contributor ("Nalin & Kane") 2nd scan (after changes): tracks.timestamp 164840 - Mittwoch, 9. Februar 2022 23:14:00 GMT+01:00 (mtime) tracks.filesize 5890048 tracks.added_time 1643710345 - Dienstag, 1. Februar 2022 11:12:25 GMT+01:00 tracks.updates_time 1644484141 - Donnerstag, 10. Februar 2022 10:09:01 GMT+01:00 scanned_files.timestamp 164840 - Mittwoch, 9. Februar 2022 23:14:00 GMT+01:00 (mtime) scanned_files.filesize 5890048 After this (2nd) scan, the track and album finally had been (on contributor_track.contributor and contributor_track.album) still be linked to the NEW contributor ("Nalin + Kane") As far as I can see, with 1st scan, scanned_files.timestamp and scanned_files.filesize have been changed, so they were different now from tracks.timestamp and tracks.filesize. But this lead to no changes on any "contributor-files". Only on 2nd scan the comparison scanned_files.timestamp != tracks.timestamp (or scanned_files.filesize != tracks.filesize) lead to changes within the contributor-fields in library.db ... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > I even don't understand in German :-D. I didn't understand > _what_ > explained the behaviour. > Ah, OK! I just wanted to express, till then we concentrated on trying to see why scanner does "wrong changes" or doesn't remove artists and in which order scans happen. But if server doesn't detect the files as changed (eg for "windows reasons") and they aren't even handled by scanner, the problem maybe is "outside scanner" and in server structure or in windows...? I'll check the scanned files too and report (will take a little for I now saved db and log after EVERY scan and I did a lot of scans ;-)) ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
... and I also took care about those files, I changed on 22-02-08 that scanner didn't see as changed before 22-02-10 (though here have been 5 scans inbetween). I checked library.db carefully, copied all lines about those files to Excel and searched for any changes - there have been no changes. I browsed all logfiles - the files have been "found" any time but not "handled" till 2 days after changing... I meanwhile don't think the problem is the db / scanner itself - the problem results from "when" scanner sees a file as "changed" and maybe which timestamp scanner has to compare with the files timestamp. Or could it even be, that there is a difference between windows mtime and the "Unix" timestamp, server sees?! I think I'm not as bad in analysing db's - but I have very little knowledge about server structure... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > > > I guess this explains, why it "sometimes works", "sometimes not"... > > I don't understand what is explained... > OK, I hoped, my English was better ;) In German "Das erklärt, warum es einmal geht und einmal nicht (obwohl nichts am Code oder an den Dateien verändert wurde)" I once again tracked one files - this time it worked on "2nd scan" already: I changed the file "12. Nalin & Kane" - Beachball.mp3 on 22-02-09 23:14 (changed "Nalin I.N.C." => "Nalin INC" - and just checked my files, it is STILL with mtime 22-02-09 23:14) AFTER that I started a scan [22-02-10 00:02:45.8662] The scan found the file [22-02-10 00:43:08.4509] Slim::Utils::Scanner::Local::Async::__ANON__ (148) Found M:\[...]\12 - Nalin & Kane - Beachball.mp3 but it was NOT handled - this is the only log-entry for this file I looked in "tracks" (library.db) there it was unchanged with added_time = 1643710345 and updated_time = 1643710345 (which is Tue Feb 01 2022 11:12:25 GMT+0100 - the day of my initial scan ) So scanner didn't see it as "changed" though it was changed more than 1 hour before it was scanned... I started a 2nd scan on [22-02-10 09:21:59.9377] NOTICE: - I didn't do anything change to the file (it is with mtime = 22-02-09 till NOW ;-)) and I there were no scanner/LMS updates It was once again FOUND: [22-02-10 10:03:58.0321] Slim::Utils::Scanner::Local::Async::__ANON__ (148) Found M:[...]\12 - Nalin & Kane - Beachball.mp3 and this time (!) it was also HANDLED: [22-02-10 10:09:01.6794] Slim::Utils::Scanner::Local::changed (969) Handling changed audio track file:///M:/[...]/12 - %20Nalin%20&%20Kane%20-%20Beachball.mp3 But I'm asking: Why didn't the scanner on "1st scan" ( [22-02-10 00:43:08.4509] ) not detect a file from [22-02-09 23:14] as handled - but does it on [22-02-10 10:03:58.0321] ?? I saw this on many files now, that CHANGED files are not detected on 1st scan but on 2nd or 3rd scan, while NEW and DELETED files (as far as I see) ALWAYS are detected on 1st scan...?! By the way: I think You could not see it from my db anywhere (and for it's a business db not even my girlfriend gets access ;-)) for as I described - the problem is, scanner doesn't detect the files and so db doesn't show any changes... I guess it's a windows/server/sql "timing" problem or something like that...?! :( 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
.. I found another proof: I did another new scan and it found 44 changed tracks - though I knew exactly I did nothing than "touch" (change mtime) 1 (!!!) file. So I looked into scanner.log - all files that were found now - 10.02.2022, 18:30 - were changed by me on 08.02.2022 between 23:00 and 23:59. I guess this explains, why it "sometimes works", "sometimes not"... Do You have any explanation for this? Double changed my region settings in windows, Time: UCT +01:00 Amsterdam, Berlin... Language: German (Germany) Land / Region: Germany Regional/territorial format (don't know what there is in english windows): recommended ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
Forever lasted a day ... or I saw a "spooky" phenomenon. I once again did some changes to my db yesterday and some of them I tracked. especially those ones "Nalin & Kane" => "Nalin + Kane" "Charly Lownoise & Mental Theo" => "Charly Lownoise + Mental Theo" "Simon & Garfunkel" => "Simon + Garfunkel" (You see the principle) I did a "new" on 10 Feb, 00:30 - obviously nothing changed. The old "&" artistst were still "in". I looked into scanner.log - some tracks were handled ("Handling changed audio track") but not all of them. I looked into library.db - and some tracks were still "unchanged" with the old "&" and role 1... Then I did another scan this morning 10 Feb, 09:30. Once again - some tracks had been changed - some not. I concentrated on 3 tracks to find them in scanner.log - they were not even there. I looked intro library.db - they were still there and not changed. Then I did a 3rd scan today 10 Feb, 10:30. I was already wondering, for scanner progress showed 99 changed files - and I had done NO changes! (I only copied the scanner.log and library.db after 2nd scan and started the 3rd scan) And to my surprise and delight: The old artists were gone. And I looked into scanner.log - those files were recognized and handled... To be sure I once again checked the mtime of my *.mp3-files (though I think, I KNOW what I do and when I do) and it confessed: Last change of all files was on 09 Feb about 23:00 - this means: ALL were changed before the 1st scan already, but only seen and handled with 3rd scan?! btw I did all 3 scans with last nightly r1644324995 Maybe You remember me mentioning this a few days of one of my testings that scanner found and changed files just at the 3rd scan after they were changed... No I'm thinking if this might be a "timing problem" between my windows time and the time scanner sees?! Maybe another observation to this point: When You post a new update, I often can see it on http://downloads.slimdevices.com/nightly/ but when I check LMS for new updates it says "There's no updated Logitech Media Server version available." When I install an update, it shows another time than the update was published. e.g r1644324995 is shown as published on "February 08 2022 13:31" After installation, LMS says "Logitech Media Server Version: 8.3.0 - 1644324995 @ Tue Feb 8 14:17:32 WEST 2022" (and this is not the time of installation but of the "version") But after scanning, LMS shows the "real" time: "The server has finished scanning your media library. Total Time: 00:37:30 (Thursday, 10. February 2022 / 11.13.42)" Is there a "time" setting withing LMS/sqlite? Or could there be a link to the language I use? Usually I use LMS in German - but for "analysis" I sometimes switch to english so I can give You the exact "response" from LMS?! I'm using windows 11 in my "usual" timezone (Germany Berlin). Mysterious... 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
ristmastime.mp3 [22-02-08 23:12:55.7537] Slim::Utils::Scanner::Local::changed (969) Handling changed audio track file:///M:/B/Bert%20Kaempfert/1971%20-%20Bert%20Kaempfert%20Now!/08%20-%20Bert%20Kaempfert%20-%20Oh%20Woman,%20Oh%20Why.mp3 [22-02-08 23:12:56.0720] Slim::Utils::Scanner::Local::changed (969) Handling changed audio track file:///M:/C/Cilla%20Black/1971%20-%20Images/02%20-%20Cilla%20Black%20-%20Junk.mp3 [22-02-08 23:12:56.0790] Slim::Schema::Contributor::rescan (244) Removing unused contributor: 69120 So it looks very good ... - though I'm careful to call it "solved forever" after one try ... ... a BIG THANK YOU! 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > >You don't have new files to clean up today?... :-D I'll propably will :D :D But before I try to do a scan only with those 2 or 3 files changed to see, what logfiles and db tell... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > >Yes, I believe this could be true: the cleanup happens when the content > > changes. But despite the updated timestamp, the scanner would not have > seen an updated artist. OK, thanks - then I will now turn the files back in "broken" status => scan => correct the tags => scan ... :) ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
Thanks for the build. Just a note: I tested by "touching" the files again (changing mtime) so they were discovered by scanner. It did but it did no changes to the db. Am I right that this is "expected behaviour" for scanner didn't see that the old "Deejay Ötzi" artist is as orphaned entry still connected to the album in contributor_album? If then I would try to create a new "Deejay Ötzi => DJ Ötzi" ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > >- what't the compilation's album artist (literally)? It's named "Various Artists" (see below) mherger wrote: > - what are your settings in Settings/My Music? - Use singe, configurable list of artists - Composer, band... NOTHING is checked - List compilation albums under each artist - Treat TPE2 MP3 tag as Album Artist - When compilation albums are grouped together, they appear under "Various Artists" by default. You can change that name below. (I typed Various Artists again, though I know it's repeated unnecessarily) - Show all albums and tracks for an artist - Only show tracks or albums matching the selected role for an artist - Search withing words - The El La Los Las Le Les Der Die Das - ; - 200 - Treat multiple disc-sets as multiple albums - Remember playlist - Leave in same order - Save playlists in order songs were added mherger wrote: > I think it has something to do with the artist roles. Therefore the last > > point could be crucial, as I don't include composers, conductors etc. in > > my collection. This is what I do - I guess... (see above) mherger wrote: > Deletion happens before the addition. OK, mentioned it in random order for I didn't know... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
@mherger: So, here are my results and logs and "what obviously could have happened". In both cases it were misspelled artsist. Both were the only entries from those artists a) "ATB: Topic" b) "Deejay Ötzi" a) with renaming: changed "ATB: Topic" => "ATB; Topic" (as album artist and track artist) AND renamed the file b) without renaming: I changed "Deejay Ötzi => DJ Ötzi" (it's an album by "Various Artists" with comp=1 ) and DIDN't rename the file Important: I did it this weekend AFTER my initial re-scan using the (at that point) last nightly (should have been r1643836091 or 1644040271). From this "1st run" I don't have the logs (resp. only the "short log" with no details). Result: a) Track was in db with artists "ATB" and "Topic" - but the "ATB: Topic" artist stayed in with an "empty" entry, b) Track was in db with "Deejay Ötzi" AND "DJ Ötzi" After changing my logging options, I "touched" them (so that scanner sees them as new) and scanned again (with r1644170574.exe) (the first track results from another thing I did, changing the artist "Voxxclub" => "voxxclub" - THIS one worked and it sais "Removing unused contributor". My examples a) and b) he also found as "changed" - but didn't obviously do anything with them. (...) [22-02-07 17:17:44.8926] Slim::Utils::Scanner::Local::changed (969) Handling changed audio track file:///M:/V/voXXclub/Donnawedda Volksmusik/18 - voxxclub - Haeddi dadi wari.mp3 [22-02-07 17:17:45.1879] Slim::Schema::Contributor::rescan (244) Removing unused contributor: 18303 [22-02-07 17:17:45.9323] Slim::Utils::SQLiteHelper::updateProgress (442) Notify to server: [ "progress:1644250658.81424||importer||M:|directory_changed||23||24||", ] [22-02-07 17:17:45.9353] Slim::Utils::SQLiteHelper::updateProgress (466) Notify to server OK [22-02-07 17:17:45.9357] Slim::Utils::Scanner::Local::changed (969) Handling changed audio track file:///M:/_Various/B/Bravo%20Hits%20030%20-%20CD%202/18%20-%20Deejay%20Oetzi%20-%20Hey%20Baby%20-%20Deejay%20Oetzi%20-%20Hey%20Baby.mp3 [22-02-07 17:17:48.4268] Slim::Utils::Scanner::Local::changed (969) Handling changed audio track file:///M:/A/ATB/2021%20-%20Your%20Love%20(Single)/01%20-%20ATB%3B%20Topic%3B%20A7S%20-%20Your%20Love%20(9PM).mp3 [22-02-07 17:17:54.2329] Slim::Utils::SQLiteHelper::updateProgress (442) Notify to server: [ "progress:1644250658||importer||M:|directory_changed||24||24||1644250674.23192", ] So I looked in my library.db: in "contributors": both misspelled artists are still "in" a) ATB: Topic = 101413 b) Deejay Ötzi = 68185 in "contributor_album": a) 10143 is linked with "role 5" and "role 6" (NOT role 1) to one album (41226) b) 68185 is linked with "role 1" to one album (30954) in "contributor_track": a + b) both contributors DOESN'T exist. in "albums": a) album 41226 shows as contributor 10143 b) album 30954 shows as contributor 3 ("Various Artists") in "tracks": a) album 41226 shows no result b) album 30954 shows track 439161 with primary_artist 5883 (which IS "DJ Ötzi", the correct contributor!) once again looking in "contributor_track" a) - (for there is no track) b) track 43961 has contributor 5883 (the correct "DJ Ötzi") with role 1 and contributor 3 ("Various Artists") with role 5 So IMHO I guess (!) this is what happens: a) scanner recognized the RENAMED file, - added the new file to teh db "tracks" (which is there, track #1160846 with correct album and correct artists) - deleted the old file from "tracks" (I also CAN'T find it searching for the old URL), but did - not see, it was the only track from the album and did not delete the "unused album". - not see, the contributor has no more entries than this "unused album" and so did not delete the "unused contributor" b) scanner recognized the CHANGED file, - added the new (corrected) contributor to "contributor_track" and deleted the "wrong" contributor from "contributor_track" - added the new (corrected) contributor to "tracks" as "primary_artist" - did not add the new (corrected) contribuotr to "contributor_album" and did not remove the "old" contributor from "contributor_album" - did not see that the "old" contributor is "unused" (which scanner couldn't see, for it is still in use in "contributor_album") Would any more information be helpful I could look up for You? Maybe this gives You a hint - otherwise I will start another test with a similar case - and this time log "everything" again... 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > > Are you sure you're running the latest buid? > Yes, I'm always running the last nightly (check it before every scan ;)). I just today did a regression to 02.02. nightly to see if it shows anoter behaviour - it didn't. mherger wrote: > > Keep in mind that one of the changes around case senstitivity require > the file the be created anew. Restoring an older file will indeed > re-introduce the problem. > Yapp, I'm aware, I tested with a backup made after the initial scan (with Your database changes) mherger wrote: > > Please double check scanned_files.url is case insensitive ("collate > nocase"). And once again Yes, I checked it, it is "text" "NOT NULL COLLATE NOCASE" And Yes, I see, if You can't reproduce I have to do some more tests maybe with a special test set (usually I do several changes everyday in my huge db ;), but I only track those "name changes". I will take the time to do nothing than those "name changes" and watch the logfiles. By the way: What setting should I chose to see: - every change, scanner has made (You know what I mean? If scanner sees a file as "changed", I would like to see that and what files scanner handled (I know, I can see it from the timestamp in the scanned_files table, but it would be more comfortable and mabye it could give more information? Right now I only have information in my logs like: [22-02-07 09:20:30.2278] Slim::Utils::Scanner::Local::__ANON__ (288) Get changed tracks count [22-02-07 09:20:35.2994] Slim::Utils::Scanner::Local::deleteTracks (519) Removing deleted audio files (392) [22-02-07 09:24:19.8598] Slim::Utils::Scanner::Local::__ANON__ (301) Scanning new audio files (2058) [22-02-07 09:28:00.0710] Slim::Utils::Scanner::Local::__ANON__ (381) Rescanning changed audio files (882) [22-02-07 09:29:38.9220] Slim::Music::Import::endImporter (710) Completed Slim::Media::MediaFolderScan Scan in 3114.360 seconds. so this is not a big help ;-) 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
ok, 4 scans further with different sets: The "you" issue seems to be back - and there seems to be another issue with casesensivity (Atb => ATB, just tried A-ha => a-ha and R3HAB => R3hab) Next test will be tommorow set I set back my library.db to an old backup (I've one from 02.02., that should be just after my initial scan) and make a n scan with a nightly from 04.02. and/or 05.02. - I will report... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
So, 2 more scans - the last one with r1644170574 - it looks that the "You & Me" => "You" issue is back again (the "you & me" artist stays in db). Could this be?! Nevertheless, I do another scan with r1644170574 with unchanged files to see what happens... ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > > [22-02-05 22:06:56.4989] > > Has renaming (folder or file) been part of this update? 29 items > previously scanned seem to be missing, 50 are new (not scanned before). > > The 70 updates might +/- be the 2/3 recognized? > > The "scanned_files" table would have the list of all files found. The > scan then would compare this with what there is in the library. The > corresponding queries can be found in > https://github.com/Logitech/slimserver/blob/5b6438c2f28dfce5c703e9452eb2c7f3ac0f8b43/Slim/Utils/Scanner/Local.pm#L212 > > downwards. > > I'm wondering whether this is a newly introduced issue after I changed > the order in which tracks are being deleted/updated/added... Yes, there were a few files changed besides the Younotus => YouNotUs thing, so it is not an 1:1 scan - but I only analyzed those "YouNotUs" files. Meanwhile I did 2 new update scans: a) HUGEL => Hugel b) Atb => ATB with fixing a few things like "ATB feat. xxx" or "ATB & xxx" => "ATB; xxx" a) was fine (about 30 tracks) b) was 89 tracks Most thing worked finde, too (honest 86 of 89, what is about 95 %, which is great :) ) ... but 3 ones failed and I can't think why: - 2 have not been renamed - but they were not even seen by scanner (not with a "today's timestamp" in scanned_files) - there are no modifications in any table of my (library).db - 1 has been scanned, but not changed - there I modified the artist "ATB: Topic" to "ATB; Topic" Please understand me right: I don't wanna have You to do "guessing work" for my collection - I try myself, too, but it's only if You have an idea, what could cause this, for I know my collection, but You know the changed to scanner :). Nevertheless, it is 95 % better than 2 weeks ago :-))) .. and next thing is to do a "second run" for the "ATB"-thing for I guess too, it has something to do with scanning order?! 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
build done! [22-02-05 22:16:42.1327] Slim::Music::Import::endImporter (710) Completed Slim::Plugin::FullTextSearch::Plugin Scan in 527.355 seconds. [22-02-05 22:16:42.1332] Slim::Music::Import::runImporter (578) Starting Slim::Plugin::ExtendedBrowseModes::Libraries scan [22-02-05 22:16:42.1334] Slim::Music::Import::endImporter (710) Completed Slim::Plugin::ExtendedBrowseModes::Libraries Scan in 0.000 seconds. [22-02-05 22:16:42.1339] Slim::Music::Import::runImporter (578) Starting Slim::Plugin::OnlineLibrary::Importer::VirtualLibrariesCleanup scan [22-02-05 22:16:42.1487] Slim::Music::Import::endImporter (710) Completed Slim::Plugin::OnlineLibrary::Importer::VirtualLibrariesCleanup Scan in 0.015 seconds. [22-02-05 22:16:43.8956] Slim::Music::Artwork::updateStandaloneArtwork (234) Starting updateStandaloneArtwork for 16120 albums [22-02-05 22:17:36.6133] Slim::Music::Import::endImporter (710) Completed updateStandaloneArtwork Scan in 54.464 seconds. [22-02-05 22:17:37.3392] Slim::Music::Artwork::precacheAllArtwork (657) Starting precacheArtwork for 36 albums [22-02-05 22:17:39.6383] Image::Scale::new (44) Warning: buffer_get_ret: trying to get more bytes 2 than in buffer 0 at /Image/Scale.pm line 44. [22-02-05 22:17:39.7399] Slim::Music::Artwork::__ANON__ (808) precacheArtwork finished in 2.39795517921448 [22-02-05 22:17:39.7401] Slim::Music::Import::endImporter (710) Completed precacheArtwork Scan in 3.119 seconds. [22-02-05 22:17:39.7429] Slim::Music::Import::runScanPostProcessing (480) Starting Database optimization. [22-02-05 22:18:23.4822] Slim::Music::Import::endImporter (710) Completed dbOptimize Scan in 43.739 seconds. ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How does new scanner detect what files to scan?
mherger wrote: > > > Did they not get recognized in the initial "looking for changed files" > already, or just not updated during the actuall update step? > No they were recognized in the initial scan but they weren't handled/changed in the 1st new) ( added_time was the same as updated_time though mtime had changed). scanner.log said nothing about them (maybe I have to change my logging options from "standard" though?) mherger wrote: > > > Are you saying that when you changed it for the second time, those files > > were picked up? > Not exactly: I did the 2nd n with UNCHANGED files - and scanner picked some of the files (changed before the 1st (!) n), some it missed again. Then I "touched" some (! not all!) of those files (all in different directories, btw), some were still unchanged (compared to 1st run) - and now it found ALL... Just doin' the same with HUGEL => Hugel and have a close look. ---- 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Removing deleted playlists from database
mherger wrote: > > > So you're good again? > > Next time you encounter a problem please keep a copy of scanner.log and > > library.db for further investigation. How large would the latter be in > your case?> > Yes, everything is fine again - just wanna give You a note though if You know about these problem - it seemed to me, scanner only scanned the new dir (playlist2) and didn't scan the old one (playlist) for it wasn't linked to lms anymore? library.db is about 2,5 GB (with a lot of personal comments and annotations and chart positions... ;-)) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115903 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] How does new scanner detect what files to scan?
To see if there is (still) a bug I wanna know: How does new scanner detect what files to scan? I changed 131 files - 2/3 have been recognized and changed, 1/3 didn't. I guessed, it takes the "file change" date (from windows) - but this had been changed with all files... Description: I renamed all tracks with artist "Younotus" => "YouNotUs" (usinge MediaMonkey5 - all in the same way). After a new scan 2/3 had "YouNotUs" as (track) artist 1/3 still had "Younotus" as (track) artist. I then looked in the contributors.. and tracks tables => all files still inked to "Younotus" had no new "updated_time" so I guess, scanner didn't see them as "changed" and didn't handle them. Checked manually the windows "file change time" - that had been updated and was the same as with the file, it "saw" and handled. So I wonder, what is the criteria for scanner to detect a file in "new"? Btw: ALL files that were linked to "Younotus" as ALBUM artist now had "Younotus" AND "YouNotUs" as ALBUM artist (sounds like a slight case sensivity bug again...?) And btw2: After scanning files 2 more times with "new" it detected all files (with the 2nd run about 15 more, withe the 3rd run the remaining...) 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 beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Removing deleted playlists from database
mherger wrote: > > Unfortunately you didn't keep the log file of this scan, did you? Did > you see any sign of progress, while it was processing the newly > discovered playlists? Or did it discover, but not process them? > I did not save them but I looked into them - scanner discovered them but did not process them in anyway (at least according to the logfiles) mherger wrote: > > I believe you are familiar with SQL? Did you check whether there was any > > sign of those playlists in the tracks table? > Yes, I checked - they have been in playlist table with d:\playlist\...m3u resp. d:\playlist2\...m3u mherger wrote: > > > So however: the only way I see is to "clean up" all playlists from > LMS > > (and not by a full rescan - it takes a day ; ) > I deleted them in tracks-table (all) and started a new - and they were imported again (and only once imported :))) ) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115903 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Removing deleted playlists from database
Is there any "easy" way to get rid of ALL playlists (and import them new). There was an error during my last re-scan so it couldn't see all playlists (only 60 of 1.259 - my fault). Running a new" said it found 1.259 playlists (that's right) but didn't import any one of the missing. 1. I tried to change the playlist-directory in LMS to an "empty" directory (D:\Test - including one "fake playlist" with one track) and do a "new"-scan - hoping scanner will remove all playlists but the "fake one". It didn't. It added the fake one but removed nothing. 2. I copyed all playlists to another dir than before ("D:\Playlists2" - btw it's another HDD than my music library) and linked this in LMS - after another new it imported the missing ones (1.099) - but the existing ones (60) were "double" in (from "D:\Playlist" and "D:\Playlist2"). 3. I deleted all duplicates manually, linked LMS back to "D:\Playlist" - and now the duplicates (60) came back. I wonder if this behaviour has anything to do with those changes made to tracks url (for I learned playlists are "normal" tracks in "tracks" table)? So however: the only way I see is to "clean up" all playlists from LMS (and not by a full rescan - it takes a day ; ) Thanks for Your help! (If You think is caused by the changes to scanner, please give me a note, I start a bug report ;) ) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115903 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] 'Search within words' not working when full text search is activated?
After 2 bugs one thing I don't know if it's a bug or "wanted behaviour": When Full text search is activated, the option "Search within words" under "My Music" seems to have no effect. So eg if I search for "Round The Christmas Tree" songs like "Rocking Around The Christmas Tree" are not found - or is there another option I missed? ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115492 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Can't access web-interface with 8.3.0-1632725023 (latest nightly)
Thanks, problem solved by installig a backup of my database (deleting "cache" folder, copying "cache" folder from my last backup). Crazy issue - database obviously worked with apps and devices, but not with the web interface - maybe caused by google drive now set up to backup "cache" folder while lms is running... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115198 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Can't access web-interface with 8.3.0-1632725023 (latest nightly)
It's a little off topic but maybe someone has an idea: - LMS is running on 127.0.0.1:9000 (resp. http://192.168.1.2:9000/) on Win10. - LMS System Control says "ok" - SB Touch, Radio and Android App Squeezer can reach LMS (showing 192.168.1.2:9000) - All browsers CAN'T reach LMS (tried it on 2 different Win10 machines (that CAN reach LMS via LMS system control) and from the browser of my smartphone - the same smartphone that CAN reach LMS via Squeezer-app). I habe NO idea what is blocking here. Look in Kaspersky after the "injection" issue - it is disabled! Tried to deactivate Kaspersky - no effect! Till this afternoon it ran fine... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115198 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Can't access web-interface with 8.3.0-1632725023 (latest nightly)
Thanks - just couldn't manage to delete the post / thread. The issue is obviously NOT caused by LMS - there is "our of nowhere" a network printer on port 9000 - just have to look for network changes. ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115198 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Can't access web-interface with 8.3.0-1632725023 (latest nightly)
Anyone else seeing this? Calling http://127.0.0.1:9000/ shows a blank site - tried on different computers and with different browsers also tried to clean cache. Access via app (Squeezer) oder SB Touch / Radio works normal. frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115198 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] "Misspelled" artists remain in the database
mherger wrote: > What would such a clean up do which the regular scan shouldn't already > be doing?... It was just an idea to keep the "new" quick (and I like it to be this quick ;)) to "outsource" options like looking for orphaned entries in a separate routine You only use once a week or once a month... (the "n" I use daily). mherger wrote: > I think we have to clearly identify the open issues we > have. Some of them already are on Github (eg. > https://github.com/Logitech/slimserver/issues/547). Can we compile a > complete list, with easy descriptions to reproduce the issue? OK, for now I have 3 main issues (I started to look into the sqlite myself to get some "idea" where they result from, but I'm really not an expert ;-)) 1. Artists without any tracks in the database are still listed and still linked to their "old" entries (I just reproduced this by looking in the db and found the reason - the misspelled name ("Beetles") was still in another track tagged with anouther contributor role (composer). So it still had an ID in contributors - and was linked in contributor_track just to this ONE track (after correcting the composers spelling it was gone). But the main problem is, that as long as the contributor id is "active" there seems to be still a connection to "old" entries, where it was mentioned before (couldn't see where it resulted from, now it's gone - will keep an eye when it happens again) 2. Chaning capitalization / lower case in FILENAME leads to double entries (I can reproduce this issue ONLY if the filename is changed - changing capitalization in another tag (e.g. track, artist) seems to work fine) 3. Adding tracks to an existing albums result in two albums of the same name (Happens when You add tracks from a deluxe edition e.g.: - Standard edition is in database (one album, 10 tracks) => all fine - You add track 11-13 from the deluxe edition: SAME (windows) folder, SAME album name, SAME year, SAME album artist, SAME compilation tag eg...) => You have TWO albums of the same name and artist in Your db, one with track 1-10 , the other one with track 11-13) Many thanks for caring Frank Once we have a good understanding of what was wrong we can look into how to fix the issues. I believe if they were easy to fix, this would have happened long before. But maybe we could indeed simply add a purely database based cleanup step, eg. figure out orphaned entries etc. > There are a few more "bugs" (e.g. the "Windows bug" (I know, it is > caused by windows and not by LMS, but it's frustrating) of being not > case sensitive (e.g. If You correct a file name from "...beatles..." to > "...Beatles..." You have TWO entries in Your database, pointing to the > same file (one with small letter, one with capital letter)... Could probably be tweaked to behave better, too. frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115021 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] "Misspelled" artists remain in the database
slartibartfast wrote: > I have always found that "new and changed" scan can leave lots of > unexpected things behind. The only way to be safe is to do a "Clear and > rescan" or remove incorrectly tagged items, do a "new and changed" scan, > replace corrected items and do another "new and changed" scan. Thanks! Yes, I have the same experience and sometimes I do it that way (moving files to a "quarantine" ordner, do a "new", correct them and move them back, do another "new"). But I guess/hope this forum is a chance to make LMS even (still) better and find a solution without those workarounds... btw: I just looked into the sqlite-database and "try" something with a new scan... frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115021 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] "Misspelled" artists remain in the database
One bug about cleaning up database, that still exists (I just did a clear scan a few weeks ago): If You correct an artists name (e.g. misspelling), the old artist remains in the database although it has NO existing tracks. e.g.: - You have misspelled "Beetles" on some tracks in Your database. - You correct it to "Beatles" - You do a "new & changed scan" - You search for "Beatles" (and click on the artist name) - the tracks (before tagged with "Beetles") are found - FINE! - You search for "Beetles" (and click on the artist name) - the tracks (before tagged with "Beetles") are still found. When You "click" them, it shows "empty" ("leer"). So they are really gone - but there still is a connection between the misspelled artist and the (now corrected) tracks. One idea: Maybe we could invent something like a "Database cleanup" routine (in addition to the "new & changed") - I saw something like this in Media Monkey. There are a few more "bugs" (e.g. the "Windows bug" (I know, it is caused by windows and not by LMS, but it's frustrating) of being not case sensitive (e.g. If You correct a file name from "...beatles..." to "...Beatles..." You have TWO entries in Your database, pointing to the same file (one with small letter, one with capital letter)... btw: THANKS for Your great work. Frank frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=115021 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] How to get rid of "old" playlists?
mherger wrote: > > Hmm... that's a good question. They certainly should be removed. Would > you mind dropping me a copy of your library.db? > Well ... a few minutes after I posted I found a workaround - I pointed the "Playlist"-directory back to "C:\Users\\Music\Playlists" that was already empted, did a "playlist only" scan - and they were gone. Then I pointed back to "D:\playlists", did another playlist-scan - and now I'm fine. So I guess, LMS really saves the path a playlist comes from - so "C:\playlist\123.m3u" is another playlist than "D:\playlist\123.m3u". mherger wrote: > > BTW: did you ever consider running LMS on a Linux system? It would be > interesting to see how it performed there, as I believe it feels more at > > home on any system other than Windows... To be honest: I once did, but I'm a music journalist and not so much into system technology besides windows that I use for my daily work. So I sold the LINUX system again for doing my whole work on windows wasn't an option (for may colleagues all use windows) and two systems didn't seem to be a good idea... frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114929 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Cover art gone - only 50x50 thumbnails exist
mherger wrote: > >I'm not sure of a clean way to do this. But you could shut down LMS, > delete artwork.db, restart and run an incremental rescan? Worst case you > > try another full scan. Only takes 30h, you said?... Forgot to answer this - no, it didn't work ;-) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114856 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] How to get rid of "old" playlists?
This gets me crazy: While installing my new system, I put my playlists into the default folder "C:\Users\Music\Playlists". LMS found 1.204 playlists. Fine. After installing my system, I moved them to my "data hard disc" D:\ ( D:\Playlists ) and changed the playlists path to D:\Playlists (btw: My music is on a separete hard disc "M:" ) After a new & changed scan I found ... 2.408 playlists, exactly everyone was "doubled". So I deleted ALL playlists but 1 from the D:\ folder (from the C:\Users\... they were already gone), did a new scan and LMS wrote "found 1 playlists", "deleting 1.203 playlists" ... and after that I had "only" 1.204 playlists - those ones already deleted from C:\Users\... What can I do to get rid of them? They are not there anymore in the folder and LMS is not pointing to that directory in any way (I see, guess, hope...) Why aren't they deleted even by a "playlist only" change? Shouldn't the scanner detect, there are 0 (or in may case: 1) playlist in the given directory and delete anything else? (OK, I'm down to 13 hrs. for a full scan but I hope to get rid of them in another way...) Thanks Frank frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114929 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Cover art gone - only 50x50 thumbnails exist
mherger wrote: > > Are you saying that you cancel the scan and restart a "rescan" the next > day? That's likely to ask for trouble. You should definitely find a way > to be able to run scans through without interruption.( Indeed I did and saw, it wasn't really a good idea... ;-) mherger wrote: > > What's your server hardware an number of tracks nowadays? ... so I upgraded my hardware this weekend and did a full scan of about 1.070 k tracks in 13 hours. That's acceptable. btw: Windows 10 Pro 64bit on an Intel Core i5-8279U CPU @ 2.40GHz (up to 4.20 GHz) system with 2 x 8 MB RAM. ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114856 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Cover art gone - only 50x50 thumbnails exist
mherger wrote: > > I'm not sure of a clean way to do this. But you could shut down LMS, > delete artwork.db, restart and run an incremental rescan? I tried this this afternoon - no effect :( mherger wrote: > Worst case you try another full scan. Only takes 30h, you said?... Yes. problem is, for security reasons I don't have my server running over night so I have to break and restart it three times (means 3 days no music). So I may step back to a backup before the last initial scan - this was fine but it had some "undeleted" files produced by the "new and changed" scan over the months. I will report in another thread, this is IMHO the "real problem", the initial scan was my way to find a "quick" solution... When I started with LMS more than 10 years ago, it was no problem to have an initial scan every week or so, lasting a few hours. But my library grew (as I guess it did for the most who does NOT want to rely on streaming services) so it is not an option anymore... :( ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114856 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Cover art gone - only 50x50 thumbnails exist
] Slim::Web::Graphics::artworkRequest (83) Artwork request: music/b0630763/cover [21-07-14 00:31:23.6665] Slim::Web::Graphics::artworkRequest (123) Resize specification: [21-07-14 00:31:23.6667] Slim::Web::Graphics::artworkRequest (289) No cover found, translated to html/images/cover.png [21-07-14 00:31:23.6676] Slim::Web::Graphics::artworkRequest (357) Using existing pre-cached file: C:\PROGRA~2\SQUEEZ~1\server\HTML\Default\html\images\cover.png Looks like server lost connection to my harddisk (makes me wonder, it's connected via USB, no network drive) during initial scan and so skipped the "resizing" - with the exception of the "50x50" one? Just did a test: - I played the file => artwork is NOT shown (on radio, touch, "big" image in browser) - "saved" the file to give it a new timestamp and played it again => artwork IS shown on all devices So it's no an option to "re-save" all of my files. Is there any way to do an "only artwork" scan, so the server scans all the files, where it has no artwork stored? Thanks! frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114856 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Cover art gone - only 50x50 thumbnails exist
Hi, after doing a complete "new" scan of my database (ok, it lasted > 30 hrs. but 1x-2x a year I do ;-)) with latest beta, the covers for many albums are gone and only the 50x50 thumbnails are there. BEFORE the rescan all worked fine... Situation: /music/d84343b4/cover_50x50_o - is there for EVERY album /music/d84343b4/cover_150x150_o and /music/d84343b4/cover - are MISSING with may albums. I didn't change any settings. In every case: - Folder.jpg is in the albums folder - the cover art is included in the *.mp3 (using mp3tag) Is it NOT a problem of the web browser or cache: Problem exists in web browser as well as on Squeezebox Touch and Squeezebox Radio as well as using eg Squeezer app (Android). What has gone wrong and more important: How can I repair (I did some update scans afterwards, nothing has changed... :( ) Thanks! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=114856 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Stream without sound
bpa wrote: > Out of curiosity - why did you start this thread in the Developers Beta > forum ? It is way off the beaten track. Oh, I thought I already answered - sry, for the delay. When I started the post it seamed to me like it was software driven - maybe caused by LMS 8.0.x - for something didn't work anymore that definitely worked last year on LMS 7.9.x , and I remembered such things like having to upgrade my Radio for LMS 8.x so I guessed it was a bug or a new setting in LMS. ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Stream without sound
bpa wrote: > Out of curiosity - why did you start this thread in the Developers Beta > forum ? It is way off the beaten track. For it worked last year and ain't working anymore I guessed it referred to some changes made in LMS 8.0.x (I remember I had to update my firmware for the radio eg, so I thought about a software-driven change or "bug". But as I said before, if it's hardware driven I have to cope with it (and use the analog output for this stream). ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Stream without sound
OK, found how to check the stream information in my soundbar - with "usual" streams or mp3 from my LMS it says "LPCM", with THIS 96 kbp/s stream it says "NO IN". So it should be either SB Touch doesn't play it out on its optical digital - or my soundbar doesn't receive it.. If there is no way to change it in SB Touch, I guess I have no chance... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Stream without sound
bpa wrote: > I made a typo sry, I was confused, too ;) bpa wrote: > > It "feels" like your DAC does not support 32kHz. > What is make/model ofthe DAC on the digital connection so specs can be > checked. > Is connected via optical or coax (some DACs interfaces have different > specs ) ? > It's via optical connected to my soundbar Sony HT-RT3 - it has an optical digital input . I checked the manual and there seem to be no limitations... bpa wrote: > What is the URL for the 128kbps. e.g. http://playerservices.streamtheworld.com/api/livestream-redirect/QMUSIC.mp3 and MANY thanks again! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Stream without sound
bpa wrote: > The http stream plays OK for me on LMS 8.0.0 30Nov, on a clean Touch (no > EDO etc.) on Windows 10 20H2 Many thanks for trying, so it's obviously not caused by the stream or the software. I know found the problem - but not the solution: It's obviously caused by a 96kHZ-Stream through the digital output. If I play using the analog output or the headphone jack, it plays fine. If I play a 128 KHz stream using the digital output, it plays fine. If I play a 96 KHz stream using the digital output - no sound! Is there any chance to change this behaviour? Thanks :) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Stream without sound
bpa wrote: > It is a https URL. Thanks, I forgot to mention, I also tried the http://icecast-qmusicnl-cdp.triple-it.nl/Qmusic_nl_classics_96.mp3 with the same result, hearing no sound (btw. using the lastest nightly, actually LMS 8.0.1r1606756069 (on Windows 10 2004) and a SB Touch with latest firmware (I guess) 7.8.0 r16754.) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Stream without sound
I have a seasonal web stream ( "Q Music Christmas", NL ) I listen to every year in december. Last year it worked, this year it doesn't. The strange thing: - stream starts - progress is shown ("time") - track information are shown correctly (and change with every new track) ... but NO sound can be heard. If I start the stream using my web browser or VLC it runs finde. Any idea what I get wrong? btw, URL is https://icecast-qmusicnl-cdp.triple-it.nl/Qmusic_nl_classics_96.mp3 Thanks! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=113346 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] LSM splits one album into multiple albums with the same name
Yes, that' the point. New & changed scans doesn't always work as expected. They are very good programmed but sometimes buggy. So it might bei s way to improve them instead of using several workarounds..? ;) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112620 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] LSM splits one album into multiple albums with the same name
slartibartfast wrote: > New and changed scans don't always do what you expect. A clear and > rescan should fix it. Alternatively remove that album folder, do a new > and changed scan then replace the folder and do another new and changed > scan. > yes, this is the workaround I use (moving the folder to antother directory (I call it "quarantine" for years, btw) , do another new, move the folder back, do once again a "new") - but I thought, why always use a workaround if there is a way to fix it? :) The above described correcting of "disc nr"-tag results in the same bug. (just to explain: a clear and rescan runs for 6-8 hours in my directory. I do it every one or 2 months, but it is no good idea to do it after every "tag correction" ;)) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112620 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] LSM splits one album into multiple albums with the same name
This is something I watched several times but no I have one case where I can reconstruct how it happened: I have one album in one folder (as usual) in my database. No I see, that 2 of the album's tracks have the wrong album-tag. (eg Track 3-10 are correctly labelled as "Album XYZ", Track 01 and Track 02 are labelled as "Album AB" and "Album CD") and correct just the album-tag to "Album XYZ". After the next "new & changed" I have 3 albums of the same name (and artist) in my database, all named "Album XYZ" - one contains "Track 01", the 2nd one "Track 02" and the 3rd one Tracks 03-12. This remains also with the nex "new & Cnahnged" scans. So LMS obviously doesn't seem them as 1 album although they are all in the same folder and all labelled with the same album (and albumartist) tag... frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112620 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] LMS 8.0 - Playlists comepletely removed (and added) with every new+changed scan
mherger wrote: > Are you using the PlayHLS plugin? Ah, sry, didn't see Your question before: No I don't. ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112395 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] LMS 8.0 - Playlists comepletely removed (and added) with every new+changed scan
mherger wrote: > I reviewed the code and didn't see how that would have changed between > LMS 7.9 and LMS 8. Are you sure it did? Yes, i had it this way before (using a subfolder) ... and sure..? I would say YES, but You are the expert :) nevertheless: I thought it would be a "changing one line thing" (like "excluding the path given in "playlists" from the regular music scan), but if it's more complicated it's maybe not worth You spend too much time in it and I will move my directory (and change the relative paths to absolute ones). Or simply "live with it" (it's 3-5 minutes more with every scan so NOW showstopper!) Thanks Frank ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112395 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] LMS 8.0 - Playlists comepletely removed (and added) with every new+changed scan
Scanner maybe sees them as "deleted" ("Handling deleted playlist file:///D:/Test_Subset/__Playlists/Test%201.m3u") though they are still there. If I do a playlist only scan, this doesn't happen: [20-06-14 21:18:17.8960] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1591851652, Thu Jun 11 07:13:03 WEDT 2020) perl 5.014001 [20-06-14 21:18:17.9940] Slim::Schema::forceCommit (2157) Warning: Trying to commit transactions before DB is initialized! [20-06-14 21:18:18.2883] Slim::Music::Import::runImporter (577) Starting Slim::Music::PlaylistFolderScan scan [20-06-14 21:18:18.2888] Slim::Utils::Scanner::Local::rescan (179) Discovering audio files in D:\Test_Subset\__Playlists [20-06-14 21:18:18.3727] Slim::Utils::Scanner::Local::__ANON__ (191) Start processing found tracks [20-06-14 21:18:18.3730] Slim::Utils::Scanner::Local::__ANON__ (199) Connect do DB [20-06-14 21:18:18.3732] Slim::Utils::Scanner::Local::__ANON__ (202) Get latest ID [20-06-14 21:18:18.3739] Slim::Utils::Scanner::Local::__ANON__ (224) Delete temporary table if exists [20-06-14 21:18:18.3742] Slim::Utils::Scanner::Local::__ANON__ (227) Re-build temporary table [20-06-14 21:18:18.3754] Slim::Utils::Scanner::Local::__ANON__ (276) Get deleted tracks count [20-06-14 21:18:18.3765] Slim::Utils::Scanner::Local::__ANON__ (283) Get new tracks count [20-06-14 21:18:18.3767] Slim::Utils::Scanner::Local::__ANON__ (288) Get changed tracks count [20-06-14 21:18:18.3771] Slim::Utils::Scanner::Local::deleteTracks (519) Removing deleted audio files (0) [20-06-14 21:18:18.3773] Slim::Utils::Scanner::Local::__ANON__ (301) Scanning new audio files (0) [20-06-14 21:18:18.3775] Slim::Utils::Scanner::Local::__ANON__ (381) Rescanning changed audio files (0) [20-06-14 21:18:18.3778] Slim::Music::Import::endImporter (709) Completed Slim::Music::PlaylistFolderScan Scan in 0 seconds. [20-06-14 21:18:18.3790] Slim::Music::Import::runImporter (577) Starting Slim::Plugin::ExtendedBrowseModes::Libraries scan [20-06-14 21:18:18.3792] Slim::Music::Import::runImporter (577) Starting Slim::Music::VirtualLibraries scan [20-06-14 21:18:18.4118] Slim::Music::Import::endImporter (709) Completed Slim::Music::VirtualLibraries Scan in 0 seconds. [20-06-14 21:18:18.4135] Slim::Music::Artwork::updateStandaloneArtwork (234) Starting updateStandaloneArtwork for 0 albums [20-06-14 21:18:18.4141] Slim::Music::Artwork::precacheAllArtwork (659) Starting precacheArtwork for 0 albums [20-06-14 21:18:18.4143] Slim::Music::Import::endImporter (709) Completed precacheArtwork Scan in 0 seconds. [20-06-14 21:18:18.4149] Slim::Music::Import::runScanPostProcessing (479) Starting Database optimization. [20-06-14 21:18:18.4158] Slim::Utils::SQLHelper::executeSQLFile (51) Executing SQL file C:\PROGRA~2\SQUEEZ~1\server\SQL\SQLite\schema_optimize.sql [20-06-14 21:18:18.4164] Slim::Utils::SQLHelper::executeSQLFile (80) Executing SQL: [ANALYZE;] [20-06-14 21:18:19.5412] Slim::Music::Import::endImporter (709) Completed dbOptimize Scan in 1 seconds. The reson seems to me that my Playlist directory is on the same hard disk as my music files (M:\ and M:\__playlists), so if he scans "M:" he finds the .m3u playlist, sees them as playlists and for some reason deletes them. I tried to avoid it by excluding .m3u from music scan but this has no effect. If I move the playlists-folder to another hard disk (c:\__Playlists] it's also fine. So, I can handle it, but I don't understand the behaviour (why the "music"-scanner is caring about playlists). Many thanks again Frank ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112395 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] LMS 8.0 - Playlists comepletely removed (and added) with every new+changed scan
mherger wrote: > Please try with a subset and enable debugging for database.sql. > > -- > > Michael [20-06-14 21:17:52.8622] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1591851652, Thu Jun 11 07:13:03 WEDT 2020) perl 5.014001 [20-06-14 21:17:52.9595] Slim::Schema::forceCommit (2157) Warning: Trying to commit transactions before DB is initialized! [20-06-14 21:17:53.2481] Slim::Music::Import::runImporter (577) Starting Slim::Media::MediaFolderScan scan [20-06-14 21:17:53.2485] Slim::Utils::Scanner::Local::rescan (179) Discovering audio files in D:\Test_Subset [20-06-14 21:17:53.4797] Slim::Utils::Scanner::Local::__ANON__ (191) Start processing found tracks [20-06-14 21:17:53.4801] Slim::Utils::Scanner::Local::__ANON__ (199) Connect do DB [20-06-14 21:17:53.4803] Slim::Utils::Scanner::Local::__ANON__ (202) Get latest ID [20-06-14 21:17:53.4810] Slim::Utils::Scanner::Local::__ANON__ (224) Delete temporary table if exists [20-06-14 21:17:53.4812] Slim::Utils::Scanner::Local::__ANON__ (227) Re-build temporary table [20-06-14 21:17:53.4824] Slim::Utils::Scanner::Local::__ANON__ (276) Get deleted tracks count [20-06-14 21:17:53.4835] Slim::Utils::Scanner::Local::__ANON__ (283) Get new tracks count [20-06-14 21:17:53.4838] Slim::Utils::Scanner::Local::__ANON__ (288) Get changed tracks count [20-06-14 21:17:53.4844] Slim::Utils::Scanner::Local::deleteTracks (519) Removing deleted audio files (3) [20-06-14 21:17:53.5113] Slim::Utils::Scanner::Local::__ANON__ (301) Scanning new audio files (0) [20-06-14 21:17:53.5116] Slim::Utils::Scanner::Local::__ANON__ (381) Rescanning changed audio files (0) [20-06-14 21:17:53.6085] Slim::Music::Import::endImporter (709) Completed Slim::Media::MediaFolderScan Scan in 0 seconds. [20-06-14 21:17:53.6094] Slim::Music::Import::runImporter (577) Starting Slim::Music::PlaylistFolderScan scan [20-06-14 21:17:53.6098] Slim::Utils::Scanner::Local::rescan (179) Discovering audio files in D:\Test_Subset\__Playlists [20-06-14 21:17:53.6255] Slim::Utils::Scanner::Local::__ANON__ (191) Start processing found tracks [20-06-14 21:17:53.6259] Slim::Utils::Scanner::Local::__ANON__ (199) Connect do DB [20-06-14 21:17:53.6262] Slim::Utils::Scanner::Local::__ANON__ (202) Get latest ID [20-06-14 21:17:53.6266] Slim::Utils::Scanner::Local::__ANON__ (224) Delete temporary table if exists [20-06-14 21:17:53.6270] Slim::Utils::Scanner::Local::__ANON__ (227) Re-build temporary table [20-06-14 21:17:53.6282] Slim::Utils::Scanner::Local::__ANON__ (276) Get deleted tracks count [20-06-14 21:17:53.6294] Slim::Utils::Scanner::Local::__ANON__ (283) Get new tracks count [20-06-14 21:17:53.6298] Slim::Utils::Scanner::Local::__ANON__ (288) Get changed tracks count [20-06-14 21:17:53.6303] Slim::Utils::Scanner::Local::deleteTracks (519) Removing deleted audio files (0) [20-06-14 21:17:53.6305] Slim::Utils::Scanner::Local::__ANON__ (301) Scanning new audio files (3) [20-06-14 21:17:53.6369] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///D:/Test_Subset/__Playlists/Test%201.m3u [20-06-14 21:17:53.6990] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///D:/Test_Subset/__Playlists/Test%202.m3u [20-06-14 21:17:53.7456] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///D:/Test_Subset/__Playlists/Test%203.m3u [20-06-14 21:17:53.7768] Slim::Utils::Scanner::Local::__ANON__ (381) Rescanning changed audio files (0) [20-06-14 21:17:53.7772] Slim::Music::Import::endImporter (709) Completed Slim::Music::PlaylistFolderScan Scan in 0 seconds. [20-06-14 21:17:53.7780] Slim::Music::Import::runImporter (577) Starting Slim::Plugin::ExtendedBrowseModes::Libraries scan [20-06-14 21:17:53.7782] Slim::Music::Import::runImporter (577) Starting Slim::Music::VirtualLibraries scan [20-06-14 21:17:53.8077] Slim::Music::Import::endImporter (709) Completed Slim::Music::VirtualLibraries Scan in 0 seconds. [20-06-14 21:17:53.8094] Slim::Music::Artwork::updateStandaloneArtwork (234) Starting updateStandaloneArtwork for 0 albums [20-06-14 21:17:53.8100] Slim::Music::Artwork::precacheAllArtwork (659) Starting precacheArtwork for 0 albums [20-06-14 21:17:53.8103] Slim::Music::Import::endImporter (709) Completed precacheArtwork Scan in 0 seconds. [20-06-14 21:17:53.8111] Slim::Music::Import::runScanPostProcessing (479) Starting Database optimization. [20-06-14 21:17:53.8120] Slim::Utils::SQLHelper::executeSQLFile (51) Executing SQL file C:\PROGRA~2\SQUEEZ~1\server\SQL\SQLite\schema_optimize.sql [20-06-14 21:17:53.8128] Slim::Utils::SQLHelper::executeSQLFile (80) Executing SQL: [ANALYZE;] [20-06-14 21:17:54.7221] Slim::Music::Import::endImporter (709) Completed dbOptimize Scan in 0 seconds. ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112395 _
Re: [SlimDevices: Beta] LMS 8.0 - Playlists comepletely removed (and added) with every new+changed scan
mherger wrote: > > > Please try with a subset and enable debugging for database.sql. IMHO > nothing should have changed in that part of the code. Are you using any > > music service integration? > > Michael No, I have no music servie integration activated - but that I'll test next ;) I did TWO scans: First a "playlists only" and after that (after making some more changes to my playlists) a "new & changed". The "playlist only" scan looks "like always" [20-06-13 15:33:15.2958] Slim::Utils::Scanner::Local::__ANON__ (381) Rescanning changed audio files (12) [20-06-13 15:33:15.2999] Slim::Utils::Scanner::Local::changed (1094) Handling changed playlist file:///M:/__Playlists/0%20Charts%20B%20-%20Top%2030%20-%202020-06-06.m3u [20-06-13 15:33:15.3020] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///M:/__Playlists/0%20Charts%20B%20-%20Top%2030%20-%202020-06-06.m3u [20-06-13 15:33:15.6857] Slim::Utils::Scanner::Local::changed (1094) Handling changed playlist file:///M:/__Playlists/0%20Neue%20Alben%20-%202020-05-22.m3u [20-06-13 15:33:15.6883] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///M:/__Playlists/0%20Neue%20Alben%20-%202020-05-22.m3u [20-06-13 15:33:18.5626] Slim::Utils::Scanner::Local::changed (1094) Handling changed playlist file:///M:/__Playlists/0%20Neue%20Alben%20-%202020-06-12.m3u [20-06-13 15:33:18.5637] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///M:/__Playlists/0%20Neue%20Alben%20-%202020-06-12.m3u [20-06-13 15:33:19.0386] Slim::Music::Import::endImporter (709) Completed Slim::Music::PlaylistFolderScan Scan in 11 seconds. The "new & changed" says: [20-06-13 17:06:00.0752] Slim::Utils::Scanner::Local::deleteTracks (519) Removing deleted audio files (1056) [...] REM: 998 of those deleted files are playlists files (files ending *.m3u) [20-06-13 17:08:57.1690] Slim::Utils::Scanner::Local::__ANON__ (301) Scanning new audio files (1005) [20-06-13 17:08:57.1733] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///M:/__Playlists/0%20Charts%20B%20-%20Top%2030%20-%202020-06-06.m3u [20-06-13 17:08:57.3257] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///M:/__Playlists/0%20Charts%20B%20-%20Vlaamse%20Top%2010%20-%202020-06-13.m3u [20-06-13 17:08:57.3726] Slim::Utils::Scanner::Local::new (905) Handling new playlist file:///M:/__Playlists/0%20Charts%20D%20-%20Airplay%20Top%2030%20-%202020-06-12.m3u [...] REM: Here are all those 998 "new" *.m3u-files added (so from those 1005 audio files 998 are in fact playlists) [20-06-13 17:11:38.1406] Slim::Utils::Scanner::Local::__ANON__ (381) Rescanning changed audio files (0) [20-06-13 17:11:38.1410] Slim::Music::Import::endImporter (709) Completed Slim::Music::PlaylistFolderScan Scan in 165 seconds. Maybe You see the difference between 11 seconds and 165 seconds for the playlist scan, too? This results from handling all playlists as "new" Frank (by the way, I didn't deactivate any filename extensions, nor for audio files neither for playlists) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112395 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] LMS 8.0 - Playlists comepletely removed (and added) with every new+changed scan
I've just upgraded to 8.0 - so good to see, LMS is going on :) Thanks, Michael - and started some testings (You maybe know, I'm the one withe the 800k database and mostly interested in the database "handling"). I'm just analyzing some changed behaviour in the logs, but first I saw, that ALL playlists are removed with every "new & changed"-scan - and added at a later stage. My playlists are all *.m3u (Windows 10 architecture, btw) and they are removed with the deleted (music-)files (I worried why it removed so much "songs" though I didn't delete anything first). In a later stage it recognizes all playlists and adds them again. In the end, they are (still) there (or: there again) but it takes some time more than the "old way" only to handle changed playlists. Is this a bug or wanted behaviour? Is it related to the *.m3u type? Thanks Frank ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112395 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] New database structuer in 8.0
I admit, I "ignored" 8.0 til now - for I didn't know about. I just saw it, when I joined the forum again to report a problem in 7.9 - but now I will first see, if it still exists in 8.0. One question: 8.0 does a full re-scan after install - is this necessary or optional? Would it be enough to copy and paste the (before saved) 7.9 database? And an aditional question: is there any listing of "features" and avantages of 8.0? Till now I only found mhergers initial post @github https://github.com/Logitech/slimserver/commit/43bc2ab494b1c2205cbde7d43b4c7e7c10f7839b Thanks! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=112377 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] search.html gives no results
mherger wrote: > Are the configurations exactly the same? Full text search on/off on all > > of them? Thanks Michael, You obviously made my day. I double checked all options and they are the same, but I forgot the plugins for I only use the standard configuration without additional plugins and didn't know full text search is set to ON by default. After deactivating and restarting LMS search seems to work now :) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=111096 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] search.html gives no results
mherger wrote: > > A full wipe & rescan should fix this. Meanwhile I did - now the "search.html" finds Titles (and genres) but no Albums or Artists So if I search fpor Beatles it finds titles containing the word "beatles" - but not the artist itself and no album (like "The Beatles (White Album)" or "Beatles 1967-1970" Maybe to remind: I'm using the SAME database on 4 installations - 3 of them work perfect - only 1 (!) shows this strange behaviour. To explain what I'm doing (on all 4 systems): I have LMS running on ONE system (for only this one is connected to the library - the other systems are for mobile use in laptop and webserver, of course there I don't wanna have the songs "online", but the library to do some reasearch). This installation is finde. On the other 3 systems I've install a "clean" LMS and do a database search (finding NULL of course). Then I stop the server, copy the artwork.db and library.db from my "production" system to the other installations (laptop, webserver...) and start LMS again. On 2 out of 3 it works perfect, ONLY the 3rd one shows this strange behaviour. So IMHO there has to be a reason outside of my database in the way LMS works (the 2 "working ones" are Windows 10 installations, the "strange one" is on Windows Server 2019 - should be the same but MAYBE there is the problem LMS suffers...?! THANKS again for Your efforts! frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=111096 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] search.html gives no results
ne 727) frame 25: main::idle (slimserver.pl line 677) frame 26: main::main (slimserver.pl line 131) frame 27: PerlSvc::Interactive (/PerlSvc.pm line 99) frame 28: PerlSvc::_interactive (slimserver.pl line 0) frame 29: (eval) (slimserver.pl line 0) [19-10-19 10:49:24.9724] Slim::Control::Request::execute (1888) Error: While trying to run function coderef [Slim::Control::Queries::artistsQuery]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: no such table: fulltext at /Slim/Schema/Storage.pm line 126 ] [19-10-19 10:49:24.9725] Slim::Menu::BrowseLibrary::_doRequest (983) Bad dispatch! [19-10-19 10:49:24.9794] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: no such table: fulltext [19-10-19 10:49:24.9796] Slim::Schema::Storage::throw_exception (122) Backtrace: ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=111096 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] search.html gives no results
I see a strange behaviour on ONE of my 4 LMS-installations (on different computers/servers). 3 of them work fine - on the 4th one: The search box (the magnifying glass symbol) - afaik linking to "search.html" - gives NO results, whatever I search for. The advanced search - linking to "advanced_search.html" - does find everything I expect to be found. On all servers I've installed the last nightly and I see this behaviour for two months now (and several updates) so it doesn't result from a special releaese. I don't see the reason - the only difference I see, the 3 "working" ones are running on Windows 10, the fourth one on Windows Server 2019. I could imagine a problem with relative paths/directorys or something like this, but I don't see the reason or any hint how to solve this... :( ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=111096 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Installing LMS on a cloud server
I promised to report and the most important things: 1. It works 2. ... halfway. First of all I installed on Windows Server (2019) - I'm a "Windows Kid" and so it was easier to me to compare and copy to and from my local installation. What I did? I installed LMS (for Windows, lastest nightly) on the Cloud Server - it worked. Then I stopped LMS, deleted the "cache" directory and copied the whole "cache" directory from my local installation of LMS to the Cloud Server. I restarted the LMS, called the web interface ( http://*MyIP*:9000/ ) from any other computer on the www - works. The only thing that DON'T work (but works on my local installation of LMS) is the search box. "Advanced Search" works fine. Browsing from the homepage artists, albums, compilations ... works perfectly - and if i browse / "click" an artist, it shows all albums this artist is on. Everything works as it should be, The only thing that doesn't work is the searchbox (from the homepage) it shows no results. Even the Search from homepage (beneath the browing sections) gives no result. (e.g. it shows "Home > Search > Artists (Beatles)" without results - but I definitely own songs and abums by the Beatles) If I see it right, it's the "search.html" that is not working (while the "advanced_search.html" is working fine). Any idea what causes this behaviour and how to solve it? Side information: I use "squeezer" on Android which seems to work in a similar way and brings no results as well while browsing works perfectly. Curious thing: When I perform a search for "Rock" btw. I get no results either in albums, artists nor songs - but I get some hits in "genres" (rock, rocknroll, hardrock).. Maybe this helps to locate the problem? Thanks Frank frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110703 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Installing LMS on a cloud server
mherger wrote: > > I'm not sure this will work: if LMS can't find the files it would start > > removing them from the database. > Many thanks again. On windows it works (Copy the .db from Desktop PC to Laptop and can browse it when I'm on the road with my Laptop. So I'll give it a try and report it here. What configuration You would recommend (Debian, Ubuntu, CentOS)? ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110703 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Installing LMS on a cloud server
Did anyone try to install LMS on a cloud server (eg from ionos/1und1). I wanna try, the idea is to install the LMS package there, copy my database ( library.db or the whole "cache"-directory ) onto the server and then adressing it from "all over the world" on http://*myIP*:9000 ) Can anyone tell if this works or if there should be any problems I don't see yet? They offer LINUX with either CentOS 6 CentOS 7 Debian 8 Debian 9 Ubuntu 16.04 Ubuntu 18.04 Which should be best for installing LMS and which LMS installer do I have to chose (sorry for the stupid question, but I'm running LMS for Windows since mor than 10 years ;) ) THANKS! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110703 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
atrocity wrote: > I use the VPN method drmatt suggested for this situation. I have > OrangeSqueeze on my phone for home use but if I'm away I start up the > VP, which lets OrangeSqueeze connect just as it would from home. > > Being able to query my library remotely has definitely prevented me on > multiple occasions from buying something I already own! Thanks for Your reply, but this means, You have Your server at home "always running"? I don't prefer this, if I'm not at home myself, server is "offline" for security reasons... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
JerryS wrote: > I can't really get my head around why you are trying to do this Well, the answer is simple: I am working in the music biz, have a 725k database/archive and I am very often abroad so I use my LMS-database when I have to find out if I have song xy by artist yz in my database and can use it for a show/program or even to see, on what album the song xy is/was available. So it would be great to have my LMS always with me (of course I could do an Excel-export but updating it and browsing an excel-sheet with 725k rows via smartphone and using filters isn't that comfortable). JerryS wrote: > instead of converting SQlite to MYSQL, why not just set up LMS to use > MYSQL instead of SQlite? That's what I do. OK, THANKS ! that's probably a good idea. I had in mind it wasn't recommended for huge databases to user MYSQL and it wasn't supported anymore. Could You give me a hint where I can find the option to change from Sqlite to Mysql (I remember there was an option about 2 or 3 years ago but I can't find it anymore...) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
mherger wrote: > > My server (ionos) has MySql support (Sqlite not sure). > > What are you running on your server? PHP has sqlite support built in. > > And without further knowledge of your application it's hard to tell how > > to best do it. [...] Or re-write the app to > use SQLite directly etc. > Thanks for Your quick answer - and I propably expressed my idea to complicated, it is much more simple (I guess): My "best" experience would be just to copy the "cache" directory onto my web server, maybe even the prorgram directory and the "server" directory, make a few modifications, start the index.html and ... done ;) or (second best) having the "library.db" on my (web)server and browse them with some sqlite-android-app... ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Running LMS on web server
I'm looking for an easy way to run LMS on a web server / cloud server. The idea is to have the database always with me, so I don't wanna hear music with it but "only" use the database to browse my library if I'm not at home, so I don't wanna do "imports" but preferably copy my local LMS-files/database to the server. My server (ionos) has MySql support (Sqlite not sure). Till now I had a (selfwritten) PHP-script for my MySql database , exported the sqlite from my local LMS installation (into *.csv) and re_imported it on my webserver. But this is pretty boring job so I look for an easier way to either a) 'automatically' convert Sqlite into MySQL b) run LMS "as is" on my webserver (copying the *.db files to the server) Any ideas? If You might see, I'm not very experienced in databases (except a little MySQL) so I just don't know how Sqlite works on a web server... :( ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] *.wav - Files not detected by "new & changed" scan
Since a few days I recognize *.wav-files no longer being detected by a "new & changed scan" (most recent scan with Logitech Media Server Version: 7.9.2 - 1554891466 ) - before they did. Did anything change or could there be any reason for this behaviour? I just had a look into Settings => Advanced => Disabled Audio File Extensions - this is left empty. Any other ideas or settings where they could be excluded/disabled? Thanks! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110454 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Downloadserver emptiy or down
mherger wrote: > I'm sorry for the late response. I did notice this earlier today, but IT > is a few timezones away. So it took a little longer to get fixed. Looked > like a web-server mis-configuration. I'll check what exactly went wrong > after the weekend. Thanks @mherger! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110299 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] Downloadserver emptiy or down
http://downloads.slimdevices.com/ seems to be "empty" or down...? ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110299 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
[SlimDevices: Beta] iTunes integration
Short question: Where can I DE-ativate iTunes integration in LMS (last nightly) I can't find it anymore. (Thought it had been in the system administration in the "Library" tab) Reason for my question: Since 2 or 3 nightly LMS AFTER a "new & update"-scan automatically starts to scan my iTunes folder. Don't know if I changed something ("unwanted") or if it's new behaviour in last nightlies in any case: I wanna deactivate this... Thanks! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110122 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Scanner MUCH quicker in r1529096694
mherger wrote: > Could you please update to the latest again? Now it's slower than a "clean scan": in 22 minutes (!) "new" scanned just 866 tracks. So I could assume it will take about 240 hours or 10 days to do the "new & changed" - I will interrupt this... ;-) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=109162 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Scanner MUCH quicker in r1529096694
mherger wrote: > Can you do a BMF and > see whether file names are still correct? I browsed for a while but could see now different behaviour from before mherger wrote: > Would you happen to have files with non-latin characters (Chinese, > Cyrillic, Hebrew etc.)? I hope: NONE, so I'm quite sure 99,9% None. I convert the filenames into latin charachters (even converting the german "Umlaute" ä, ö, ü, ß) mherger wrote: > That's where the whole > database would be re-written to optimize disk space allocation. > Previously this would have been run in memory, and only be written to > disk when done. > > How large is your library.db? ok, I never saw this problem. My library.db is about 984 MB (the artwork.db btw about 1,5 GB) mherger wrote: > Could you please update to the latest again? That previous change > introduced a problem with the filename expansion in case of Windows > short filenames (abcdef~1.mp3). Would you have many files without > metadata? I will update just in a few seconds. With metadata it's the same as with non-latin characters, for I try to re-tag every file there should be meta-data and 'correct' filenames to 99,9% of my DB, btw. Many thanks again for keeping up the great work! ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=109162 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Scanner MUCH quicker in r1529096694
mherger wrote: > > Since which build? Just since THIS sepcific build from last friday r1529096694. I try every nightly and do a "new & changed"-scan every day (sometimes twice a day), so I would have recognized if this had happened earlier mherger wrote: > > There was a change specific to scanning very large connections about > two > weeks ago: > BUT I would have expected this change to actually slow down the process, > > rather than speed it up... Yes, I've recognized this, too, some one or two builds ago - it slowed down the server VERY much (a new lasted 2-3 hours instead of 15-20 minutes, but it happened only a few times, normally the scan was in the "15-20 minutes window") mherger wrote: > >Can you tell me about your server system (OS, memory, disk system where > > cache lives)? Windows 10 Pro intelCore i7-2600, 3,4 Hz 8 GB RAM Cache on local HDD (2TB, NTFS) ---- frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=109162 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta