Long term data query producing Error 500 (Internal Server Error)

[yubiuser]

As Coro already said, it is like a php memory issue. You can increase the limit by
changing memory_limit in /etc/php/7.3/cgi/php.ini and

sudo service lighttpd force-reload

Adjust to limit according to the amout of RAM you have.

See here for more details:

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

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. [Bildschirmfoto zu 2020-04-29 11-54-15] I would not recommend to set it to -1.