Bug #17285: Removing the plugin causes DB structure left overs which cause foreign key violations when deleting hosts - Foreman Remote Execution - Foreman

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 over 7 years ago. Updated about 3 years ago.

Status:

Rejected

Priority:

Normal

Assignee:

Category:

Foreman

Target version:

Difficulty:

Triaged:

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.