[Maia-users] TROUBLE in process_request: DBD::mysql::st execute failed

[Robert LeBlanc]

Travis Mikalson wrote:
> I'm getting a lot of this same error from amavisd-maia:
> 
> Feb 23 01:22:26 <local2.warn> ea2 amavis[35667]: (35667-02) lookup_sql:
> 2006, MySQL server has gone away
> Feb 23 01:22:26 <local2.warn> ea2 amavis[35667]: (35667-02) NOTICE:
> Disconnected from SQL server
> Feb 23 01:22:26 <local2.err> ea2 amavis[35667]: (35667-02) TROUBLE in
> process_request: DBD::mysql::st execute failed: MySQL server has gone
> away at (eval 53) line 256, <GEN12> line 5.

The "MySQL server has gone away" error usually means that there haven't
been any database queries for a long time, and the database connection
has timed out.  MySQL's default timeout is 8 hours, so on production
servers this virtually never occurs (8 hours without receiving a single
mail item would be very unusual in a "real-world" scenario).  On the
other hand, in testing scenarios where there's no regular flow of mail
traffic, these kinds of timeouts can certainly occur.

Usually these errors are self-correcting, since the fatal error causes
the mail to remain queued at your upstream mail server, and when it
tries to submit it again to amavisd-maia, a new database connection is
established, and the mail gets processed successfully the second time.

If you feel that a longer timeout value would solve your problem, you
can increase the timeout setting in your /etc/my.cnf file, of course,
but usually this is unnecessary, especially on a production server which
will be expected to receive a steady stream of mail traffic.

-- 
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://www.renaissoft.com/pipermail/maia-users/attachments/20060223/67e24fca/signature.bin