After upgrading Magento from 2.4.3-p2 to 2.4.3-p3 (community edition) products cannot be updated.
I try to edit any product, even with no changes, and same error always.
Error is showing:
"The stock item was unable to be saved. Please try again."
Error log is showing:
[2022-08-10 11:16:48] main.CRITICAL: Exception message: The stock item was unable to be saved. Please try again.
Trace: <pre>#1 Magento\CatalogInventory\Model\StockRegistry->updateStockItemBySku() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#2 Magento\CatalogInventory\Model\StockRegistry\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#3 Magento\CatalogInventory\Model\StockRegistry\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#4 Magento\CatalogInventory\Model\StockRegistry\Interceptor->___callPlugins() called at [generated/code/Magento/CatalogInventory/Model/StockRegistry/Interceptor.php:95]
#5 Magento\CatalogInventory\Model\StockRegistry\Interceptor->updateStockItemBySku() called at [vendor/magento/module-catalog-inventory/Observer/SaveInventoryDataObserver.php:125]
#6 Magento\CatalogInventory\Observer\SaveInventoryDataObserver->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#7 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#8 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66]
#9 Magento\Framework\Event\Manager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95]
#10 Magento\Framework\Event\Manager\Proxy->dispatch() called at [vendor/magento/framework/Model/AbstractModel.php:829]
#11 Magento\Framework\Model\AbstractModel->afterSave() called at [vendor/magento/module-catalog/Model/Product.php:985]
#12 Magento\Catalog\Model\Product->afterSave() called at [generated/code/Magento/Catalog/Model/Product/Interceptor.php:248]
#13 Magento\Catalog\Model\Product\Interceptor->afterSave() called at [vendor/magento/framework/EntityManager/Observer/AfterEntitySave.php:34]
#14 Magento\Framework\EntityManager\Observer\AfterEntitySave->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#15 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#16 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66]
#17 Magento\Framework\Event\Manager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95]
#18 Magento\Framework\Event\Manager\Proxy->dispatch() called at [vendor/magento/framework/EntityManager/EventManager.php:51]
#19 Magento\Framework\EntityManager\EventManager->dispatchEntityEvent() called at [vendor/magento/framework/EntityManager/Operation/Update.php:110]
#20 Magento\Framework\EntityManager\Operation\Update->execute() called at [vendor/magento/framework/EntityManager/EntityManager.php:106]
#21 Magento\Framework\EntityManager\EntityManager->save() called at [vendor/magento/module-catalog/Model/ResourceModel/Product.php:781]
#22 Magento\Catalog\Model\ResourceModel\Product->save() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#23 Magento\Catalog\Model\ResourceModel\Product\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#24 Magento\Catalog\Model\ResourceModel\Product\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-catalog-search/Model/Indexer/Fulltext/Plugin/Product.php:58]
#25 Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->addCommitCallback() called at [vendor/magento/module-catalog-search/Model/Indexer/Fulltext/Plugin/Product.php:28]
#26 Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->aroundSave() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#27 Magento\Catalog\Model\ResourceModel\Product\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#28 Magento\Catalog\Model\ResourceModel\Product\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Interceptor.php:194]
#29 Magento\Catalog\Model\ResourceModel\Product\Interceptor->save() called at [vendor/magento/framework/Model/AbstractModel.php:655]
#30 Magento\Framework\Model\AbstractModel->save() called at [generated/code/Magento/Catalog/Model/Product/Interceptor.php:1706]
#31 Magento\Catalog\Model\Product\Interceptor->save() called at [vendor/magento/module-catalog/Controller/Adminhtml/Product/Save.php:143]
#32 Magento\Catalog\Controller\Adminhtml\Product\Save->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#33 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#34 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#35 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Controller/Adminhtml/Product/Save/Interceptor.php:23]
#36 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:111]
#37 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/module-backend/App/AbstractAction.php:151]
#38 Magento\Backend\App\AbstractAction->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#39 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#40 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-backend/App/Action/Plugin/Authentication.php:145]
#41 Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#42 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#43 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Controller/Adminhtml/Product/Save/Interceptor.php:32]
#44 Magento\Catalog\Controller\Adminhtml\Product\Save\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:245]
#45 Magento\Framework\App\FrontController->getActionResponse() called at [vendor/magento/framework/App/FrontController.php:212]
#46 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:147]
#47 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#48 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#49 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#50 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:23]
#51 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116]
#52 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:23]
#53 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:264]
#54 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:29]
</pre> [] []
Tried many solutions:
1) Restart elastic search (and server).
2) Switching to update on save or update on schedule.
3) Flush, reindex, etc... no success.
4) Export database, drop and re-import. No success.
mysqldump --single-transaction -u root -p mydb --triggers | sed -e 's/DEFINER[ ]=[ ][^]*/*/' > mydb_without_definer.sql
5) Apply all minor patches with no success.
Any ideas?
Hi @DoctorBromo
Please check cataloginventory_stock table.
If its blank then try below query.
INSERT INTO cataloginventory_stock (stock_id, website_id, stock_name) VALUES ('1', '0', 'default');
OR
INSERT INTO cataloginventory_stock (stock_id, website_id, stock_name) VALUES ('1', '0', 'default');
Problem Solved? Accept as solution!
Hope it helps!
Thanks
Hello @DoctorBromo
Please try below command:
sudo service elasticsearch start php bin/magento indexer:reindex
It may help you!
Thank you
We already checked that before opening thread with no success.
Any ideas? Problem is still there...
We have upgraded our dev server and error is the same. Went backwards again.
Please help...