SQLSTATE [40001]:序列化失败:1213尝试获取锁时发现了死锁；错误消息是:尝试通过Magento职位重新开始交易 [英] SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction by Magento position

问题描述

当我们尝试从管理类别中设置产品在类别中的位置时，我们在Magento商店中遇到了问题.当我们在更改类别产品"中的位置后尝试保存产品时，出现以下错误:

We have a problem in our Magento shop when we try to set the position of the products in a category from manage categories. When we try to save a product after changing the position in "category products" we get the following failure:

SQLSTATE [40001]:序列化失败:尝试尝试时发现1213死锁 锁尝试重新启动事务

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

有人知道如何解决这个问题吗?

Does anyone know how to solve this?

推荐答案

最有可能发生此错误，因为您将产品位置索引设置为自动，并且Magento尝试与产品保存一起重建索引.
转到System->Index Management，并将与目录相关的索引设置为手动".
然后设置产品位置，完成后手动重建索引.

The error occurs most probably because you have the product position index set to auto and Magento tries to rebuild the index along with the product save.
Go to System->Index Management and set the indexes related to catalog to 'manual'.
Then set the product positions and when you are done rebuild the indexes manually.

这篇关于SQLSTATE [40001]:序列化失败:1213尝试获取锁时发现了死锁；错误消息是:尝试通过Magento职位重新开始交易的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！