Bug #77691 Aborted connection
Submitted: 12 Jul 2015 9:09 Modified: 13 Jul 2015 6:09
Reporter: Dmitry Sazonov Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.9.3 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[12 Jul 2015 9:09] Dmitry Sazonov
Description:
Hello to everyone. I develop an application that should work 24 hours in a day. Sometimes It generates excheption:
----------------------------------------------------------------------------
MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host '127.0.0.1' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ---> 
MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> 
System.IO.IOException: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. ---> 
System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine
   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 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.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText)
   at HistoryDataApi.DataExpirationCtrl.GetExpirationIdByName(String expirationName) 
----------------------------------------------------------------------------
I know there is a situation when the mysql server closes connections inactive for a long time. To solve this problem some kind of "ping" signal is used to detect it. However in my cases I try to get data from data base via 'MySqlHelper.ExecuteScalar(string connectionString, string commandText)', moreover my function, calling 'MySqlHelper.ExecuteScalar', is executed each 5 minutes. Does anybody know methods to solve this problem ? (MySQL Server version is '5.6')

Best regards, Dmitry.

How to repeat:
Bug is difficult to repeat.
[13 Jul 2015 6:09] Chiranjeevi Battula
Hello Dmitry Sazonov,

Thank you for the bug report.
This is duplicate of Bug #76597.

Thanks,
Chiranjeevi.