Why does my unknown script raises the error «Asymmetric transaction rollback»?

brst_dev · September 28, 2016, 12:10pm

Hello,

I am running a script in which products qty and price are updated. but after updating 500 - 600 products its giving error “Asymmetric transaction rollback”. I have total 6k products. Please let me know the issue and how to solve it.

Thanks

dmitry_fedyuk · September 28, 2016, 12:21pm

It is a bug of your unknown script: it tries to rollback a transaction when there is nothing to rollback.

github.com

magento/magento2/blob/2.1.1/lib/internal/Magento/Framework/DB/Adapter/AdapterInterface.php#L65-L68


/**
 * Error message for asymmetric transaction rollback
 */
const ERROR_ASYMMETRIC_ROLLBACK_MESSAGE = 'Asymmetric transaction rollback.';

github.com

magento/magento2/blob/2.1.1/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php#L258-L278


/**
 * Rollback DB transaction
 *
 * @return $this
 * @throws \Exception
 */
public function rollBack()
{
    if ($this->_transactionLevel === 1) {
        $this->logger->startTimer();
        parent::rollBack();
        $this->_isRolledBack = false;
        $this->logger->logStats(LoggerInterface::TYPE_TRANSACTION, 'ROLLBACK');
    } elseif ($this->_transactionLevel === 0) {
        throw new \Exception(AdapterInterface::ERROR_ASYMMETRIC_ROLLBACK_MESSAGE);
    } else {
        $this->_isRolledBack = true;
    }
    --$this->_transactionLevel;
    return $this;
}

brst_dev · September 28, 2016, 12:26pm

Hello Dmitry,

Thanks for the reply. Can you please explain a little more so that I can fix it?

dmitry_fedyuk · September 28, 2016, 12:34pm

Just read the code of the rollBack method I have published above.
Your script calls the method when there is nothing to rollback, so it is obviously error in the script.

brst_dev · September 28, 2016, 1:02pm

Dmitry,

In my script, I am just loading all enabled products and updating their qty and price

$product->setPrice($price);
$product->setQuantityAndStockStatus(array(‘is_in_stock’=>1,‘qty’=>$qty));
$product->save();

Also I have checked, the price and qty values are correct. Still not able to find the issue. Please if you help me more