Page MenuHomePhabricator
Create Task
Maniphest T298505

Recreate views for globaluser table
Closed, ResolvedPublic
Actions

Description

After {T297094: Add globaluser.gu_hidden_level column to production} the maintain views script needs to be rerun after merging: https://gerrit.wikimedia.org/r/743948 so the new column is selectable.

Details

SubjectRepoBranchLines +/-
clouddb: depool clouddb1018 to update viewsoperations/puppetproduction+4 -4
clouddb: repool clouddb1014.eqiad.wmnetoperations/puppetproduction+4 -4
Re-depool dbproxy1019 to update localuser table which I forgotoperations/puppetproduction+5 -5
Revert "clouddb: depool clouddb1014"operations/puppetproduction+5 -5
clouddb: depool clouddb1014operations/puppetproduction+5 -5
Customize query in gerrit

Related Objects
Search...

Event Timeline

• Marostegui created this task.Jan 4 2022, 7:53 AM
Restricted Application edited projects, added cloud-services-team (Kanban); removed cloud-services-team. · View Herald TranscriptJan 4 2022, 7:53 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Jan 4 2022, 4:31 PM
bd808 moved this task from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.
• nskaggs assigned this task to • razzi.Jan 4 2022, 5:17 PM

Razzi, I understand you got try help try one of these last month. If you're up for it, here's another one! Thanks for your help!

• nskaggs added a project: Data-Engineering.Jan 4 2022, 5:17 PM
• razzi added a comment.Jan 4 2022, 5:30 PM

Yeah I'll give it a go!

BTullis subscribed.Jan 4 2022, 5:30 PM
odimitrijevic triaged this task as Medium priority.Jan 5 2022, 12:23 AM
odimitrijevic added a project: Data-Engineering-Kanban.
odimitrijevic moved this task from Incoming (new tickets) to Datasets on the Data-Engineering board.
BTullis moved this task from Next Up to In Progress on the Data-Engineering-Kanban board.Jan 5 2022, 5:11 PM
gerritbot added a comment.Jan 5 2022, 6:37 PM

Change 751779 had a related patch set uploaded (by Razzi; author: Razzi):

[operations/puppet@production] clouddb: depool clouddb1013

https://gerrit.wikimedia.org/r/751779

gerritbot added a project: Patch-For-Review.Jan 5 2022, 6:37 PM
gerritbot added a comment.Jan 5 2022, 7:27 PM

Change 751779 merged by Razzi:

[operations/puppet@production] clouddb: depool clouddb1014

https://gerrit.wikimedia.org/r/751779

Stashbot added a comment.Jan 5 2022, 7:31 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-05T19:31:02Z] <razzi> reload haproxy on dbproxy1018 for T298505

Stashbot added a comment.Jan 5 2022, 7:41 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-05T19:41:12Z] <razzi> reload haproxy on dbproxy1019 (previously incorrectly reloaded dbproxy1018) for T298505

Maintenance_bot removed a project: Patch-For-Review.Jan 5 2022, 8:10 PM
gerritbot added a comment.Jan 5 2022, 8:30 PM

Change 751798 had a related patch set uploaded (by Razzi; author: Razzi):

[operations/puppet@production] Revert \"clouddb: depool clouddb1014\"

https://gerrit.wikimedia.org/r/751798

gerritbot added a project: Patch-For-Review.Jan 5 2022, 8:30 PM
gerritbot added a comment.Jan 5 2022, 8:37 PM

Change 751798 merged by Razzi:

[operations/puppet@production] Revert \"clouddb: depool clouddb1014\"

https://gerrit.wikimedia.org/r/751798

Stashbot added a comment.Jan 5 2022, 8:39 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-05T20:39:35Z] <razzi> reload haproxy on dbproxy1019 to repool clouddb1014 for T298505

gerritbot added a comment.Jan 5 2022, 8:49 PM

Change 751800 had a related patch set uploaded (by Razzi; author: Razzi):

[operations/puppet@production] Re-depool dbproxy1019 to update localuser table which I forgot

https://gerrit.wikimedia.org/r/751800

gerritbot added a comment.Jan 5 2022, 11:16 PM

Change 751800 merged by Razzi:

[operations/puppet@production] Re-depool dbproxy1019 to update localuser table which I forgot

https://gerrit.wikimedia.org/r/751800

Stashbot added a comment.Jan 5 2022, 11:26 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-05T23:26:09Z] <razzi> run sudo maintain-views --databases centralauth --debug --replace-all on clouddb1014 for T298505

gerritbot added a comment.Jan 5 2022, 11:42 PM

Change 751823 had a related patch set uploaded (by Razzi; author: Razzi):

[operations/puppet@production] clouddb: repool clouddb1014.eqiad.wmnet

https://gerrit.wikimedia.org/r/751823

gerritbot added a comment.Jan 5 2022, 11:43 PM

Change 751823 merged by Razzi:

[operations/puppet@production] clouddb: repool clouddb1014.eqiad.wmnet

https://gerrit.wikimedia.org/r/751823

gerritbot added a comment.Jan 5 2022, 11:46 PM

Change 751824 had a related patch set uploaded (by Razzi; author: Razzi):

[operations/puppet@production] clouddb: depool clouddb1018 to update views

https://gerrit.wikimedia.org/r/751824

Stashbot added a comment.Jan 5 2022, 11:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-05T23:50:34Z] <razzi> sudo systemctl reload haproxy on dbproxy1019 to repool clouddb1014 for T298505

gerritbot added a comment.Jan 6 2022, 12:11 AM

Change 751824 merged by Razzi:

[operations/puppet@production] clouddb: depool clouddb1018 to update views

https://gerrit.wikimedia.org/r/751824

Maintenance_bot removed a project: Patch-For-Review.Jan 6 2022, 1:10 AM
Stashbot added a comment.Jan 6 2022, 6:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-06T18:50:03Z] <razzi> run sudo maintain-views --databases centralauth --replace-all on clouddb1018 for T298505

Stashbot added a comment.Jan 6 2022, 7:02 PM

Mentioned in SAL (#wikimedia-operations) [2022-01-06T19:02:38Z] <razzi> systemctl restart haproxy on dbproxy1018 to repool clouddb1018 for T298505

• razzi closed this task as Resolved.Jan 6 2022, 7:04 PM

This is done. Took even more manual steps since I made some human errors; let's automate this!
https://phabricator.wikimedia.org/T297026

taavi mentioned this in T301674: Recreate views for globaluser table.Feb 14 2022, 12:59 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL