Project

General

Profile

Actions
Copy link

Bug #17285

closed

Removing the plugin causes DB structure left overs which cause foreign key violations when deleting hosts

Added by Wolfram Strauss about 8 years ago. Updated almost 4 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Foreman
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

The Foreman remote execution plugin was installed as an rpm and later removed again. After its removal it is no longer possible to delete hosts in Foreman. The error message is

Oops, we're sorry but something went wrong Cannot delete or update a parent row: a foreign key constraint fails (`foreman`.`targeting_hosts`, CONSTRAINT `targeting_hosts_host_id` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`))

Reinstalling the plugin solves the problem. Apparently there are DB structures left over which should be properly removed once the plugin is removed.

The used Foreman version is 1.11.3 and the remote execution plugin's version is 0.3.2.

Actions
Copy link

Also available in: Atom PDF