This issue has been mentioned on Matomo forums. There might be relevant details there:

https://forum.matomo.org/t/high-traffic-sites-and-custom-period-date-ranges-selection/44717/2

@mritzmann Thanks for creating the issue.
Which size is your memory limit set to? Just wondering if you limit is quite small or if the memory consumption of our script is very high in that case.

Hello @sgiehl, thank you very much for your reply.

Which size is your memory limit set to?

The PHP memory limit was set to 4G.

$ cat php.ini | grep memory_limit
memory_limit = 4G

$ php -r 'echo ini_get("memory_limit");'      
4G

Ok. That should indeed be enough to clean up the data. I guess we need to investigate how our code to remove old visits currently works. Maybe it tries to query all data before removing it or has another memory lack we should close.
ping @tsteur

Had a quick look at the code and the delete log data task should be quite low memory and we delete max 2000 visits at once there and shouldn't save much in memory. On our own instance have never seen any memory issues there.

This may trigger also the log_actions cleanup though. @mritzmann could you maybe add below entry to your config/config.ini.php to see if it still happens? This effectively should delay running the log_action cleanup by a lot of days and basically disables it

[Deletelogs]
delete_logs_unused_actions_schedule_lowest_interval = 9000000

I am sorry, but I can no longer reproduce the problem, as I have since deleted several GB of RAW data (to solve the problem described above). The cronjob is currently running successfully for me. Therefore, it probably doesn't make sense for me to check settings like delete_logs_unused_actions_schedule_lowest_interval.

But I still think that some kind of monitoring check (for example a notification in webui) would be interesting. This would be less a bug, but more a feature request.