cockroachdb / cockroachdb/cockroach
jobs: optimize pausing unclaimed jobs
Open
A-disaster-recovery
A-jobs
C-enhancement
O-postmortem
P-3
T-disaster-recovery
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
The database contains a `PAUSE JOBS ` command that can be used pause the execution of large numbers of jobs at once.
Pausing a job currently requires the job to transition through the following states:
`running` -> `pause requested` -> `pause`
If the job record is not claimed (i.e. there is no `claim_session_id`), we could go directly from `running` to `pause`. This is useful for incident remediation where a large number of jobs are preventing the system from claiming high priority jobs.
Jira issue: CRDB-50713
Epic CRDB-50858
Contributor guide
Assessment
This issue has not been assessed yet.