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

Duplicate artist credits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug Fixes, 2012-02-20
    • Component/s: Edit system
    • Labels:
      None

      Description

      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)
      

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                Bug Fixes, 2012-02-20