Project

General

Profile

Actions

Bug #22342

closed

Unable to delete the host from foreman

Added by amith ravuru almost 7 years ago. Updated almost 7 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Unattended installations
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

Foreman Version: 1.9.3

When the host is built using foreman, entry is made in tokens table for the host. I found 4 entries for the same host in tokens table. This results in foreman host record deletion error.

mysql> select * from tokens where host_id=110827;
-------------------------------------------+---------------------+---------+ | id | value | expires | host_id |
-------------------------------------------+---------------------+---------+ | 10148 | d0a939ab-f318-4bf8-bf57-f2d4caf98687 | 2018-01-05 02:05:21 | 110827 | | 10149 | 9e11c00c-28c5-4e64-8c25-b59f14c42a07 | 2018-01-05 02:05:28 | 110827 | | 10150 | e57c8428-c8e6-4181-abdf-233bb0067333 | 2018-01-05 02:05:33 | 110827 | | 10151 | 33659bbc-3e87-432b-be6b-a2e65d0239aa | 2018-01-05 02:05:33 | 110827 |
-------------------------------------------+---------------------+---------+

ERROR in foreman UI:
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

Let me know if you need additional information.


Related issues 1 (0 open1 closed)

Related to Foreman - Bug #10558: Remove and prevent duplicate tokens via DB migrationClosedOri Rabin05/20/2015Actions
Actions #1

Updated by Anonymous almost 7 years ago

  • Related to Bug #10558: Remove and prevent duplicate tokens via DB migration added
Actions #2

Updated by Anonymous almost 7 years ago

  • Project changed from 38 to Foreman
  • Category set to Unattended installations
  • Status changed from New to Rejected

1.9.3 is old and long out of support. The problem you're seeing should specifically be fixed with 1.10, at least according to the related issue.

Actions

Also available in: Atom PDF