I am running Magento 2.1.5 and facing a really strange issue. I have over 6,500 products uploaded to the store but some items are not showing up after performing a complete reindex. Of course, some items are out of stock but many of the products that are not showing up in their respective categories are the similar as others that are showing up just fine. These products are simple (not configurable) and belong to do the same attribute group.
Upon searching for the items in search the missing products show up. Upon saving the item the item appears again only to go missing again upon reindex.
After performing reindex one by one, I noticed the issue is affecting the following tables:
I even went ahead and added a row which made the product appear again on the front-end but after reindexing the row was deleted.
Does anyone have any clue as to what this issue could be? It's very, very strange but I'm hoping there is a simple solution.
Update 02/27/2017: I am still not able figure out a solution for this bug. If any Magento Expert can gain some insight into this and fix it he or she will be rewarded.