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

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2015-11-02
    • None
    • Edit system
    • None

      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.
      

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

              Created:
              Updated:
              Resolved:

                Version Package
                2015-11-02