I'm experiencing duplicate "track" records in TrackStat for songs which
have identical musicbrainzids. Symptoms are that I can't browse certain
albums with trackstat any longer, giving me an error like in the
attached server log. The number of duplicate TrackStat entries increases
with every re-scan. I've been checking this by exporting the trackstat
statistics, editing out the "history" records, and then running a
"unique" test on a unix command line.
This is the result from yesterday:
Code:
--------------------
$ grep musicbrainzId
/media/stubenas/usb1/trackstat/trackstat_scheduled_backup_20120425-manual-nohist.xml
| sort | uniq -c -d
2381
<musicbrainzId>0b495e68-da5b-49a9-852d-9771d4d1f63d</musicbrainzId>
289
<musicbrainzId>183abdbe-7cbd-4df5-a5d8-97a1a29af0d1</musicbrainzId>
145
<musicbrainzId>47a39498-42fe-42a5-8881-74469f31af07</musicbrainzId>
145
<musicbrainzId>4cbbaef0-92d5-4e8f-a162-472cf6a81afb</musicbrainzId>
145
<musicbrainzId>5fa66963-a450-44e2-b72f-95e38b7881c6</musicbrainzId>
145
<musicbrainzId>692818d2-d7e4-47f2-b8cc-5ae47b6c2d04</musicbrainzId>
145
<musicbrainzId>6c61baa3-eac2-4391-b3e2-c6a2f1a74f22</musicbrainzId>
145
<musicbrainzId>93c3216b-2da2-41e1-90de-dafb93094cd8</musicbrainzId>
145
<musicbrainzId>9484cd4f-a3ee-44a0-8cd6-a34ab969bd95</musicbrainzId>
145
<musicbrainzId>95b78add-436c-4d51-b9bb-8e20a99c38ea</musicbrainzId>
145
<musicbrainzId>9ac1ebc5-a8ed-4108-a641-b274f9e0af49</musicbrainzId>
145
<musicbrainzId>b54db3b3-4a5f-404e-b4aa-d96c3110935a</musicbrainzId>
145
<musicbrainzId>e034c992-bd36-4c7b-80fc-df1fa1d23506</musicbrainzId>
--------------------
And this from today, after two re-scans:
Code:
--------------------
$ grep musicbrainzId
/media/stubenas/usb1/trackstat/trackstat_scheduled_backup_20120426-manual-nohist.xml
| sort | uniq -c -d
2381
<musicbrainzId>0b495e68-da5b-49a9-852d-9771d4d1f63d</musicbrainzId>
289
<musicbrainzId>183abdbe-7cbd-4df5-a5d8-97a1a29af0d1</musicbrainzId>
149
<musicbrainzId>47a39498-42fe-42a5-8881-74469f31af07</musicbrainzId>
149
<musicbrainzId>4cbbaef0-92d5-4e8f-a162-472cf6a81afb</musicbrainzId>
149
<musicbrainzId>5fa66963-a450-44e2-b72f-95e38b7881c6</musicbrainzId>
145
<musicbrainzId>692818d2-d7e4-47f2-b8cc-5ae47b6c2d04</musicbrainzId>
149
<musicbrainzId>6c61baa3-eac2-4391-b3e2-c6a2f1a74f22</musicbrainzId>
149
<musicbrainzId>93c3216b-2da2-41e1-90de-dafb93094cd8</musicbrainzId>
145
<musicbrainzId>9484cd4f-a3ee-44a0-8cd6-a34ab969bd95</musicbrainzId>
149
<musicbrainzId>95b78add-436c-4d51-b9bb-8e20a99c38ea</musicbrainzId>
149
<musicbrainzId>9ac1ebc5-a8ed-4108-a641-b274f9e0af49</musicbrainzId>
149
<musicbrainzId>b54db3b3-4a5f-404e-b4aa-d96c3110935a</musicbrainzId>
149
<musicbrainzId>e034c992-bd36-4c7b-80fc-df1fa1d23506</musicbrainzId>
--------------------
Looking at the cases of duplicate musicbrainzids in my library, they
appear to occur from either of two causes:
1) It seems that somewhere in the migration process, duplicate
musicbrainzids have been slapped on to every song of an album where some
songs where tagged with ids and some weren't. In these cases, all the
songs without ids had been mysteriously tagged with the id of the last
song in order having an id. E.g. in the case of the 2381 duplicates, it
was an album where 20 bonus tracks had been tagged with the id of the
last proper album track.
2) The same songs sometimes appear on a "normal" album as well as on one
or many compilation albums. At least in some cases it seems these tracks
are also tagged with the same musicbrainzid. Not sure if this is how it
is supposed to be, but it makes some sense to me as long as it is the
exact same version of the song.
Now, I can fix the cases under 1) by deleting the duplicate ids from the
tags (leaving the tracks with no id), or by re-tagging them with correct
unique ids. This is what I've done, and these cases are represented by
the numbers that didn't go up between the two scans above. Unfortunately
though, I can see no easy way to get rid of the duplicate entries
already in the TrackStat database.
However there's not much I can do for the cases under 2), and the
duplicates TrackStat entries keep increasing with every re-scan.
This behaviour seems to have been introduced with my updating from 7.5.1
to 7.7.1 a few weeks ago, which correlates to about 75 re-scans since
then.
By the way it also appears that the total number of duplicates above
(4301) roughly correlates with the negative number from the Database
Query "Missing entries in TrackStat" (-4279).
Any ideas about how to solve these problems? Many thanks in advance.
+-------------------------------------------------------------------+
|Filename: trackstaterr.txt.zip |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=13312|
+-------------------------------------------------------------------+
------------------------------------------------------------------------
haschmich's Profile: http://forums.slimdevices.com/member.php?userid=41882
View this thread: http://forums.slimdevices.com/showthread.php?t=94950
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
