Running version 2.11.1 we are having an issue of the Web UI constantly timing out during archive runs.
Archive runs via cron job once an hour. During the 20-30 minute archive run the Web ui becomes inaccessible multiple times for 2-3 minutes at a time.
Http error log is full of this entries:
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
I thought that 2.11.1 release fixed this issue.
IS there way of throttling the archive job?
Our DB server supports up to 3000 IOPS and I think the DB Lock wait timeout errors are being caused by us maxing out the IOPS on the server.
It’s possible you’re experiencing this buG: Mysql process list is clogged with very inefficient updates on the archive blob tables · Issue #7195 · matomo-org/piwik · GitHub
can you try upgrade to latest beta and confirm this is fixed for you?
Matt,
We are already running 2.11.1
Hi there, ok please createa new issue with as much info as can be useful. Maybe other users with the same problem will comment as well
Issue logged.