Bug 17881 - BMF scan corrupts dB replacing title with file name
: BMF scan corrupts dB replacing title with file name
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.7.1
: PC All
: P1 major with 12 votes (vote)
: 7.7.2
Assigned To: Michael Herger
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-02-06 10:56 UTC by Mikael Nyberg
Modified: 2012-11-01 03:20 UTC (History)
2 users (show)

See Also:
Category: ---


Attachments
server log attachment (5.68 KB, text/x-log)
2012-04-16 04:42 UTC, truthbetold333
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mikael Nyberg 2012-02-06 10:56:38 UTC
BMF scan corrupts dB replacing title with file name .

How to reproduce .

Have an album with files named for example "01-song.flac" or similar .

Make sure it's ok in all UI song are ok, named "song" when browsed via album or srtist or search .

Now go to the album via "Music Folder" with the web-UI start adding files to the playlist.

Now go back to the album view watch how the songs you added to the playlist have a title ""01-song.flac" instead of "song" which is was before.

Workaround.

"Clear and rescan everything" or make your tag app modify the time stamp and "scan for new"
Comment 1 Mikael Nyberg 2012-02-06 10:57:40 UTC
This version have the issue.

Logitech Media Server Version: 7.7.2 - r33811 @ Mon Feb 6 03:07:10 MST 2012
Hostname: hal.home.lan
Server IP Address: 192.168.1.5
Server HTTP Port Number: 9000
Operating system: Red Hat - EN - utf8
Platform Architecture: i686-linux
Perl Version: 5.8.8 - i686-linux-thread-multi
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Total Players Recognized: 4

Also on ubuntu/debian

http://forums.slimdevices.com/showthread.php?t=93204
Comment 2 Mikael Nyberg 2012-02-06 11:07:38 UTC
This bug is the kind that drives you slowly nuts as you library slowly starts to look rubbish ? if you use "Browse music folder" a lot :-/

I don't but some bewildered user are...
Comment 3 jeanieanddon 2012-02-06 11:36:02 UTC
*** This bug has been confirmed by popular vote. ***
Comment 4 Mikael Nyberg 2012-02-06 11:43:02 UTC
Sorry for spamming, must add that this applies to already scanned files.

It's the effect of adding the files to a playlist that triggers the bug.

The fact that the file already is in the dB , might be one more issue that lms scan them again (but does something wrong).
Comment 5 truthbetold333 2012-02-06 13:18:46 UTC
This problem seems to occur in Windows XP also

Logitech Media Server Version: 7.7.1 - r33750 @ Mon Dec 12 09:42:47 PST 2011
Hostname: username
IP: 192.168.1.100
HTTP Port: 9000
OS: Windows XP - EN - cp1252
Platform: 586
Perl Version: 5.14.1 - MSWin32-x86-multi-thread
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Comment 6 Timothy Byrd 2012-02-19 18:02:23 UTC
I am seeing what may be a related issue when I add a track from a flac-image-with-cue album to a playlist.

Quite often the track will not play in the playlist.
Sometimes it wants to play the entire flac-image file.
And occasionally, the track disappears from the album until I rescan everything.

Logitech Media Server Version: 7.7.1 - r33735 @ Mon Nov 28 15:45:08 PST 2011
Operating system: Debian - EN - utf8
Platform Architecture: i686-linux
Perl Version: 5.12.4 - i686-linux-gnu-thread-multi-64int
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Comment 7 Timothy Byrd 2012-02-20 00:55:03 UTC
(In reply to comment #6)
And I'm not the only one:
http://forums.slimdevices.com/showthread.php?p=691537

Andy, do you think it's the same root cause, or should I open another bug for what I'm seeing?
Comment 8 Michael Herger 2012-02-22 05:23:44 UTC
This is a web UI issue.
Comment 9 SVN Bot 2012-02-22 06:07:35 UTC
 == Auto-comment from SVN commit #33857 to the slim repo by mherger ==
 == http://svn.slimdevices.com/slim?view=revision&revision=33857 ==

Fixed Bug: 17881
Description: don't set the track title when we're dealing with a local file - metadata is being extracted from the file itself
Comment 10 Timothy Byrd 2012-02-22 10:31:42 UTC
Okay - I think the playlist issue in my comments is separate, then.

I have opened bug 17900 - please ignore my other comments in this bug.
Comment 11 truthbetold333 2012-04-01 11:01:39 UTC
I am still getting songs appearing by File name when using "Music Folder" under Ubuntu 10.10 using LMS 7.7.2
I don't think the problem is "Fixed"
Comment 12 Mikael Nyberg 2012-04-01 11:33:28 UTC
(In reply to comment #11)
> I am still getting songs appearing by File name when using "Music Folder" under
> Ubuntu 10.10 using LMS 7.7.2
> I don't think the problem is "Fixed"

Works for me in 7.8 with the rpm build .

Did you really do a "clear and rescan everything" as the old damage would not go away because of the fix you must rescan to get a new database (the existing one is corrupted due to the bug) .

The fix is so that it does not happen again .

But stranger things have happened  .

I use SQlite as provided by logitech you don't use your own MySQL instance .
(if you don't know what this is you are using SQlite just as me )
Comment 13 truthbetold333 2012-04-01 12:32:39 UTC
You may be right. I rescanned and I couldn't duplicate the problem. Perhaps a false alarm
Comment 14 truthbetold333 2012-04-01 14:53:23 UTC
It is still happening. I was at first trying it on Squeezeplay and it didn't happen but I think it is an old version of Squeezeplay (Player Model: SqueezePlay
Firmware: 7.6.0-r9286M) so that may be why. At the Squeezebox Player the problem is happening again with music selected from "Music Folder" displaying as a file name.
I am going to start using "Music Library" instead as everyone else seems to do. I may have to do a bit of retagging but it will work.
Comment 15 truthbetold333 2012-04-01 17:00:36 UTC
(In reply to comment #13)
> You may be right. I rescanned and I couldn't duplicate the problem. Perhaps a
> false alarm

edit: It isn't working on my Squeezebox Classic . It was working on Squeezeplay on the computer but that appears to be firmware 7.6 so may be much older
Comment 16 truthbetold333 2012-04-05 07:29:43 UTC
While this Bug is reported "Resolved" I am still having the same problem with tracks selected in "Music Folder" showing up on the web interface and the SB Classic player by file name only even when "Now Playing" Is pressed. I use Ubuntu 10.10 for my OS and have LMS 7.7.2 installed and have done rescan and clear cache commands in LMS
Comment 17 Michael Herger 2012-04-15 23:22:36 UTC
Could you please provide run a wipe & rescan of your collection, then describe step by step how to reproduce the issue? What server versions, what firmware versions, what devices etc.
Comment 18 truthbetold333 2012-04-16 04:42:21 UTC
Created attachment 7668 [details]
server log attachment
Comment 19 Michael Herger 2012-04-16 04:53:50 UTC
Oh, while you're at it: please reproduce with _all_ 3rd party plugins disabled. From the short log snippet you uploaded I do at least see LazySearch and Denon AV or similar.
Comment 20 truthbetold333 2012-04-16 05:11:15 UTC
Funny I thought it was working properly after the clear and rescan but after picking the 10th song from Music Folder I had the incorrect display again. I have attached the server log if that is of any use.
Steps I take are:
1) Navigate with remote to Music Folder
2) Navigate to individual track in a folder 
3) Press Play
4) Display then shows track number-file name.flac both on web interface and player
ie 1. 01 - I Looked Away.flac

If I choose a track from Music Library instead it displays correctly
ie 2. Bell Bottom Blues

When tracks display incorrectly they will persist that way on replay until I do a clear and rescan.



Player Information
Information on all identified devices connected to Logitech Media Server
 
BoomBoom
Player Model: Squeezebox Boom
Firmware: 57
Player IP Address: 192.168.1.103
Player MAC Address: 00:04:20:1e:0d:fb
Wireless Signal Strength: 81%
 
MainSqueeze
Player Model: Squeezebox Classic
Firmware: 137
Player IP Address: 192.168.1.101
Player MAC Address: 00:04:20:07:59:a0
 



Logitech Media Server Status
Logitech Media Server Version: 7.7.2 - r33893 @ Wed Mar 14 05:46:46 PDT 2012
Hostname: MainSqueezer
IP: 192.168.1.100
HTTP Port: 9000
OS: Debian - EN - utf8
Platform: x86_64-linux
Perl Version: 5.10.1 - x86_64-linux-gnu-thread-multi
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Total Players Recognized: 1
 
Library Statistics
Total Images: 4,762
Total Videos: 23
Total Tracks: 20,380
Total Albums: 1,750
Total Artists: 615
Total Genres: 84
Total Playing Time: 1458:14:38
Comment 21 truthbetold333 2012-04-16 05:11:59 UTC
I disabled 3rd party plugins with the same results
Comment 22 Michael Herger 2012-04-17 04:47:03 UTC
Working fine here... Are you sure you're running a clean installation with no stale file left? Anything particular about your setup we don't know yet? Are you using cue sheets?
Comment 23 truthbetold333 2012-04-17 07:00:50 UTC
I unistalled LMS 7.7.1 before installing 7.7.7. I do use Squeezeplay and the problem doesn't occur with that . It is an earlier version of firmware though (7.6.0-r9286M). I do have cue sheets in my Flac directory but I never use them to playback music. Mikael Nyberg said he is having no problems with LMS 7.8 so perhaps it will sort itself out on future installations. I apologize for being such a nuisance. If I can only convince my wife to use Music Library instead of Music Folder it won't be an issue
Comment 24 truthbetold333 2012-08-20 19:04:29 UTC
Bug is marked as resolved but as far I am concerned LMS 7.7.2 did not change the nature of the problem. I still get songs selected from Music Folder showing up on the player by file name and then they seem stuck with that label until a complete rescan is done. I think because most people use Music Library/ Artist this is not an issue for most people. This was not an issue with older versions of SBS or Slimserver

 This is my setup: 
Logitech Media Server Version: 7.7.2 - r33893 @ Wed Mar 14 05:46:46 PDT 2012
Hostname: david-desktop
Server IP Address: 192.168.1.105
Server HTTP Port Number: 9000
Operating system: Debian - EN - utf8
Platform Architecture: x86_64-linux
Perl Version: 5.14.2 - x86_64-linux-gnu-thread-multi
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Total Players Recognized: 2
Comment 25 Zoltan 2012-11-01 03:20:57 UTC
I can confirm that the problem is still present...