Hi

We have been experiencing problems with the database connection to mysql after keywords are detected in messages. I first noticed the problem after doubling the default keyword filter size limit. Putting the limit size back made a big difference to the frequency however we are still getting the error.

It also occurs when a banned attachment is blocked. I suspect it is something to do with the size of the attachment that is being written to the quarantine DB. The following is a sample of the errors received from our log:
=============================
11/08/06 08:50:50:582 -- (9760) Found Keywords: [Found prohibited attachment: Judgement1.wmv]
11/08/06 08:50:50:582 -- (9760) EMail from user@address.co.nz to other@other.co.nz, other1@other.co.nz matches content filter rules - rejected.
11/08/06 08:50:50:941 -- (9760) Created thread (944) to add email to quarantine
11/08/06 08:50:51:347 -- (9760) Blacklist cache - Added 210.54.141.243 to limbo
11/08/06 08:50:51:988 -- (9760) SFDB - Added 210.54.141.243 - Response: Error=0
11/08/06 08:50:51:988 -- (9760) Disconnect
11/08/06 08:50:52:316 -- (944) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Lost connection to MySQL server during query ( 83 84 85 86 86a 86b 86c 87 88 89 90 91)

=================================
11/10/06 08:50:51:238 -- (2328) Connection from: 207.46.50.72  -  Originating country : United States
11/10/06 08:50:52:613 -- (2328) Resolving 207.46.50.72 - mail-sin1.microsoft.com
11/10/06 08:50:53:457 -- (2328) found SPF record for microsoft.com: v=spf1 mx include:_spf-a.microsoft.com include:_spf-b.microsoft.com include:_spf-c.microsoft.com ~all
11/10/06 08:50:54:019 -- (2328) found SPF record for _spf-a.microsoft.com: v=spf1 ip4:213.199.128.139 ip4:213.199.128.145 ip4:207.46.50.72 ip4:207.46.50.82 a:delivery.pens.microsoft.com a:mh.microsoft.m0.net mx:microsoft.com ~all
11/10/06 08:50:54:019 -- (2328) SPF query result: pass
11/10/06 08:50:54:019 -- (2328) - SPF analysis for _spf-a.microsoft.com done: - pass
11/10/06 08:50:54:019 -- (2328) SPF query result: pass
11/10/06 08:50:54:019 -- (2328) - SPF analysis for microsoft.com done: - pass
11/10/06 08:50:54:019 -- (2328) RCPT TO: user@address.co.nz accepted
11/10/06 08:51:02:988 -- (2328) Found Keywords: [((?i)(\boem\b))]
11/10/06 08:51:02:988 -- (2328) EMail from user@address.co.nz to other@other.co.nz matches content filter rules - rejected.
11/10/06 08:51:03:035 -- (2328) Created thread (9752) to add email to quarantine
11/10/06 08:51:03:316 -- (9752) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Lost connection to MySQL server during query ( 83 84 85 86 86a 86b 86c 87 88 89 90 91)
============================
Has anyone come across this problem or have any ideas for a resolution? At the moment restarting SF seems to be the only way to reconnect to the quarantine. Unfortunately if the error is not seen to occur a lot of email doesn't make it to the quarantine.

Regards
David Fox

Roberto

Thanks very much for the info. I have modified the settings and will see how it goes.

Regards
David