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
 #1

Updated by Ohad Levy over 6 years ago

  • Status changed from New to Resolved

This has been fixed a long time ago, please upgrade your foreman instance.

Actions
Copy link
 #2

Updated by tarak sinha over 6 years ago

  • Tracker changed from Support to Bug
Actions
Copy link
 #3

Updated by tarak sinha over 6 years ago

Ohad Levy wrote:

This has been fixed a long time ago, please upgrade your foreman instance.

Hi, Ohad,

Thanks for your prompt response, but this issue is happening in only from one datacenter, all the other hosts are good to delete.

Can you share me the request which was previously closed.

Thanks

Actions
Copy link

Also available in: Atom PDF