Project

General

Profile

Actions
Copy link

Bug #3468

closed

host deletion fails when token exists

Added by Martin Bacovsky over 11 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Greg Sutcliffe
Category:
Host creation
Target version:
1.3.2
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

This has happened when I tried to destroy the host


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

If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace and relevant log entries.
PG::Error
ERROR: update or delete on table "hosts" violates foreign key constraint "tokens_host_id_fk" on table "tokens" DETAIL: Key (id)=(63) is still referenced from table "tokens".
app/controllers/hosts_controller.rb:120:in `destroy'
app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'

Related issues 1 (0 open — 1 closed)

Related to Foreman - Bug #3379: It's not possible to destroy hosts that have entries in the tokens tableRejectedSam Kottler10/21/2013Actions
Actions
Copy link
 #1

Updated by Dominic Cleal over 11 years ago

Heh, #3379 too, but I couldn't reproduce it. Maybe I didn't have foreign keys working properly?

Actions
Copy link
 #2

Updated by Dominic Cleal over 11 years ago

  • Related to Bug #3379: It's not possible to destroy hosts that have entries in the tokens table added
Actions
Copy link
 #3

Updated by Martin Bacovsky over 11 years ago

  • Description updated (diff)

I fixed the misleading information in the description

I cen reproduce it when I set token expiration to 1 min and try to delete the host after that time.

Actions
Copy link
 #4

Updated by Martin Bacovsky over 11 years ago

To workaround this issue just cancel the build before deletion

Actions
Copy link
 #5

Updated by Greg Sutcliffe over 11 years ago

  • Status changed from New to Assigned
  • Assignee set to Greg Sutcliffe
  • Target version set to 1.10.0
Actions
Copy link
 #6

Updated by Dominic Cleal over 11 years ago

  • Status changed from Assigned to Ready For Testing
  • Translation missing: en.field_release set to 3
Actions
Copy link
 #7

Updated by Greg Sutcliffe over 11 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF