Skip to content

jobs: migration to add job_type causes too much contention #105663

Closed
Closed
jobs: migration to add job_type causes too much contention#105663
Assignees
jayshrivastava
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.branch-release-23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1
@jayshrivastava

Description

@jayshrivastava
jayshrivastava
opened on Jun 27, 2023

See https://cockroachlabs.slack.com/archives/C04N0AS14CT/p1687897409947369.

The migration which adds job_type to system.jobs attempts to do it on one transaction. This locks up the whole jobs table. We should batch these updates.

Jira issue: CRDB-29143

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.branch-release-23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions