Change advisory lock in Data pruning to non-blocking.

In case of lock it'll add tenant to incompleted_tenants and tries it next round. 

It'll speed up the job in case of long running rollups