Slow computer listing and high CPU with version 1.5.1.01798

[Infojoe]

Hi everyone !
Since I update to 1.5.10.1798, it takes up to 3mn to show full computers listing on index.php?node=host. During this time, php-fpm8.3 consume 100% CPU time.
And all others pages (groups for ex) don’t respond during this time. But they load fine after computers list finally loads.

And sometimes, it end up with a gateway timeout…

Am I alone with this problem ?

[tatanas]

Same here

[olivier.bonnici]

Same here, 1.5.10.1734 to 1.5.10.1798 on debian 13.3 freshly installed.
Hosts Web Page hangs several minute.

[Tom Elliott]

@olivier-bonnici How many hosts do you have?

@tatanas @Infojoe as well, apologies on delayed response.

[Infojoe]

@Tom-Elliott No problem.
On my side, I have about 630 hosts. Usually, hosts page loads in a second.

[olivier.bonnici]

This post is deleted!

[olivier.bonnici]

@Tom-Elliott
Hi Tom.
634 hosts
Take 3 secondes with 1.5.1734

[Tom Elliott]

Can you get some output from /var/log/php-fpm/www-error.log (if redhat based?) or /var/log/apache2/error.log (if debian)

Basically try to load the page, and tail the log and return that output here for htat rough timestamp.

Also see if there’s anything in the history table:

SELECT * from fog.history;

For around that time frame.

[tatanas]

Hi,
177 hosts and it takes almost one minute

[olivier.bonnici]

@Tom-Elliott I’m on another server, DEBIAN13.3, fog 1.5.1.01798 no slowing page here but number had been added on the hosts lists :

[olivier.bonnici]

@Tom-Elliott Error.log

[Wed Mar 18 13:56:12.727237 2026] [proxy:error] [pid 907:tid 907] (111)Connection refused: AH00957: FCGI: attempt to connect to 127.0.0.1:9000 (127.0.0.1:9000) failed
[Wed Mar 18 13:56:12.727296 2026] [proxy_fcgi:error] [pid 907:tid 907] [client 10.72.228.101:56843] AH01079: failed to make connection to backend: 127.0.0.1
[Wed Mar 18 13:56:12.727758 2026] [mpm_prefork:notice] [pid 865:tid 865] AH00163: Apache/2.4.66 (Debian) OpenSSL/3.5.5 configured -- resuming normal operations
[Wed Mar 18 13:56:12.727797 2026] [core:notice] [pid 865:tid 865] AH00094: Command line: '/usr/sbin/apache2'
[Wed Mar 18 13:56:13.201595 2026] [proxy_fcgi:error] [pid 910:tid 910] [client 10.72.233.20:57281] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to a member function lastInsertId() on false in /var/www/fog/lib/db/pdodb.class.php:615\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(521): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(62): FOGController->save()\n#2 /var/www/fog/lib/fog/fogpage.class.php(223): HookManager->processEvent()\n#3 /var/www/fog/lib/pages/schemaupdaterpage.class.php(39): FOGPage->__construct()\n#4 /var/www/fog/lib/fog/fogpagemanager.class.php(381): SchemaUpdaterPage->__construct()\n#5 [internal function]: FOGPageManager->{closure:FOGPageManager::loadPageClasses():350}()\n#6 /var/www/fog/lib/fog/fogpagemanager.class.php(386): array_map()\n#7 /var/www/fog/lib/fog/fogpagemanager.class.php(79): FOGPageManager->loadPageClasses()\n#8 [internal function]: FOGPageManager->__construct()\n#9 /var/www/fog/lib/fog/fogbase.class.php(481): ReflectionClass->newInstanceArgs()\n#10 /var/www/fog/management/index.php(25): FOGBase::getClass()\n#11 {main}\n  thrown in ...'