Additional
AnyDAC
SimpleIAX
Forums
Welcome, Guest
Please Login or Register to post messages. Lost Password?
MySQL server has gone
(1 viewing) 1 Guest
Go to bottom
TOPIC: MySQL server has gone
#19984
aspahn2011
Fresh Boarder
Posts: 9
graphgraph
Karma: 0
User Offline Click here to see the profile of this user
MySQL server has gone 2012/01/23 08:51 (3 Months, 4 Weeks ago)
Hi,

i have sometimes the anydac error "MySQL server has gone away". But the server still runs; it does not stop !!!
Why does anydac report this error ? and how can i handle it ?

Best regards
Logged Logged
The administrator has disabled public write access.
#19986
Support
Moderator
Posts: 4708
graph
Karma: 68
User Offline Click here to see the profile of this user
Re:MySQL server has gone 2012/01/23 09:08 (3 Months, 4 Weeks ago)
Hello

1) The most common reason for the "MySQL server has gone away" error is that the server timed out and closed the connection:
dev.mysql.com/doc/refman/5.0/en/gone-away.html

2) In general, you can call TADConnection.Ping method by a timer. Or set ResourceOptions.AutoReconnect to True.
With best regards,
DA-SOFT Technologies Support Team
Logged Logged
The administrator has disabled public write access.
#20047
PaulBr
Junior Boarder
Posts: 24
graphgraph
Karma: 0
User Offline Click here to see the profile of this user
Re:MySQL server has gone 2012/01/27 04:29 (3 Months, 3 Weeks ago)
Hello,

you get the message even, if the parameter "max_allow_packet" is too small.
Logged Logged
The administrator has disabled public write access.
Go to top