Is Flush Tables causing Stack overflow exception
Posted: 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??
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??