Topic: Mysql server has gone away

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

Hi Zhang,

I have enabled quarantine/spam & sql_dns in amavisd. When  i monitor the maillog it see below error message

Feb 24 03:44:03 maildomain postfix/smtpd[7588]: E08ABDC179: client=unknown[]
Feb 24 14:14:04 maildomain postfix/cleanup[7714]: E08ABDC179: message-id=<27913288.4141844.1361694320336.JavaMail.Pankaj@smartmoves>
Feb 24 14:14:04 maildomain postfix/cleanup[7714]: E08ABDC179: from unknown[]; from=<no_reply@indiatimes.com> to=<user@domain.com> proto=SMTP helo=<mail.eperiumindia.com>
Feb 24 14:14:05 maildomain postfix/qmgr[29565]: E08ABDC179: from=<no_reply@indiatimes.com>, size=10608, nrcpt=1 (queue active)
Feb 24 14:14:05 maildomain amavis[25069]: (25069-02) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 87) line 166, <GEN12> line 1664.

My current mysql connection limit is 2500


Re: Mysql server has gone away

Reference: http://www.iredmail.org/forum/topic2536 … ailed.html

- Low traffic mail server will have this issue, because MySQL connection (open by Amavisd) timed out.
- Restarting MySQL service will cause the same issue, because existing MySQL connection (open by Amavisd) cannot connect MySQL server.


Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee