Skip to content
代码片段 群组 项目
  • Leonardo Rosa's avatar
    a3e02ea4
    Remove duplicated index from boards_epic_board_recent_visits · a3e02ea4
    Leonardo Rosa 创作于
    ## What does this MR do and why?
    
    Remove duplicated index from `boards_epic_board_recent_visits` table.
    
    ### It removes:
    
    Drop `index_boards_epic_board_recent_visits_on_user_id` as it's already covered by:
    | Index | Columns |
    | ----- | ------ |
    | `index_epic_board_recent_visits_on_user_group_and_board` | `user_id asc`, `group_id asc`, `epic_board_id asc` |
    
    It is possible that this MR will still need some changes to drop the index from the database.
    Currently, the `gitlab-housekeeper` is not always capable of removing all references, so you must check the diff and pipeline failures to confirm if there are any issues.
    Ensure that the index exists in the production database by checking Joe Bot trough https://console.postgres.ai/gitlab.
    If the index was already removed or if the index it's being removed in another merge request, consider closing this merge request.
    
    This change was generated by
    [gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
    using the Keeps::RemoveDuplicatedIndexes keep.
    
    To provide feedback on your experience with `gitlab-housekeeper` please comment in
    <https://gitlab.com/gitlab-org/gitlab/-/issues/442003>.
    
    Changelog: other
    a3e02ea4
    历史
    Remove duplicated index from boards_epic_board_recent_visits
    Leonardo Rosa 创作于
    ## What does this MR do and why?
    
    Remove duplicated index from `boards_epic_board_recent_visits` table.
    
    ### It removes:
    
    Drop `index_boards_epic_board_recent_visits_on_user_id` as it's already covered by:
    | Index | Columns |
    | ----- | ------ |
    | `index_epic_board_recent_visits_on_user_group_and_board` | `user_id asc`, `group_id asc`, `epic_board_id asc` |
    
    It is possible that this MR will still need some changes to drop the index from the database.
    Currently, the `gitlab-housekeeper` is not always capable of removing all references, so you must check the diff and pipeline failures to confirm if there are any issues.
    Ensure that the index exists in the production database by checking Joe Bot trough https://console.postgres.ai/gitlab.
    If the index was already removed or if the index it's being removed in another merge request, consider closing this merge request.
    
    This change was generated by
    [gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
    using the Keeps::RemoveDuplicatedIndexes keep.
    
    To provide feedback on your experience with `gitlab-housekeeper` please comment in
    <https://gitlab.com/gitlab-org/gitlab/-/issues/442003>.
    
    Changelog: other
代码所有者
将用户和群组指定为特定文件更改的核准人。 了解更多。