A Client has mentioned to me a bug which is near impossible to re-produce thus only leaves theory based solutions.
I thought I would check to see if anyone else has stumbled upon this issue and with guidance or a solution.
our client has
- 60,000 + products
- over 40 sites (within single magento build)
When they run a re-index it takes up to 4 hours (yes our import script disabled re-index on save to help speed up the indexing process, this is due to number of products X number of stores)
Approximately 4 times in the past couple of months, ONE of the category pages shows 0 products, for a time of up to 1 day.
It appears re-indexing is still running when this happens.
It is difficult to reproduce (tried several scenarios) but is very important to resolve.
Has anyone else heard of / looked into / resolved this issue in the past?
1: They are viewing the page during the re-index process (re-index empties the SQL table then re-populates it, they happen to catch this as this time)
1a: Index Crashed during this step
1b: FPC has cached this version of the page during this process.
So I ask my friends, any more suggestions would be appreciated here.