SOLVED Attempting To Send Inventory - Invalid Host? SVN 4193
-
I am getting Attempting To Send Inventory - Invalid Host? on computers now that i have up to 4193
-
For future readers, the select statement that @ch3i posted can be converted into a delete statement like so:
DELETE hostName FROM hosts WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
-
I have deleted all that where in the list and got the host to register.
-
@Uncle-Frank said:
@Raymond-Bell Have you updated to current trunk since yesterday? I really wonder why you do not see any mysql connections on your FOG server. Maybe this issue was solved just by itself. Well then you might want to head for your initial problem and I think ch3i is pointing you the correct way!
Yes i have updated to 4199
Hopefully @ch3i can help me delete these out of here and then i can re-register them -
@Raymond-Bell Have you updated to current trunk since yesterday? I really wonder why you do not see any mysql connections on your FOG server. Maybe this issue was solved just by itself. Well then you might want to head for your initial problem and I think ch3i is pointing you the correct way!
-
@ch3i And all are missing from fog Host Search
mysql> SELECT hostName -> FROM hosts -> WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC ); +---------------+ | hostName | +---------------+ | es-54-01 | | es-33-t | | jh-18-t2 | | es-53-04 | | es-53-01 | | es-53-02 | | es-53-06 | | es-53-09 | | es-53-08 | | es-53-t | | es-53-10 | | 0023ae5a3b86 | | es-52-08 | | es-52-05 | | es-52-04 | | es-52-03 | | es-52-02 | | es-52-01 | | es-08-t | | ad-bmace-2015 | | HS-104-08-Lap | +---------------+ 21 rows in set (0.01 sec)
-
@Raymond-Bell said:
@ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users
You have the same bug than me, some mac address disappeard and I canât view it in the host view⊠can you post the result of
SELECT hostName FROM hosts WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
-
@ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users
-
@ch3i This is a host that was reg and then was missing from fog a week later. I will check the mac address table
-
@Raymond-Bell Hi, is it new hosts or hosts that are disappeared that you want to register ? Iâve a same problem with my FOG server, some mac address are missing in the mac address table, Iâve to delete all hosts which are not in the mac address table to register it.
-
@Uncle-Frank Nothing show up running
Ubuntu 12.04fog@fog-virtual-machine2:~$ lsof -i :3306 fog@fog-virtual-machine2:~$```
-
@Raymond-Bell And while you are at it. Please run the same command using port 80 again. My guess is that you see a lot of apache processes in the first listing (port 3306) and it would be interesting to see âwhoâ is calling all these (connections from your clients is my guess):
lsof -i :80
-
@Uncle-Frank The reasoning is that in some cases the connection just appears to go dead. So on the construct (which is already called) it automatically makes the link, rather than implicitly making it do so.
-
Searching through the forums I saw that Raymond Bell and Joseph Hales both mentioned those errors in apache log some time ago. For example see here: https://forums.fogproject.org/topic/5661/web-interface-slow-svn-4333
Browsing the code history around that time I found this: http://sourceforge.net/p/freeghost/code/3971/
Why a connect call (in the query function) which wasnât there before?
-
@Uncle-Frank of course I canât. I believe youâre on the right track though as I only have one or two clients connecting to my system. And most of the time they are off to begin with. So it isnât a surprise to me if it is related to sheer numbers of clients connecting and disconnecting. Iâm of the mind though that itâs my attempt to use the real connect after initializing the mysqli object in lib/db/MySQL.class.php and missing some check somewhere as this is a fairly new issue, not one people have been experiencing the whole time.
-
@Tom-Elliott And I guess you canât reproduce this on your system?!
@Raymond-Bell How many clients do you have? Could you please run this command on your FOG server:
lsof -i :3306 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME apache2 22534 www-data 12u IPv4 21769312 0t0 TCP localhost:43411->localhost:mysql (ESTABLISHED) mysqld 24347 mysql 10u IPv4 20564983 0t0 TCP localhost:mysql (LISTEN) mysqld 24347 mysql 31u IPv4 21769313 0t0 TCP localhost:mysql->localhost:43411 (ESTABLISHED)
Maybe you need to install it first. Package in debian is called âlsofâ just like the tool itself.
-
@Uncle-Frank thatâs the fun bit. I donât and it only recently started occurring.
-
@Tom-Elliott For sure persistent connections are better than opening a new one for every call. But how do you keep track of all the open connections? Why are there several dozens of open connections? Re-using a persistent connection is one thing. But keeping âhundredsâ of them?
-
@Uncle-Frank all the sleep means is the connection is waiting. This is because in most cases persistent connections are much better than create/use/close methods.
-
Why SLEEP?? I greped through the source code but could not find the mysql sleep used anywhere⊠Or does it mean that the connection is sleeping (not being used)?