Issue Details (XML | Word | Printable)

Key: MBS-4010
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Oliver Charles
Reporter: Lukáลก Lalinský
Votes: 3
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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: Ascending order - Click to sort in descending order

Aurélien Mino added a comment - 08/Feb/12 03:12 PM

I think this example is a bit more meaningful, because nearly all artist credit are duplicated: http://musicbrainz.org/artist/302bd7b9-d012-4360-897a-93b00c855680/aliases


Oliver Charles added a comment - 20/Feb/12 03:32 PM