Magento 126.96.36.199 all patches. We have a weird indexing issue. We have all indexers set to "Update on Save" But we still keep getting "Reindex Required", mostly index product stock status.
I thought that if you have "Update on Save" it reindexes right away, and you would never see "Reindex Required"?
The second weird thing is when I go into the index_process_event table, the event that has a status of "new" is a very old one, like 2 years old? What is happening here? It almost seems like something is changing old rows in index_process_event to "new"?
My index_event table has 26456 rows and my index_process_event has 2322
I think this is related, we also keep having products disappear from categories. It just happens randomly. One to three products will not show up a couple times a day, when we are busy. So then we reindex or save the product and it comes back.
Do you think truncating the index_process tables would fix this?