1.3.4 - high cpu load - client login
-
@Wayne-Workman I tried running that command from the wiki and received an error.
ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'hostSecTime' at row 1
-
@andjjru OK I discovered the IGNORE option and it appears to have run on 5025 hosts. No noticeable improvement in CPU load still, so probably need figure out that error.
mysql> UPDATE IGNORE hosts SET hostPubKey="", hostSecToken="", hostSecTime="0000-00-00 00:00:00"; Query OK, 5025 rows affected, 21415 warnings (0.43 sec) Rows matched: 21415 Changed: 5025 Warnings: 21415
-
@Tom-Elliott has the format for that command changed? The one for resetting encryption manually?
-
So I started stopping the FOG Services at multiple buildings via a GPO. We have gotten the CPU load down enough to keep FOG running and actually start an imaging task. I think the issue we have now is that our clients need to have their encryption reset. The ones that don’t are replying back every min. The ones that have been reset are told to sleep for 30min.
-
@UWPVIOLATOR @andjjru Do you two work at the same place? This is getting a bit confusing - I’m not sure you two even have the same issue.
@andjjru there’s no reason why the manual reset commands wouldn’t work, something has to be wrong with your DB. If I were you, I’d backup my DB first, then I’d export my image definitions via Image Management & then I would drop the entire fog database, rerun the installer & then import the image definitions back in. The hosts with the FOG Client on them & working will report in slowly under the pending area. This is how to wipe this issue clean with one fell swoop. And if you backed up your DB prior, you could go back though I would not recommend going back.
If you have snapins, you could export just those too in Snapin Management. Same with printers.
I recommend dropping the DB because something went wrong with one of your upgrades somewhere, the DB isn’t how it should be - and the fastest path to operational is to wipe it.
-
Yes we all work at the same place. @ablohowiak @andjjru
Log files this am.
[Wed Feb 22 06:27:20.975049 2017] [mpm_prefork:notice] [pid 5303] AH00163: Apache/2.4.25 (Ubuntu) OpenSSL/1.0.2k configured -- resuming normal operations [Wed Feb 22 06:27:20.975097 2017] [core:notice] [pid 5303] AH00094: Command line: '/usr/sbin/apache2' [Wed Feb 22 07:25:05.523258 2017] [php7:warn] [pid 16551] [client 10.115.155.125:61276] PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0
-
@UWPVIOLATOR said in 1.3.4 - high cpu load - client login:
PHP Warning: Unknown: FTP server error 426:426 Failure writing network stream.\r\n in Unknown on line 0
There is free space available on all mount points?
df -h
-
Before your replies we rebooted.
After Reboot
[Wed Feb 22 08:27:21.974455 2017] [php7:error] [pid 9017] [client 10.116.153.149:23549] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:22.355014 2017] [php7:error] [pid 9039] [client 10.119.1.12:28114] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.161415 2017] [php7:error] [pid 7484] [client 10.111.150.165:61959] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.285845 2017] [php7:error] [pid 8373] [client 10.111.1.13:2775] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.324201 2017] [php7:error] [pid 4966] [client 10.82.150.46:59273] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.381359 2017] [php7:error] [pid 8986] [client 10.125.1.6:35132] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.432561 2017] [php7:error] [pid 8372] [client 10.116.157.159:43753] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.599594 2017] [php7:error] [pid 8987] [client 10.115.153.85:15205] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.784907 2017] [php7:error] [pid 5031] [client 10.118.150.65:30756] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.866541 2017] [php7:error] [pid 8984] [client 10.107.1.35:54531] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:23.936238 2017] [php7:error] [pid 9027] [client 10.118.2.57:26557] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:24.016330 2017] [php7:error] [pid 8842] [client 10.92.150.13:20952] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:24.187220 2017] [php7:error] [pid 9021] [client 10.109.150.96:14695] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:25.274256 2017] [php7:error] [pid 8939] [client 10.110.1.13:21783] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:25.426605 2017] [php7:error] [pid 8531] [client 10.88.1.59:9031] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:25.948918 2017] [php7:error] [pid 8990] [client 10.115.154.176:38872] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:26.108836 2017] [php7:error] [pid 8937] [client 10.116.3.91:31055] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:26.384484 2017] [php7:error] [pid 8532] [client 10.116.2.16:62439] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:26.415361 2017] [php7:error] [pid 9010] [client 10.82.1.7:62022] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:26.640042 2017] [php7:error] [pid 9034] [client 10.123.1.93:47350] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:26.855784 2017] [php7:error] [pid 8417] [client 10.118.2.66:9475] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:27.385476 2017] [php7:error] [pid 9021] [client 10.111.1.44:45313] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:27.394782 2017] [php7:error] [pid 8531] [client 10.116.2.19:28389] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:27.399780 2017] [php7:error] [pid 8978] [client 10.111.150.38:60849] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:27.698819 2017] [php7:error] [pid 8952] [client 10.115.153.24:23645] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:27.979249 2017] [php7:error] [pid 8948] [client 10.116.153.8:25911] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:28.185703 2017] [php7:error] [pid 9013] [client 10.108.150.239:34752] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:28.215599 2017] [php7:error] [pid 4966] [client 10.88.1.197:44084] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:28.377755 2017] [php7:error] [pid 8986] [client 10.115.3.35:36484] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:28.438369 2017] [php7:error] [pid 8981] [client 10.120.152.134:64890] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:28.709761 2017] [php7:error] [pid 8351] [client 10.116.153.74:23230] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:29.167632 2017] [php7:error] [pid 8354] [client 10.102.152.99:24999] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:29.439748 2017] [php7:error] [pid 8990] [client 10.116.3.18:38908] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:29.702478 2017] [php7:error] [pid 8909] [client 10.118.2.8:20966] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:29.868560 2017] [php7:error] [pid 8807] [client 10.88.1.206:17958] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:29.957723 2017] [php7:error] [pid 6687] [client 10.94.152.195:22423] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:30.041336 2017] [php7:error] [pid 9014] [client 10.116.157.8:57584] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:30.682368 2017] [php7:error] [pid 9029] [client 10.116.156.48:42963] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:30.754530 2017] [php7:error] [pid 8531] [client 10.110.150.38:44056] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:31.174117 2017] [php7:error] [pid 8985] [client 10.107.150.146:4629] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:31.859047 2017] [php7:error] [pid 9034] [client 10.115.3.102:27161] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:31.906061 2017] [php7:error] [pid 6687] [client 10.116.1.84:56838] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:32.020304 2017] [php7:error] [pid 6765] [client 10.115.152.40:7892] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:32.417617 2017] [php7:error] [pid 8982] [client 10.115.154.62:44367] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:32.897455 2017] [php7:error] [pid 8948] [client 10.138.150.136:48208] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:33.206325 2017] [php7:error] [pid 9040] [client 10.110.150.118:22371] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:33.585225 2017] [php7:error] [pid 8352] [client 10.115.155.139:54178] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:33.863953 2017] [php7:error] [pid 9014] [client 10.118.2.60:17317] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:34.072907 2017] [php7:error] [pid 9017] [client 10.75.152.126:49009] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:34.779944 2017] [php7:error] [pid 8952] [client 10.116.2.17:41443] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443 [Wed Feb 22 08:27:34.864604 2017] [php7:error] [pid 8938] [client 10.120.1.183:17079] 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/bootmenu.class.php(442): FOGController->save()\n#2 /var/www/html/fog/lib/fog/bootmenu.class.php(368): BootMenu->_ipxeLog()\n#3 /var/www/html/fog/service/ipxe/boot.php(35): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443
-
This is our current enable mod. What I see it is missing ServerLimit. What should these settings be by default?
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 5 MinSpareServers 5 MaxSpareServers 10 MaxRequestWorkers 150 MaxConnectionsPerChild 0 </IfModule> # vim: syntax=apache ts=4 sw=4 sts=4 sr noet
-
@UWPVIOLATOR This appears, to me, like PHP and Apache are starting before mysql services are running. At least that’s why I imagine those errors are suddenly showing up.
-
Yeah we had to restart those services after reboot. So we are semi stable right now after I disabled all the FOG Services on our clients. What else can we do to test why we keep maxing out the CPU?
Still getting this error.
[Wed Feb 22 09:02:41.373552 2017] [mpm_prefork:error] [pid 28247] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
-
@UWPVIOLATOR said in 1.3.4 - high cpu load - client login:
ched MaxRequestWorkers s
What’s your client checkin time set to?
-
30min but I have GPO pushed out to stop all FOG Service until we get it stable.
If you look back a few posts. I think encryption is part of the issue. All our clients encryptions were broke and replying back every minute. We tried to reset all but we got errors. So at this point I am not sure all clients encryptions have been reset.
mysql
use fog
UPDATE hosts SET hostPubKey=“”, hostSecToken=“”, hostSecTime=“0000-00-00 00:00:00”; -
@UWPVIOLATOR As long as things are “usable” you might have better luck just running:
UPDATE `hosts` SET `hostPubKey`= '', `hostSecToken` = '';
The hostSecTime is irrelevant at that point.
I don’t think simply clearing them will fix the problem though. I suspect what’s happening is the hosts are being “kicked” out because there’s simply too many.
Another way to achieve the “reset all” would be:
Put all hosts into a group.
From the group you can then reset all data (whether or not there is data to be reset).
-
We tried to put them all into one group before. We have to many hosts and it crashes.
Will try UPDATE
hosts
SEThostPubKey
= ‘’,hostSecTok
= ‘’;We want to leave FOG alone today since we can do imaging while the GPO is in effect. We will then schedule an update to RC10 or newest. Then see if it stays stable. Then start removing the GPO site by site to see if we crash it again.
Did you see the mpm_prefork.conf file I posted below? Does that look right?
-
ERROR 1054 (42S22): Unknown column ‘hostSecTok’ in ‘field list’
-
@UWPVIOLATOR Edited the original, sorry i missed the en at the end.
-
Query OK, 4023 rows affected (0.15 sec)
Rows matched: 21413 Changed: 4023 Warnings: 0 -
What is this doing that it is pulling so much resources? Happening multiple times a day.
-
could you verify for me the path listed for “Snapin Path” in your Storage management master node