0

We have been facing an issue while saving products & categories at the admin end we are getting Rolled back transaction has not been completed correctly. We are using Magento 2.3.1 EE

enter image description here

Can anyone help me with the steps to resolve this issue?

Improve this question
2
  • Exception on save. Disabled third-party extension one by one and check
    – Qaisar Satti
    Commented Oct 25, 2019 at 14:14
  • Also what do your site index configs look like?
    – Dominic Pixie
    Commented Oct 26, 2019 at 15:49

4 Answers 4

Reset to default
2

I have faced similar issue. When I review all the magento and server logs, I found an error which is caused by a product save after observer. Here, the product saved but the observer is trying to do a mysql transaction (which is not related to product) which is failing. So the magento is trying to roll back the transaction and failing. Trying removing all the after save observers and plugings are your first step of debugging.

Improve this answer
1
0

I faced a similar issue saving one product and checked logs. In my case it was Square Up Extension. I found that from var/log. I deleted the the Square Id and saved it worked fine. So I can assume the issue is 3rd party module breaking up the saving process.

Improve this answer
0

I have also faced the similar issue but in my case eav attribute of an extension is not created properly or an product save after observer is causing the issue by commenting the event you can check .

Improve this answer
4
  • regarding this issue have you found the solution?
    – Savan Dholu
    Commented Jan 20, 2022 at 6:43
  • you can check the product save after observer by commenting it .
    – Mallika Jaiswal
    Commented Jan 22, 2022 at 10:47
  • Thanks for answering me, But I have found a solution from my end.
    – Savan Dholu
    Commented Jan 24, 2022 at 6:01
  • Did you find the solution for it ?
    – Jaisa
    Commented Apr 12, 2023 at 3:06
0

I have found that solution.

The solution is some 3rd party module database table not defined properly AUTO INCREMENT & PRIMARY KEY. In my case module is SMTP Mageplaza & Magefan Magento 2 Blog. when upgrading the Magento version that time database is not saved properly.

I have checked to disable one-by-one module & check them & got the error. Now it's working fine from my side.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.