execute failed: ERROR: duplicate key value violates unique constraint "medium_uniq"

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: None
    • Component/s: Edit system, Release editor
    • None

      Got the following error message when entering edit:

      23505 DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "medium_uniq" DETAIL: Key (release, "position")=(1943162, 2) already exists. [for Statement "INSERT INTO medium (release,name,position,format) VALUES (?,?,?,?) RETURNING id" with ParamValues: 1='1943162', 2='', 3='2', 4='1']

      Corrected this release https://musicbrainz.org/release/c15f42a8-6bf2-428b-bee7-955194ce73c9
      (separated medium into 2 discs, fixed artists and feat. artists, catalog number, barcode).

      Attached screenshot of changes.

      This is not the first time I got such a error message.

      Was told to open a bug report (https://community.metabrainz.org/t/error-message-after-submitting-edits/241700).

        1. keep_calm_and_unwind.png
          316 kB
          Michael Spies

            Assignee:
            Unassigned
            Reporter:
            Michael Spies
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:

                Version Package