High MySQL CPU Usage Bogging Down Server

UWPVIOLATOR · Feb 19, 2018, 3:56 PM

FOG 1.4.4
Ubuntu 16.04.2

We have had this issue in the past and it’s back again. I did update a handful of machines (manually) to the new FOG Client 11.14 for testing. Their logs look normal but otherwise nothing else has changed in our environment. Note: The server works fine early in the morning when no clients are on.

Here is a look at HTOP. Suggestions on what to do?

UWPVIOLATOR · Feb 19, 2018, 5:50 PM

Apache Log

[Mon Feb 19 11:09:58.783894 2018] [core:warn] [pid 4266] AH00045: child process 17921 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.783922 2018] [core:warn] [pid 4266] AH00045: child process 14389 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.783950 2018] [core:warn] [pid 4266] AH00045: child process 17788 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.783977 2018] [core:warn] [pid 4266] AH00045: child process 14391 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784004 2018] [core:warn] [pid 4266] AH00045: child process 17951 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784031 2018] [core:warn] [pid 4266] AH00045: child process 14393 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784058 2018] [core:warn] [pid 4266] AH00045: child process 20465 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784085 2018] [core:warn] [pid 4266] AH00045: child process 14414 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784112 2018] [core:warn] [pid 4266] AH00045: child process 17809 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784138 2018] [core:warn] [pid 4266] AH00045: child process 17952 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784166 2018] [core:warn] [pid 4266] AH00045: child process 14417 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784194 2018] [core:warn] [pid 4266] AH00045: child process 14450 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784222 2018] [core:warn] [pid 4266] AH00045: child process 14511 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784253 2018] [core:warn] [pid 4266] AH00045: child process 14520 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784281 2018] [core:warn] [pid 4266] AH00045: child process 17957 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784308 2018] [core:warn] [pid 4266] AH00045: child process 18843 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784340 2018] [core:warn] [pid 4266] AH00045: child process 17958 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784367 2018] [core:warn] [pid 4266] AH00045: child process 14525 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784395 2018] [core:warn] [pid 4266] AH00045: child process 17959 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784422 2018] [core:warn] [pid 4266] AH00045: child process 17960 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784450 2018] [core:warn] [pid 4266] AH00045: child process 18080 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784476 2018] [core:warn] [pid 4266] AH00045: child process 18085 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784504 2018] [core:warn] [pid 4266] AH00045: child process 14642 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784533 2018] [core:warn] [pid 4266] AH00045: child process 14531 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784560 2018] [core:warn] [pid 4266] AH00045: child process 18086 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784587 2018] [core:warn] [pid 4266] AH00045: child process 18140 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784614 2018] [core:warn] [pid 4266] AH00045: child process 14534 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.784642 2018] [core:warn] [pid 4266] AH00045: child process 14643 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.788872 2018] [core:warn] [pid 4266] AH00045: child process 20494 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789670 2018] [core:warn] [pid 4266] AH00045: child process 18164 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789703 2018] [core:warn] [pid 4266] AH00045: child process 18165 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789730 2018] [core:warn] [pid 4266] AH00045: child process 18253 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789757 2018] [core:warn] [pid 4266] AH00045: child process 14649 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789784 2018] [core:warn] [pid 4266] AH00045: child process 18254 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789810 2018] [core:warn] [pid 4266] AH00045: child process 14656 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789837 2018] [core:warn] [pid 4266] AH00045: child process 18359 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789863 2018] [core:warn] [pid 4266] AH00045: child process 18256 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789889 2018] [core:warn] [pid 4266] AH00045: child process 20495 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789916 2018] [core:warn] [pid 4266] AH00045: child process 18268 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789942 2018] [core:warn] [pid 4266] AH00045: child process 18389 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789969 2018] [core:warn] [pid 4266] AH00045: child process 19392 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.789995 2018] [core:warn] [pid 4266] AH00045: child process 18271 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790021 2018] [core:warn] [pid 4266] AH00045: child process 18272 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790048 2018] [core:warn] [pid 4266] AH00045: child process 18273 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790074 2018] [core:warn] [pid 4266] AH00045: child process 18274 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790101 2018] [core:warn] [pid 4266] AH00045: child process 18390 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790127 2018] [core:warn] [pid 4266] AH00045: child process 18475 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790154 2018] [core:warn] [pid 4266] AH00045: child process 18500 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790180 2018] [core:warn] [pid 4266] AH00045: child process 18501 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790216 2018] [core:warn] [pid 4266] AH00045: child process 18511 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790243 2018] [core:warn] [pid 4266] AH00045: child process 18512 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790269 2018] [core:warn] [pid 4266] AH00045: child process 18513 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790296 2018] [core:warn] [pid 4266] AH00045: child process 18514 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790323 2018] [core:warn] [pid 4266] AH00045: child process 18539 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790350 2018] [core:warn] [pid 4266] AH00045: child process 18540 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790376 2018] [core:warn] [pid 4266] AH00045: child process 18541 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790402 2018] [core:warn] [pid 4266] AH00045: child process 18542 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790428 2018] [core:warn] [pid 4266] AH00045: child process 18543 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790455 2018] [core:warn] [pid 4266] AH00045: child process 20496 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790481 2018] [core:warn] [pid 4266] AH00045: child process 18545 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790508 2018] [core:warn] [pid 4266] AH00045: child process 18546 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790534 2018] [core:warn] [pid 4266] AH00045: child process 20497 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790560 2018] [core:warn] [pid 4266] AH00045: child process 18631 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790587 2018] [core:warn] [pid 4266] AH00045: child process 18637 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790613 2018] [core:warn] [pid 4266] AH00045: child process 18638 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790639 2018] [core:warn] [pid 4266] AH00045: child process 18639 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790666 2018] [core:warn] [pid 4266] AH00045: child process 18640 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790692 2018] [core:warn] [pid 4266] AH00045: child process 18661 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790718 2018] [core:warn] [pid 4266] AH00045: child process 18662 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790744 2018] [core:warn] [pid 4266] AH00045: child process 18663 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790771 2018] [core:warn] [pid 4266] AH00045: child process 18664 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790797 2018] [core:warn] [pid 4266] AH00045: child process 18665 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790824 2018] [core:warn] [pid 4266] AH00045: child process 18666 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790849 2018] [core:warn] [pid 4266] AH00045: child process 18667 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790876 2018] [core:warn] [pid 4266] AH00045: child process 18670 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790902 2018] [core:warn] [pid 4266] AH00045: child process 18854 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790929 2018] [core:warn] [pid 4266] AH00045: child process 18855 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790955 2018] [core:warn] [pid 4266] AH00045: child process 18866 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.790981 2018] [core:warn] [pid 4266] AH00045: child process 18867 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791008 2018] [core:warn] [pid 4266] AH00045: child process 20499 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791034 2018] [core:warn] [pid 4266] AH00045: child process 18869 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791060 2018] [core:warn] [pid 4266] AH00045: child process 18892 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791092 2018] [core:warn] [pid 4266] AH00045: child process 18893 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791119 2018] [core:warn] [pid 4266] AH00045: child process 18894 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791145 2018] [core:warn] [pid 4266] AH00045: child process 18895 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791172 2018] [core:warn] [pid 4266] AH00045: child process 18896 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791205 2018] [core:warn] [pid 4266] AH00045: child process 18897 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791232 2018] [core:warn] [pid 4266] AH00045: child process 18898 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791259 2018] [core:warn] [pid 4266] AH00045: child process 18911 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791285 2018] [core:warn] [pid 4266] AH00045: child process 18916 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791312 2018] [core:warn] [pid 4266] AH00045: child process 20500 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791338 2018] [core:warn] [pid 4266] AH00045: child process 20501 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791364 2018] [core:warn] [pid 4266] AH00045: child process 18919 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791391 2018] [core:warn] [pid 4266] AH00045: child process 18920 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791417 2018] [core:warn] [pid 4266] AH00045: child process 18921 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791443 2018] [core:warn] [pid 4266] AH00045: child process 18922 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791469 2018] [core:warn] [pid 4266] AH00045: child process 18933 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791496 2018] [core:warn] [pid 4266] AH00045: child process 19200 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791523 2018] [core:warn] [pid 4266] AH00045: child process 18948 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791549 2018] [core:warn] [pid 4266] AH00045: child process 18949 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791578 2018] [core:warn] [pid 4266] AH00045: child process 18958 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791605 2018] [core:warn] [pid 4266] AH00045: child process 18959 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791631 2018] [core:warn] [pid 4266] AH00045: child process 18960 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791657 2018] [core:warn] [pid 4266] AH00045: child process 18965 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791692 2018] [core:warn] [pid 4266] AH00045: child process 19201 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791720 2018] [core:warn] [pid 4266] AH00045: child process 19202 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791746 2018] [core:warn] [pid 4266] AH00045: child process 19203 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791772 2018] [core:warn] [pid 4266] AH00045: child process 19204 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791798 2018] [core:warn] [pid 4266] AH00045: child process 19205 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791825 2018] [core:warn] [pid 4266] AH00045: child process 19206 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791851 2018] [core:warn] [pid 4266] AH00045: child process 19207 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791877 2018] [core:warn] [pid 4266] AH00045: child process 19238 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791903 2018] [core:warn] [pid 4266] AH00045: child process 19393 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791929 2018] [core:warn] [pid 4266] AH00045: child process 19412 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791955 2018] [core:warn] [pid 4266] AH00045: child process 19413 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.791986 2018] [core:warn] [pid 4266] AH00045: child process 19414 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792013 2018] [core:warn] [pid 4266] AH00045: child process 19415 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792039 2018] [core:warn] [pid 4266] AH00045: child process 19443 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792065 2018] [core:warn] [pid 4266] AH00045: child process 19444 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792092 2018] [core:warn] [pid 4266] AH00045: child process 19445 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792118 2018] [core:warn] [pid 4266] AH00045: child process 19446 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792144 2018] [core:warn] [pid 4266] AH00045: child process 19447 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792170 2018] [core:warn] [pid 4266] AH00045: child process 19451 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792197 2018] [core:warn] [pid 4266] AH00045: child process 19452 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792223 2018] [core:warn] [pid 4266] AH00045: child process 21274 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792249 2018] [core:warn] [pid 4266] AH00045: child process 19466 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792276 2018] [core:warn] [pid 4266] AH00045: child process 19467 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792302 2018] [core:warn] [pid 4266] AH00045: child process 19468 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792328 2018] [core:warn] [pid 4266] AH00045: child process 19469 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792355 2018] [core:warn] [pid 4266] AH00045: child process 19470 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792381 2018] [core:warn] [pid 4266] AH00045: child process 19473 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792407 2018] [core:warn] [pid 4266] AH00045: child process 19580 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792434 2018] [core:warn] [pid 4266] AH00045: child process 19484 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792460 2018] [core:warn] [pid 4266] AH00045: child process 19497 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792486 2018] [core:warn] [pid 4266] AH00045: child process 19498 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792512 2018] [core:warn] [pid 4266] AH00045: child process 19499 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792538 2018] [core:warn] [pid 4266] AH00045: child process 19500 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792565 2018] [core:warn] [pid 4266] AH00045: child process 19504 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792591 2018] [core:warn] [pid 4266] AH00045: child process 19505 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792686 2018] [core:warn] [pid 4266] AH00045: child process 19506 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792718 2018] [core:warn] [pid 4266] AH00045: child process 19507 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792745 2018] [core:warn] [pid 4266] AH00045: child process 19593 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792772 2018] [core:warn] [pid 4266] AH00045: child process 19594 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792798 2018] [core:warn] [pid 4266] AH00045: child process 19655 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792845 2018] [core:warn] [pid 4266] AH00045: child process 19656 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792875 2018] [core:warn] [pid 4266] AH00045: child process 19657 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792902 2018] [core:warn] [pid 4266] AH00045: child process 19658 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792928 2018] [core:warn] [pid 4266] AH00045: child process 19696 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792959 2018] [core:warn] [pid 4266] AH00045: child process 19697 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.792986 2018] [core:warn] [pid 4266] AH00045: child process 19698 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793012 2018] [core:warn] [pid 4266] AH00045: child process 19699 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793039 2018] [core:warn] [pid 4266] AH00045: child process 19700 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793065 2018] [core:warn] [pid 4266] AH00045: child process 19705 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793091 2018] [core:warn] [pid 4266] AH00045: child process 19706 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793117 2018] [core:warn] [pid 4266] AH00045: child process 19713 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793143 2018] [core:warn] [pid 4266] AH00045: child process 19719 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793169 2018] [core:warn] [pid 4266] AH00045: child process 19720 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793195 2018] [core:warn] [pid 4266] AH00045: child process 19733 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793221 2018] [core:warn] [pid 4266] AH00045: child process 19734 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793247 2018] [core:warn] [pid 4266] AH00045: child process 19735 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793273 2018] [core:warn] [pid 4266] AH00045: child process 19737 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793300 2018] [core:warn] [pid 4266] AH00045: child process 19738 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793326 2018] [core:warn] [pid 4266] AH00045: child process 19743 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793353 2018] [core:warn] [pid 4266] AH00045: child process 19745 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793380 2018] [core:warn] [pid 4266] AH00045: child process 20502 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793406 2018] [core:warn] [pid 4266] AH00045: child process 19747 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793432 2018] [core:warn] [pid 4266] AH00045: child process 19767 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793459 2018] [core:warn] [pid 4266] AH00045: child process 19780 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793485 2018] [core:warn] [pid 4266] AH00045: child process 19781 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793511 2018] [core:warn] [pid 4266] AH00045: child process 19782 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793537 2018] [core:warn] [pid 4266] AH00045: child process 19788 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793564 2018] [core:warn] [pid 4266] AH00045: child process 19790 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793590 2018] [core:warn] [pid 4266] AH00045: child process 19791 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793616 2018] [core:warn] [pid 4266] AH00045: child process 19792 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793642 2018] [core:warn] [pid 4266] AH00045: child process 19804 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793669 2018] [core:warn] [pid 4266] AH00045: child process 19805 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793695 2018] [core:warn] [pid 4266] AH00045: child process 19806 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793721 2018] [core:warn] [pid 4266] AH00045: child process 19807 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793747 2018] [core:warn] [pid 4266] AH00045: child process 19818 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793774 2018] [core:warn] [pid 4266] AH00045: child process 19831 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793800 2018] [core:warn] [pid 4266] AH00045: child process 19832 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793830 2018] [core:warn] [pid 4266] AH00045: child process 19833 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793857 2018] [core:warn] [pid 4266] AH00045: child process 19834 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793883 2018] [core:warn] [pid 4266] AH00045: child process 19835 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793909 2018] [core:warn] [pid 4266] AH00045: child process 21323 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793935 2018] [core:warn] [pid 4266] AH00045: child process 19839 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793961 2018] [core:warn] [pid 4266] AH00045: child process 19840 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.793987 2018] [core:warn] [pid 4266] AH00045: child process 21752 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794013 2018] [core:warn] [pid 4266] AH00045: child process 20507 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794039 2018] [core:warn] [pid 4266] AH00045: child process 19851 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794065 2018] [core:warn] [pid 4266] AH00045: child process 19852 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794092 2018] [core:warn] [pid 4266] AH00045: child process 19857 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794118 2018] [core:warn] [pid 4266] AH00045: child process 19858 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794144 2018] [core:warn] [pid 4266] AH00045: child process 20514 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:58.794170 2018] [core:warn] [pid 4266] AH00045: child process 19872 still did not exit, sending a SIGTERM
[Mon Feb 19 11:09:59.819114 2018] [mpm_prefork:notice] [pid 4266] AH00169: caught SIGTERM, shutting down
[Mon Feb 19 11:10:24.090975 2018] [mpm_prefork:notice] [pid 983] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured -- resuming normal operations
[Mon Feb 19 11:10:24.096911 2018] [core:notice] [pid 983] AH00094: Command line: '/usr/sbin/apache2'
[Mon Feb 19 11:11:51.576882 2018] [mpm_prefork:error] [pid 983] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
[Mon Feb 19 11:42:46.144274 2018] [php7:error] [pid 4871] [client 10.109.150.24:51984] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(1157): HookManager->processEvent('IPXE_EDIT', Array)\n#3 /var/www/html/fog/lib/fog/bootmenu.class.php(197): BootMenu->_parseMe(Array)\n#4 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#5 {main}\n  thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443

Joe Schmitt · Feb 19, 2018, 5:53 PM

@Tom-Elliott can you take a look at this?

Wayne Workman · Feb 19, 2018, 6:34 PM

@uwpviolator said in High MySQL CPU Usage Bogging Down Server:

I did update a handful of machines (manually) to the new FOG Client 11.14 for testing.

It’s possible the high CPU load is being caused by most of the clients being an older version. @Joe-Schmitt thoughts?

UWPVIOLATOR · Feb 19, 2018, 6:36 PM

@wayne-workman So you’re saying because there are just a few 11.14 FOG clients? Currently the client on the Fog Server is 11.12.

UWPVIOLATOR · Feb 19, 2018, 6:42 PM

@Wayne-Workman @Joe-Schmitt

Just checking machines now and I am finding this. So we need to reset encryption

------------------------------------------------------------------------------
----------------------------------UserTracker---------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:40 PM Client-Info Client Version: 0.11.13
 2/19/2018 12:40 PM Client-Info Client OS:      Windows
 2/19/2018 12:40 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:40 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:40 PM Middleware::Response ERROR: Object reference not set to an instance of an object.
 2/19/2018 12:40 PM Service Sleeping for 60 seconds

Wayne Workman · Feb 19, 2018, 6:43 PM

@uwpviolator said in High MySQL CPU Usage Bogging Down Server:

Just checking machines now and I am finding this. So we need to reset encryption

Can’t hurt.

UWPVIOLATOR · Feb 19, 2018, 8:28 PM

@wayne-workman Rest Encryption but clients could not reach server to get cert so they keep trying and trying. Killed for service via GPO and will bring back online. It has already come back under control but we will have to see come tomorrow.

Wayne Workman · Feb 19, 2018, 2:32 PM

@uwpviolator said in High MySQL CPU Usage Bogging Down Server:

clients could not reach server to get cert so they keep trying and trying.

What’s the new error in the fog.log file from one of them? Please give us the whole ‘section’ where the error is.

UWPVIOLATOR · Feb 19, 2018, 8:39 PM

@wayne-workman

2/19/2018 11:52 AM Service Sleeping for 1241 seconds
 2/19/2018 12:13 PM Middleware::Communication URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&configure&newService&json
 2/19/2018 12:13 PM Middleware::Communication ERROR: Could not contact FOG server
 2/19/2018 12:13 PM Middleware::Communication ERROR: Unable to connect to the remote server
 2/19/2018 12:13 PM Middleware::Response Success
 2/19/2018 12:13 PM Service ERROR: Invalid promptTime, using default
 2/19/2018 12:13 PM Middleware::Communication URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&mac=10:60:4B:85:D2:35&newService&json
 2/19/2018 12:14 PM Middleware::Communication ERROR: Could not contact FOG server
 2/19/2018 12:14 PM Middleware::Communication ERROR: Unable to connect to the remote server
 2/19/2018 12:14 PM Middleware::Response Success
 2/19/2018 12:14 PM Middleware::Communication URL: http://fogserver/fog/service/getversion.php?clientver&newService&json
 2/19/2018 12:14 PM Middleware::Communication URL: http://fogserver/fog/service/getversion.php?newService&json

 2/19/2018 12:14 PM Service Creating user agent cache
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response Success
 2/19/2018 12:14 PM ClientUpdater ERROR: Unable to parse versions
 2/19/2018 12:14 PM ClientUpdater ERROR: Input string was not in a correct format.
------------------------------------------------------------------------------


------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

------------------------------------------------------------------------------
---------------------------------SnapinClient---------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

------------------------------------------------------------------------------
--------------------------------PrinterManager--------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

------------------------------------------------------------------------------
--------------------------------PowerManagement-------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

------------------------------------------------------------------------------
----------------------------------UserTracker---------------------------------
------------------------------------------------------------------------------
 2/19/2018 12:14 PM Client-Info Client Version: 0.11.12
 2/19/2018 12:14 PM Client-Info Client OS:      Windows
 2/19/2018 12:14 PM Client-Info Server Version: 1.4.4
 2/19/2018 12:14 PM Middleware::Response ERROR: Unable to get subsection
 2/19/2018 12:14 PM Middleware::Response ERROR: Object reference not set to an instance of an object.
 2/19/2018 12:14 PM Service Sleeping for 60 seconds
 2/19/2018 12:15 PM Middleware::Communication URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&configure&newService&json
 2/19/2018 12:16 PM Middleware::Response Success
 2/19/2018 12:16 PM Middleware::Communication URL: http://fogserver/fog/management/index.php?sub=requestClientInfo&mac=10:60:4B:85:D2:35&newService&json
 2/19/2018 12:17 PM Middleware::Response Success
 2/19/2018 12:17 PM Middleware::Communication URL: http://fogserver/fog/service/getversion.php?clientver&newService&json
 2/19/2018 12:17 PM Middleware::Communication URL: http://fogserver/fog/service/getversion.php?newService&json

 2/19/2018 12:17 PM Service Creating user agent cache
 2/19/2018 12:17 PM Middleware::Response Module is disabled globally on the FOG server
 2/19/2018 12:17 PM Middleware::Response Module is disabled on the host
 2/19/2018 12:17 PM Middleware::Response Module is disabled globally on the FOG server

Wayne Workman · Feb 19, 2018, 8:40 PM

@uwpviolator said in High MySQL CPU Usage Bogging Down Server:

http://fogserver/fog/management/index.php?sub=requestClientInfo&mac=10:60:4B:85:D2:35&newService&json

Can you actually access your FOG Server with that address?
http://fogserver/fog/management

UWPVIOLATOR · Feb 19, 2018, 8:42 PM

@wayne-workman Yes but this only after we killed the FOG service on clients. That freed up the CPU to start allowing clients to authenticate again.

Wayne Workman · Feb 19, 2018, 8:45 PM

@uwpviolator I see. Can you check your Apache error log for problems?

UWPVIOLATOR · Feb 19, 2018, 8:46 PM

@wayne-workman

[Mon Feb 19 13:13:08.200450 2018] [php7:warn] [pid 4912] [client 10.120.151.193:61680] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.128957 2018] [php7:warn] [pid 4277] [client 10.129.150.173:60025] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.205088 2018] [php7:warn] [pid 4277] [client 10.129.150.173:60025] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.210500 2018] [php7:warn] [pid 4277] [client 10.129.150.173:60025] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.220202 2018] [php7:warn] [pid 2671] [client 10.121.150.77:53345] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.231038 2018] [php7:warn] [pid 4943] [client 10.116.1.137:50185] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.319301 2018] [php7:warn] [pid 4987] [client 10.113.150.174:54611] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.319336 2018] [php7:warn] [pid 4987] [client 10.113.150.174:54611] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.339659 2018] [php7:warn] [pid 3850] [client 10.92.150.14:62267] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.359975 2018] [php7:warn] [pid 4291] [client 10.120.1.122:56845] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.360012 2018] [php7:warn] [pid 4291] [client 10.120.1.122:56845] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.364681 2018] [php7:warn] [pid 3722] [client 10.121.150.67:62773] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.364715 2018] [php7:warn] [pid 3722] [client 10.121.150.67:62773] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.377304 2018] [php7:warn] [pid 4987] [client 10.113.150.174:54611] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.425173 2018] [php7:warn] [pid 4564] [client 10.106.150.74:61776] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.425219 2018] [php7:warn] [pid 4564] [client 10.106.150.74:61776] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.428607 2018] [php7:warn] [pid 4564] [client 10.106.150.74:61776] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.441358 2018] [php7:warn] [pid 1095] [client 10.129.150.221:50776] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.562152 2018] [php7:warn] [pid 3722] [client 10.121.150.67:62773] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.436269 2018] [php7:warn] [pid 4291] [client 10.120.1.122:56845] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.602369 2018] [php7:warn] [pid 3848] [client 10.103.1.26:51877] PHP Warning:  array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 1029
[Mon Feb 19 13:13:08.618425 2018] [php7:warn] [pid 4738] [client 10.106.151.97:51232] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.618477 2018] [php7:warn] [pid 4738] [client 10.106.151.97:51232] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.642636 2018] [php7:warn] [pid 4565] [client 10.75.1.49:51793] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.642677 2018] [php7:warn] [pid 4565] [client 10.75.1.49:51793] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.684912 2018] [php7:warn] [pid 4299] [client 10.116.151.206:56595] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:08.684974 2018] [php7:warn] [pid 4299] [client 10.116.151.206:56595] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:09.096405 2018] [php7:warn] [pid 3858] [client 10.105.150.66:55526] PHP Warning:  PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:09.096461 2018] [php7:warn] [pid 3858] [client 10.105.150.66:55526] PHP Warning:  PDOStatement::execute(): Error reading result set's header in /var/www/html/fog/lib/db/pdodb.class.php on line 582
[Mon Feb 19 13:13:09.299891 2018] [php7:error] [pid 1236] [client 10.107.1.19:44883] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(1157): HookManager->processEvent('IPXE_EDIT', Array)\n#3 /var/www/html/fog/lib/fog/bootmenu.class.php(197): BootMenu->_parseMe(Array)\n#4 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#5 {main}\n  thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443
[Mon Feb 19 13:13:09.883195 2018] [php7:error] [pid 3886] [client 10.88.1.67:52314] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(1157): HookManager->processEvent('IPXE_EDIT', Array)\n#3 /var/www/html/fog/lib/fog/bootmenu.class.php(197): BootMenu->_parseMe(Array)\n#4 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#5 {main}\n  thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443
[Mon Feb 19 13:13:10.104024 2018] [php7:error] [pid 3977] [client 10.84.1.2:54487] PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(59): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(1157): HookManager->processEvent('IPXE_EDIT', Array)\n#3 /var/www/html/fog/lib/fog/bootmenu.class.php(197): BootMenu->_parseMe(Array)\n#4 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#5 {main}\n  thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443
[Mon Feb 19 13:14:25.954217 2018] [core:warn] [pid 982] AH00045: child process 3981 still did not exit, sending a SIGTERM
[Mon Feb 19 13:14:27.961702 2018] [core:warn] [pid 982] AH00045: child process 3981 still did not exit, sending a SIGTERM
[Mon Feb 19 13:14:29.963817 2018] [core:warn] [pid 982] AH00045: child process 3981 still did not exit, sending a SIGTERM
[Mon Feb 19 13:14:31.965940 2018] [core:error] [pid 982] AH00046: child process 3981 still did not exit, sending a SIGKILL
[Mon Feb 19 13:14:32.970135 2018] [mpm_prefork:notice] [pid 982] AH00169: caught SIGTERM, shutting down
[Mon Feb 19 13:14:33.576263 2018] [mpm_prefork:notice] [pid 15054] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured -- resuming normal operations
[Mon Feb 19 13:14:33.576327 2018] [core:notice] [pid 15054] AH00094: Command line: '/usr/sbin/apache2'
[Mon Feb 19 13:15:44.013030 2018] [mpm_prefork:error] [pid 15054] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting

Wayne Workman · Feb 19, 2018, 8:48 PM

@uwpviolator said in High MySQL CPU Usage Bogging Down Server:

PDOStatement::execute(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 582

MySQL might be crashing - or running out of buffer space or ram. What’s your max clients set at? Max packet size? Those are mysql settings.

Tom Elliott · Feb 19, 2018, 8:48 PM

One log shows .11.12 and the other shows 0.11.14, are you getting logs from the same machine?

UWPVIOLATOR · Feb 19, 2018, 8:49 PM

@wayne-workman Our mpm_prefork.conf

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# MaxRequestWorkers: maximum number of server processes allowed to start
# MaxConnectionsPerChild: maximum number of requests a server process serves

<IfModule mpm_prefork_module>
 StartServers 10
 MinSpareServers 8
 MaxSpareServers 15
	MaxRequestWorkers	500
	ServerLimit		500
	MaxConnectionsPerChild   0
</IfModule>

# vim: syntax=apache ts=4 sw=4 sts=4 sr noet

UWPVIOLATOR · Feb 19, 2018, 8:51 PM

@tom-elliott No.

Been working on getting Windows 1709 working with FOG. Put the new client on about 30 machines to test last week. Our admin doesnt want to update FOG until there is a stable release. Was told I could have 11.14 in my environment but my server only has 11.12 on it. Have not added it to push out.

UWPVIOLATOR · Feb 19, 2018, 8:54 PM

@wayne-workman I upped max connections to 1000 today. Before it was 500

Maximum number of connections 1000
Query cache size in bytes 256MB
Maximum packet size 16MB

Everything else is default

Tom Elliott · Feb 19, 2018, 9:02 PM

@uwpviolator I understand just wondering why were seeing three logs from different machines. I’ve seen versions 0.11.12 0.11.13 and 0.11.14.

I’m just trying to get information. I doubt the version client you’re running is the problem. Maybe client checkin time is too low?

High MySQL CPU Usage Bogging Down Server

219

12.0k

17.3k

155.1k