cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

SOLVED

Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

Upgrade 2.1.9 to 2.2.0

PHP 7.0.24

MSQL 5.6

setup:upgrade could not finish upgrade

 

main.CRITICAL: Asymmetric transaction rollback. {"exception":"[object] (Exception(code: 0): Asymmetric transaction rollback. at /............/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:316)"} []

 

Best Regards

Peter

4 REPLIES

Re: Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

Below is more info from log:

Exception #0 (Magento\Framework\Exception\LocalizedException): Please upgrade your database: Run "bin/magento setup:upgrade" from the Magento root directory.
The following modules are outdated:
Magento_Store data: current version - 2.0.0, required version - 2.1.0
Magento_Directory data: current version - 2.0.0, required version - 2.0.1
Magento_Eav data: current version - 2.0.0, required version - 2.1.1
Magento_Theme data: current version - 2.0.1, required version - 2.0.2
Magento_Customer data: current version - 2.0.9, required version - 2.0.12
Magento_Indexer data: current version - 2.0.0, required version - 2.1.0
Magento_Cms data: current version - 2.0.1, required version - 2.0.2
Magento_Catalog data: current version - 2.1.4, required version - 2.2.3
Magento_Bundle data: current version - 2.0.2, required version - 2.0.4
Magento_Quote data: current version - 2.0.4, required version - 2.0.6
Magento_CatalogRule data: current version - 2.0.1, required version - 2.1.0
Magento_Widget data: current version - 2.0.0, required version - 2.0.1
Magento_CatalogInventory data: current version - 2.0.1, required version - 2.3.0
Magento_Sales data: current version - 2.0.3, required version - 2.0.7
Magento_CurrencySymbol data: current version - 2.0.0, required version - 2.0.1
Magento_Downloadable data: current version - 2.0.1, required version - 2.0.2
Magento_User data: current version - 2.0.1, required version - 2.0.3
Magento_ConfigurableProduct data: current version - 2.0.0, required version - 2.2.0
Magento_NewRelicReporting data: current version - 2.0.0, required version - 2.0.1
Magento_SalesRule data: current version - 2.0.1, required version - 2.0.3
Magento_Robots data: current version - none, required version - 2.0.0
Magento_Paypal data: current version - 2.0.0, required version - 2.0.1
Magento_CheckoutAgreements data: current version - 2.0.1, required version - 2.2.0
Magento_OfflineShipping data: current version - 2.0.0, required version - 2.0.1
Magento_ConfigurableProductSales data: current version - none, required version - 2.2.0
Magento_UrlRewrite data: current version - 2.0.0, required version - 2.0.1
Magento_Swatches data: current version - 2.0.1, required version - 2.0.3
Magento_Tax data: current version - 2.0.1, required version - 2.0.2
Magento_Braintree data: current version - 2.0.0, required version - 2.0.1
Magento_Wishlist data: current version - 2.0.0, required version - 2.0.1
Shopial_Facebook data: current version - none, required version - 1.0.0
#0 /-------/vendor/magento/framework/Interception/Interceptor.php(121): Magento\Framework\Module\Plugin\DbStatusValidator->beforeDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Magento\Framework\App\Request\Http))
#1 /-------/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#2 /-------/generated/code/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, Array)
#3 /-------/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#4 /-------/vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http->launch()
#5 /-------/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#6 {main}

 

Re: Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

One issue resolved. The reason for modules not updated is difference of modules versions in 

setup_module Table. Schema Version and Data Version in some modules was different.

Corrected data entry and run setup:upgrade

result is that Front Site is working but still no access to Admin Module.

The original exception during a setup:upgrade is still here:

[2017-10-15 13:10:01] main.CRITICAL: Asymmetric transaction rollback. {"exception":"[object] (Exception(code: 0): Asymmetric transaction rollback. at /------------/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:316)"} []

 

In addition on Admin Site we got :

1 exception(s):
Exception #0 (InvalidArgumentException): Unable to unserialize value.

Exception #0 (InvalidArgumentException): Unable to unserialize value.
#0 /-----/vendor/magento/module-user/Model/ResourceModel/User.php(244): Magento\Framework\Serialize\Serializer\Json->unserialize('a:1:{s:11:"conf...')
#1 /-----/vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php(356): Magento\User\Model\ResourceModel\User->_afterLoad(Object(Magento\User\Model\User\Interceptor))
#2 /-----/vendor/magento/framework/Model/AbstractModel.php(536): Magento\Framework\Model\ResourceModel\Db\AbstractDb->load(Object(Magento\User\Model\User\Interceptor), '1', 'user_id')
#3 /-----/vendor/magento/module-user/Model/User.php(618): Magento\Framework\Model\AbstractModel->load('1')
#4 /-----/vendor/magento/module-backend/App/Action/Plugin/Authentication.php(122): Magento\User\Model\User->reload()
#5 /-----/vendor/magento/framework/Interception/Interceptor.php(135): Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch(Object(Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#6 /-----/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#7 /-----/generated/code/Magento/Backend/Controller/Adminhtml/Dashboard/Index/Interceptor.php(39): Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor->___callPlugins('dispatch', Array, NULL)
#8 /-----/vendor/magento/framework/App/FrontController.php(55): Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#9 /-----/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))
#10 /----/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', Array)
#11 /-----/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#12 /-----/generated/code/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, Array)
#13 /-----/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#14 /-----/vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http->launch()
#15 /-----/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#16 {main}

Re: Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

I´m getting to the conclusion that I´m lost.

Done the review of additional modules. Found that one module from one provider was incompatible with M2.2.0, but already got updated package so re installed it. second module which I found from different provider will be updated by end of week, meantime I disabled this module and remove a code directory.

run setup:upgrade no errors, actually ¨Asymmetric transaction rollback¨ error gone, it is no problem anymore

run setup:di:compile  no issues

run setup:static-content:deploy no issues

has been clearing cache, removing recommended directory's as required before compilation process so it should be as clean as possible. no log errors.

Front site as I´m concerned no issues.

To access Admin Site filled user and pswd , log in and endup with: 

1 exception(s):
Exception #0 (InvalidArgumentException): Unable to unserialize value.

Exception #0 (InvalidArgumentException): Unable to unserialize value.
#0 //vendor/magento/module-user/Model/ResourceModel/User.php(244): Magento\Framework\Serialize\Serializer\Json->unserialize('a:1:{s:11:"conf...')
#1 //vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php(356): Magento\User\Model\ResourceModel\User->_afterLoad(Object(Magento\User\Model\User\Interceptor))
#2 //vendor/magento/framework/Model/AbstractModel.php(536): Magento\Framework\Model\ResourceModel\Db\AbstractDb->load(Object(Magento\User\Model\User\Interceptor), '1', 'user_id')
#3 //vendor/magento/module-user/Model/User.php(618): Magento\Framework\Model\AbstractModel->load('1')
#4 //vendor/magento/module-backend/App/Action/Plugin/Authentication.php(122): Magento\User\Model\User->reload()
#5 //vendor/magento/framework/Interception/Interceptor.php(135): Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch(Object(Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#6 //vendor/magento/framework/Interception/Interceptor.php(153): Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#7 //generated/code/Magento/Backend/Controller/Adminhtml/Dashboard/Index/Interceptor.php(39): Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor->___callPlugins('dispatch', Array, NULL)
#8 //vendor/magento/framework/App/FrontController.php(55): Magento\Backend\Controller\Adminhtml\Dashboard\Index\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#9 //vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))
#10 //vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', Array)
#11 //vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#12 //generated/code/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, Array)
#13 //vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#14 //vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http->launch()
#15 //index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#16 {main}

Any body could give me a clue for what to look for?

Thanks

Peter

Re: Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

Issue resolved due to  update of some extensions.