What’s the problem?
mysql_dump archive_invalidations
LOCK TABLES `archive_invalidations` WRITE;
/*!40000 ALTER TABLE `archive_invalidations` DISABLE KEYS */;
INSERT INTO `archive_invalidations` VALUES
(369855,159,'done',1,'2014-01-01','2014-12-31',4,'2025-03-18 16:50:27',0,NULL,NULL,NULL,NULL),
(369856,162,'done',2,'2014-01-01','2014-12-31',4,'2025-03-18 16:50:27',0,NULL,NULL,NULL,NULL),
(369857,NULL,'done',3,'2014-01-01','2014-12-31',4,'2025-03-18 16:50:27',0,NULL,NULL,NULL,NULL),
...
(513492,NULL,'done',49,'2025-01-01','2025-01-01',1,'2025-03-18 16:50:35',0,NULL,NULL,NULL,NULL),
(513493,88194,'done',49,'2025-01-01','2025-01-31',3,'2025-03-18 16:50:35',0,NULL,NULL,NULL,NULL),
(513494,126848,'done',49,'2025-01-01','2025-12-31',4,'2025-03-18 16:50:35',0,NULL,NULL,NULL,NULL);
Logfile: ./console core:purge-old-archive-data all
Purging outdated archives for 1996_01...Done. [Time elapsed: 0.005s]
Purging outdated archives for 1996_02...Done. [Time elapsed: 0.002s]
Purging outdated archives for 1996_03...Done. [Time elapsed: 0.002s]
...
Purging outdated archives for 2025_02...Done. [Time elapsed: 0.004s]
Purging outdated archives for 2025_03...Done. [Time elapsed: 0.003s]
Purging outdated archives for 2025_04...Done. [Time elapsed: 0.001s]
Purging invalidated archives for 1996_01...Done. [Time elapsed: 0.003s]
Purging invalidated archives for 1996_02...Done. [Time elapsed: 0.006s]
Purging invalidated archives for 1996_03...Done. [Time elapsed: 0.002s]
...
Purging invalidated archives for 2025_02...Done. [Time elapsed: 0.011s]
Purging invalidated archives for 2025_03...Done. [Time elapsed: 0.008s]
Purging invalidated archives for 2025_04...Done. [Time elapsed: 0.002s]
Purging custom range archives for 1996_01...Done. [Time elapsed: 0.006s]
Purging custom range archives for 1996_02...Done. [Time elapsed: 0.002s]
Purging custom range archives for 1996_03...Done. [Time elapsed: 0.002s]
...
Purging custom range archives for 2025_02...Done. [Time elapsed: 0.014s]
Purging custom range archives for 2025_03...Done. [Time elapsed: 0.014s]
Purging custom range archives for 2025_04...Done. [Time elapsed: 0.007s]
Optimizing archive tables...
Optimizing table archive_numeric_1996_01...Done. [Time elapsed: 0.013s]
Optimizing table archive_blob_1996_01...Done. [Time elapsed: 0.005s]
Optimizing table archive_numeric_1996_02...Done. [Time elapsed: 0.006s]
Optimizing table archive_blob_1996_02...Done. [Time elapsed: 0.004s]
Optimizing table archive_numeric_1996_03...Done. [Time elapsed: 0.005s]
Optimizing table archive_blob_1996_03...Done. [Time elapsed: 0.004s]
...
Optimizing table piwik_archive_numeric_2025_02...Done. [Time elapsed: 0.043s]
Optimizing table piwik_archive_blob_2025_02...Done. [Time elapsed: 0.082s]
Optimizing table piwik_archive_numeric_2025_03...Done. [Time elapsed: 0.033s]
Optimizing table piwik_archive_blob_2025_03...Done. [Time elapsed: 0.048s]
Optimizing table piwik_archive_numeric_2025_04...Done. [Time elapsed: 0.018s]
Optimizing table piwik_archive_blob_2025_04...Done. [Time elapsed: 0.008s]
But after that no change in the database.