Is Flush Tables causing Stack overflow exception

Is Flush Tables causing Stack overflow exception

Postby 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??
joy87
 
Posts: 2
Joined: Fri 10 Feb 2012 09:24

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1862
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL