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

"Reorder mediums" edit is stuck after being left open and trying to move a medium into a position that already has one

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2015-11-02
    • Component/s: Edit system
    • Labels:
      None

      Description

      https://musicbrainz.org/edit/35380667

      Error while processing edit #35380667: Failed query:
      	'UPDATE medium SET position =
                     (SELECT position
                        FROM (VALUES (?::INTEGER, ?::INTEGER))
                          AS mpos (medium, position)
                       WHERE mpos.medium = medium.id)
               WHERE id IN (?)'
      	(1762022 1 1762022)
      23505 DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique constraint "medium_uniq"
      DETAIL:  Key (release, "position")=(230664, 1) already exists. at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Connector.pm line 42.
      

        Attachments

          Activity

            People

            • Assignee:
              bitmap Michael Wiencek
              Reporter:
              bitmap Michael Wiencek
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2015-11-02