0

We just started getting this error at the command line on index. Is it possible to truncate this table and re-index?

Catalog Search Index index process unknown error:
exception 'Enterprise_Index_Model_Action_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '13654292' for key 'PRIMARY'' in html/app/code/core/Enterprise/CatalogSearch/Model/Index/Action/Fulltext/Refresh.php:154
Stack trace:
#0 

EDIT: I backed up the database and ran the index on my local using the same code

Brents-MacBook-Pro-3:brandshopper-uhc brent$ magerun index:reindex catalogsearch_fulltext 


  Reindex  


Started reindex of: catalogsearch_fulltext
Estimated end: 2014-07-04 19:21:55 UTC
Successfully reindexed catalogsearch_fulltext (Runtime: 1m 18s)

No I don't know what to think?

1 Answer 1

0

I ended up truncating the table and then re-indexing and it works now

[html]$ magerun index:reindex catalogsearch_fulltext 


  Reindex  


Started reindex of: catalogsearch_fulltext
Estimated end: 2014-07-04 19:53:52 UTC
Successfully reindexed catalogsearch_fulltext (Runtime: 1m 42s)
[html]$ 

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.