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


  • Developer

    @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


  • Developer

    @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 ?


  • Developer

    @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 !


  • Developer

    @lebrun78 See my initial answer and post logs.



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


  • Developer

    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.


  • Developer

    @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.


Log in to reply
 

290
Online

6.8k
Users

14.1k
Topics

133.3k
Posts