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: 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?