Batch Process - Delete old data

Support & Bugs
1

Hi,
When the batch process run “Piwik\Plugins\PrivacyManager\Tasks.deleteLogData”, this task execute a sql statement that consume all storage database and lock tables so all piwik stay blocked.

Information:

SQL statement:
DELETE LOW_PRIORITY QUICK IGNORE piwik_log_action
FROM piwik_log_action
LEFT JOIN piwik_tmp_log_actions_to_keep tmp ON tmp.idaction = piwik_log_action.idaction
WHERE tmp.idaction IS NULL

Table piwik_log_action: 69524.03 MB

Piwik version: 2.15

Regards
Mariano

1 Like
2

Hi,
we have the same Problem in our installation.
Was there any solution for this?
Once in a week our piwik is blocked becouse Privacy Task.

102384382 Table rows
22,1 GB Data length
3,3 GB Index length

Our Piwik Version is 3.2.

Regards
Michael