Inserts into artist_tag_raw are not checking for existence first

ExportXMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • Bug fixes, 2012-09-03
    • Affects Version/s: None
    • Component/s: 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.

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

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2012-09-03