topleft
topright
SQLPlex forums
Welcome, Guest
Please Login or Register.    Lost Password?
SQLPlex forums Mentat Technologies IDE's DreamCoder for MySQL
Re:Lost connection to MySQL server during query (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Lost connection to MySQL server during query
#33
mail-question (User)
Junior Boarder
Posts: 29
graph
User Offline Click here to see the profile of this user
Lost connection to MySQL server during query 6 Months ago Karma: 0  
2013 Lost connection to MySQL server during query
Socket error on read. WSAGetLastError return 10054($2746)

MySQL Server 5.0.27-community-nt
MySQL Client 4.1.3 Direct
Charset

License Mentat Technologies
Hardware 8D-A6-DB-9E-5C-4B-10-A6

OS Version WinNT, full 32-bit 5 Build : 2600 Service Pack 2

Question from : Abraham Chacko
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#34
ptesone (Admin)
Admin
Posts: 29
graph
User Offline Click here to see the profile of this user
Re:Lost connection to MySQL server during query 6 Months ago Karma: 0  
The follow error : 2013 Lost connection to MySQL server during query " is returned by MySQL because the server timed out and closed.

Solution : Increase the mysql variables.

connect_timeout
interactive_timeout
net_read_timeout
net_write_timeout
slave_net_timeout
wait_timeout
max_connections
max_user_connections

Also you can check the mysql documentation error :
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

Regards,
Peter
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
get the latest posts directly to your desktop
 
SQLPlex | Copyright © 2008 Mentat Technologies. All Rights Reserved