Project

General

Profile

Bug #20316

unable to delete user. leads to foreign key violation

Added by Christian Meißner over 3 years ago. Updated 5 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Users, Roles and Permissions
Target version:
Difficulty:
Triaged:
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

I try to delete a user account from foreman. But I get a foreign key violation error.

Oops, we're sorry but something went wrong ERROR: update or delete on table "users" violates foreign key constraint "fk_rails_51975e21a8" on table "notification_recipients" DETAIL: Key (id)=(16) is still referenced from table "notification_recipients".

Attached you can find the log corresponding with the error.

May a useful information is that the user data comes from a active directory database.

user_delete.err user_delete.err 17.6 KB Christian Meißner, 07/17/2017 07:45 AM

Related issues

Related to Foreman - Bug #20899: Unable to delete default admin userDuplicate2017-09-12
Related to Foreman - Bug #19657: Cannot delete administrator user account: update or delete on table "users" violates foreign key constraintDuplicate

Associated revisions

Revision ac4efbd1 (diff)
Added by Ohad Levy over 3 years ago

fixes #20316 - allow to delete a user that has notifications

Revision a6921a69 (diff)
Added by Ohad Levy about 3 years ago

fixes #20316 - allow to delete a user that has notifications

(cherry picked from commit ac4efbd1f26040141f83b864adbb60139d7ddcb4)

History

#1 Updated by Ivan Necas over 3 years ago

  • Project changed from Foreman Maintain to Foreman
  • Category set to 218

#2 Updated by The Foreman Bot over 3 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Ohad Levy
  • Pull request https://github.com/theforeman/foreman/pull/4741 added

#3 Updated by Ohad Levy over 3 years ago

  • Legacy Backlogs Release (now unused) set to 287

#4 Updated by Ohad Levy over 3 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#5 Updated by Marek Hulán about 3 years ago

  • Related to Bug #20899: Unable to delete default admin user added

#6 Updated by Marek Hulán about 3 years ago

  • Related to Bug #19657: Cannot delete administrator user account: update or delete on table "users" violates foreign key constraint added

#7 Updated by Tomer Brisker 5 months ago

  • Category changed from 218 to Users, Roles and Permissions

Also available in: Atom PDF