Fog painfully slow with plenty RAM left
I recently updated to the latest trunk and I noticed that fog became painfully slow,
I checked the RAM usage on the server and it was over 80% free
now the CPU is being taken over by the apache server, which wasn’t happening before
the home screen is not displaying all the data, but its done loading
and when I try to schedule a task I get a php error
Long story short, I updated my fog installation and everything went south
@Tom-Elliott I don’t think it’s a mysql error but a php error, php for centos tends to be a little tricky and some things are missing on the redhat builds, the apache logs point out that same php error, maybe we could try an alternative for mysqli->query
Well the errors are not why things are failing.
While on the dashboard page, can you tail the apache error logs and output the random errors that are popping up?
The mysql issue you see I don’t think is the problem at all, rather it’s a remnant from the time the server was actually being updated.
@Tom-Elliott just updated, installation went fine but, home page is still not loading, and when trying to deploy an image I get a new error
Can you try updating, again? Just pushed the undefined index fix (I hope).
@Tom-Elliott Centos 6.7
What OS are you running?
@Sebastian-Roth tried that, same results
DB is up and running (
service mysql status)? Maybe restart the DB (
service mysql restart)?
@Wayne-Workman Apache error logs state the following
[Wed Apr 13 03:39:58 2016] [error] [client 10.54.0.203] PHP Warning: mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 49, referer: http://fogserver.collective.lan/management/index.php?node=home
and I guess this error is the one preventing the home folder from loading completely
I’m on the same version and I’m not seeing any performance issues. Can you check your apache error logs?