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
-
I’m on the same version and I’m not seeing any performance issues. Can you check your apache error logs?
-
@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=homeand I guess this error is the one preventing the home folder from loading completely
-
DB is up and running (
service mysql status)? Maybe restart the DB (service mysql restart)? -
@Sebastian-Roth tried that, same results
-
What OS are you running?
-
@Tom-Elliott Centos 6.7
-
Can you try updating, again? Just pushed the undefined index fix (I hope).
-
@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
-
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 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