Skip navigation links

MySQL Forums :: Connector/NET and C#, Mono, .Net :: Fatal error encountered during command execution


Advanced Search

Fatal error encountered during command execution
Posted by: Nikolay Konko ()
Date: August 27, 2009 09:25AM

Hello!
I have faced with the following issue in my app and still can't find any solution how to resolve it. Before creating this post I read a lot of different articles, but without any useful results. I try to describe shortly configuration: .net app + mysql connector version 5.2.5(pooling is on) + remote mysql server 5.0.84. The problems appears time to time while saving some binary data(blob) with the following exception(please, see below). After exception, one of the app's connections hangs on the server even the app is closed, moreover this connection blocks some resources and normal application work impossible even after restart. Any help appreciated.


Fatal error encountered during command execution

MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
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 System.IO.BufferedStream.ReadByte()
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

Options: ReplyQuote


Subject Written By Posted
Fatal error encountered during command execution Nikolay Konko 08/27/2009 09:25AM
Re: Fatal error encountered during command execution Nikolay Konko 08/28/2009 01:33PM
Re: Fatal error encountered during command execution Nikolay Konko 09/01/2009 01:36AM
Re: Fatal error encountered during command execution Alexey Ersmambetov 10/06/2009 08:31AM
Re: Fatal error encountered during command execution hemant yadav 10/06/2009 11:19PM


Sorry, you can't reply to this topic. It has been closed.

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.