Bug #32092 It seemes that MySqlConnection.open() ignores "Connect timeout" setting
Submitted: 4 Nov 2007 21:58 Modified: 13 Nov 2007 20:05
Reporter: Alexander Maglyovany Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.1.3 OS:Windows (used with VS 2005 Team Edition (SP1))
Assigned to: CPU Architecture:Any
Tags: connection timeout

[4 Nov 2007 21:58] Alexander Maglyovany
Description:
When remote MySQL server is blackholed - Open() hangs.
"Connect timeout" key contains 1000 ms but nothing happens at all.
It seems like "Connect timeout" is ignored by MySqlConnection object.

Code snippet:

***********
Dim mcsbBuilder As MySql.Data.MySqlClient.MySqlConnectionStringBuilder = New MySql.Data.MySqlClient.MySqlConnectionStringBuilder
                mcsbBuilder.CharacterSet = "utf8"
                mcsbBuilder.ConnectionTimeout = 1000
                mcsbBuilder.Database = Server_database
                mcsbBuilder.Password = server_password
                mcsbBuilder.Server = Server_host
                mcsbBuilder.UserID = server_username
                mcsbBuilder.Port = UInteger.Parse(Server_port)
ConnectionString mcsbBuilder.ToString

Dim mc As MySql.Data.MySqlClient.MySqlConnection = New MySql.Data.MySqlClient.MySqlConnection(ConnectionString)
Try
            mc.Open()
Catch ex As Exception
End Try
**************

P.S. I tried to use different values for "Connect timeout"  - the result is the same.

How to repeat:
Destination server must be blackholed on MySQL servers port.
[13 Nov 2007 18:32] Alexander Maglyovany
Fake alarm, method works correctly. It was my mistake.
Close this bug, please.
Sorry.
[13 Nov 2007 20:05] Tonci Grgin
Alexander, thanks for your report and your interest in MySQL. The main thing is that the problem is gone.