Database goals for April 11th, 2018

@abrandl:

• SQL query used for getting assigned issues is overly complex https://gitlab.com/gitlab-org/gitlab-ce/issues/37125
  • MR done: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18219
  • Also closed https://gitlab.com/gitlab-org/gitlab-ce/issues/37126 with the same change
• Cache User#personal_projects_count in Redis https://gitlab.com/gitlab-org/gitlab-ce/issues/37462

@_stark:

• Arrange/plan upgrade to 9.6.8 in gitlab.com #15 (closed)

  • Plan and document upgrade process and migrate knowledge from jtevnan to DB team
    • Continue testing in staging
    • Fix problems caused by hard-coded IP addresses in chef
    • Fix problem causing failure to do automatic failover after a switchover
    • Finish whole procedure in staging
  • Have a specific scheduled time for production upgrade -- possibly complete it this week?

• Polish up gitlab-org/omnibus-gitlab!2332 (closed)

  • Resolve review comments from richardc

• Change Postgres prefix to "9.6" - gitlab-org/omnibus-gitlab#3346 (closed)

  • Start work on MR

• Investigate high transaction rollback rate in GPRD

  • migration#292 (closed)

@yorickpeterse:

• https://gitlab.com/gitlab-org/gitlab-ce/issues/43048 (carried over from April 4th): take care of the problem mentioned in https://gitlab.com/gitlab-org/gitlab-ce/issues/43048#note_65779009
  • WIP MR: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18157
• https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18144: add the necessary database migrations/schema changes
• www-gitlab-com#2030 (closed): MR www-gitlab-com!11018 (merged)
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18153
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5039
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17839
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18169
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5157
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18197
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17894
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18009
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18219
• Make sure all tests pass for https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5308

Last week's goals: #6 (closed)

Next week's goals: #66 (closed)