On Fri, Jul 31, 2009 at 4:26 AM, Sahil Tandon<sa...@tandon.net> wrote: > I've seen discussion of this before with respect to mysql's wait_timeout > variable, but my question is a little different. > > If I restart amavisd-new and mysql, mail flows fine. This is a test machine > so if I try to send another test message the next day (i.e. this morning), I > start seeing this again: > > Jul 31 07:13:43 polymath amavis[30861]: (30861-03) NOTICE: reconnecting in > response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has > gone away at (eval 102) line 166, <GEN21> line 307. > > I understand why this might happen after a very long time as a new connection > to the mysql server needs to be re-established, but the problem is that the > above line re-appears for *every* new test message thereafter, which is what > puzzles me. i.e.: > > Jul 31 07:14:30 polymath amavis[30862]: (30862-02) NOTICE: reconnecting in > response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has > gone away at (eval 102) line 166, <GEN21> line 726. > > Does this occur because different amavisd processes are handling the > consecutively new messages and each establish their own connection to the > mysql server? I haven't debugged that aspect too closely but just wondering > if anyone else has experienced this. If not then I will have to debug on the > mysql server. Thanks.
Yup, each process makes it's own mysql connection. So however many processes you have setup to run in amavisd should be the number of this error you see. If you have 10 processes, and send more than 10 emails through the system, and see that error more than 10 times, there might be a prob. Otherwise, I imagine it's just those idle connections timing out on the mysql end and you have nothing to worry about as it's all working as expected. - N ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
