Error occurred during TAddToQuarantineThread when |
Post Reply |
Author | |
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
Posted: 04 December 2007 at 9:51am |
Any idea why I am constantly getting this Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
*************** 12/03/07 23:59:46:249 -- (29376) Running TTerminateIdleThreads - SFTC=1 - SFFC=1 12/03/07 23:59:46:249 -- (30068) Blacklist cache - starting cleanup 12/03/07 23:59:46:249 -- (29376) Running TTerminateIdleThreads SSL - SFTC=0 - SFFC=1 12/03/07 23:59:46:249 -- (30076) Starting to process quarantine directory... 12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 222.124.65.204 from limbo during cleanup 12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 67.163.241.33 from cache during cleanup 12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 189.138.161.167 from cache during cleanup 12/03/07 23:59:46:249 -- (30068) Blacklist cache - removed IP 222.232.234.47 from limbo during cleanup 12/03/07 23:59:46:249 -- (30120) Adding to Quarantine file:Qrt30F4.tmp.queued 12/03/07 23:59:46:265 -- (26796) Adding to Quarantine file:Qrt41EF.tmp.queued 12/03/07 23:59:46:327 -- (30616) SpamFilterForm - Begin loading corpus.db 12/03/07 23:59:46:358 -- (29576) Adding to Quarantine file:Qrt4390.tmp.queued 12/03/07 23:59:46:483 -- (27260) Adding to Quarantine file:Qrt48D4.tmp.queued 12/03/07 23:59:46:515 -- (30120) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:46:546 -- (29820) Adding to Quarantine file:Qrt61D4.tmp.queued 12/03/07 23:59:46:593 -- (29996) Adding to Quarantine file:Qrt5405.tmp.queued 12/03/07 23:59:46:640 -- (20852) Adding to Quarantine file:QrtC21B.tmp.queued 12/03/07 23:59:46:671 -- (34420) Adding to Quarantine file:Qrt50E8.tmp.queued 12/03/07 23:59:46:671 -- (32532) Adding to Quarantine file:Qrt7B3C.tmp.queued 12/03/07 23:59:46:671 -- (26796) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:46:765 -- (28724) Adding to Quarantine file:QrtA31A.tmp.queued 12/03/07 23:59:46:796 -- (29664) Adding to Quarantine file:QrtE2CB.tmp.queued 12/03/07 23:59:46:952 -- (24784) Adding to Quarantine file:QrtDEEB.tmp.queued 12/03/07 23:59:46:952 -- (29820) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:46:983 -- (31848) Adding to Quarantine file:QrtFDE0.tmp.queued 12/03/07 23:59:47:062 -- (27260) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:47:077 -- (30616) TSpamFilterForm - Begin LoadFromFile for corpus.db (db.dat) 12/03/07 23:59:47:155 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - copied db.dat -> IndF3F8.tmp 12/03/07 23:59:47:202 -- (32532) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:47:280 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - copied db.dat.prb -> IndF3F9.tmp 12/03/07 23:59:47:452 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - Reading Buffer in mem 12/03/07 23:59:47:593 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - loaded files in memory - IndF3F8.tmp 12/03/07 23:59:47:702 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - setting Buffer size to 11410077 12/03/07 23:59:47:718 -- (29664) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:47:983 -- (29996) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:47:983 -- (28724) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:54:155 -- (20852) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:54:155 -- (34420) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:54:155 -- (29576) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:54:155 -- (31848) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:54:155 -- (29788) Reloading file for tblBL_HoneypotBlockedIPs: HoneypotBlockedIPs.txt (919790 bytes) 12/03/07 23:59:54:155 -- (24784) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/03/07 23:59:54:155 -- (30616) TSpamFilterForm - LoadFromFile for Corpus.db - loaded files in memory - IndF3F9.tmp 12/03/07 23:59:54:155 -- (30616) TSpamFilterForm - End LoadFromFile for corpus.db (db.dat) (6874) 12/03/07 23:59:54:155 -- (30616) SpamFilterForm - End loading corpus.db 12/03/07 23:59:54:921 -- (27124) Received RCPT TO: 3djavier.maza@mycompany.com 12/03/07 23:59:55:015 -- (27124) Resolving 189.164.74.150 - dsl-189-164-74-150.prod-infinitum.com.mx 12/03/07 23:59:55:015 -- (27124) - EMail To is in honeypot emails - 12/03/07 23:59:55:749 -- (27124) - Added 189.164.74.150 to honeypot blacklist 12/03/07 23:59:55:749 -- (27124) 189.164.74.150 - Mail from: sukumar@der.com To: 3djavier.maza@mycompany.com will be rejected 12/03/07 23:59:59:452 -- (27124) Starting quarantine procedures 12/03/07 23:59:59:452 -- (27124) Created thread (23368) to add email to quarantine 12/03/07 23:59:59:452 -- (27124) Starting bayesian procedures 12/03/07 23:59:59:452 -- (23368) Adding to Quarantine file:QrtF3FB.tmp 12/03/07 23:59:59:499 -- (23368) EMail from sukumar@der.com to 3djavier.maza@mycompany.com was received and quarantined. Size: 2 KB, 2048 bytes 12/03/07 23:59:59:499 -- (23904) Time to add Msg to Bayes corpus:0 12/04/07 00:00:02:249 -- (29236) Connection from: 189.181.229.87 - Originating country : Mexico 12/04/07 00:00:02:608 -- (29236) Received MAIL FROM: <promociones@expopublicitas.com> 12/04/07 00:00:02:671 -- (29236) Received RCPT TO: javier.maza@mycompany.com 12/04/07 00:00:02:749 -- (29236) Resolving 189.181.229.87 - dsl-189-181-229-87.prod-infinitum.com.mx 12/04/07 00:00:02:890 -- (27072) Connection from: 88.204.209.218 - Originating country : Kazakstan |
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
This posting should have the answer to the problem:
http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5868 |
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
Where do I set this value in MySQL? Couldn't find it in Google.
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
If you're using the "MySQL Administrator" tools, there should be an option for the "Max Packet Size" in the graphical user interface, often under the "Advanced Networking" options.
You can also find (or set) the value by manually editing the "my.cnf" configuration file for MySQL, and setting the value in the [mysqld] section with something like: [mysqld] #Max packetlength to send/receive from to server. max_allowed_packet=16M |
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
don't have my.cnf file.
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
The specific locations (and sometimes the names) of the config files vary depending on the platform (Windows, Mac OS X, Linux, etc) where MySQL is installed on. I'd recommend using the MySQL Administration tool (which is available for all those platforms) to tweak the MySQL configuration, so that you may "graphically" change that setting.
|
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
Found it, thanks, Roberto.
MySQL Admin for Windows, Advanced Networking, Max. packet size. Edited by Stupid - 10 December 2007 at 4:59pm |
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
I am still having big problems with this after I increased the max packet size to 16MB.
12/12/07 14:34:49:236 -- (35716) Starting to process quarantine directory... 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 74.127.6.175 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 201.233.45.56 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 81.203.73.144 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 77.180.25.113 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 84.58.206.218 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 78.54.212.192 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 79.184.37.204 from limbo during cleanup 12/12/07 14:34:49:251 -- (40636) Blacklist cache - removed IP 96.227.73.18 from limbo during cleanup 12/12/07 14:34:49:251 -- (42444) Adding to Quarantine file:Qrt1711.tmp.queued 12/12/07 14:34:49:267 -- (45324) Adding to Quarantine file:Qrt1A18.tmp.queued 12/12/07 14:34:49:345 -- (44692) Received MAIL FROM: <montgomery@viquel.com> 12/12/07 14:34:49:392 -- (10700) Adding to Quarantine file:Qrt30F4.tmp.queued 12/12/07 14:34:49:439 -- (44308) Adding to Quarantine file:Qrt41EF.tmp.queued 12/12/07 14:34:49:439 -- (38684) Adding to Quarantine file:Qrt3CEA.tmp.queued 12/12/07 14:34:49:470 -- (26904) Adding to Quarantine file:Qrt4390.tmp.queued 12/12/07 14:34:49:548 -- (46848) Adding to Quarantine file:Qrt50E8.tmp.queued 12/12/07 14:34:49:626 -- (44692) Received RCPT TO: customer.servicen@mycompany.com 12/12/07 14:34:49:626 -- (42444) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:49:626 -- (5588) Adding to Quarantine file:Qrt7B3C.tmp.queued 12/12/07 14:34:49:783 -- (12076) Adding to Quarantine file:Qrt48D4.tmp.queued 12/12/07 14:34:49:783 -- (8160) Adding to Quarantine file:Qrt61D4.tmp.queued 12/12/07 14:34:49:798 -- (44308) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:49:783 -- (38248) Adding to Quarantine file:Qrt9355.tmp.queued 12/12/07 14:34:49:798 -- (5588) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:49:829 -- (9680) Adding to Quarantine file:Qrt5405.tmp.queued 12/12/07 14:34:50:033 -- (10700) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:142 -- (38248) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:236 -- (8160) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:267 -- (12744) Adding to Quarantine file:QrtA31A.tmp.queued 12/12/07 14:34:50:283 -- (38684) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:283 -- (1988) Adding to Quarantine file:Qrt9B89.tmp.queued 12/12/07 14:34:50:283 -- (9680) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:564 -- (12076) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:751 -- (17372) Adding to Quarantine file:QrtC21B.tmp.queued 12/12/07 14:34:50:845 -- (12744) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:50:939 -- (17776) Adding to Quarantine file:QrtDEEB.tmp.queued 12/12/07 14:34:51:033 -- (2392) Sync Corpus.db pass 0a 12/12/07 14:34:51:033 -- (2392) Sync Corpus.db - 629439 - 349 12/12/07 14:34:51:017 -- (2392) Begin Sync Corpus.db 12/12/07 14:34:51:064 -- (2392) Sync Corpus.db pass 0c 12/12/07 14:34:51:267 -- (26904) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:298 -- (1988) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:298 -- (46848) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:345 -- (2392) Sync Corpus.db pass 0b 12/12/07 14:34:51:345 -- (6388) Adding to Quarantine file:QrtE2CB.tmp.queued 12/12/07 14:34:51:345 -- (45324) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:345 -- (45932) Adding to Quarantine file:QrtFDE0.tmp.queued 12/12/07 14:34:51:408 -- (29788) Adding to Quarantine file:QrtE17A.tmp.queued 12/12/07 14:34:51:486 -- (17372) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:829 -- (6388) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:939 -- (29788) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:51:970 -- (17776) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Got a packet bigger than 'max_allowed_packet' bytes ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) 12/12/07 14:34:52:345 -- (33308) Reloading file for tblBL_HoneypotBlockedIPs: HoneypotBlockedIPs.txt (1183011 bytes) 12/12/07 14:34:52:595 -- (45932) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Lost connection to MySQL server during query ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91) |
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
The same error "Got a packet bigger than 'max_allowed_packet'" is being logged, which probably indicates the received emails are still too large for MySQL. Can you please zip and email us the section of SpamFilter's activity logfile for 12/12/07, for the entries between 14:00 and 15:00?
|
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
log sent
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Yeap, we got them, and we replied via email that same evening on 12/13/07 :-) I'm going to re-send you the partial response via PM.
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Well... We received all the tmp files, and while yes, they are all below 16MB in size, they are also all over 1MB. This could indicate that the setting you changed in MySQL did not take effect. Have you restarted MySQL after making the change? Could you verify that the MySQL Administration tools have actually made the change in the .ini file in MySQL? Unfortunately I'll have to refer you to MySQL's documentation to locate the proper file, as each installation can be different, and both the filename and the directory in which it's located can be changed depending on how MySQL has been installed.
|
|
Stupid
Senior Member Joined: 28 November 2005 Status: Offline Points: 127 |
Post Options
Thanks(0)
|
I restarted and will see how it works from now on. I think you are right on the restarting thing!
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.387 seconds.