Background jobs are getting deleted due to lock table overflow.
We are facing critical problem in production whenever lock table overflow issue occurred suddenly some critical jobs are getting deleted and it is effecting business badly. When we check system log getting the below:
Failed to reschedule a periodic job
> job ... AUTO-DELIVER
> Unable to generate ID number for job
Help us on how to resolve this issue for not to delete any job and why the jobs are getting deleted, we have also increased
enque/table_size=16000 to 32000 now changed to 64000.
When we have changed from 16000 to 32000 also many jobs are got deleted.