Page MenuHomePhabricator
Create Task
Maniphest T383491

Deploy new file tables in production
Closed, ResolvedPublic
Actions

Description

  • Add them to the table catalog
  • Add the views
  • Deploy the views
  • Roll out the new tables to production
  • set ROW_FORMAT=COMPRESSED to filerevision (file shouldn't need it)

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
P:wmcs: wikireplicas: Fix fr_actor not being exposedoperations/puppetproduction+1 -1
Add new file tables to WMCS viewsoperations/puppetproduction+36 -0
Customize query in gerrit

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
OpenLadsgroupT28741 Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)
ResolvedLadsgroupT383491 Deploy new file tables in production
· · ·

Event Timeline

Ladsgroup created this task.Jan 11 2025, 6:05 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 11 2025, 6:05 PM
Ladsgroup moved this task from Triage to In progress on the DBA board.Jan 11 2025, 6:15 PM
gerritbot added a comment.Jan 11 2025, 6:35 PM

Change #1110046 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] Add new file tables to WMCS views

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

gerritbot added a project: Patch-For-Review.Jan 11 2025, 6:35 PM
Ladsgroup updated the task description. (Show Details)Jan 11 2025, 7:16 PM
fnegri subscribed.Jan 13 2025, 10:35 AM
fnegri added a project: Data-Engineering.Jan 13 2025, 11:07 AM
Ottomata moved this task from Incoming (new tickets) to Tag with Radar on the Data-Engineering board.Jan 14 2025, 7:01 PM
Ottomata added a project: Data-Engineering-Radar.
Ladsgroup updated the task description. (Show Details)Jan 22 2025, 12:40 PM
gerritbot added a comment.Jan 22 2025, 12:51 PM

Change #1110046 merged by Ladsgroup:

[operations/puppet@production] Add new file tables to WMCS views

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

Ladsgroup updated the task description. (Show Details)Jan 22 2025, 12:58 PM
Ladsgroup updated the task description. (Show Details)Jan 22 2025, 1:01 PM
fnegri claimed this task.Jan 22 2025, 1:17 PM
fnegri removed a project: Data-Engineering-Radar.

Thanks @Ladsgroup for reviewing and merging, I'm gonna run the update-views cookbook, following https://wikitech.wikimedia.org/wiki/Portal:Data_Services/Admin/Runbooks/Deploy_wiki_replicas_view_change

Maintenance_bot removed a project: Patch-For-Review.Jan 22 2025, 1:30 PM
Ladsgroup updated the task description. (Show Details)Jan 22 2025, 1:31 PM
fnegri reassigned this task from fnegri to Ladsgroup.Jan 22 2025, 1:32 PM

Reassigning it to @Ladsgroup as he's already on it!

Ladsgroup closed this task as Resolved.Jan 22 2025, 2:08 PM
Ladsgroup moved this task from In progress to Done on the DBA board.
In T383491#10483908, @fnegri wrote:

Reassigning it to @Ladsgroup as he's already on it!

Sorry I stepped on your toes, I missed the comment and didn't want to add more work for you so I just ran the bash myself.

fnegri added a comment.Jan 22 2025, 2:33 PM

That's ok! The exact workflow for these changes is still unclear to everyone, I'm doing my best to clarify it, see T382607: Decision request - Who runs wikireplicas cookbooks.

gerritbot added a comment.Mar 16 2025, 4:31 PM

Change #1128041 had a related patch set uploaded (by Majavah; author: Majavah):

[operations/puppet@production] P:wmcs: wikireplicas: Fix fr_actor not being exposed

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

gerritbot added a project: Patch-For-Review.Mar 16 2025, 4:31 PM
gerritbot added a comment.Mar 17 2025, 10:45 AM

Change #1128041 merged by Ladsgroup:

[operations/puppet@production] P:wmcs: wikireplicas: Fix fr_actor not being exposed

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

Maintenance_bot removed a project: Patch-For-Review.Mar 17 2025, 11:31 AM
ops-monitoring-bot added a comment.Mar 17 2025, 11:43 AM

Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views

ops-monitoring-bot added a comment.Mar 17 2025, 11:52 AM

Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup completed:

  • an-redacteddb1001.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1017.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1018.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1019.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1020.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1013.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1014.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1015.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
  • clouddb1016.eqiad.wmnet (PASS)
    • Ran Puppet agent
    • Ran 'maintain-views --replace-all --auto-depool --all-databases --table filerevision'
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 · Credits