MySQL InnoDB事务回滚不起作用(MySQL InnoDB transaction rollback is not working)

 我遇到了从Yii框架（使用PDO）发送到InnoDB MySql数据库的事务的问题，问题是：回滚不起作用，更新语句立即提交。 
 
 
 
 我试图明确设置autoCommit，没有运气。 
 
 
 查了Mysql的通用日志，只有一个Connection正在打开，发送了一个Start事务，后来只有一个回滚。 
 
 
 在通用日志中，“开始事务”，“回滚”和更新语句都来自同一客户端线程。 
 
 
 在整个日志中没有发现任何提交。 
 
 
 尝试从mysql客户端（MySQLWorkbench）回滚示例和回滚工作！ 
 
 
 问题在于MySql在从Yii应用程序发送它时立即提交，我不知道为什么。 
 
 没有特别的原因，我只是尝试在my.cnf中启用log_bin并且回滚工作!! 
 
 有人能解释发生了什么吗？ 
 
 我使用MySql 5.6.25，PHP 5.6.10和Yii 1.1.14。 
 
 更新： 
 
 事实证明，我犯了一个错误，我认为在启用log_bin后回滚工作，但它没有。 
 
 所以现在我回到了原来的问题，回滚不起作用，这里是源代码： 
 
$transaction = Yii::app()->db->beginTransaction();
try {

    $data = array();
    // fill some data here..
    $model = Model::createOrUpdate($data);

    $errors = $model->getErrors();

} catch (Exception $e) {
    $errors []= $e->getMessage();
}

if (empty($errors)) {
    $msg = 'Success message!';
    $transaction->commit();
    echo CJSON::encode(array('success', $msg));
} else {
    if ($transaction->active) {
        $transaction->rollback();
    }
    echo CJSON::encode(array('error', implode(', ', $errors)));
}

Yii::app()->end();

I had a problem with a transaction sent from Yii framework (using PDO) to InnoDB MySql database, the problem was: rollback was not working, update statement was committing right away.
 
 
 
I tried setting autoCommit explicitly, with no luck.
 
 
Checked Mysql general log, only one Connection is being open, with one Start transaction sent, and later only one rollback.
 
 
In the general log, "Start transaction", "rollback" and the update statement were all from the same client thread.
 
 
No commit was found in the whole log.
 
 
Tried a rollback example from a mysql client (MySQLWorkbench) and rollback worked!
 
 
The problem was just that MySql was committing right away when its sent from the Yii app and I didn't know why.
 
For no particular reason, I just tried enabling log_bin in my.cnf and the rollback worked!!
 
Can someone please explain what just happened?
 
I'm using MySql 5.6.25, with PHP 5.6.10 and Yii 1.1.14.
 
Update:
 
Turns out that I have made a mistake, I thought the rollback worked after enabling log_bin, but it didn't.
 
So now I'm back to the original problem, the rollback is not working, and here is the source code:
 
$transaction = Yii::app()->db->beginTransaction();
try {

    $data = array();
    // fill some data here..
    $model = Model::createOrUpdate($data);

    $errors = $model->getErrors();

} catch (Exception $e) {
    $errors []= $e->getMessage();
}

if (empty($errors)) {
    $msg = 'Success message!';
    $transaction->commit();
    echo CJSON::encode(array('success', $msg));
} else {
    if ($transaction->active) {
        $transaction->rollback();
    }
    echo CJSON::encode(array('error', implode(', ', $errors)));
}

Yii::app()->end();

原文：https://stackoverflow.com/questions/39944305