Migrate system_note_metadata.id to bigint
system_note_metadata.id
column is an int4 primary key currently exceeding 50% of saturation. As a result, that key must be migrated to a big int to ensure we don't exhaust potential values.
Capacity planning issue - https://gitlab.com/gitlab-com/gl-infra/capacity-planning/-/issues/1173.
Timeline
This process needs to be started ASAP - exhausting this column would cause serious harm to the running application.
Process
Following the process outlined here, we must:
Designs
- Show closed items
Activity
-
Newest first Oldest first
-
Show all activity Show comments only Show history only
- Krasimir Angelov added to epic &8070
added to epic &8070
- Krasimir Angelov changed the description
Compare with previous version changed the description
- Krasimir Angelov changed milestone to %16.4
changed milestone to %16.4
- Krasimir Angelov removed devopsdata stores label
removed devopsdata stores label
- 🤖 GitLab Bot 🤖 added devopsdata stores label
added devopsdata stores label
- Krasimir Angelov removed groupdatabase label
removed groupdatabase label
- Krasimir Angelov removed sectioncore platform label
removed sectioncore platform label
- 🤖 GitLab Bot 🤖 added sectioncore platform label
added sectioncore platform label
- Krasimir Angelov removed workflowin review label
removed workflowin review label
- Krasimir Angelov removed twtriaged label
removed twtriaged label
- Krasimir Angelov removed sectioncore platform label
removed sectioncore platform label
- 🤖 GitLab Bot 🤖 added sectioncore platform label
added sectioncore platform label
- Krasimir Angelov removed Category:Database label
removed Category:Database label
- Krasimir Angelov removed missed:15.10 label
removed missed:15.10 label
- Krasimir Angelov removed missed:16.3 label
removed missed:16.3 label
- Krasimir Angelov removed missed:16.2 label
removed missed:16.2 label
- Krasimir Angelov removed missed:16.1 label
removed missed:16.1 label
- Krasimir Angelov removed missed:16.0 label
removed missed:16.0 label
- Krasimir Angelov removed missed:15.11 label
removed missed:15.11 label
- Krasimir Angelov marked the checklist item Initialize the conversion (release N) as incomplete
marked the checklist item Initialize the conversion (release N) as incomplete
- Krasimir Angelov marked the checklist item Swap the columns (release N + 1) as incomplete
marked the checklist item Swap the columns (release N + 1) as incomplete
- Krasimir Angelov marked the checklist item Remove the trigger and old integer columns (release N + 2) as incomplete
marked the checklist item Remove the trigger and old integer columns (release N + 2) as incomplete
- Krasimir Angelov marked the checklist item Remove ignore rules (release N + 3) as incomplete
marked the checklist item Remove ignore rules (release N + 3) as incomplete
- Krasimir Angelov added groupproject management label
added groupproject management label
- 🤖 GitLab Bot 🤖 added devopsplan sectiondev labels and removed devopsdata stores sectioncore platform labels
added devopsplan sectiondev labels and removed devopsdata stores sectioncore platform labels
- Bob Van Landuyt mentioned in commit gitlab-com/runbooks@a08313dd
mentioned in commit gitlab-com/runbooks@a08313dd
- Bob Van Landuyt mentioned in commit gitlab-com/runbooks@fef9e68a
mentioned in commit gitlab-com/runbooks@fef9e68a
- Bob Van Landuyt mentioned in merge request gitlab-com/runbooks!6237 (merged)
mentioned in merge request gitlab-com/runbooks!6237 (merged)
- Maintainer
Setting label(s) Category:Team Planning based on groupproject management.
- 🤖 GitLab Bot 🤖 added Category:Team Planning label
added Category:Team Planning label
- Bob Van Landuyt mentioned in commit gitlab-com/runbooks@ab3f4211
mentioned in commit gitlab-com/runbooks@ab3f4211
- Alex Ives added GitLab.com Resource Saturation label
added GitLab.com Resource Saturation label
FYI @donaldcook - We created this issue based on this alert from the infrastructure team. The process for migrating these is well documented, but has to be spread over 4 milestones due to the nature of the background migrations. Additionally, since it takes so long to mitigate, it's best to resolve this early.
Collapse replies - Developer
@donaldcook, like @alexives commented, the procedure is well-documented. I would expect each task (per milestone) to be weight 1 or less (following the new weighting system https://gitlab.com/gitlab-org/plan-stage/product/-/issues/14.)
- Alex Ives mentioned in issue gitlab-org/database-team/team-tasks#374 (closed)
mentioned in issue gitlab-org/database-team/team-tasks#374 (closed)
- Donald Cook changed milestone to %16.5
changed milestone to %16.5
- Donald Cook added workflowplanning breakdown label
added workflowplanning breakdown label
- Author Maintainer
system_note_metadata
is referenced byresource_link_events
, fortunatelyresource_link_events.system_note_metadata_id
is already bigint, so no need to convert. We still have to recreate thefk_2a039c40f4
FK. - Donald Cook mentioned in issue #416207 (closed)
mentioned in issue #416207 (closed)
- euko mentioned in merge request !135322 (merged)
mentioned in merge request !135322 (merged)
- euko added #429627 (closed) as child task
added #429627 (closed) as child task
- euko added #429628 (closed) as child task
added #429628 (closed) as child task
- euko added #429629 (closed) as child task
added #429629 (closed) as child task
- euko changed the description
Compare with previous version changed the description
- euko added workflowin dev label and removed workflowplanning breakdown label
added workflowin dev label and removed workflowplanning breakdown label
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#14676 (closed)
mentioned in issue gitlab-org/quality/triage-reports#14676 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#14794 (closed)
mentioned in issue gitlab-org/quality/triage-reports#14794 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#14889 (closed)
mentioned in issue gitlab-org/quality/triage-reports#14889 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#14960 (closed)
mentioned in issue gitlab-org/quality/triage-reports#14960 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15056 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15056 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15170 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15170 (closed)
- 🤖 GitLab Bot 🤖 added 1 deleted label
added 1 deleted label
- euko mentioned in merge request !138610 (merged)
mentioned in merge request !138610 (merged)
- euko mentioned in issue #429611 (closed)
mentioned in issue #429611 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15265 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15265 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15385 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15385 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15481 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15481 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15548 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15548 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15689 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15689 (closed)
- euko mentioned in merge request !141220 (merged)
mentioned in merge request !141220 (merged)
- euko mentioned in merge request !141330 (merged)
mentioned in merge request !141330 (merged)
- euko mentioned in merge request !141331 (merged)
mentioned in merge request !141331 (merged)
- euko mentioned in merge request !141333 (merged)
mentioned in merge request !141333 (merged)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15813 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15813 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15886 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15886 (closed)
- euko mentioned in issue #427975 (closed)
mentioned in issue #427975 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15996 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15996 (closed)
- euko mentioned in merge request !143344 (merged)
mentioned in merge request !143344 (merged)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16166 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16166 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16269 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16269 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16352 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16352 (closed)
- euko mentioned in merge request !145125 (merged)
mentioned in merge request !145125 (merged)
- euko added workflowin review label and removed workflowin dev label
added workflowin review label and removed workflowin dev label
- Donald Cook added Deliverable label
added Deliverable label
- euko added workflowverification label and removed workflowin review label
added workflowverification label and removed workflowin review label
- euko added workflowcomplete label and removed workflowverification label
added workflowcomplete label and removed workflowverification label
- euko closed
closed
- euko mentioned in merge request gitlab-com/content-sites/handbook!3879 (closed)
mentioned in merge request gitlab-com/content-sites/handbook!3879 (closed)