There are a lot of lines (every day) in totoro's PostgreSQL server log:
Aug 8 07:01:27 totoro postgres[28892]: [2-1] ERROR: duplicate key value violates unique constraint "artist_tag_raw_pkey" Aug 8 07:01:27 totoro postgres[28892]: [2-2] DETAIL: Key (artist, editor, tag)=(23256, 580498, 41014) already exists. Aug 8 07:01:27 totoro postgres[28892]: [2-3] STATEMENT: INSERT INTO artist_tag_raw (artist, tag, editor) VALUES ('23256', '41014', 'xxx')
Whatever is trying to do these insertions is doing a bad job of checking first.
I've put this in 2012-09-03 because I'd really like to get it squashed, but not sure I'll make it this week. If I have time, I'll bump it forward.
In review with http://codereview.musicbrainz.org/r/2194/
Bug
Closed
Normal
Inserts into artist_tag_raw are not checking for existence first
I've put this in 2012-09-03 because I'd really like to get it squashed, but not sure I'll make it this week. If I have time, I'll bump it forward.