Wanting to point out to readers this problem was due to no remote access enabled on the database, and the answer is in the wiki article “Troubleshoot MySQL”.

@Raymond-Bell I’m going to solve this then. The issue was likely from a far older revision of fog where 0 id’s were very much prevelant. This should no longer be the case, with any luck.

v0.10.3 fixes this issue, please update

Found another typo, sorry. Been doing a lot lately.

Should now be fixed properly.

@Wayne-Workman I’m already looking at it.

Because of what you reported, I’m working on a hopefully better approach to getting the dumped out file.

@Raymond-Bell Is this still an issue in latest trunk?

Wanted to post another update. Updated to 6893 this morning. Removed my sleep and service stop commands from rc.local and rebooted. CPU seems to be in check again. Thanks for all your hard work!

@Sebastian-Roth Yes this issue has been resolved with the update

@Tom-Elliott said:

@Tom-Elliott I’m more impressed that it hasn’t been noticed more often, but glad it was simple enough find and fix.

Thank you for your time.

@Wayne-Workman said:

Wiki has been updated about kernel updating. I made a new article because I couldn’t find anything about it.

Article is here, it is pretty sharp looking 🙂
https://wiki.fogproject.org/wiki/index.php?title=Kernel_Update

Looks GREAT!!!

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 );

Any errors in apache log file?

@Tom-Elliott I will leave was just going to try to clean up DB because it is like 96Mb

Working on this in a new thread: https://forums.fogproject.org/topic/6020/fog-svn-5020-and-above-cpu-hammered-thread

I can also confirm that version 4866 resolved the issue.

@Tom-Elliott Yes reenabling capone fixed the iPXE issue

@Raymond-Bell Is anything not working?

@Jbob Thanks

Issue looks like it is resolved. (web interface slow)

Upgraded VM server to svn 4469 ubuntu 12.04
Upgraded/Rebuilt storage node to svn 4469 ubuntu 12.04

Now i am getting this in the Apache Error Log any ideals?

FYI - you guys have been awesome help…

[Fri Aug 21 15:21:34.512243 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.513252 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.513890 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.514301 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.514866 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.515173 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.515689 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63```

Ok i will give that a shot this afternoon thanks