Project

General

Profile

Bug #20316

unable to delete user. leads to foreign key violation

Added by Christian Meißner about 1 year ago. Updated 2 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Users
Target version:
Difficulty:
Triaged:
Bugzilla link:
Team Backlog:
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 constraintDuplicate2017-05-24

Associated revisions

Revision ac4efbd1 (diff)
Added by Ohad Levy about 1 year ago

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

Revision a6921a69 (diff)
Added by Ohad Levy about 1 year ago

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

(cherry picked from commit ac4efbd1f26040141f83b864adbb60139d7ddcb4)

History

#1 Updated by Ivan Necas about 1 year ago

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

#2 Updated by The Foreman Bot about 1 year 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 about 1 year ago

  • Legacy Backlogs Release (now unused) set to 287

#4 Updated by Ohad Levy about 1 year ago

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

#5 Updated by Marek Hulán about 1 year ago

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

#6 Updated by Marek Hulán about 1 year ago

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

Also available in: Atom PDF