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

Inserts into artist_tag_raw are not checking for existence first

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • Bug fixes, 2012-09-03
    • None
    • None
    • None

      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.

            acid2 Oliver Charles
            acid2 Oliver Charles
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2012-09-03