Devart Forums

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??

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.