无法重新索引卡在“处理"中的magento 1.7.0.2. [英] Can't reindex magento 1.7.0.2 stuck on "processing"

问题描述

我的9个magento索引中有7个停留在处理中"，我需要重新索引它们以使我的网站正确显示.

7 out of 9 of my magento indexes are stuck on "processing", and I need to reindex them to get my site showing correctly.

我通过ftp访问我的var/locks并删除其中的两个文件，但是当我刷新索引页面时，它们只是重新包装(index_process_3.lock)和(index_process_5.lock).

I access my var/locks via ftp and delete the two files that are in there, but when I refresh the index page, they just reapper (index_process_3.lock) and (index_process_5.lock).

有趣的是索引3和5才是真正准备就绪的，所有其他未出现的锁都是卡在处理中的锁.

Funnily index 3 and 5 are the only ones that are actually ready, all the other locks that don't appear are the ones stuck on processing.

关于如何执行此操作的任何线索?

Any clues on how to go about this?

推荐答案

检查表index_process，从此处以及从var/locks中删除锁，然后重试.同样在1.7.0.2上，建立索引时存在一个错误，它在数据库中的某些表上创建了一些互斥锁，您无法使用它们，可以在最新的Enterprise版本中找到修复程序. 我建议从php cli> shell/indexer.php

Check the table index_process, delete the locks from there and also from var/locks and try again. Also on 1.7.0.2 there is a bug when indexing, it creates some exclusive locks in the database on some tables and you can't use them, you can find a fix in the latest Enterprise version. I would recommend indexing from php cli > shell/indexer.php

这篇关于无法重新索引卡在“处理"中的magento 1.7.0.2.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！