Address cron_job table having entries that are stuck in pending stage (job_status = 3) and preventing subsequent crons from executing
Open
application
- Dominant language
- JavaScript
- Stars
- 12
- Forks
- 8
- Avg merge
- 23h 38m
- Merged PRs (30d)
- 15
Description
Currently, a cron checks the cron_job table for any cron jobs that are in the pending status (job_status = 3) and will not execute if it finds a job_status = 3 for the same job_type. It has happened with the Touchpoints cron (job_type = "TPI-JOB") that a job_status will not be updated from 3 for some reason because the job was interrupted.
We should have a handler in the code that reverts the job_status back to 4 after an hour (or however long the cron should take to execute + an hour) and to create a log in the cron_job table that a "manual" pending status update had to occur.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.