Improve delete-logs-data memory usage #20038
Delete logs data
Fatal error: Allowed memory size of 1677721600 bytes exhausted (tried to allocate 20480 bytes) in /var/www/clients/client2/web282/web/piwik/plugins/PrivacyManager/Model/DataSubjects.php on line 497
Steps to Reproduce (for Bugs)
1../console core:delete-logs-data --dates=2011-01-01,2017-12-31 --limit 1000 in /var/www/somepath/web/piwik/core/DataTable/Manager.php
The text was updated successfully, but these errors were encountered:
Hi @grzchr15, thanks for reporting this.
Issue 19695 occurs when archiving data so it's probably not related.
Deleting log data can use quite a bit of memory. The code that ran out of memory in the fatal error above was building a database query with multiple visitor ids. It's possible that this area of code could be made more memory efficient.
Does decreasing the
1.) it would be helpfull to have a way to calculate the needed memory for that.