Bug #41417 MySQL Proxy hangs if Server is stopped
Submitted: 12 Dec 2008 6:53 Modified: 16 Dec 2008 11:45
Reporter: mahesh patil
Status: Verified
Category:Proxy Severity:S1 (Critical)
Version:0.6.1 OS:Microsoft Windows (Vista,XP, 2008 Web server)
Assigned to: Kay Roepke Target Version:
Triage: Needs Triage: D2 (Serious)

[12 Dec 2008 6: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 6:54] mahesh patil 
I will mark it as Critical
[12 Dec 2008 7: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 10: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 10:29] mahesh patil 
Reproducible in XP and Vista.
[16 Dec 2008 11:45] Sveta Smirnova 
Thank you for the feedback.

Verified as described.
[11 Jun 17:17] Kay Roepke 
Waiting for Windows build to verify/fix.