Resource group sometimes stuck when a job failed with
`data_integrity_failure`. This commit adds the auto-recovery
method in the worker.

Changelog: fixed