Ensure id uniqueness on `p_ci_pipelines`
Before writing to multiple partitions on p_ci_pipelines
we must ensure at the database level that users/developers can't generate duplicate ids. This was done on p_ci_builds
using a trigger to always assign the id from the database sequence, even if it was provided by the application.
- Similar to !142526 (merged)
Designs
- Show closed items
Blocks
- #482673Next 1-3 releases
Relates to
Activity
-
Newest first Oldest first
-
Show all activity Show comments only Show history only
- Caroline Simpson added to epic &11803
added to epic &11803
- Caroline Simpson marked #429940 (closed) as a duplicate of this issue
marked #429940 (closed) as a duplicate of this issue
- Caroline Simpson marked this issue as related to #429940 (closed)
marked this issue as related to #429940 (closed)
- Caroline Simpson set weight to 2
set weight to 2
- Caroline Simpson changed the description
Compare with previous version changed the description
- Caroline Simpson removed needs weight label
removed needs weight label
- Caroline Simpson added cicdactive label and removed cicdplanning label
added cicdactive label and removed cicdplanning label
- Caroline Simpson added workflowready for development label and removed workflowplanning breakdown label
added workflowready for development label and removed workflowplanning breakdown label
- Marius Bobin mentioned in epic &7522
mentioned in epic &7522
- Alex Ives mentioned in issue gitlab-org/database-team/team-tasks#384 (closed)
mentioned in issue gitlab-org/database-team/team-tasks#384 (closed)
- Caroline Simpson changed the description
Compare with previous version changed the description
- Caroline Simpson changed the description
Compare with previous version changed the description
- Caroline Simpson changed milestone to %17.0
changed milestone to %17.0
- Caroline Simpson changed milestone to %Next 4-6 releases
changed milestone to %Next 4-6 releases
- Caroline Simpson changed milestone to %17.2
changed milestone to %17.2
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#15997 (closed)
mentioned in issue gitlab-org/quality/triage-reports#15997 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16167 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16167 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16270 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16270 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16353 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16353 (closed)
- Max Orefice changed the description
Compare with previous version changed the description
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16459 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16459 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16628 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16628 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16729 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16729 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16812 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16812 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16918 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16918 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#16997 (closed)
mentioned in issue gitlab-org/quality/triage-reports#16997 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#17190 (closed)
mentioned in issue gitlab-org/quality/triage-reports#17190 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#17270 (closed)
mentioned in issue gitlab-org/quality/triage-reports#17270 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#17346 (closed)
mentioned in issue gitlab-org/quality/triage-reports#17346 (closed)
- 🤖 GitLab Bot 🤖 mentioned in issue gitlab-org/quality/triage-reports#17445 (closed)
mentioned in issue gitlab-org/quality/triage-reports#17445 (closed)
- Caroline Simpson added groupci platform label and removed grouppipeline execution label
added groupci platform label and removed grouppipeline execution label
- 🤖 GitLab Bot 🤖 changed milestone to %17.3
changed milestone to %17.3
- 🤖 GitLab Bot 🤖 added missed:17.2 label
added missed:17.2 label
- Marius Bobin changed milestone to %17.5
changed milestone to %17.5
- Marius Bobin added workflowblocked label and removed workflowready for development label
added workflowblocked label and removed workflowready for development label
- Tianwen Chen marked this issue as blocking #482673 (closed)
marked this issue as blocking #482673 (closed)
- Tianwen Chen mentioned in merge request !164707 (merged)
mentioned in merge request !164707 (merged)
- Tianwen Chen assigned to @tianwenchen
assigned to @tianwenchen
- Tianwen Chen added workflowin review label and removed workflowblocked label
added workflowin review label and removed workflowblocked label
- Tianwen Chen changed milestone to %Next 1-3 releases
changed milestone to %Next 1-3 releases
- Tianwen Chen added workflowcomplete label and removed workflowin review label
added workflowcomplete label and removed workflowin review label
- Maintainer
See https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/33580/commands/103329
p_ci_pipelines.id
's default value is removed andassign_p_ci_pipelines_id_trigger
is added to updatep_ci_pipelines.id
onINSERT
. 1 - Tianwen Chen closed
closed