SQLSTATE [40001]: sequential processing failed: 1213 deadlock was detected while trying to get a lock; try restarting the transaction by position Magento

Question

We have a problem in our Magento store when we try to establish the position of products in the category from the management category. When we try to save a product after changing a position in a product category, we get the following failure:

SQLSTATE [40001]: sequential processing failed: 1213. get the lock; try restarting the transaction

Does anyone know how to solve this?

Answer 1

The error is most likely due to the fact that the product position index is set to auto, and Magento is trying to rebuild the index along with saving the product.
Go to System->Index Management and set the directory related indexes to "manual".
Then set the product position, and when you finish rebuilding the indexes manually.