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

Bug #29409	Bug on Open Connection with pooling=true to a MYSQL Server that is shutdown
Submitted:	28 Jun 2007 4:28	Modified:	7 Aug 2007 7:22
Reporter:	Jack Chan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	MySQL Connector Net 5.0.7	OS:	Windows (XP with Visual Studio 2005)
Assigned to:		CPU Architecture:	Any

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.