Description:
I am frequently getting these exceptions in the connector .net library. The error does not happen consistently. Usually, if the query fails once, I can run it again, and it will succeed the second time.
It seems to be throwing exceptions in int32 and int64 parsing. While the table does technically allow for nulls, there are never any nulls present. I have just verified this.
System.FormatException: Invalid format.
in <0x002c9> System.Int64:Parse (string,bool,long&)
in <0x00022> System.Int64:Parse (string)
in <0x0006b> MySql.Data.Types.MySqlInt64:ReadValue
(MySql.Data.MySqlClient.PacketReader,long)
in <0x00116> MySql.Data.MySqlClient.NativeDriver:ReadFieldValue
(int,MySql.Data.MySqlClient.MySqlField,MySql.Data.Types.MySqlValue)
in <0x000c2> MySql.Data.MySqlClient.CommandResult:ReadDataRow (bool)
in <0x000d9> MySql.Data.MySqlClient.MySqlDataReader:Read ()
and this similar one:
System.FormatException: Invalid format.
in <0x0035e> System.Int32:Parse (string,bool,int&)
in <0x0002f> System.Int32:Parse (string)
in <0x000de> MySql.Data.Types.MySqlInt32:ReadValue
(MySql.Data.MySqlClient.PacketReader,long)
in <0x0015b> MySql.Data.MySqlClient.NativeDriver:ReadFieldValue
(int,MySql.Data.MySqlClient.MySqlField,MySql.Data.Types.MySqlValue)
in <0x00113> MySql.Data.MySqlClient.CommandResult:ReadDataRow (bool)
in <0x0018a> MySql.Data.MySqlClient.MySqlDataReader:Read ()
(this one might be something else, but I'll add it anyway):
MySql.Data.MySqlClient.MySqlException: Connection unexpectedly terminated
in <0x0028e> MySql.Data.MySqlClient.PacketReader:Read (byte[]&,long,long)
in <0x000a0> MySql.Data.MySqlClient.PacketReader:Skip (long)
in <0x0005e> MySql.Data.MySqlClient.PacketReader:OpenPacket ()
in <0x00135> MySql.Data.MySqlClient.NativeDriver:Authenticate411 ()
in <0x0009d> MySql.Data.MySqlClient.NativeDriver:Authenticate ()
in <0x00071> MySql.Data.MySqlClient.NativeDriver:Reset ()
in <0x002e5> MySql.Data.MySqlClient.MySqlPool:GetPooledConnection ()
in <0x0006f> MySql.Data.MySqlClient.MySqlPool:GetConnection ()
in <0x001b2> MySql.Data.MySqlClient.MySqlPoolManager:GetConnection
(MySql.Data.MySqlClient.MySqlConnectionString)
in <0x000d3> MySql.Data.MySqlClient.MySqlConnection:Open ()
How to repeat:
Not sure... when I see this exception, usually I'm running a series of commands that creates some tables and drops them. Once it's done, if I try to read a different table, this happens.
