Timeout Error When using Long Term Query

[italeffect20]

Expected Behavior:
Web interface: Long term data > Query log, selecting the date and time range you should see the queries for the selected date and time range with no error or timeout.

Actual Behaviour:
Selecting a longer time frame longer than 2-3 days causes the query to time out and throw an error.
Error message appears after less than 10 seconds: "An unknown error occurred loading the data"

This is running on a Raspberry Pi 3B and pihole is the only thing running. Same behavior in safari and chrome browsers on mac os 10.15 and Chrome on Win 10. (So I assume it's not a browser issue).

I have a separate pihole instance via Docker on my server and that one works as expected.

I thought that the Pi 3B should be powerful enough for this and should not error out so quickly. Is there a way to increase the resources available to it? Or is something else going on?

Debug Token:
jb218flx7u

Thanks!

[yubiuser]

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

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 or if it's by design. Maybe a better error message is required if that's the case. Under Long Term Data menu, you have three options to search by. Graphics, Query Log, and Top Lists. In Graphics i…

[italeffect20]

Thank you! When I searched I could only find older posts that were not helpful. This nails it exactly.