Project

General

Profile

Actions

Bug #20316

closed

unable to delete user. leads to foreign key violation

Added by Christian Meißner almost 7 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Users, Roles and Permissions
Target version:
Difficulty:
Triaged:
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.


Files

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

Related issues 2 (0 open2 closed)

Related to Foreman - Bug #20899: Unable to delete default admin userDuplicate09/12/2017Actions
Related to Foreman - Bug #19657: Cannot delete administrator user account: update or delete on table "users" violates foreign key constraintDuplicateActions
Actions #1

Updated by Ivan Necas over 6 years ago

  • Project changed from Foreman Maintain to Foreman
  • Category set to 218
Actions #2

Updated by The Foreman Bot over 6 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
Actions #3

Updated by Ohad Levy over 6 years ago

  • translation missing: en.field_release set to 287
Actions #4

Updated by Ohad Levy over 6 years ago

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

Updated by Marek Hulán over 6 years ago

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

Updated by Marek Hulán over 6 years ago

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

Updated by Tomer Brisker almost 4 years ago

  • Category changed from 218 to Users, Roles and Permissions
Actions

Also available in: Atom PDF