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
• Status: Closed
• Category: Connector / NET
• Severity: S3 (Non-critical)
• Version: 5.1.3
• OS: Windows (used with VS 2005 Team Edition (SP1))
• 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.