Bug #7692 System.FormatException in Connector .Net
Submitted: 5 Jan 2005 19:23 Modified: 12 Feb 2005 20:48
Reporter: Keith Dreibelbis Email Updates:
Status: No Feedback Impact on me:
Category:Connector / NET Severity:S3 (Non-critical)
Version: OS:Linux (linux)
Assigned to: Assigned Account CPU Architecture:Any

[5 Jan 2005 19:23] Keith Dreibelbis
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
in <0x00116> MySql.Data.MySqlClient.NativeDriver:ReadFieldValue
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
in <0x0015b> MySql.Data.MySqlClient.NativeDriver:ReadFieldValue
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
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.
[12 Jan 2005 20:48] Reggie Burnett
we need to find some code that will reproduce this.  We'll keep an eye on this one.
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".