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

Fail gracefully when trying to remove a relationship which is in use as an example

    XMLWordPrintable

    Details

      Description

      The relationship below is the example for https://musicbrainz.org/relationship/6578f0e9-1ace-4095-9de8-6e517ddb1ceb and can't be removed. There's no indication of that to the user though, and the edit remains open forever.


      Edit 57208916 produces the following error when the approval button is selected. The problem may also be stopping the edit from closing normally.

       

      Caught exception in MusicBrainz::Server::Controller::Edit->approve "Failed query:
      	'DELETE FROM l_release_group_url
                          WHERE id IN (?)'
      	(9841)
      23503 DBD::Pg::st execute failed: ERROR:  update or delete on table "l_release_group_url" violates foreign key constraint "l_release_group_url_example_fk_id" on table "l_release_group_url_example"
      DETAIL:  Key (id)=(9841) is still referenced from table "l_release_group_url_example". [for Statement "DELETE FROM l_release_group_url
                          WHERE id IN (?)" with ParamValues: 1='9841']
       at lib/Sql.pm line 115.
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                reosarevok Nicolás Tamargo
                Reporter:
                chiark Simon Austin
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  2020-06-15