Error: Something went wrong while saving the category in magento 2.1.8

[InspireDev]

I have installed magento 2.1.8 in my localhost and also hosted the same from an online server. I am facing a problem  in online server while saving the category showing 'Something went wrong while saving the category' but in my localhost i can save or update any category without any error. I have already followed the following link:

https://community.magento.com/t5/Magento-2-x-Technical-Issues/Error-Something-went-wrong-while-savin...
I have also checked the log file but no error is generated

Thanks in advance.

[Sunil Patel]

Hello,

Please enable developer mode and check it.

[InspireDev]

I have checked exception.log file. It's showing the following. Not understand what's the error..

[2018-05-03 07:23:51] main.CRITICAL: Exception: Asymmetric transaction rollback. in /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:278
Stack trace:
#0 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Model/ResourceModel/AbstractResource.php(99): Magento\Framework\DB\Adapter\Pdo\Mysql->rollBack()
#1 /home/forge/magdrill.loudondesign.com/public/var/generation/Magento/Catalog/Model/ResourceModel/Category/Interceptor.php(908): Magento\Framework\Model\ResourceModel\AbstractResource->rollBack()
#2 /home/forge/magdrill.loudondesign.com/public/vendor/magento/module-catalog-search/Model/Indexer/Fulltext/Plugin/Category.php(52): Magento\Catalog\Model\ResourceModel\Category\Interceptor->rollBack()
#3 /home/forge/magdrill.loudondesign.com/public/vendor/magento/module-catalog-search/Model/Indexer/Fulltext/Plugin/Category.php(29): Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Category->addCommitCallback(Object(Magento\Catalog\Model\ResourceModel\Category\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Category\Interceptor))
#4 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Category->aroundSave(Object(Magento\Catalog\Model\ResourceModel\Category\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Category\Interceptor))
#5 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Catalog...', 'save', Object(Magento\Catalog\Model\ResourceModel\Category\Interceptor), Array, 'clean_cache')
#6 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/App/Cache/FlushCacheByTags.php(71): Magento\Catalog\Model\ResourceModel\Category\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Catalog\Model\Category\Interceptor))
#7 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(142): Magento\Framework\App\Cache\FlushCacheByTags->aroundSave(Object(Magento\Catalog\Model\ResourceModel\Category\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Category\Interceptor))
#8 /home/forge/magdrill.loudondesign.com/public/var/generation/Magento/Catalog/Model/ResourceModel/Category/Interceptor.php(364): Magento\Catalog\Model\ResourceModel\Category\Interceptor->___callPlugins('save', Array, Array)
#9 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Model/AbstractModel.php(631): Magento\Catalog\Model\ResourceModel\Category\Interceptor->save(Object(Magento\Catalog\Model\Category\Interceptor))
#10 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Framework\Model\AbstractModel->save()
#11 /home/forge/magdrill.loudondesign.com/public/var/generation/Magento/Catalog/Model/Category/Interceptor.php(1534): Magento\Catalog\Model\Category\Interceptor->___callPlugins('save', Array, Array)
#12 /home/forge/magdrill.loudondesign.com/public/vendor/magento/module-catalog/Controller/Adminhtml/Category/Save.php(212): Magento\Catalog\Model\Category\Interceptor->save()
#13 /home/forge/magdrill.loudondesign.com/public/var/generation/Magento/Catalog/Controller/Adminhtml/Category/Save/Interceptor.php(24): Magento\Catalog\Controller\Adminhtml\Category\Save->execute()
#14 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/App/Action/Action.php(102): Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor->execute()
#15 /home/forge/magdrill.loudondesign.com/public/vendor/magento/module-backend/App/AbstractAction.php(226): Magento\Framework\App\Action\Action->dispatch(Object(Magento\Framework\App\Request\Http))
#16 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Backend\App\AbstractAction->dispatch(Object(Magento\Framework\App\Request\Http))
#17 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor->___callParent('dispatch', Array)
#18 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Catalog...', 'dispatch', Object(Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor), Array, 'adminAuthentica...')
#19 /home/forge/magdrill.loudondesign.com/public/vendor/magento/module-backend/App/Action/Plugin/Authentication.php(143): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain\{closure}(Object(Magento\Framework\App\Request\Http))
#20 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch(Object(Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#21 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Catalog...', 'dispatch', Object(Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor), Array, 'adminMassaction...')
#22 /home/forge/magdrill.loudondesign.com/public/vendor/magento/module-backend/App/Action/Plugin/MassactionKey.php(33): Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#23 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(142): Magento\Backend\App\Action\Plugin\MassactionKey->aroundDispatch(Object(Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#24 /home/forge/magdrill.loudondesign.com/public/var/generation/Magento/Catalog/Controller/Adminhtml/Category/Save/Interceptor.php(65): Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor->___callPlugins('dispatch', Array, Array)
#25 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/App/FrontController.php(55): Magento\Catalog\Controller\Adminhtml\Category\Save\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#26 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))
#27 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', Array)
#28 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'dispatch', Object(Magento\Framework\App\FrontController\Interceptor), Array, 'install')
#29 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Module/Plugin/DbStatusValidator.php(69): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))
#30 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/Interception/Interceptor.php(142): Magento\Framework\Module\Plugin\DbStatusValidator->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#31 /home/forge/magdrill.loudondesign.com/public/var/generation/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, Array)
#32 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#33 /home/forge/magdrill.loudondesign.com/public/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#34 /home/forge/magdrill.loudondesign.com/public/pub/index.php(37): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#35 {main} [] []

[Manthan Dave]

Hi @InspireDev

To resolve the issue ,following are the steps

Reindex by using the following command

php bin/magento indexer:reindex

run below commands

rm -rf var/cache/*
rm -rf var/page_cache/*
rm -rf var/generation/*

rm -rf generated

then run php bin/magento setup:di:compile and php bin/magento setup:static-content:deploy -f 

Hope it helps

[Sunil Patel]

Hello @InspireDev

Seems like Indexer mode set on Save, can you please change to manual and check it.