Project

General

Profile

Actions

Bug #9900

closed

ERROR: update or delete on table "hosts" violates foreign key constraint "tokens_host_id_fk" on table "tokens" DETAIL: Key (id)=(6) is still referenced from table "tokens"

Added by Ignacio Bravo over 9 years ago. Updated over 9 years ago.

Status:
Duplicate
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

This happened on a fresh install of 1.7

I was modifying the partition tables (trying different alternatives) and the host in question was being created over and over. In one of the runs, it did not allowed me to delete the host any more.

I tried re-discovering it, and now I have it added as a discovered host (macXXXXX) and also a host with the same mac. I can't reprovision the discovered host with the same name, and when I try to delete the host I am getting the tokens key error.

When looking for full trace, this is the result:

PGError
ERROR: update or delete on table "hosts" violates foreign key constraint "tokens_host_id_fk" on table "tokens" DETAIL: Key (id)=(6) is still referenced from table "tokens".
app/controllers/hosts_controller.rb:118:in `destroy'
app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'
lib/middleware/catch_json_parse_errors.rb:9:in `call'


Related issues 1 (0 open1 closed)

Is duplicate of Discovery - Bug #9597: FK violation when trying to delete a discovered host after provisionClosedOri Rabin03/01/2015Actions
Actions #1

Updated by Dominic Cleal over 9 years ago

  • Is duplicate of Bug #9597: FK violation when trying to delete a discovered host after provision added
Actions #2

Updated by Dominic Cleal over 9 years ago

  • Status changed from New to Duplicate

I think this is probably an issue from the Discovery plugin, it had a bug (#9597) in 2.0.0 which caused duplicate tokens to be created. 2.0.1 fixes the issue and we're pushing packages this morning to the repos - please update when it becomes available.

Actions

Also available in: Atom PDF