Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Register
  • Sign in
  • G gitlab-ce
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Metrics
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • nexedinexedi
  • gitlab-ce
  • Repository
You need to sign in or sign up before continuing.
  • gitlab-ce
  • db
  • structure.sql
Find file BlameHistoryPermalink
  • Luke Duncalfe's avatar
    Add PG trigger for has_external_issue_tracker · 2cc9f641
    Luke Duncalfe authored Jan 20, 2021
    We cache whether a project has an External Issue Tracker integration
    enabled in the `has_external_issue_tracker` column on `projects`. It
    will be `TRUE` if the project has any integration (a record in
    `services`) with a category of "issue_tracker" enabled.
    
    This was previously maintained with application code.
    
    This cache is easy to fall out of consistency when we fail to maintain
    it during bulk operations (including PostgreSQL cascading deletes
    https://gitlab.com/gitlab-org/gitlab/-/merge_requests/48163/) as
    mentioned in:
    
    - https://gitlab.com/gitlab-org/gitlab/-/issues/273574#note_457006686
    - https://gitlab.com/gitlab-org/gitlab/-/issues/289798
    
    As Ecosystem is increasingly changing integration data using bulk
    operations this has been changed to be maintained through a PostgreSQL
    trigger.
    
    https://gitlab.com/gitlab-org/gitlab/-/issues/290715
    https://gitlab.com/gitlab-org/gitlab/-/issues/289798
    2cc9f641
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7