1

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

2

Re: Erros Amavis-MySQL

marcelomartinatti wrote:

- iRedMail version: v1.3.0

Are you still running iRedAdmin-Pro-MySQL-1.3.0? The latest stable release is 1.8.2.

Do you have many SQL records in SQL database "amavisd"? Especially in tables "amavisd.msgs" and "amavisd.msgrcpt".