[Mimedefang] MySQL Greylisting issue - server gone away

Paul Murphy pmurphy at ionixpharma.com
Thu Aug 26 04:57:26 EDT 2004


Hi,

I changed to use the MySQL version of greylisting from
http://www.bl.org/~jpk/md-greylist/ after issues with Berkeley DB surfaced while
using Jonas' original code.  It has been working well for several weeks, but I
now get problems with slaves dying occasionally with the mail log showing:

Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Slave 2 died prematurely
-- check your filter rul
es
Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Slave 2 stderr:
DBD::mysql::st execute failed: My
SQL server has gone away at /etc/mail/greylist-msql/mimedefang-filter-greylist
line 246. DBD::mysql::st
 execute failed: MySQL server has gone away at
/etc/mail/greylist-msql/mimedefang-filter-greylist line
246.
Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Reap: Idle slave 2 (pid
10176) exited normally wi
th status 32 (SLAVE DIED UNEXPECTEDLY)
Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Slave 2 resource usage:
req=8, scans=2, user=3.12
0, sys=0.150, nswap=0, majflt=224, minflt=10457, maxrss=0, bi=0, bo=0
Aug 26 09:45:49 adelie mimedefang[26637]: Error from multiplexor: ERR No
response from slave

Line 246 of the mimedefang-filter-greylist file is in the greylist_check
routine, and is the execute call to search the database:

$select_sth->execute($ip, $sender, $recipient); 

As this works normally, and the other slaves are still OK (MySQL is still
running), I'm wondering whether there's something strange happening with the
Perl session.  I'm using MD 2.43, embedded Perl 5.8.3, and MySQL 12.22/4.0.18 on
Debian Linux.

Any ideas what might be causing this?

Best Wishes,

Paul.
__________________________________________________
Paul Murphy
Head of Informatics
Ionix Pharmaceuticals Ltd
418 Science Park, Cambridge, CB4 0PA

Tel. 01223 433741
Fax. 01223 433788

_______________________________________________________________________
DISCLAIMER:
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to which they
are addressed.  If you have received this email in error please contact
the sender or the Ionix IT Helpdesk on +44 (0) 1223 433741
_______________________________________________________________________ 



More information about the MIMEDefang mailing list