Project

General

Profile

Actions
Copy link

Bug #22322

closed

Unable to delete the host on foreman

Added by tarak sinha over 6 years ago. Updated over 6 years ago.

Status:
Resolved
Priority:
High
Assignee:
-
Category:
Database
Target version:
-
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
1.9.1
Red Hat JIRA:

Description

Hello All,

I am getting below error during deletion of my host. can you please assist me to reproduce this issue.

Error Message on foreman along with past bin.
https://pastebin.com/YpwMBADL

Warning!
Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails (`foreman`.`tokens`, CONSTRAINT `tokens_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`)): DELETE FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 110827

Thanks,

Tarak

Files

Screen Shot 2018-01-19 at 1.45.41 PM.png View Screen Shot 2018-01-19 at 1.45.41 PM.png 132 KB tarak sinha, 01/19/2018 08:20 AM
Screen Shot 2018-01-19 at 1.45.53 PM.png View Screen Shot 2018-01-19 at 1.45.53 PM.png 1.14 MB tarak sinha, 01/19/2018 08:20 AM
Screen Shot 2018-01-19 at 1.45.56 PM.png View Screen Shot 2018-01-19 at 1.45.56 PM.png 1.14 MB tarak sinha, 01/19/2018 08:20 AM
Actions
Copy link

Also available in: Atom PDF