I recently migrated from magento 1.9.4.5 to magento 2.3.6 then upgraded to version 2.3.7-p2; I imported customers, orders, categories and products with the magento import tool. All went well. Now after some time, having to modify configurable products, I encounter problems with saving after the modifications, the system presents me with the error “Rolled back transaction has not been completed correctly.” and I cannot find a suitable solution which then applies to all old imported products.
The exception.log file show this error:
main.CRITICAL: Rolled back transaction has not been completed correctly. {"exception":"[object] (Exception(code: 0): Rolled back transaction has not been completed correctly. at /home/.../public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:310)"} []
In practice, for many products, I am forced to recreate the associates, or in extreme cases to totally recreate the product with all the associates.
I need help to solve this problem, could you please indicate a solution?