Topic: New everything, same problem with Amavis / SQL timeouts.
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: Debian 8.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue: /var/log/mail.log
====
So here's the story. I was getting errors like the ones below on my old server. I had thought that by tweaking the Amavis settings, that I may have fixed the problem, only to find out that when I went to send a mailing list campaign, the server failed spectacularly, postfix collapsed under the load, and as a result, I had to completely stop the campaign from going out. I built a new server from scratch as a hot-swap machine. Completely different hardware. Upgraded from 2 to 4GB of RAM. I installed everything from scratch. I re-created all of the accounts by hand. I built all new databases, except for my sa_bayes database. I migrated the users' mailboxes by hand. Basically, everything is brand new. And yet, still, I'm getting this error. I believe that it's more than coincidence that this is happening. I created the same setup, with Debian 8.1, iRedMail, Apache, and the exact same software, on a completely different machine. I have no idea what file (eval 95) line 200 even references, but whatever file it is, there's a problem with it. Here's what's happening.
Aug 26 03:44:31 mail postfix/qmgr[15012]: C8BD56218E1: from=<root@mail.x.x>, size=1646, nrcpt=1 (queue active)
Aug 26 03:45:35 mail amavis[15053]: (15053-03) NOTICE: reconnecting in response to: err=2013, HY000, timed out
Aug 26 03:45:35 mail amavis[15053]: (15053-03) (!)lookup_sql: timed out at (eval 95) line 200., ,
Aug 26 03:45:35 mail amavis[15053]: (15053-03) (!)Requesting process rundown, task exceeded allowed time
Aug 26 03:49:31 mail postfix/smtp[21114]: C8BD56218E1: to=<root@mail.x.x>, relay=127.0.0.1[127.0.0.1]:10024, delay=1168, delays=868/0.05/0.01/300, dsn=4.4.2, status=deferred (conversation with 127.0.0.1[127.0.0.1] timed out while sending MAIL FROM)
Aug 26 04:00:02 mail amavis[15055]: (15055-03) NOTICE: reconnecting in response to: err=2013, HY000, timed out
Aug 26 04:00:02 mail amavis[15055]: (15055-03) (!)lookup_sql: timed out at (eval 95) line 200., ,
Aug 26 04:00:02 mail amavis[15055]: (15055-03) (!)Requesting process rundown, task exceeded allowed time
I've gotta get this issue fixed. I could definitely use the help, here, because I'm at a total loss. Thanks everyone!
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.