MySQL server has gone away 1 2 3 4 5 6 7 36 37 38
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6214
Printed Date: 16 July 2025 at 11:27am
Topic: MySQL server has gone away 1 2 3 4 5 6 7 36 37 38
Posted By: Stupid
Subject: MySQL server has gone away 1 2 3 4 5 6 7 36 37 38
Date Posted: 23 August 2007 at 12:27pm
|
What is this? After a while of this msg, it works again without me touching anything 08/23/07 09:14:52:884 -- (4812) 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 ( 83 84 85 86 86a 86b 86c 87 88 89 90 91) 08/23/07 09:14:54:321 -- (6836) Connection from: 63.95.36.36 - Originating country : United States 08/23/07 09:14:54:665 -- (6836) Resolving 63.95.36.36 - pvhkmail1.householdaccount.com 08/23/07 09:14:55:165 -- (6836) found SPF record for ebusiness.partnercardservices.com: v=spf1 a mx ip4:63.111.163.35 ip4:63.111.163.36 ip4:63.111.163.37 ip4:63.95.36.35 ip4:63.95.36.36 ip4:63.95.36.37 -all 08/23/07 09:14:55:165 -- (6836) SPF query result: pass 08/23/07 09:14:55:165 -- (6836) Mail from: alerts.951170025.726946.0@ebusiness.partnercardservices.com 08/23/07 09:14:55:165 -- (6836) - SPF analysis for ebusiness.partnercardservices.com done: - pass 08/23/07 09:14:55:587 -- (5248) Exception occurred during TDeliverQuarantineThread.Execute: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]MySQL server has gone away 1 2 3 4 5 6 7 36 37 38 08/23/07 09:15:00:587 -- (984) Exception occurred during TDeliverQuarantineThread.Execute: [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]MySQL server has gone away 1 2 3 4 5 6 7 36 37 38 08/23/07 09:15:00:696 -- (6836) DNS Error:TimedOut |
Replies:
Posted By: LogSat
Date Posted: 23 August 2007 at 7:32pm
That's an example of SpamFilter doing it job  . If your database server becomes unavailable (as it appears to be the case from these logs), SpamFilter will continue to receive emails correctly and forward clean emails to your server. It will ignore any emails that are spam as it is not able to store them to the database. However SpamFilter will continuously check your DB, and will resume the archiving operations automatically as soon as it's back online.
------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: Stupid
Date Posted: 24 August 2007 at 9:21am
| But my MySQL didn't go away. During that period, I can still access it. |
Posted By: LogSat
Date Posted: 24 August 2007 at 7:49pm
|
I can't answer answer as to what exactly happened. The error " [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]MySQL server has gone away" is what MySQL, or rather the MySQL driver, sends in responses to connection attemps and/or queries made. It could be for example that rejections specifically by SpamFilter are refused, or that connections can be made, but queries can't be performed. You'll need to check your MySQL logs to see exactly why the errors are being sent. ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: Rifleman
Date Posted: 28 August 2007 at 2:33pm
| I noticed that this happens when a table in MySQL is corrupted. I would check and do some repairs on the DB. |