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

    • Type: Improvement
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      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

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              chiark Simon Austin
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:

                Packages

                Version Package