1 (edited by JeeGee 2014-10-12 03:01:50)

Topic: amavis DBD::mysql::st execute failed: MySQL server has gone away at (

==== Required information ====
- iRedMail version: 0.8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Linux/BSD distribution name and version: CentOS 6.5
- Related log if you're reporting an issue: maillog
====

Today on my backup MX I see this in de maillog:
amavis[920]: (00920-02) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 101) line 172.

I already searched the forum and found this topic:
http://www.iredmail.org/forum/topic2536 … ailed.html

But:
1. it seems configuration is different nowadays, as there is no 50-users file. Only amavisd.conf I see in this file twice:
$max_servers = 2;            # num of pre-forked children (2..30 is common), -m
and at the end:
# Num of pre-forked children.
# WARNING: it must match (equal to or larger than) the number set in
# /etc/postfix/master.cf "maxproc" column for the 'smtp-amavis' service.
$max_servers = 10;

1;  # insure a defined return

What to do?  O and $max_requests = 1; is not in the file.

2. Should I also set the max connections in my.cfg? Or is this for something else?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: amavis DBD::mysql::st execute failed: MySQL server has gone away at (

*) If you have duplicate parameter in Amavisd config file, only the last one will be used.
*) You can add $max_requests manually.
*) It's not a SQL server side issue, so no need to touch MySQL config file (my.cnf).

3 (edited by JeeGee 2014-10-12 16:07:39)

Re: amavis DBD::mysql::st execute failed: MySQL server has gone away at (

Clear. Going to start with the 2 settings.

But do the changes in amavisd.conf?

Will let you know.

4

Re: amavis DBD::mysql::st execute failed: MySQL server has gone away at (

Ok. Didn't change anything yet, but today I saw again the lines in the logfile:

amavis[7708]: (07708-02) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 101) line 172.

So I added the 2 lines in /etc/amavisd/amavisd.conf

Hopefully this will fix it.

To be continued.