[#MBS-4010] Duplicate artist credits - MusicBrainz JIRA

MusicBrainz Server

Duplicate artist credits

Created: 16/Dec/11 12:05 PM Updated: 27/Feb/12 02:36 PM Resolved: 27/Feb/12 02:36 PM

Component/s:

Edit system

Affects Version/s:

None

Fix Version/s:

Bug Fixes, 2012-02-20

Description

« Hide

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)

Sort Order:

Lukáš Lalinský made changes - 16/Dec/11 12:06 PM

Field	Original Value	New Value
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)	While working on ~~MBS-3494~~, I've noticed that there are some duplicate artist credits in the database. For example: {noformat} 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) {noformat}