Failed to destroy host !

[Sebastian Roth]

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.

[lebrun78]

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

[Sebastian Roth]

@lebrun78 See my initial answer and post logs.

[lebrun78]

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 !

[Sebastian Roth]

@lebrun78 What about the apache error log?

[lebrun78]

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 ?

[Sebastian Roth]

@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

[lebrun78]

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

[Sebastian Roth]

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

[lebrun78]

Yes