Re: Detecting auto-closed/ killed connection

[秀平 山下]

Hi Hans!

Had the same problem .... I also

Server: MySQL 5.5.29
.NET Connector: 6.6.5
Connection Type: SSL

Error:
-------------------------------------------------- -------------------------------------------------- --------------
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.EndOfStreamException: ストリームの末尾を越えて読み取ろうとしました。
場所 MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
場所 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
--- 内部例外スタック トレースの終わり ---
場所 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
場所 MySql.Data.MySqlClient.MySqlStream.ReadPacket()
場所 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
場所 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
場所 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
場所 MySql.Data.MySqlClient.MySqlDataReader.NextResult()
--- 内部例外スタック トレースの終わり ---
場所 MySql.Data.MySqlClient.MySqlDataReader.NextResult()
場所 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--- 内部例外スタック トレースの終わり ---
場所 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
場所 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
場所 dobarzero.do_sql.do_update(String sql)
------------------------------------------------------------------------------------------------------------------


The cause is that the server has been disconnected
I can not be determined in the "State" if the

I will introduce the measures that I have carried out

#############################################################
# VB.NET
#############################################################

If ( conn.Ping () = False ) Then

conn.Open ();

End If

#############################################################

To check the connection with "Ping", but it is probably the most accurate way
Please try once

* not good at English, I use the translation of Google. I'm sorry I was confusing