One of my archive_blob tables is truly massive, it’s 207GB. When I run console diagnostics:analyze-archive-table 2023_01 it takes a few hours to run, I get lots of entries that look relatively normal, but then at the bottom I get the following:
+--------------------------------------------+------------+---------------+-------------+---------+-----------+----------------+-------------+-------------+
| Group | # Archives | # Invalidated | # Temporary | # Error | # Segment | # Numeric Rows | # Blob Rows | # Blob Data |
+--------------------------------------------+------------+---------------+-------------+---------+-----------+----------------+-------------+-------------+
[...]
| week[2023-01-16 - 2023-01-22] idSite = 56 | 12 | 168 | - | - | - | - | - | - |
| year[2023-01-01 - 2023-12-31] idSite = 56 | 432 | 2377474 | - | - | - | - | - | - |
| year[2023-01-01 - 2023-12-31] idSite = 61 | 303 | 1571421 | - | - | - | - | - | - |
and the task exits with:
Uncaught exception: TypeError: Unsupported operand types: int + string in /bitnami/matomo/plugins/Diagnostics/Commands/AnalyzeArchiveTable.php:69
Stack trace:
#0 /opt/bitnami/matomo/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\Diagnostics\Commands\AnalyzeArchiveTable->execute()
#1 /opt/bitnami/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run()
#2 /opt/bitnami/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand()
#3 [internal function]: Symfony\Component\Console\Application->doRun()
#4 /opt/bitnami/matomo/core/Console.php(135): call_user_func()
#5 /opt/bitnami/matomo/core/Access.php(670): Piwik\Console->Piwik\{closure}()
#6 /opt/bitnami/matomo/core/Console.php(136): Piwik\Access::doAsSuperUser()
#7 /opt/bitnami/matomo/core/Console.php(87): Piwik\Console->doRunImpl()
#8 /opt/bitnami/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun()
#9 /opt/bitnami/matomo/console(32): Symfony\Component\Console\Application->run()
#10 {main}
Uncaught exception in /bitnami/matomo/plugins/Diagnostics/Commands/AnalyzeArchiveTable.php line 69:
Unsupported operand types: int + string
Sites with those IDs don’t exist.
I’ve also performed core:purge-old-archive-data. That took over 4 hours to optimize just the largest table. Made no difference to the size.
Could this be contributing to my huge table? The DB itself is over 600GB and I’m trying to reign it in!