Archive jobs cause the Web UI to become inaccessible


#1

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.


#2

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.


(Matthieu Aubry) #3

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?


#4

Matt,

We are already running 2.11.1


(Matthieu Aubry) #5

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


#6

Issue logged.