Expected Behavior:
Unable to load admin page or panels become responsive if scripts loaded from cache.
Actual Behavior:
Admin dashboard either does not load or panels become unresponsive for the following panels:
query types
queries answered by
top permitted domains
top blocked domains panels.
In incognito, the admin page just never loads but default landing page does. When you do a force-reload/cache-less load of /admin/, the following files are not retrieved from the lighthttpd server (network requests stall):
bootstrap.min.js
select2.min.css
default-dark.css
adminlte.min.js
Chart.min.js
logo.svg
donate.gif
ip-address-sorting.js
utils.js
queries.js
footer.js
pihole1 utilization: >336000 queries, >2500 per hour.
pihole2 utilization: ~84000 queries, ~100 per hour.
no high CPU usage
restarting does not restore functionality
/var/log/pihole.log{,.1} sizes being 38MiB & 67MiB, respectively, on pihole1 and 16MiB & 7.4MiB on pihole2.
Env info:
Xen VM instance (2core, 2GiB, 24GiB VHD on local SSD), Guest Agent 8.0
Ubuntu Server 20.04 w/kernel 5.4.0-70-generic (fully updated)
lighttpd 1.4.55
php 7.4.3
pihole 5.2.4
adminLTE 5.4
FTL 5.7
unbound 1.9.4-2ubuntu1.1apt
browser client - Windows 10 Pro w/Chrome 89.0.4389.114 32b
2021-04-07 13:52:07: (mod_fastcgi.c.421) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/admin/api_FTL.php on line 324
2021-04-07 13:52:13: (mod_fastcgi.c.421) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/admin/api_FTL.php on line 324
The database is not involved in any of these. The data is provided from FTL which has them in its memory. You have "HA" in your title. What do you mean? Are the two Pi-holes somehow synchronized? If so, how?
I mean I have two piholes, on the same LAN, that all hosts are told about via DHCP and that they are configured the same as to support the same effective state across both instances. While I would agree this is not true HA, the effective result is similar enough for my usecase.
After removing the memory limit and restarting pihole-FTL, there has been no issues once the number of queries rose to over 360k. The panels now load up without issue and are just as quick to load as if the server was freshly installed. Also marking solution.