Bug #29409 Bug on Open Connection with pooling=true to a MYSQL Server that is shutdown

Description:
Hi 

   I am using VB.NET 2005 and MySQL Connector Net 5.0.7. I get a time out problem to connect to a mysql server which is down for optimize. 

I get the time out error after try for 6 times(Max Pool Size=6). Then i start up Mysql server, becuase the maxium pool size is reached,I still get the time out error even the mysql server is up. i will need to shutdown my application and restart it again.

Here is my code in VB.net to generate the error

How to repeat:

Dim ConString As String = "server=localhost;uid=uuuu;pwd=pppp;database=ddddd;port=3306;pooling=true;Max Pool Size=6;connect timeout=3" 

Dim DBcon As MySql.Data.MySqlClient.MySqlConnection

Dim Errcount As Integer = 0

Do

Try

DBcon = New MySql.Data.MySqlClient.MySqlConnection(ConString)

DBcon.Open()

DBcon.Close()

Catch ex As Exception

Errcount += 1

Debug.WriteLine(Now & " : " & Errcount & " - " & DBcon.State.ToString & " - " & ex.Message)

DBcon.Close()

End Try

Loop

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31445

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31448

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31449

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31452

Fixed in 1.0.10, 5.0.8, and 5.1.3

A note has been added to the 1.0.10, 5.0.8 and 5.1.3 changelogs: 

The availability of a MySQL server would not be reset when using pooled connections (pooling=true). This would lead to the server being reported as unavailable, even if the server become available while the application was still running.