[Core] Add retry for insertion logic to make the load process more robust

The default behavior is NO RETRY, which is the current behavior.

But optionally user can enable retry if they are working with a DB backend that is better tolerated by allowing a few retries.