Centos8 Query Log Allowed Memory insufficient

[jogalt]

The issue I am facing:
Unable to view long-term queries via web interface. Logs say my php memory allocation is insufficient.

Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/admin/api_FTL.php on line 319

Details about my system:
Running in ESXi 7.0b, OS is Centos8 (basic server image), 4 Cores, 8GBs RAM, 80GB HD

What I have changed since installing Pi-hole:
Nothing has changed. Fresh Install - has run 24 hours. Had several hangs while trying to download blocklists (I'm assuming it's probably related to this memory allocation issues).

Debug token: https://tricorder.pi-hole.net/7p59vts7bo

[jfb]

You are likely running out of PHP memory (and using a lot of memory in general) due to the activity level on your Pi:

   [2020-10-28 20:16:00.857 41417M] Resizing "/FTL-queries" from 16515072 to 16777216
   [2020-10-28 20:16:00.862 41417M] Imported 260121 queries from the long-term database
   [2020-10-28 20:16:00.862 41417M]  -> Total DNS queries: 260121
   [2020-10-28 20:16:00.862 41417M]  -> Cached DNS queries: 216059
   [2020-10-28 20:16:00.862 41417M]  -> Forwarded DNS queries: 34839
   [2020-10-28 20:16:00.862 41417M]  -> Blocked DNS queries: 9223
   [2020-10-28 20:16:00.862 41417M]  -> Unknown DNS queries: 0
   [2020-10-28 20:16:00.862 41417M]  -> Unique domains: 2216
   [2020-10-28 20:16:00.862 41417M]  -> Unique clients: 42
   [2020-10-28 20:16:00.862 41417M]  -> Known forward destinations: 2

How do I increase PHP's memory?

pi@ph5:~ $ sudo nano /etc/php/*/cgi/php.ini [..] ; Maximum amount of memory a script may consume (128MB) ; http://php.net/memory-limit memory_limit = 128M [..] pi@ph5:~ $ sudo service lighttpd restart pi@ph5:~ $ pi@ph5:~ $ php-cgi -i | grep memory_limit <tr><td class="e">memory_limit</td><td class="v">128M</td><td class="v">128M</td></tr>

[jogalt]

Followed the instructions. Get the expected CLI output but I still have the error and now the allocated memory is even less that it was originally.

FastCGI-stderr:PHP Fatal error: Allowed memory size of 2097152 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/admin/api_db.php on line 112

[jogalt]

memory_limit1024MB1024MB

[jogalt]

I took the leap and removed the memory limit altogether (= -1) and the query completed successfully and quickly. I ported everything from a RPi 3B yesterday and never had any problems running the same query. Any suggestions on what could have changed?

[jfb]

No, I don't.