Hello,
I got a problem where I get the well known "Lost connection" error while deleting entries from a big table.
The table looks like:
DROP TABLE IF EXISTS `aoi_delete_db`.`inspectionresults`;
CREATE TABLE `aoi_delete_db`.`inspectionresults` (
`ResultIndex` bigint(20) unsigned NOT NULL auto_increment,
`Time` datetime NOT NULL default '0000-00-00 00:00:00',
`ProductIndex` int(10) unsigned NOT NULL default '0',
`LayerIndex` int(10) unsigned NOT NULL default '0',
`BatchIndex` int(10) unsigned NOT NULL default '0',
`SectionIndex` int(10) unsigned NOT NULL default '0',
`Review` varchar(40) NOT NULL default '',
`Image` mediumblob,
`CameraIndex` int(10) unsigned default NULL,
`InspectionIndex` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ResultIndex`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=4294967295 AVG_ROW_LENGTH=109596;
contains about 8000 rows and is about 900 Mb big.
The DELETE statement I try to execute is an ordinary "DELETE FROM ... WHERE BatchIndex=..." statement and should delete about 7600 rows.
I have already set all timeouts I could find ( Connection, Command and MySQLServer timeouts) to one hour (3600 seconds) and have set the max packet size to 128 Mb. I also tried setting the Direct-property of the connection to false, but that only gave me a "Not-Supported" exception.
Nothing of what I did helped, I always get the "Lost connection" error.
What else can I do?
Thanks a lot,
Vince
Lost connection error although CommandTimeout, ConnectionTimeout and MySQLServer timeouts are increased
-
- Posts: 10
- Joined: Wed 27 Jul 2005 11:36
-
- Posts: 10
- Joined: Wed 27 Jul 2005 11:36
forgot...
I forgot to mention that I also alread checked wether the connection is still alive and open (Ping, Connection.State etc.) before executing the statement....
Vince
Vince
-
- Posts: 10
- Joined: Wed 27 Jul 2005 11:36
even more forgotten....
I also forgot to metion that I work in C# with VS 8.0 and corelabs 3.55 .net 2.0 on a local DB with mySQL Server 5.0.19 and mySQLClient 5.0.11 and that the delete statement works fine when I copy the same statement into the MySQL Query Browser and execute it there.....
Vince
Vince
-
- Posts: 10
- Joined: Wed 27 Jul 2005 11:36