Is Flush Tables causing Stack overflow exception

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
joy87
Posts: 2
Joined: Fri 10 Feb 2012 09:24

Is Flush Tables causing Stack overflow exception

Post by joy87 » Fri 10 Feb 2012 10:55

Here is one of procedures which i execute from c# code..

DELIMITER $$

DROP PROCEDURE IF EXISTS `ClearTempTable`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `ClearTempTable`()
BEGIN
FLUSH TABLES;
TRUNCATE TABLE tbl_cdrload;
TRUNCATE TABLE tbl_cdrdetails_temp;
END$$

DELIMITER ;
Flush Tables is causing me an error An unhandled exception of type 'System.StackOverflowException' occurred in Devart.Data.MySql.dll But when i remove the flush tables from the procedure , it works fine.Why is it happening??

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Tue 14 Feb 2012 14:22

We cannot reproduce the issue in our environment. Colud you please specify the following:
1. The dotConnect for MySQL version (x.xx.xxx);
2. The MySQL server version;
3. Have you worked with other tables before invoking the `ClearTempTable` procedure? If yes, how many tables did you work with?
4. If it possible, create and send us a small test project for reproducing the issue;
5. Call stack of the exception.

Post Reply