We did not change the refresh interval in the bulk load. Yes we manually refresh the table and then run flush/sync but it failed because of some pending operations. The thing is I can even see the document which was published a few weeks ago. Not sure the reason why es failed to delete the in the deleting process followed by the bulk load.