Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - MySQL server has gone away 1 2 3 4 5 6 7 36 37 38
  FAQ FAQ  Forum Search   Register Register  Login Login

MySQL server has gone away 1 2 3 4 5 6 7 36 37 38

 Post Reply Post Reply
Author
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Topic: MySQL server has gone away 1 2 3 4 5 6 7 36 37 38
    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

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2007 at 7:32pm
That's an example of SpamFilter doing it job Smile. 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

LogSat Software

Spam Filter ISP
Back to Top
Stupid View Drop Down
Senior Member
Senior Member


Joined: 28 November 2005
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stupid Quote  Post ReplyReply Direct Link To This Post Posted: 24 August 2007 at 9:21am
But my MySQL didn't go away. During that period, I can still access it. 
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.