SOLVED Failed to destroy host !


  • Hello,

    I can’t erase disk, when I try I get “Failed to destroy host”
    I have the problem on uefi laptop.

    Arnaud


  • Yes text alternatif

  • Moderator

    @lebrun78 Yes, host deletion does remove the host object from the database. If you want to wipe the disk there is a task for you but only within the Web UI, not from the PXE menu.

    I suppose the DB cleanup did work.


  • mysql> DELETE FROM `hosts` WHERE `hostID` = '0';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC` WHERE `hmPrimary` = '1');
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC`);
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> DELETE FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`);
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `tasks` WHERE `taskStateID` IN ("1","2","3");
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM `snapinTasks` WHERE `stState` in ("1","2","3");
    Query OK, 4 rows affected (0.00 sec)
    
    mysql> TRUNCATE TABLE multicastSessions; 
    Query OK, 0 rows affected (0.02 sec)
    
    mysql> TRUNCATE TABLE multicastSessionsAssoc; 
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> DELETE FROM tasks WHERE taskTypeId=8;
    Query OK, 437 rows affected (0.01 sec)
    
    mysql> TRUNCATE TABLE history;
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> TRUNCATE TABLE userTracking;
    Query OK, 0 rows affected (0.00 sec)
    
    

    Quist host deletion > It erase the host from the database, I thought it was wipping the disk text alternatif

  • Moderator

    @lebrun78 said in Failed to destroy host !:

    Our fog version is 1.5.7.60, should I upgrade ?

    Can’t imagine there being a difference in that part of FOG since 1.5.7.60.

    Please run the DB maintenance and see if the error goes away: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL#Database_Maintenance_Commands


  • Nothing in apache error.log:

    [Sun Feb 09 03:14:01.195079 2020] [lbmethod_heartbeat:notice] [pid 26820:tid 140285265893632] AH02282: No slotmem from mod_heartmonitor
    [Sun Feb 09 03:14:01.195787 2020] [mpm_event:notice] [pid 26820:tid 140285265893632] AH00489: Apache/2.4.37 (centos) OpenSSL/1.1.1c configured -- resuming normal operations
    [Sun Feb 09 03:14:01.195799 2020] [core:notice] [pid 26820:tid 140285265893632] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
    [Mon Feb 10 16:48:20.677240 2020] [proxy_fcgi:error] [pid 14434:tid 140283463317248] (70008)Partial results are valid but processing is incomplete: [client 148.60.10.10:45504] AH01075: Error dispatching request to : (reading input brigade), referer: https://fogus//fog/management/index.php?node=snapin&sub=edit&id=4
    

    Our fog version is 1.5.7.60, should I upgrade ?

  • Moderator

    @lebrun78 What about the apache error log?


  • Here is httpd access log :

    148.60.3.152 - - [12/Feb/2020:08:36:39 +0100] "POST /fog/service/ipxe/boot.php HTTP/1.1" 200 4002 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:36:39 +0100] "GET /fog/service/ipxe/bg-plateforme2.png HTTP/1.1" 200 45904 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:36:56 +0100] "GET /fog/service/ipxe/refind.conf HTTP/1.1" 200 29719 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:36:56 +0100] "GET /fog/service/ipxe/refind_x64.efi HTTP/1.1" 200 208776 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:34 +0100] "POST /fog/service/ipxe/boot.php HTTP/1.1" 200 4000 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:34 +0100] "GET /fog/service/ipxe/bg-plateforme2.png HTTP/1.1" 200 45904 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:46 +0100] "POST /fog/service/ipxe/boot.php HTTP/1.1" 200 510 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:49 +0100] "POST /fog/service/ipxe/boot.php HTTP/1.1" 200 501 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:52 +0100] "POST /fog/service/ipxe/boot.php HTTP/1.1" 200 4339 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:53 +0100] "GET /fog/service/ipxe/bg-plateforme2.png HTTP/1.1" 200 45904 "-" "iPXE/1.0.0+ (3fe68)"
    148.60.3.152 - - [12/Feb/2020:08:44:58 +0100] "GET /fog/service/ipxe/grub.exe HTTP/1.1" 200 234697 "-" "iPXE/1.0.0+ (3fe68)"
    

    No trace on phpfpm

    [12-Feb-2020 08:34:16] NOTICE: [pool www] child 704 exited with code 0 after 10966.343745 seconds from start
    [12-Feb-2020 08:34:16] NOTICE: [pool www] child 15058 started
    [12-Feb-2020 08:35:13] NOTICE: [pool www] child 1211 exited with code 0 after 10688.067733 seconds from start
    [12-Feb-2020 08:35:13] NOTICE: [pool www] child 15128 started
    [12-Feb-2020 08:36:31] NOTICE: [pool www] child 1763 exited with code 0 after 10354.590384 seconds from start
    [12-Feb-2020 08:36:31] NOTICE: [pool www] child 15203 started
    [12-Feb-2020 08:38:17] NOTICE: [pool www] child 2377 exited with code 0 after 9967.474334 seconds from start
    [12-Feb-2020 08:38:17] NOTICE: [pool www] child 15340 started
    [12-Feb-2020 08:38:35] NOTICE: [pool www] child 2597 exited with code 0 after 9858.520146 seconds from start
    [12-Feb-2020 08:38:35] NOTICE: [pool www] child 15357 started
    [12-Feb-2020 08:38:59] NOTICE: [pool www] child 2745 exited with code 0 after 9775.417709 seconds from start
    [12-Feb-2020 08:38:59] NOTICE: [pool www] child 15382 started
    [12-Feb-2020 08:39:44] NOTICE: [pool www] child 3033 exited with code 0 after 9556.303340 seconds from start
    [12-Feb-2020 08:39:44] NOTICE: [pool www] child 15423 started
    [12-Feb-2020 08:40:02] NOTICE: [pool www] child 3207 exited with code 0 after 9455.172945 seconds from start
    [12-Feb-2020 08:40:02] NOTICE: [pool www] child 15457 started
    

    I try erase disk with a centos 8 deployed image (uefi too). No error after but system allways present on reboot !

  • Moderator

    @lebrun78 See my initial answer and post logs.


  • Hello,
    actually, I’m trying to do a “quick host deletion” from the PXE menu.

  • Moderator

    Yeah, at first I thought too. But greping the code for the error message “Failed to destroy Host” I can only find that in the part used when you delete a host from the PXE boot menu.

    When actually wiping a host you might get “Failed to update Host”.

    @lebrun78 Please clarify. Best if you take a picture of the error on screen and post here.


  • I think he’s talking about the disk wipe feature.

  • Moderator

    @lebrun78 I’ve just done a quick test and host deletion from the menu worked perfectly fine. Can you please check the apache and php-fpm logs just after the error occurs. Post details here and we should be able to figure it out.

346
Online

9.6k
Users

16.0k
Topics

147.9k
Posts