Track bigint conversion work for `deployments`, `deployment_clusters`, and `deployment_merge_requests`. For the integer-to-bigint migration process and release ordering, see [Integer primary keys to bigint](https://docs.gitlab.com/development/database/avoiding_downtime_in_migrations/#migrating-integer-primary-keys-to-bigint). ## Status | Table | Parent work item | Current state | Next step | | --- | --- | --- | --- | | `deployments` | https://gitlab.com/gitlab-org/gitlab/-/work_items/551602 | All four canonical columns use bigint. The release N+2 cleanup shipped in GitLab 19.4 and is verified on production. The model ignore rules were removed in GitLab 19.5. | None. Conversion complete. | | `deployment_clusters` | https://gitlab.com/gitlab-org/gitlab/-/work_items/581417 | Canonical `deployment_id` and `cluster_id` use bigint. The release N+2 cleanup shipped in GitLab 19.4 and is verified on production. The model ignore rules were removed in GitLab 19.5. | None. Conversion complete. | | `deployment_merge_requests` | https://gitlab.com/gitlab-org/gitlab/-/work_items/581419 | All three canonical columns use bigint. The swap and the removal of the temporary indexes and foreign keys shipped in GitLab 19.5 and are verified on production. | Remove the conversion artifacts in GitLab 19.6: https://gitlab.com/gitlab-org/gitlab/-/work_items/627123. | ## Completed in milestone 19.4 - `deployments` release N+2 cleanup: https://gitlab.com/gitlab-org/gitlab/-/work_items/551605, shipped by https://gitlab.com/gitlab-org/gitlab/-/merge_requests/252750. - `deployment_clusters` release N+2 cleanup: https://gitlab.com/gitlab-org/gitlab/-/work_items/627120, shipped by https://gitlab.com/gitlab-org/gitlab/-/merge_requests/252927. - First `deployment_merge_requests` preparation step: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/252939, which finalizes the backfill, adds synchronous bigint indexes, and creates the three `NOT VALID` foreign keys. - Queue the `deployment_merge_requests` bigint foreign key validations: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/253469. ## Completed in milestone 19.5 - `deployment_merge_requests` column swap: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/255297, reached production on 15 September 2026. Preparation tracked in https://gitlab.com/gitlab-org/gitlab/-/work_items/581430. - Restore of the `deployment_id` index that the swap consumed: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/256063. - Removal of the six temporary indexes and foreign keys: https://gitlab.com/gitlab-org/gitlab/-/work_items/581431, shipped by https://gitlab.com/gitlab-org/gitlab/-/merge_requests/255903, reached production on 22 September 2026. - Removal of the `Deployment` ignore rules, the release N+3 step: https://gitlab.com/gitlab-org/gitlab/-/work_items/551606, shipped by https://gitlab.com/gitlab-org/gitlab/-/merge_requests/257469 on 24 September 2026. - Removal of the `DeploymentCluster` ignore rules, the release N+3 step: https://gitlab.com/gitlab-org/gitlab/-/work_items/627121, shipped by https://gitlab.com/gitlab-org/gitlab/-/merge_requests/257471 on 24 September 2026. - Correction of the `DeploymentMergeRequest` ignore rule removal target: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/257473, merged on 24 September 2026. The rule moved from `remove_with: '18.5', remove_after: '2025-11-01'` to `remove_with: '19.7', remove_after: '2026-11-14'`. The old values were stale and wrong; the three `*_convert_to_bigint` shadow columns are still in production. ## Remaining work ### `deployment_merge_requests` conversion The release ladder is fixed: | Step | Milestone | Tracking | | --- | --- | --- | | N+1 column swap | 19.5 | https://gitlab.com/gitlab-org/gitlab/-/merge_requests/255297, production on 15 September 2026 | | N+2 remove trigger and integer columns | 19.6 | https://gitlab.com/gitlab-org/gitlab/-/work_items/627123 | | N+3 remove ignore rules | 19.7 | https://gitlab.com/gitlab-org/gitlab/-/work_items/627122 | Milestone 19.7 opens on 2026-11-14. ## Trigger ownership Bigint cleanup must remove only the synchronization trigger for the relevant conversion. - `deployments`: `trigger_a2cc844b73ed` removed in GitLab 19.4. - `deployment_clusters`: `trigger_c08229f1c143` removed in GitLab 19.4. Project sharding-key trigger `trigger_ad05b7ebe49b` retained. - `deployment_merge_requests`: Retain bigint synchronization trigger `trigger_b472fca0a1da` until the release N+2 cleanup. Retain project sharding-key trigger `trigger_cfbec3f07e2b`.