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

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2015-10-19
    • None
    • Edit system
    • None

      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.

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

              Created:
              Updated:
              Resolved:

                Version Package
                2015-10-19