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.
matthieu
(Matthieu Aubry)
3
Matt,
We are already running 2.11.1
matthieu
(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