Tracking unavailable when data rotation happens #13636
Description
On a large site, when the PrivacyManager\Tasks.deleteLogData task is executed, the tables can get locked for a very long time, thus blocking receiving new data.
MariaDB [(none)]> show processlist;
+--------+-------------+-----------+--------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+--------+-------------+-----------+--------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 881641 | matomo | localhost | matomo | Sleep | 27088 | | NULL | 0.000 |
| 881644 | matomo | localhost | matomo | Query | 1707 | Sending data | /* trigger = CronArchive, idSegments = [7] */
SELECT
count(distinct log_inner.idvisitor) AS | 0.000 |
| 883625 | matomo | localhost | matomo | Query | 828 | Waiting for table metadata lock | LOCK TABLES matomo_log_action WRITE, matomo_log_conversion READ, matomo_log_conversion_item READ, ma | 0.000 |
| 901550 | matomo | localhost | matomo | Query | 280 | Waiting for table metadata lock | SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32('secure.pro | 0.000 |
| 901551 | matomo | localhost | matomo | Query | 280 | Waiting for table metadata lock | SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32('secure.pro | 0.000 |
| 901549 | matomo | localhost | matomo | Query | 280 | Waiting for table metadata lock | SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32('secure.pro | 0.000 |
| 901552 | matomo | localhost | matomo | Query | 280 | Waiting for table metadata lock | SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32('secure.pro | 0.000 |
| 901574 | matomo | localhost | matomo | Sleep | 237 | | NULL | 0.000 |
| 901575 | matomo | localhost | matomo | Query | 234 | Waiting for table metadata lock | SELECT
log_link_visit_action.idvisit,
COALESCE(log_action.type, log_action_title.type) AS | 0.000 |
| 901648 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
+--------+-------------+-----------+--------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+