Error updating product after upgrading from Magento 2.4.3-p2 to 2.4.3-p3

[DoctorBromo]

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?

[Bhanu Periwal]

Hello @DoctorBromo 

If you are using CPanel you may navigate to MySQL Databases inside the DATABASES section or search for it. Then look for the Current Databases section and on the same row as your Magento database under the column Privileged Users click on the user turkey123_magentech.

On the next page titled Manage User Privileges , simply check the top left checkbox for ALL PRIVILEGES and finally click on the Make Changes button at bottom left of the page.

[DoctorBromo]

I am sorry, but no success...

[Ankit Jasani]

Hi @DoctorBromo ,

Have you tried below solution?

INSERT INTO cataloginventory_stock (stock_id, website_id, stock_name) VALUES ('1', '1', 'default');

Problem Solved? Accept as Solution!

Hope it helps!

Thanks

[hopteckzap84f4]

I am also having this problem thank you for helping me to fix this problem

[DoctorBromo]

Upgrading to 2.4.4 or 2.4.5 it's not an option because many plugins still do not support and a complete redesign would be needed.

It's amazing how Magento fires patches which are not stable.

[DoctorBromo]

Yes, I tried! Thank you.

No solution.

[hopteckzap84f4]

Can you tell me what source code should mod apk free I use if I want to make games like this?

[DoctorBromo]

We continue with same problem. Any solution? Thanks!

[le4714419ge550]

What data should I use to process APK mods?