1 Topic by soundarajan

  • soundarajan
  • Member
  • Offline
  • Registered: 2013-01-17
  • Posts: 29

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[122.160.115.237]
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[122.160.115.237]; 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

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

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.