Bug #41417 MySQL Proxy hangs if Server is stopped
Submitted: 12 Dec 2008 5:53 Modified: 16 Dec 2008 10:45
Reporter: mahesh patil Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Proxy Severity:S1 (Critical)
Version:0.6.1 OS:Microsoft Windows (Vista,XP, 2008 Web server)
Assigned to: Assigned Account CPU Architecture:Any
Triage: Needs Triage: D2 (Serious)

[12 Dec 2008 5:53] mahesh patil
Description:
MySQL- proxy does not return any error if server is stopped ( server for which proxy is configured)

How to repeat:
1. Set up a Proxy like this,

C:\mysql_proxy\proxy>mysql-proxy.exe --proxy-address=localhost:4042 --proxy-back
end-addresses=localhost:3305

Now, Using MySQL Command line utility connect,

2. C:\MySQL\bin>mysql -hlocalhost -uroot -proot -P4042

Connects Successfully.

3. Now Stop the MySQL server 

4. Try the (2) step again, 

It will not return any error and continues to wait for response.

Suggested fix:
I think here , 
Error 2003 is required.

And wait time-out should not be more than 2 minutes.
[12 Dec 2008 5:54] mahesh patil
I will mark it as Critical
[12 Dec 2008 6:47] Sveta Smirnova
Thank you for the report.

Please clarify what you do to repeat the problem:

> 2. C:\MySQL\bin>mysql -hlocalhost -uroot -proot -P4042
> Connects Successfully.
...
> 4. Try the (2) step again, 
> It will not return any error and continues to wait for response.

Do you disconnect client connected in step 2 before reconnect and start new connection?
[12 Dec 2008 9:16] mahesh patil
Do you disconnect client connected in step 2 before reconnect and start new connection?

-- Yes i disconnected a client and then started a new connection after Stopping the MySQL server.

FYI: It can be reproducible if server is stopped and you are connecting using proxy to it.
[12 Dec 2008 9:29] mahesh patil
Reproducible in XP and Vista.
[16 Dec 2008 10:45] Sveta Smirnova
Thank you for the feedback.

Verified as described.
[11 Jun 2009 15:17] Kay Roepke
Waiting for Windows build to verify/fix.
[16 Apr 2010 9:29] Enterprise Tools JIRA Robot
Michael Schuster writes: 
please re-test once PR-255 is pushed.
[19 Jun 2012 13:35] Mahesh Patil
What is status here it has been fixed or not in latest MySQL library?
[20 Jun 2012 7:43] Mahesh Patil
It seems like not been fixed in latest v0.8.1 as well
[20 Jun 2012 8:12] Jan Kneschke
A fix is comitted to 0.8.3 which is about to be released.