Topic: Erros Amavis-MySQL
==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version: v1.3.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian Squeeze
- Related log if you're reporting an issue:
====
Recently at times of very large flow of emails begun some erros in Amavis in access to MySQL tables. The mailog shows:
Jun 2 08:29:17 smtp02 amavis[19607]: (19607-17) (!)WARN save_info_final: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exce
eded; try restarting transaction at (eval 113) line 166, <GEN37> line 13909.
Jun 2 08:29:17 smtp02 amavis[21006]: (21006-06) (!)WARN save_info_final: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exce
eded; try restarting transaction at (eval 113) line 166, <GEN37> line 4029.
Jun 2 08:29:22 smtp02 amavis[19482]: (19482-16) (!)WARN save_info_final: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exce
eded; try restarting transaction at (eval 113) line 166, <GEN37> line 11502.
Jun 2 08:29:29 smtp02 amavis[19934]: (19934-13) (!)WARN save_info_final: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exce
eded; try restarting transaction at (eval 113) line 166, <GEN37> line 253044.
Jun 2 08:29:29 smtp02 amavis[20266]: (20266-11) (!)WARN save_info_final: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exce
eded; try restarting transaction at (eval 113) line 166, <GEN37> line 9868.
(...)
In this cases, I stop postfix, amavis and disable content filter in /etc/postfix/main.cf.
So I start postfix and server normalize again. After some time I start again Amavis and no errors.
Any idea?
Tks.
M Martinatti
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.