Forums

Index Search Engine job crashes with cache enabled

Permalink
We've got a website with 1263 pages. Whenever we want to run the Index Search Engine job on the System & Maintenance section the job crashes and gave me the following error:

mysql error: [1062: Duplicate entry '1967' for key 1] in EXECUTE("INSERT INTO CollectionSearchIndexAttributes ( CID, AK_META_TITLE, AK_META_DESCRIPTION, AK_META_KEYWORDS, AK_EXCLUDE_NAV, AK_PHOTO ) VALUES ( 1967, '', '', '', 0, 76 )")


It only happens when I've got the cache setting enabled in Sitewide Settings > Debug > Caching.
When I change the caching setting to disabled I can run the job again.

Can anyone reply why the caching is crashing my job and what can I do to fix it?

It's not the allowed memory size, because we've already changed that setting to 134217728 bytes.

Thanks for your reply!
NUL76
 
Mnkras replied on at Permalink Reply
Mnkras
go to the table CollectionSearchIndexAttributes and delete row 1967
NUL76 replied on at Permalink Reply
NUL76
Thats not it. I've had the same problem before but with entry 1239. After that I've changed the integer in the ColelctionSearchIndexAttributes table. From int(11) to bigint(20). After that I got the problem with entry 1967.
Mnkras replied on at Permalink Reply
Mnkras
that is the problem, tho, there is a duplicate entry, C5 is trying to insert because it doesn't think its there instead of updating