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

Stuck edit: update or delete on table "recording" violates foreign key constraint "recording_alias_fk_recording" on table "recording_alias"

    XMLWordPrintable

    Details

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

      Description

      http://musicbrainz.org/edit/35225255

      Error while processing edit #35225255: 23503 DBD::Pg::db commit failed: ERROR: update or delete on table "recording" violates foreign key constraint "recording_alias_fk_recording" on table "recording_alias"
      DETAIL: Key (id)=(17450383) is still referenced from table "recording_alias".
      CONTEXT: SQL statement "DELETE FROM recording WHERE id = OLD.recording"
      PL/pgSQL function "delete_orphaned_recordings" line 51 at SQL statement at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Connector.pm line 42.
      at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 268.
      at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 332.

        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-10-19