This project has moved and is read-only. For the latest updates, please go here.

Timeout expired

Feb 5, 2014 at 12:57 PM
I am trying to run MySQL Tuner on a server, and it is giving me a 'Timeout expired', as per below:

MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
--- End of inner exception stack trace ---
at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySqlTuner.MySqlServer.Load() in c:\Users\Peter\Documents\Visual Studio 2012\Projects\MySQLTuner\MySQLTuner\MySqlServer.cs:line 459
at MySqlTuner.FormMain.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) in c:\Users\Peter\Documents\Visual Studio 2012\Projects\MySQLTuner\MySQLTuner\FormMain.cs:line 369

I am sure the server is online and functional. Any ideas what could be the reason?

Thanks & Regards,
Karl
Feb 5, 2014 at 7:39 PM
Hi Karl,
I have just published version 0.7 which should fix this bug. I have not been able to test it properly yet, but have published it urgently to help you with your issue.

Are you able to give this version a try, and see if you still get the error? Please let me know if it fixes this crash for you, or not.

You can download 0.7 at https://mysqltuner.codeplex.com/releases/view/117575

Thanks,


Peter Chapman
Marked as answer by pmachapman on 2/5/2014 at 11:40 AM