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