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: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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.