Doctrine : Rollback failed. There is no active transaction.

Question

Rollback failed. There is no active transaction.

I am getting the above error when i tried to rollback. I googled the issue and few suggested to disabling the autocommit..... How do we disable autocommit?

Is there any other reason for the above error?

I am using MYSQL and Zend and my php.ini file loaded the required drivers

Thanks in advance

Answer 1

MySQL works in autocommit by default. You can turn it off with:

$connection->setAttribute(Doctrine_Core::ATTR_AUTOCOMMIT, false);

Another idea I have is you didn't start the transaction (which should disable autocommit in Doctrine):

$connection->beginTransaction();

Answer 2

Found the problem.....I have called rollback() function 2 times in different places in the code