IndexOutOfRangeException: Result set index too big
IndexOutOfRangeException: Result set index too big
I have seen :
IndexOutOfRangeException: Result set index too big
at CoreLab.MySql.MySqlDataReader.a(Int32 A_0,String A_1)
this is while the code being executed is:
mySqlDump1.Backup(x);
Please advise.
tia
IndexOutOfRangeException: Result set index too big
at CoreLab.MySql.MySqlDataReader.a(Int32 A_0,String A_1)
this is while the code being executed is:
mySqlDump1.Backup(x);
Please advise.
tia
The problem continues, but only very rarely ...
Out of about 100 runs, I got it again:
Error during Backup: System.IndexOutOfRangeException: Result set index too big.
at CoreLab.MySql.MySqlDataReader.a(Int32 A_0, String A_1)
at CoreLab.MySql.MySqlDataReader.GetString(Int32 i)
at CoreLab.MySql.MySqlDump.c(TextWriter A_0)
at CoreLab.MySql.MySqlDump.Backup(TextWriter writer)
at CoreLab.MySql.MySqlDump.Backup(String fileName)
Out of about 100 runs, I got it again:
Error during Backup: System.IndexOutOfRangeException: Result set index too big.
at CoreLab.MySql.MySqlDataReader.a(Int32 A_0, String A_1)
at CoreLab.MySql.MySqlDataReader.GetString(Int32 i)
at CoreLab.MySql.MySqlDump.c(TextWriter A_0)
at CoreLab.MySql.MySqlDump.Backup(TextWriter writer)
at CoreLab.MySql.MySqlDump.Backup(String fileName)
Alexey,
I don't think making a test project is going to make any difference. I think the key is the environment (read: local load) and table data.
I'm running against a 5.0.42-enterprise
The server is local to the run time, and is actually a live replication slave with many other functions running ... sometimes leading to heavy cpu and ram load.
the database contains:
99 tables, 6,921,660 rows, 2.5GB data
with each table ranging from 0 to 689,174 rows and 16kb to 203mb
This database will soon be doubling in size.
anyways,
here is a simplified version of the code being used:
I don't think making a test project is going to make any difference. I think the key is the environment (read: local load) and table data.
I'm running against a 5.0.42-enterprise
The server is local to the run time, and is actually a live replication slave with many other functions running ... sometimes leading to heavy cpu and ram load.
the database contains:
99 tables, 6,921,660 rows, 2.5GB data
with each table ranging from 0 to 689,174 rows and 16kb to 203mb
This database will soon be doubling in size.
anyways,
here is a simplified version of the code being used:
Code: Select all
databaseConnection.Host = edHost.Text;
databaseConnection.UserId = edUser.Text;
databaseConnection.Password = edPassword.Text;
databaseConnection.Port = (int)edPort.Value;
databaseConnection.Database = cbDatabase.Text;
databaseConnection.Open();
mySqlDump1.Connection = databaseConnection;
mySqlDump1.ExportAll = false;
mySqlDump1.GenerateHeader = true;
LogThis("Backup in progress " + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString());
this.Update();
DataTable dataTable = databaseConnection.GetSchema("Tables", new String[] { databaseConnection.Database });
foreach (DataRow dataRow in dataTable.Rows)
{
string thissqlname = thishour + "." + dataRow["Name"].ToString() + ".sql";
mySqlDump1.Tables = dataRow["Name"].ToString();
try
{
LogThis("Backup of " + thissqlname + " in progress");
this.Update();
mySqlDump1.Backup(thisOutputFolderHour + thissqlname);
LogThis("Backup of " + thissqlname + " complete");
this.Update();
}
catch (Exception Ex)
{
LogThis("Error during table backup: " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString());
this.Update();
MessageBox.Show("Error during Backup: " + Ex);
return;
}
}
Have you had any luck identifying a potential cause?
I'm still getting the same errors ... about once every 75 to 150 runs.
But I'm also seeing:
only a couple of times:
and this also (only a couple of times)
I'm still getting the same errors ... about once every 75 to 150 runs.
But I'm also seeing:
only a couple of times:
Code: Select all
Commands out of sync; You can't run this command now
Code: Select all
System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.String.System.IConvertible.ToInt64(IFormatProvider provider)
at System.Convert.ToInt64(Object value)
at CoreLab.MySql.MySqlDump.c(TextWriter A_0)
at CoreLab.MySql.MySqlDump.Backup(TextWriter writer)
at CoreLab.MySql.MySqlDump.Backup(String fileName)