1 Topic by fisher006 (edited by fisher006 2016-08-01 23:13:23)

  • fisher006
  • Member
  • Offline
  • Registered: 2016-08-01
  • Posts: 46

Topic: Many errors MySQL server has gone away

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  0.9.5-1
- Linux/BSD distribution name and version:  centos 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? NO
- Related log if you're reporting an issue:
====

Server have 30 mail per day not more... But have many SQL erors.
I check passwords and evrything is OKay

amavisd.conf

$max_servers = 2;
$max_requests = 2;

or

$max_servers = 20;
$max_requests = 20;


and this same result


This errors is for all plugins:

2016-08-01 16:46:15 ERROR <!> Error while applying plugin "greylisting": (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone 
2016-08-01 16:46:15 ERROR <!> Error while applying plugin "amavisd_wblist": (_mysql_exceptions.OperationalError) (2006, 'MySQL server has 
2016-08-01 17:00:51 ERROR <!> Error while applying plugin "reject_sender_login_mismatch": (_mysql_exceptions.OperationalError) (2006, 
2016-08-01 17:00:51 ERROR <!> Error while applying plugin "greylisting": (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone 
2016-08-01 17:00:51 ERROR <!> Error while applying plugin "amavisd_wblist": (_mysql_exceptions.OperationalError) (2006, 'MySQL server has 
2016-08-01 17:00:51 DEBUG --> Apply plugin: amavisd_wblist
2016-08-01 17:00:51 DEBUG Possible policy senders: ['@.', 'ulxuyvq@barak.int.net', '@barak.int.net', '@.barak.int.net', '@int.net', '@.int.net', '@net', '@.net', 'ulxuyvq@*', '69.47.101.192', '69.47.*.192', '*.*.101.192', '69.47.*.*', '*.47.101.192', '69.*.*.*', '*.*.*.192', '69.47.101.*', '69.*.101.192', '*.*.*.*', '69.*.*.192']
2016-08-01 17:00:51 DEBUG Possible policy recipients: ['@.', 'mail@pella.pl', '@pella.pl', '@.pella.pl', '@pl', '@.pl']
2016-08-01 17:00:51 DEBUG Apply wblist for inbound message.
2016-08-01 17:00:51 DEBUG [SQL] Query local addresses: 
SELECT id, email
               FROM users
              WHERE email IN ('@.', 'mail@pella.pl', '@pella.pl', '@.pella.pl', '@pl', '@.pl')
           ORDER BY priority DESC
2016-08-01 17:00:51 ERROR <!> Error while applying plugin "amavisd_wblist": (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: "SELECT id, email\n               FROM users\n              WHERE email IN ('@.', 'mail@pella.pl', '@pella.pl', '@.pella.pl', '@pl', '@.pl')\n           ORDER BY priority DESC"]
2016-08-01 17:00:51 DEBUG Session ended
2016-08-01 17:00:51 INFO [69.47.101.192] RCPT, ulxuyvq@barak.int.net -> mail@pella.pl, DUNNO

----

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: 31,165

Re: Many errors MySQL server has gone away

With iRedMail-0.9.5-1, you're running iRedAPD-1.9.1 (/opt/iRedAPD-1.9.1), please open file /opt/iRedAPD-1.9.1/libs/utils.py, find lines below:

        conn = create_engine(uri,
                             pool_size=20,
                             pool_recycle=3600,
                             max_overflow=0)

Change the pool_size to 5, and pool_recycle to 1. Then restart iRedAPD service. Let's see whether it works for you.

3 Reply by fisher006

  • fisher006
  • Member
  • Offline
  • Registered: 2016-08-01
  • Posts: 46

Re: Many errors MySQL server has gone away

Hi, it works perfect!
Thank You