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

Inserts into artist_tag_raw are not checking for existence first

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug fixes, 2012-09-03
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Bug fixes, 2012-09-03