Database goals for April 23, 2018

@abrandl:

• internal_ids can get of of sync if old code still runs during a deployment https://gitlab.com/gitlab-org/gitlab-ce/issues/45269
• Atomic ID generation for other models in https://gitlab.com/gitlab-org/gitlab-ce/issues/44259

@_stark:

• Arrange/plan upgrade to 9.6.8 in gitlab.com #15 (closed)
  • Running late due to production issues and release -- not until next Tuesday at earliest
  • Plan and document upgrade process and migrate knowledge from jtevnan to DB team
    • Continue testing in staging
    • Fix problem with chef running reconfigure unexpectedly
    • Finish whole procedure in staging
• Raise client_max_conn and add metrics and alerts for pgbouncer errors (#70 (closed))
  • https://dev.gitlab.org/cookbooks/chef-repo/merge_requests/1870
  • gitlab-cookbooks/gitlab-mtail!5 (merged)
  • runbooks!554 (merged)
• Polish up gitlab-org/omnibus-gitlab!2332 (closed)
  • Resolve review comments from richardc
• Polish up https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17196
  • Resolve review comments from @DylanGriffith
• Change Postgres prefix to "9.6" - gitlab-org/omnibus-gitlab#3346 (closed)
  • Start work on MR
• Add monitoring for slow lock logs (including trigram index bug): #68 (closed)
  • https://dev.gitlab.org/cookbooks/chef-repo/merge_requests/1853
  • gitlab-cookbooks/gitlab-exporters!10 (merged)

@yorickpeterse:

• Check the impact of Goldiloader being deployed on https://gitlab.com/gitlab-org/gitlab-ce/issues/43048
  • No clearly visible impact on this controller, though the maximum number of SQL queries across the board did go down per https://performance.gitlab.net/dashboard/db/transaction-overview?panelId=11&fullscreen&orgId=1&from=now-12h&to=now
• https://gitlab.com/gitlab-org/gitlab-ce/issues/43132
  • WIP MR: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18427
  • Didn't manage to look into this much more due to production issues and spending most Wednesday reverting Goldiloader (deep into the evening)
  • The MR includes one small fix, but there are several more problems that need to be looked into (and that I want to include in this MR).
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18402
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5390
• Adjust interviewing questions for the DB position (e.g. the CTE question is a bit too simple)
  • https://gitlab.com/gitlab-com/people-ops/applicant-questionnaires/merge_requests/49
  • https://gitlab.com/gitlab-com/people-ops/hiring-processes/merge_requests/47/diffs

Last week's goals: #66 (closed)