Database goals for March 21th, 2018

@abrandl:

• https://gitlab.com/gitlab-org/gitlab-ce/issues/44251 (dead end mostly)

Carried over from March 14 goals

• Internal IDs are not atomic https://gitlab.com/gitlab-org/gitlab-ce/issues/31114
• Fix concurrency issue with migration that builds user_interacted_projects table https://gitlab.com/gitlab-org/gitlab-ce/issues/44205

Picked up during the week

• Concurrent migration helpers https://gitlab.com/gitlab-org/gitlab-ce/issues/43887
• UserControllers#show timings increased https://gitlab.com/gitlab-org/gitlab-ce/issues/44446
  • MR: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17890
  • Fixed temporarily for gitlab.com

@_stark:

• Structured logging -- omnibus integration (will be opening new issues to break up json logging into subtasks), originally from March 7 [x] Broken up issue into steps
  • gitlab-org/omnibus-gitlab!2332 (comment 62951392)
  • semi-blocked on meeting with Marin about proceeding.
• Fix our alerting! (https://gitlab.com/gitlab-com/infrastructure/issues/3829 and refine the plan for https://gitlab.com/gitlab-com/infrastructure/issues/3853)
  • This turned out to not just be our alerting -- All alerting to slack was broken for over a week! Many tasks to make alerting more reliable:
  • gitlab-com/runbooks!534 (merged) (Enable pagerduty for most important database alerts)
  • https://gitlab.com/gitlab-com/infrastructure/issues/3853 gitlab-cookbooks/gitlab-mtail!3 (merged)
  • https://gitlab.com/gitlab-com/infrastructure/issues/3868 gitlab-com/runbooks!535 (merged)
• https://gitlab.com/gitlab-com/infrastructure/issues/2547: do some tests in staging to see what the data looks like and if it's useful

** Picked up during week**

• https://gitlab.com/gitlab-com/infrastructure/issues/3850 Postmortem for outage on commenting
• https://gitlab.com/gitlab-com/infrastructure/issues/3871 Redis cache cluster replication was broken
• https://gitlab.com/gitlab-org/gitlab-ce/issues/44470#note_64232242
• Investigate deadlocks seen in production:
  • problem is with board reordering: https://gitlab.com/gitlab-org/gitlab-ce/issues/44445

@yorickpeterse:

• gitlab-com/chatops#12 (closed)
  • Pending gitlab-com/chatops#12 (comment 63923187)
• Break gitlab-com/chatops#1 (closed) into smaller issues
• https://gitlab.com/gitlab-com/infrastructure/issues/3452
• Start planning the Q2 OKR: gitlab-com/www-gitlab-com#2008 (comment 64138434)
• Set up database user for chatops: gitlab-com/migration#261 (comment 64339286)
• gitlab-com/chatops#4 (closed)
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/4549

Last week's goals: https://gitlab.com/gitlab-com/infrastructure/issues/3809