I need some advice please as I have tried all hints which I found online so far. I am running several matomo-instances on different hosting packages and on dedicated servers for a long time, performing updates regularly.
In the last week of March I updated one of these matomos from 3.12(? not sure anymore) to 3.13 via online-updater from within the matomo dashboard.
It’s a rather small website with about 300 visitors daily and haven’t set up a cron job for archiving in this installation. When I enter the dashboard I can access everything up to the date when I performed the update but not anything afterwards and in addition as soon as I enter the dashboard (which means archiving starts) something goes completely wrong and my whole server (it’s a dedicated server) gets filled until nothing but restart helps.
All webpages and services on this server are gone within 15-25 minutes because of no-space-left-on-device. After a restart all is ok again and free space has recovered. I tried to turn off the archiving via entering the dashboard and added a cronjob, but when I start archiving manually via ./console core:archive the same happens. I cannot identify which table is filled and why. I also tried to set up a fresh installation and connected it to the existing database, but the same behaviour remains. None of the other installations is showing this behaviour and I don’t know what else to try.
I already tried the hints mentioned in this thread: Size of piwik_archive_blob files is astronomical and After updating the 2019_01 archive blob tables are gaining size · Issue #10439 · matomo-org/matomo · GitHub but nothing changed.
I ported the installation to a local ubuntu machine using a virtual host to see if I can dig in deeper without killing a server online regularly but the behaviour is the same. As soon as I kill mysqld in this machine all space gained is free again so it has to be something in the database-accessing. The funny thing is that the log says “nothing to do” and in the background there still is obviously something running regarding mysql and the harddrive gets filled while I’m just sitting there doing nothing. Now as long as I don’t enter this specific matomo instance’s backend (respectively as long as I don’t start console core:archive) nothing happens at all, free space remains free.
Does anybody know a way to make archiving work again? Any help is appreciated.