lost connection to mysqlserver during query socket error on read .WSAGETLASTERROR return 10054 ($2746)

While I am creating constraint on mysql 5 from delphi 2006, it gives me the following error
"lost connection to mysqlserver during query socket error on read .WSAGETLASTERROR return 10054($2746)."
After that the mysql cannot connect to it unless I restart the mysql server on windows xp.  Any suggestion
nabil_zakkakAsked:
Who is Participating?
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
Cool...

Thanks,
Umesh
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Pls amke sure MySQ: server parameters are properly set (increase)

connect_timeout
interactive_timeout
net_read_timeout
net_write_timeout
slave_net_timeout
wait_timeout
max_connections
max_user_connections

MySQL docs..

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

and

http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Pls ignore this variable... 'slave_net_timeout'
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
nabil_zakkakAuthor Commented:
I did what u told me.  But this didn't solve the problem
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Where did you set these parameters?
 in my.cnf(my.ini if windows) or from mysql prompt?

mysql>SET GLOBAL connect_timeout = 20;
0
 
nabil_zakkakAuthor Commented:
in my.ini because i am using windows
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
yes , that's correct...on windows my.ini

Are you on windows... then I'm sure its not an MySQL fault... may be some windows settings is just causing this.. I'll post you the tread similar to this..at the end user noticed that some windows setting was the problem
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Also, I wan to see the erro log... it would be nice if you can get me the error log during in which you got below error

lost connection to mysqlserver during query socket error on read .WSAGETLASTERROR return 10054 ($2746)

This may help you...

http://dev.mysql.com/doc/mysql-windows-excerpt/6.0/en/can-not-connect-to-server-on-windows.html
0
 
nabil_zakkakAuthor Commented:
The problem is not showing any more.  I don't know why
0
All Courses

From novice to tech pro — start learning today.