Page MenuHomePhabricator
Create Task
Maniphest T180045

Review and deploy schema change on dropping oresc_rev_predicted_model index
Closed, ResolvedPublic
Actions

Description

s1

  • enwiki

s2

  • cswiki
  • fiwiki
  • nlwiki
  • plwiki
  • ptwiki
  • trwiki

s3

  • etwiki
  • sqwiki

s5

  • wikidatawiki

s6

  • frwiki
  • ruwiki

s7

  • fawiki
  • hewiki
  • rowiki

Details

ProjectBranchLines +/-Subject
operations/mediawiki-configmaster+1 -1db-eqiad.php: Depool db1089
Customize query in gerrit

Related Objects
Search...

Event Timeline

• Ladsgroup removed • Ladsgroup as the assignee of this task.Nov 8 2017, 3:55 PM
• Ladsgroup created this task.
• Ladsgroup added a project: DBA.
Marostegui moved this task from Triage to Pending comment on the DBA board.Nov 8 2017, 4:39 PM
Marostegui updated the task description. (Show Details)Nov 8 2017, 5:04 PM
Marostegui claimed this task.Nov 13 2017, 7:24 AM
Marostegui moved this task from Pending comment to In progress on the DBA board.
awight moved this task from Parked to Pending deployment on the Machine-Learning-Team (Active Tasks) board.Nov 13 2017, 11:12 PM
Marostegui added a comment.Nov 21 2017, 8:39 AM

I have dropped the index on enwikion db1089, and will leave it for a day or so, to make sure nothing really uses it (ie: FORCE INDEX) before going ahead and starting to drop it across the board.

Stashbot added a subscriber: Stashbot.Nov 21 2017, 8:39 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-21T08:39:28Z] <marostegui> Drop index on db1089 enwiki.ores_classification - T180045

Stashbot added a comment.Nov 22 2017, 7:48 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-22T07:48:48Z] <marostegui> Drop index from ores_classification on s7 - T180045

Marostegui updated the task description. (Show Details)Nov 22 2017, 7:48 AM
Stashbot added a comment.Nov 22 2017, 7:50 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-22T07:50:21Z] <marostegui> Drop index from ores_classification on s6 - T180045

Marostegui updated the task description. (Show Details)Nov 22 2017, 7:50 AM
Stashbot added a comment.Nov 22 2017, 7:56 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-22T07:56:22Z] <marostegui> Drop index from ores_classification on s3 - T180045

Marostegui updated the task description. (Show Details)Nov 22 2017, 7:56 AM
Stashbot added a comment.Nov 22 2017, 10:51 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-22T10:51:16Z] <marostegui> Drop index from ores_classification on s5 - T180045

Marostegui updated the task description. (Show Details)Nov 22 2017, 10:51 AM
gerritbot added a comment.Nov 23 2017, 6:48 AM

Change 393016 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1089

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

gerritbot added a project: Patch-For-Review.Nov 23 2017, 6:48 AM
gerritbot added a comment.Nov 23 2017, 6:51 AM

Change 393016 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1089

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

Stashbot added a comment.Nov 23 2017, 6:53 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-23T06:53:04Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1089 - T180045 (duration: 00m 45s)

Stashbot added a comment.Nov 23 2017, 6:53 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-23T06:53:11Z] <marostegui> Drop index on ores_classification on s2 - T180045

Marostegui updated the task description. (Show Details)Nov 23 2017, 6:54 AM
Stashbot added a comment.Nov 23 2017, 6:55 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-23T06:55:04Z] <marostegui> Drop index on ores_classification on s1 - T180045

Marostegui updated the task description. (Show Details)Nov 23 2017, 6:55 AM
Stashbot added a comment.Nov 23 2017, 6:58 AM

Mentioned in SAL (#wikimedia-operations) [2017-11-23T06:58:57Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Repool db1089 - T180045 (duration: 00m 45s)

Marostegui closed this task as Resolved.Nov 23 2017, 6:59 AM

All done

awight moved this task from Pending deployment to Completed on the Machine-Learning-Team (Active Tasks) board.Nov 28 2017, 5:22 PM
awight mentioned this in Blog Post: Status Update (January 30, 2018).Jan 30 2018, 7:03 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