topleft
topright
SQLPlex forums
Welcome, Guest
Please Login or Register.    Lost Password?
SQLPlex forums Mentat Technologies IDE's DreamCoder for MySQL
Lost connection to MySQL server during query (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: 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