Am using solr with my application , specially for certain search module. I had a failure few days back with which the entity audit table went out of sync. After rectifying that issue whenever i add some data , it disappears the next day and solr shows the data which was there before that failure . Say I add 500 users to my app on day 1 , go to solr admin UI and query : , it gives me all ( old data + new 500 ) , however when I login again next day and look for solr data , it gives that old data , does not shows newly added 500 .
After a delta-sync import , it starts to show correct one , but again back to square one the next day.
I suspect it to be some stale restoration happening , but seeking help as its haunting me now for a while.
Tried solr sync , but it works for then and there , and shows stale data the next day again .