Please follow the below template, it will help us to help you! Please ensure that you are running the latest version of the beta code. Run pihole -up to update to the latest, then verify that the problem still exists before reporting it. Problem with Beta 5.0: I am not sure if this is a problem …

[image] gordon15969: Allowed memory size of 134217728 bytes exhausted This is like 128 MB. Either your device doesn't have enough memory available or (more likely) there is some configuration somewhere on your device that limits the amount of memory PHP can use. When it hits this barrier, PHP…

I’m running pihole in an Ubuntu 18.04 LTS server VM I will investigate where I can make this change. Thanks for the feedback.

I had to bump my VM to 4GB of ram, and set PHP to consume up to 2GB. Once I made this change everything started to work. This implies to me that my 1GB ram pi 3B+ won't be able to run this in the manner I would like from a logging perspective. I wonder if this is a bug or is this the intended ope…

Just wanted to jump in here and say that I recently ran into the same problem. My setup has 14 total devices, and generates an average of between 60k and 80k queries per day (with some days peaking at 100k). 1GB memory_limit, what I set now, seems to be working, but the performance is lacking: load…

[image] cmrt: Would you consider, for the next release, server-side (in SQLite) query paging as a requirement? We have server-side pagination already implemented for our next-gen API, which is currently scheduled for Pi-hole v6.0.

I encounter the same issue. Using the long-term database to query 30 days results in "An unknown error occurred with loading the data" and (mod_fastcgi.c.421) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 16777224 bytes) in /var/www/html/admi…

Set the memory to -1 and it will work.

Doesn't that risk that the device runs out of memory completely? Add It does. It worked for "this year" (1.3M queries) but the device got total unresponsive querying "all time". It run out of memory, out of swap and pihole didn't resolve DNS anymore. I hard resetted it after a few minutes. [Bi…

Works fine for the nanopi neo LTS that I'm running on. 512M Ram/256M swap.

Maybe you database is much smaller? How many queries do you retrieve for 'all time'?

Pi-hole Userspace

Querying long term data failed due to limited allowed memory for PHP resulting in "An unknown error occurred with loading the data"

General Beta 5.0