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
Solved! Go to Solution.
Issue resolved due to update of some extensions.
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}
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}
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