kodi 16.1, duplicate albums
#1
Kodi 16.1 showing duplicate albums when tags are identical wrt Album, Album Artist, Artist names, year, and picture. I've cleaned up my collection with easytag. Actually I've cleaned them up and added an album cover. It passes what I think is a sanity check, and even NextCloud's Music app displays them correctly. What am I overlooking? Yup, I'm lost reading, "jarvis messed up my albums threads." Is there a method to inspect kodi's db to determine what exactly it is kodi thinks?

too much info: library is a webdav mount, flac audio files and tags.
Reply
#2
Not sure if you are saying Kodi is showing two of an album that you only have once, or if you have the same album as music files in mutilple folders? I need some more information.

You can of course always look at the underlying SQLite database (MyMusic56.db for v16.1) using a db utility, but I would not mess with that unless you have some understanding of such things.
Reply
#3
Two of an album.

I think I made headway: I was looking in the wrong place:

Code:
# exiftool "4 -"*
ExifTool Version Number         : 10.36
File Name                       : 4 - Weighty Ghost.flac
Directory                       : .
File Size                       : 28 MB
File Modification Date/Time     : 2017:01:25 13:26:06-04:00
File Access Date/Time           : 2017:01:28 08:21:24-04:00
File Inode Change Date/Time     : 2017:01:25 13:26:06-04:00
File Permissions                : rw-r--r--
File Type                       : FLAC
File Type Extension             : flac
MIME Type                       : audio/flac
Block Size Min                  : 4608
Block Size Max                  : 4608
Frame Size Min                  : 14
Frame Size Max                  : 16428
Sample Rate                     : 44100
Channels                        : 2
Bits Per Sample                 : 16
Total Samples                   : 9656724
Vendor                          : reference libFLAC 1.2.1 20070917
Title                           : Weighty Ghost
Artist                          : Wintersleep
Albumartist                     : Wintersleep
Album                           : Welcome to the Night Sky
Date                            : 2007
Track Number                    : 04
Tracktotal                      : 10
Picture Type                    : Front Cover
Picture MIME Type               : image/jpeg
Picture Description             : index.jpg
Picture Width                   : 242
Picture Height                  : 209
Picture Bits Per Pixel          : 0
Picture Indexed Colors          : 0
Picture Length                  : 5638
Picture                         : (Binary data 5638 bytes, use -b option to extract)
Duration                        : 0:03:38

Code:
# exiftool "5 -"*
ExifTool Version Number         : 10.36
File Name                       : 5 - Murderer.flac
Directory                       : .
File Size                       : 30 MB
File Modification Date/Time     : 2017:01:25 13:26:06-04:00
File Access Date/Time           : 2017:01:28 08:21:49-04:00
File Inode Change Date/Time     : 2017:01:25 13:26:06-04:00
File Permissions                : rw-r--r--
File Type                       : FLAC
File Type Extension             : flac
MIME Type                       : audio/flac
Block Size Min                  : 4608
Block Size Max                  : 4608
Frame Size Min                  : 14
Frame Size Max                  : 16508
Sample Rate                     : 44100
Channels                        : 2
Bits Per Sample                 : 16
Total Samples                   : 11578896
Vendor                          : reference libFLAC 1.2.1 20070917
Title                           : Murderer
Artist                          : Wintersleep
Albumartist                     : Wintersleep
Album                           : Welcome to the Night Sky
Date                            : 2007
Track Number                    : 05
Tracktotal                      : 10
Artistsort                      : Wintersleep
Discid                          : 7f09c60a
Musicbrainz Discid              : 4VpV.Z2EFUaw5cOYb5uwt4FD6BA-
Musicbrainz Albumartistid       : cda8e877-fe39-4939-8b09-045d68617367
Musicbrainz Albumid             : b58464aa-7112-41e0-b5c8-d13b7cbdad19
Musicbrainz Artistid            : cda8e877-fe39-4939-8b09-045d68617367
Musicbrainz Trackid             : 466f7395-9299-400c-ac51-a402279b8043
Picture Type                    : Front Cover
Picture MIME Type               : image/jpeg
Picture Description             : index.jpg
Picture Width                   : 242
Picture Height                  : 209
Picture Bits Per Pixel          : 0
Picture Indexed Colors          : 0
Picture Length                  : 5638
Picture                         : (Binary data 5638 bytes, use -b option to extract)
Duration                        : 0:04:22

So I suspect Kodi's doing exactly as expected, easytag doesn't show all of the tags, and I need to remove all these "Musicbrainz" tags which I'm unsure how or when they appeared (kodi, grip or soundjuicer?).
Reply
#4
Double Post.

So, unless this has been done ad nauseum.

Code:
for i in *.flac; do echo "Processing $i"; \
metaflac --show-tag=Artistsort "$i"; \
metaflac --show-tag=Discid "$i"; \
metaflac --show-tag=Musicbrainz_Discid "$i"; \
metaflac --show-tag=Musicbrainz_Albumartistid "$i"; \
metaflac --show-tag=Musicbrainz_Albumid "$i"; \
metaflac --show-tag=Musicbrainz_Artistid "$i"; \
metaflac --show-tag=Musicbrainz_Trackid "$i"; \
done;
Shows the offending tags.

Code:
for i in *.flac; do echo "Processing $i"; \
metaflac --remove-tag=Artistsort "$i"; \
metaflac --remove-tag=Discid "$i"; \
metaflac --remove-tag=Musicbrainz_Discid "$i"; \
metaflac --remove-tag=Musicbrainz_Albumartistid "$i"; \
metaflac --remove-tag=Musicbrainz_Albumid "$i"; \
metaflac --remove-tag=Musicbrainz_Artistid "$i"; \
metaflac --remove-tag=Musicbrainz_Trackid "$i"; \
done;
Removes the offending tags.

I'll know if I'm wrong soon enough. The next guy can make it recursive.
Reply
#5
Actually I hope the next guy will leave his Musicbrainz id tags in place, applied correctly they have a use.
Reply
#6
Well I appear wrong. I'm walking away for now but I'm back to thinking Kodi decided to file them under another album for no apparent reason. Any direction is appreciated.
Reply
#7
I am happy to try and help you, but I need more information. What is the problem, can you explain more clearly?

It could be related to Musicbrainz id tags, when present Kodi will use them to uniquely identify albums and artists etc. But rather than rip all the tags out, do explain more about your issue. What files do you have, how are they tagged and what do yo see that looks wrong to you or unexpected?
Reply
#8
sigh.., I gotta walk away. I still see album duplicates in db, strMusicBrainxAlbumID is the only difference, I assumed a clean and rescan would have worked it out. I'm sure a:
cd ~
rm -Rf ./kodi
will guarantee a new db. Is there a... softer method? Or am I pounding salt?
Reply
#9
Yeah we risk having two threads on the go here. I'm walking away for the afternoon and will check again after supper (6hrs). Thanks.
Reply
#10
Update library does not remove all orphans, it is designed to allow for some music sources to be temp ofline and does not rip everything out. Try a music library clean from Settings, that will remove orphaned albums etc.

Having 2 albums with same title, artists but different album mbid implies that you have had this in your tags at some point. But no need for any drastic measures, you just need to communicate with me more clearly.
Reply
#11
Ok. The short is I nuked kodi. After a reinstall I came to accepted that Kodi prefers Music Brain's tags and/or online info, and unless I want to rebuild from, o I don't know, 2008 code then I need to work with it.

I've rebuilt picard for CentOS7 (fedora srpm) and am running through my library. I already have stragglers (one track from one album out of four albums processed) but I see no sense in whining before I finish with Picard. I hope this makes sense.

A summary is:
duplicate, sometimes triplicate, album entries. ie., for one album who happens to be ./Music/Artist_Name/Album_Name/ and whos tracks are tagged with identical Artist and Album Names produce duplicate album entries. Navigate by file, not a problem, navigate by album is. Picard is reducing the number of duplicates but it is not 100%. I should finish processing my library with picard before whining further.
Reply
#12
(2017-01-29, 01:15)beaker__ Wrote: I should finish processing my library with picard before whining further.
Smile

Consistant tagging is a good place to start to get a nice music library. But try to chill out a bit too. Kodi can do good things, but sometimes people start off on the wrong foot (no blame implied in any direction) and it turns into a drama. Treat it as an experiment, start small, and keep a sense of humor.

(2017-01-29, 01:15)beaker__ Wrote: Ok. The short is I nuked kodi. After a reinstall I came to accepted that Kodi prefers Music Brain's tags and/or online info, and unless I want to rebuild from, o I don't know, 2008 code then I need to work with it.
To be clear: if musicbrainz id tags are present then Kodi uses them, and expects that they are accurate and consistent. Earlier versions of Kodi did have some issues, v17 is better than v16 at over comming some tagging inconsistencies.

Why have mbid tags?
a) they are the only way to separate artists with the same name. Name is not unique e.g. John Williams composer of movie scores, and John Williams classical guitarist, and I think Musicbrainz as more than 23 different bands all called "Eclispse" etc.

b) it helps correctly identify artists and albums when scraping extra information and artwork from online sources. Again name is not enough, tag it with the mbid. It also makes scarping more efficient and reduces the chances of server lockout.

You do not have to have them, but they do have a use as long as they are accurate. Manual intervention, partially editing, is usually the reason they cause a problem. With v16 albums with multiple album artists, but no ALBUMARTISTS tag, can also give odd results.

While doing that big retagging with Picard, it would have been good to add
$setmulti(albumartists,%_albumartists%)
in the Picard tagger script (found under Options>Options>Advanced>Scripting) to ensure you have an ALBUMARTIST tag, sadly Picard does not do this by default yet.

Quote:A summary is:
duplicate, sometimes triplicate, album entries. ie., for one album who happens to be ./Music/Artist_Name/Album_Name/ and whos tracks are tagged with identical Artist and Album Names produce duplicate album entries. Navigate by file, not a problem, navigate by album is. Picard is reducing the number of duplicates but it is not 100%.
Just to be clear - you only have one copy of these music files? BTW Kodi does not use the folder path to identify album or artists just tags. You do not mention the ALBUMARTIST tag. Did all the tracks have the same, or any, Musicbrainz Album Id tag?

If you can share, via cloud, an example album with this issue then maybe I can spot the cause. Otherwise a full list of the tag values in each file would do, but users so often have difficulty doing that and data (often the multiple values) get omitted.

In addition to Picard, Mp3tag is a good tool for seeing all the tag values.

No nuking, or whining come to that, but I am happy to help you if you can give me more specific info.
Reply
#13
That's cool and appreciated. Sometimes it helps to spin my wheels and beet my head against a wall.

Yup, I'm about 70% through (picard) and have only a couple of discs not behaving but I understand why; local artist, musicbrainz as a couple of their songs in its db but not their entire album so kodi treats it as two separate albums.

I think the lion share of my problems are attributed to age. Basically I'm too old to know of musicbrainz and assumed anything outside of id3v1 metadata didn't exist. I'm guessing either grip or sound juicer added musicbrainz tags to what they could and kodi just happened to be the first player I ran into who prefers musicbrainz's tags.

I just noticed your paragraph wrt tagger script ($setmulti(albumartists,%_albumartists%)). I think I'm at a point where I need to complete tagging as I started, and pour a nice big glass of rum afterwards. It's a, "I risk fighting myself" kind of logic. Something to try next week forsure.

Yeah I had set ALBUMARTIST with easytag. It was a my first round and worked out for owncloud's music app.

Yup, opening up owncloud is easy enough but but I'm not there yet. I need to finish with picard first.
Reply
#14
(2017-01-29, 20:34)beaker__ Wrote: Sometimes it helps to spin my wheels and beet my head against a wall.
Fair enough, I just hate to see dumb animals users suffer. Smile

Quote:Yup, I'm about 70% through (picard) and have only a couple of discs not behaving but I understand why; local artist, musicbrainz as a couple of their songs in its db but not their entire album so kodi treats it as two separate albums.
Well you could always contribute to the Musicbrainz db. Also Picard can pick up the wrong release (as in that case), so you do need to keep an eye on it.

Quote:I think the lion share of my problems are attributed to age.
Same here bud. :p

Quote:Basically I'm too old to know of musicbrainz and assumed anything outside of id3v1 metadata didn't exist. I'm guessing either grip or sound juicer added musicbrainz tags to what they could and kodi just happened to be the first player I ran into who prefers musicbrainz's tags.
Also possibly the only player that uses them fully, or tries.

Quote:I just noticed your paragraph wrt tagger script ($setmulti(albumartists,%_albumartists%)). I think I'm at a point where I need to complete tagging as I started, and pour a nice big glass of rum afterwards. It's a, "I risk fighting myself" kind of logic. Something to try next week forsure.

In v16 the only albums that need ALBUMARTISTS tag are those with multiple album artists and the names not separated by the standard item separator. For example if you have ALBUMARTIST = "B. B. King & Eric Clapton", and then 2 mbids, Kodi does not know how to split the names and pair them with mbid - " & " is too often in the artist name to be used as a separator. If you had ALBUMARTIST = "B. B. King / Eric Clapton" all would be well, but that is not what Picard outputs and some people like to see "B. B. King & Eric Clapton" when the album plays etc. The solution is set ALBUMARTISTS = "B. B. King / Eric Clapton" (note the S).

So no need to have a big battle, nor for lots of rework, just check those albums with multiple album artists. Kodi will cope with some, v17 deals with more, but clues to an issue will be mbids appearing as artist names.

Now time for dinner.
Reply

Logout Mark Read Team Forum Stats Members Help
kodi 16.1, duplicate albums0