cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Upgrade 2.1.9 to 2.2.0 Asymmetric transaction rollback

Issue resolved due to  update of some extensions.

View solution in original post

4 REPLIES 4

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.