I have an employeeId as primary key, we are doing a full index everyday running on master and deltaIndex every 5 min. Using master/slave replication copying every 1 min to slave. Sometimes we are getting duplicate employee records with same employeeId while querying the index. Could someone let me know if there is anything wrong we are doing, The only possibility I can think of is deltaIndex overlapping while fullIndex is running.

Once we get the duplicate query results issue, the issue is fixed if we run fullIndex one more time. any suggestion to avoid duplicate records will be helpful.

Thanks
L