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

ProjectBranchLines +/-Subject
operations/puppetproduction+4 -4clouddb: depool clouddb1018 to update views
operations/puppetproduction+4 -4clouddb: repool clouddb1014.eqiad.wmnet
operations/puppetproduction+5 -5Re-depool dbproxy1019 to update localuser table which I forgot
operations/puppetproduction+5 -5Revert "clouddb: depool clouddb1014"
operations/puppetproduction+5 -5clouddb: depool clouddb1014
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 added a subscriber: BTullis.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 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 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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