Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-4010

Duplicate artist credits

XMLWordPrintable

      While working on MBS-3494, I've noticed that there are some duplicate artist credits in the database. For example:

      acoustid=> select * from artist_credit_name where artist_credit in (832431, 44954);
       artist_credit | position | artist |  name  | join_phrase 
      ---------------+----------+--------+--------+-------------
               44954 |        0 |  44954 | 590816 | 
              832431 |        0 |  44954 | 590816 | 
      (2 rows)
      
      acoustid=> select * from artist_credit where id in (832431, 44954);
         id   |  name  | artist_count | ref_count |            created            
      --------+--------+--------------+-----------+-------------------------------
        44954 | 590816 |            1 |      3471 | 2011-05-16 16:32:11.963929+00
       832431 | 590816 |            1 |       280 | 2011-06-21 18:59:35.986056+00
      (2 rows)
      

            acid2 Oliver Charles
            lukas Lukáš Lalinský
            Votes:
            3 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Bug Fixes, 2012-02-20