Internal Server Error - Row Evolution Error

General questions
1

Hello, there is always a Internal Server Error when opening

Date Range = Month

Behavior → Pages → Page Url → Row Evolution (of a page)

Example current Month (1.-16. 4. 2024).

Matomo 5.0.3
PHP 8.3
memory limit 384 MB (Maximum)

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at xxx@example.com to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.
Apache Server at example.com Port 443

With PHP 8.1 there was this message:

Matomo encountered an error: Allowed memory size of 402653184 bytes exhausted (tried to allocate 20480 bytes) (which lead to: Allowed memory size of 402653184 bytes exhausted (tried to allocate 20480 bytes))

2

Hi @melbao
There is this FAQ:

3

@heurteph-ei , more than memory_limit 384 MB is not possible. It is the maximum on the webhost. max_execution_time is 60 seconds. But, the Error comes directly 2 seconds after click.

With a Date Range of 1 day it is OK. So, the problem is maybe the big memory premise. Is there no solution to decrease the memory premise to adjust the PHP code or database requests?

4

Hi @melbao

I don’t know such kind of possibility… :frowning_face:
But if you run (by scripting) one deletion every 2 minutes for example, you can delete 1 month per hour… and 2 years per day !