Duplicate artists

[Coert000 0]

My libraries show the same artist name showing up many times in "Artist" view.

I noticed other people running into the same issue over the years, but have not found a solution.  To help isolate this, I made a library with a single track.  This .mp3 track is tagged as:

ffprobe.txt

The Emby library shows the artist twice

Examining the metadata in Emby, I find

1. The first artist icon has MusicBrainzId bb97bf2b-c325-4d00-982b-f2423f7d8c4a.  The artist page on MusicBrainz show that this is Stephen Gunzenhauser (conductor)
2. The second artist icon has MusicBrainzId 819eaeb2-8dd8-48a5-ad07-0bcd137985ef.  The artist page on MusicBrainz show that this is indeed for Antonín Dvořák (composer)

I get the impression that Emby gets confused about the multiple entries in the ID3 artist tag.  This is where I run into a wall.  Does Emby use this tag?  If so why does it show up as Antonín Dvořák.  Or why is there none for Slovenská filharmónia.

Quote

artist          : Antonín Dvořák;Stephen Gunzenhauser (conductor);Slovenská filharmónia

The server log shows:

embyserver.txt

test.txt

[Luke 37106]

Hi, your track is not tagged correctly. Look, album artist looks OK:

album_artist    : Antonín Dvořák
MusicBrainz Album Artist Id: 819eaeb2-8dd8-48a5-ad07-0bcd137985ef

But look at artist:

artist          : Antonín Dvořák;Stephen Gunzenhauser (conductor);Slovenská filharmónia
MusicBrainz Artist Id: bb97bf2b-c325-4d00-982b-f2423f7d8c4a

So that's why a second Antonin Dvorak gets created with the different musicbrainz id. The musicbrainz artist id should be the id for the first artist.

[Coert000 0]

Thanks.  Trying to understand how things things fit together.  

I removed the first artist, so the ID3 tag reads

Quote

album_artist    : Antonín Dvořák
MusicBrainz Album Artist Id: 819eaeb2-8dd8-48a5-ad07-0bcd137985ef

artist          : Stephen Gunzenhauser (conductor);Slovenská filharmónia
MusicBrainz Artist Id: bb97bf2b-c325-4d00-982b-f2423f7d8c4a

I removed the test library, and re-added it.  Still the same.  I would expect Stephen Gunzenhauser (conductor) to be one of the artists, instead of seeing Antonín Dvořák twice.

I cleared the browser cache and refreshed the page.  Do I need to do something on the Emby side as well?  Clear a cache, or something else?

Thanks

embyserver.txt

[Luke 37106]

I'm guessing you didn't actually change the audio file.

[Coert000 0]

That would be the most obvious explanation.  However ffmpeg and Emby's metadata don't agree over this:

ffmpeg sees:
 

Quote

PS M:\audio\test> M:\ffprobe.exe '\\nas\audio\test\1.03 Dvorák Symphony #9 In E Minor, Op. 95, B 178, From The New World - 3. Molto Vivace.m4a'
ffprobe version 4.3.1 Copyright (c) 2007-2020 the FFmpeg developers
  built with gcc 10.2.1 (GCC) 20200726
  configuration: --enable-gpl --enable-version3 --enable-sdl2 --enable-fontconfig --enable-gnutls --enable-iconv --enable-libass --enable-libdav1d --enable-libbluray --enable-libfreetype --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-libopus --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libsrt --enable-libtheora --enable-libtwolame --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxml2 --enable-libzimg --enable-lzma --enable-zlib --enable-gmp --enable-libvidstab --enable-libvmaf --enable-libvorbis --enable-libvo-amrwbenc --enable-libmysofa --enable-libspeex --enable-libxvid --enable-libaom --enable-libgsm --disable-w32threads --enable-libmfx --enable-ffnvcodec --enable-cuda-llvm --enable-cuvid --enable-d3d11va --enable-nvenc --enable-nvdec --enable-dxva2 --enable-avisynth --enable-libopenmpt --enable-amf
  libavutil      56. 51.100 / 56. 51.100
  libavcodec     58. 91.100 / 58. 91.100
  libavformat    58. 45.100 / 58. 45.100
  libavdevice    58. 10.100 / 58. 10.100
  libavfilter     7. 85.100 /  7. 85.100
  libswscale      5.  7.100 /  5.  7.100
  libswresample   3.  7.100 /  3.  7.100
  libpostproc    55.  7.100 / 55.  7.100
[mov,mp4,m4a,3gp,3g2,mj2 @ 000001fee8b9ff00] stream 0, timescale not set
    Last message repeated 3 times
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from '\\nas\audio\test\1.03 Dvořák Symphony #9 In E Minor, Op. 95, B 178, From The New World - 3. Molto Vivace.m4a':
  Metadata:
    major_brand     : M4A
    minor_version   : 0
    compatible_brands: M4A mp42isom
    creation_time   : 2014-04-09T13:47:04.000000Z
    track           : 7/8
    disc            : 1/1
    ~length         : 8:06
    date            : 1995-11
    WWW             : http://musicbrainz.org/release/3da13b17-3bf6-4dbe-9688-3ac083432525
    title           : Symphony no. 9 "From the New World": III. Molto vivace
    SCRIPT          : Latn
    Publisher       : Naxos
    originalyear    : 1995
    originaldate    : 1995-11
    MUSICBRAINZ_TRACKID: f42293c5-cc0c-459b-8d4a-60fdfe595ac2
    MusicBrainz Release Track Id: fc9dc9d8-445e-4064-be97-c3c02895e4fa
    MusicBrainz Release Group Id: f280742f-9e54-43aa-9d1e-cc824f8f7509
    MusicBrainz Artist Id: bb97bf2b-c325-4d00-982b-f2423f7d8c4a
    MusicBrainz Album Type: album
    MusicBrainz Album Status: official
    MUSICBRAINZ_ALBUMID_BK: 3da13b17-3bf6-4dbe-9688-3ac083432525
    MusicBrainz Album Id: 3da13b17-3bf6-4dbe-9688-3ac083432525
    MusicBrainz Album Artist Id: 819eaeb2-8dd8-48a5-ad07-0bcd137985ef
    MusicBrainz Track Id: f42293c5-cc0c-459b-8d4a-60fdfe595ac2
    MEDIA           : CD
    LABEL           : Naxos
    GENRE           : Classical
    composer        : Antonín Dvořák
    CATALOGNUMBER   : 8.553229
    BARCODE         : 0730099422925
    ASIN            : B0000270MS
    sort_artist     : Dvořák, Antonín
    artist          : Stephen Gunzenhauser (conductor);Slovenská filharmónia
    sort_album_artist: Dvořák, Antonín, Borodin, Alexander Porfyrevich; Slovenská filharmónia, Symfonický orchester Slovenského rozhlasu, Gunzenhauser, Stephen
    album_artist    : Antonín Dvořák
    album           : Symphony no. 9 "From the New World" / Borodin: Symphony no. 2
  Duration: 00:07:59.10, start: 0.000000, bitrate: 290 kb/s
    Stream #0:0(und): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 260 kb/s (default)
    Metadata:
      creation_time   : 2014-04-09T13:47:04.000000Z
    Stream #0:1: Video: mjpeg (Baseline), yuvj444p(pc, bt470bg/unknown/unknown), 1408x1400, 90k tbr, 90k tbn, 90k tbc (attached pic)
    Stream #0:2: Video: mjpeg (Baseline), yuvj444p(pc, bt470bg/unknown/unknown), 1412x1396, 90k tbr, 90k tbn, 90k tbc (attached pic)
    Stream #0:3: Video: mjpeg (Baseline), yuvj444p(pc, bt470bg/unknown/unknown), 1404x1396, 90k tbr, 90k tbn, 90k tbc (attached pic)
    Stream #0:4: Video: mjpeg (Baseline), yuvj444p(pc, bt470bg/unknown/unknown), 1408x1400, 90k tbr, 90k tbn, 90k tbc (attached pic)

Emby sees

 

Just to make sure.  I deleted that library.  Waited for the green progress bar on the dashboard to finish; restarted Emby, and re-added the library.  Same effect.  Here's the log for that one:embyserver.txt
 

Thanks

[Coert000 0]

Going out on a limb .. I stopped the server, and browsed library.db (read-only) and noticed that the artist showed up twice. 

[Luke 37106]

Try refreshing the metadata of the file in emby server and see if that helps.

[Coert000 0]

It stayed the same after the refresh.

I also removed another library that included the original version  of that track.

[Happy2Play 8296]

With two itemids you would need to find out what they are linked to.  I assume both Artist shows different items correct?  But you may have to remove all of the items from one of the artists so that link can bring them into one item.

[Coert000 0]

Even all libraries removed that ever contained that track, the db still shows two entries

Then when filter the media items on that "artist" or "album artist" it comes up empty.  IMHO indicating that the items with that artist were indeed removed.

Is there a way to clean the database?  I have already tried

Quote

sqlite3 library.db "VACUUM"
sqlite3 library.db "ANALYZE"
sqlite3 library.db "REINDEX"

An interesting tidbit is that this mainly occurs with classical tracks.  MusicBrainz is inconsistent in that regard, but mostly uses the artist tag for the composer, and artist tag for a combination of the composer and performers.

Thanks