MySQL Bugs: #38796: MySqlConnection.open() hangs if disconnect connection

Bug #38796	MySqlConnection.open() hangs if disconnect connection
Submitted:	14 Aug 2008 12:31	Modified:	10 Jun 2009 9:42
Reporter:	Glen Boonzaier	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	5.2.2.0	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	MySqlConnection open hangs disconnect connection

Description:
The MySqlConnection hangs if the disconnection occurs while the Open method is executing.

My connection timeout is on default which outputs 15
However, this function does not seem to timeout and just endlessly sits on the open method.

    Private Function initConnection() As Boolean
        Dim pingResult As Boolean = False
        If _conn.State = ConnectionState.Open Then
            Try
                Console.WriteLine("Pinging MySQL Connection")
                _conn.Ping()
                pingResult = True
            Catch ex As Exception
                pingResult = False
            End Try
        End If

        If _conn.State <> ConnectionState.Open Or Not pingResult Then
            Try
                Console.WriteLine("Opening MySQL Connection")
                Console.WriteLine("Connection Timeout: " & _conn.ConnectionTimeout)
                _conn.Open()

            Catch ex As Exception
                Dim choice As DialogResult = MessageBox.Show("Error connecting to database!" & vbCrLf & ex.Message, "Connection Error!", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error)
                If choice = DialogResult.Cancel Then
                    _conn.Dispose()
                    Application.Exit()
                    End
                Else
                    delay(0.1)
                    initConnection()
                End If
            End Try
        End If
        Return True
    End Function

How to repeat:
As the .open method is called.

Disconnect your internet by either, unplugging your network cable, shutting down your modem, etc...

Suggested fix:
There doesn't seem to be a work around for this error.  I assume that somewhere in the MySqlConnection.open method, there needs to be repeated check if the connection is available?

The same problem seems to exist if I disconnect during the ping method.
The timeout is ignored and it just hangs there endlessly.

I reconnected my modem after about 30 seconds and it then continued without a problem.

Hi Glen and thanks for your report.

I'm having troubles following it so I made simplified test based on your last post:

    MySqlConnection m_myConnection = new MySqlConnection();
    m_myConnection.ConnectionString = "server=localhost; database=test; User id=root; port=****; password=*****";
    m_myConnection.Open();
    System.Threading.Thread.Sleep(6000);

    // Open succeed, put BP here and shutdown the mysql server (or do it while Sleep loops)
    // then execute the following code
    bool bRes = m_myConnection.Ping(); // bRes is false
    System.Data.ConnectionState state = m_myConnection.State; // state is Closed!

Now, where am I supposed to put BP to get exact case as you did? Which line in the code of driver (or test)? You can not seriously expect me to click "connect" and run to disconnect network...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Lower Connection timeout

Attachment: patch-38796.patch (application/octet-stream, text), 624 bytes.

Hi Tonci,

Sorry for this late reply, I'm sure you know how hectic things get.  Basically what happened is, I told my client that there is a constant monitor before any query is done to check the database connection is still available.

In a test, he disconnected his network cable as it executed the connection.Open() command and the program froze.  The mysql server, sits at an overseas hosting so naturally it takes about 5 or 6 seconds to execute the Open() command.  If you disconnect during that time, the driver just never responds and the program comes to a halt there.

I can understand that testing on a local mysql database would be really difficult as the Open() command will execute quickly and you will have a very short window to disconnect.  When I said disconnect, I do mean disconnecting the machine that is running the application with the driver on it, not the mysql server.  You can perhaps just try and unplug your network cable at that point.

Potential Work Around:
Run a thread to connect to the database, while the thread is executing, monitor it and set your own timeout mechanism.

ps.
Not quiet sure what you mean by BP, but I am assuming it stands for bypass?

BreakPoint :-) Lat me look at this again tomorrow.

Tomorrow prolonged... I still don't have such bad connection to MySQL server anywhere to check on this.

This is actually a duplicate of verified report, Bug#29756.