Page MenuHomePhabricator

Schema change for rc_this_oldid index
Closed, ResolvedPublic

Description

After T190444: Add index on rc_namespace, rc_title, rc_timestamp on recentchanges table It would be great to apply this change

From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes:

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/450083/2/maintenance/archives/patch-recentchanges-rc_this_oldid-index.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: ?
  4. If the schema change is backwards compatible: Yes.
  5. If the schema change has been tested already on some of the test/beta wikis: Tested in beta cluster
  6. if the data should be made available on the labs replicas and/or dumps: Yes, data in this table is public (unless the wiki is private which we don't replicate at all)

One note: This index might be already existing but under name of tmp_1 or tmp_2 or tmp_3. I don't know how complex renaming an index is but that'd be useful.

Progress:

s1

s2

s3

s4

s5

s6

s7

s8

wikitech

  • eqiad
  • codfw

Details

ProjectBranchLines +/-Subject
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+7 -7
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+12 -12
operations/mediawiki-configmaster+7 -7
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/puppetproduction+2 -2
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+8 -8
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
Show related patches Customize query in gerrit

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

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

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

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-13T06:16:58Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1086 T86338 T202167 (duration: 00m 51s)

Mentioned in SAL (#wikimedia-operations) [2018-12-13T06:17:07Z] <marostegui> Deploy schema change on db1086 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-13T06:38:20Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1086 T86338 T202167 (duration: 00m 51s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-13T06:45:09Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1079 T86338 T202167 (duration: 00m 53s)

Mentioned in SAL (#wikimedia-operations) [2018-12-13T06:46:13Z] <marostegui> Deploy schema change on db1079 with replication, lag will be generated on labsdb:s7 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-13T07:22:33Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1079 T86338 T202167 (duration: 00m 52s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-13T08:45:38Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1090:3317 T86338 T202167 (duration: 00m 53s)

Mentioned in SAL (#wikimedia-operations) [2018-12-13T08:45:44Z] <marostegui> Deploy schema change on db1090:3317 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-13T09:34:50Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1090:3317 T86338 T202167 (duration: 00m 51s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-13T09:59:56Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1101:3317 T86338 T202167 (duration: 00m 51s)

Mentioned in SAL (#wikimedia-operations) [2018-12-13T10:44:24Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1101:3317 T86338 T202167 (duration: 00m 51s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-14T05:55:08Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1094 T86338 T202167 (duration: 00m 47s)

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:10:19Z] <marostegui> Deployed schema change on db1094 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:14:12Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1094 T86338 T202167 (duration: 00m 44s)

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:14:20Z] <marostegui> Deploy schema change on db1062 (s7 primary master) T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:54:26Z] <marostegui> Deploy schema change on db2043 (s3 codfw master) - this will generate lag on s3 codfw T86338 T202167

s3 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1124
  • db1123
  • db1095
  • db1078
  • db1077
  • db1075

Mentioned in SAL (#wikimedia-operations) [2018-12-14T07:58:59Z] <marostegui> Deploy schema change on dbstore1002:s3 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-14T09:33:47Z] <marostegui> Deploy schema change on db1095:3313 T86338 T202167

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-17T06:28:21Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1123 T86338 T202167 (duration: 00m 46s)

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:15:57Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1123 T86338 T202167 (duration: 00m 45s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:21:44Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1077 T86338 T202167 (duration: 00m 45s)

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:21:52Z] <marostegui> Deploy schema change on db1077 with replication (lag will be generated on labsdb:s3) T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:47:13Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1077 T86338 T202167 (duration: 00m 45s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-12-18T06:07:07Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1078 T86338 T202167 (duration: 00m 45s)

Mentioned in SAL (#wikimedia-operations) [2018-12-18T06:07:11Z] <marostegui> Deploy schema change on db1078 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-18T07:49:10Z] <marostegui> Deploy schema change on db1075 (s3 master) T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2018-12-18T07:49:39Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1078 T86338 T202167 (duration: 00m 45s)

Mentioned in SAL (#wikimedia-operations) [2019-01-02T07:00:59Z] <marostegui> Deploy schema change on s1 codfw master (lag will be generated on s1 codfw) - T202167 T86338

enwiki has KEY tmp_1 (rc_this_oldid), which I am removing as part of this schema change so we only leave: KEY rc_this_oldid (rc_this_oldid)

s1 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • dbstore1001
  • db1124
  • db1119
  • db1114
  • db1106
  • db1105
  • db1099
  • db1089
  • db1083
  • db1080
  • db1067

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-02T11:23:42Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1099:3311 T86338 T202167 (duration: 00m 45s)

Mentioned in SAL (#wikimedia-operations) [2019-01-02T11:24:37Z] <marostegui> Deploy schema change on db1099:3311 - T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:01:12Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1099:3311 T86338 T202167 (duration: 00m 47s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:05:48Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1119 T86338 T202167 (duration: 00m 45s)

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:06:47Z] <marostegui> Deploy schema change on db1119 - T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:30:41Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1119 T86338 T202167 (duration: 00m 44s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-08T15:56:16Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1089 T86338 T202167 (duration: 00m 45s)

Mentioned in SAL (#wikimedia-operations) [2019-01-08T15:59:55Z] <marostegui> Deploy schema change on db1089 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-08T16:29:14Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1089 T86338 T202167 (duration: 00m 45s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-08T16:54:53Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1105:3311 T86338 T202167 (duration: 00m 44s)

Mentioned in SAL (#wikimedia-operations) [2019-01-08T16:54:58Z] <marostegui> Deploy schema change on db1105:3311 T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-08T18:28:45Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1105:3311 T86338 T202167 (duration: 00m 45s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-09T15:10:02Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1106 T86338 T202167 (duration: 00m 52s)

Mentioned in SAL (#wikimedia-operations) [2019-01-09T15:10:08Z] <marostegui> Deploy schema change on db1106 (sanitarium s1 master) with replication, lag will be generated on s1 labs - T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-09T15:34:56Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1106 T86338 T202167 (duration: 00m 51s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-09T16:29:15Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1083 T86338 T202167 (duration: 00m 53s)

Mentioned in SAL (#wikimedia-operations) [2019-01-09T16:29:34Z] <marostegui> Deploy schema change on db1083 - T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-09T17:05:28Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1083 T86338 T202167 (duration: 00m 52s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:33:05Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1114 T86338 T202167 (duration: 00m 53s)

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:33:12Z] <marostegui> Deploy schema change on db1114 - T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:55:42Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1114 T86338 T202167 (duration: 00m 52s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:59:14Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1080 T86338 T202167 (duration: 00m 52s)

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:59:18Z] <marostegui> Deploy schema change on db1080 - T86338 T202167

Mentioned in SAL (#wikimedia-operations) [2019-01-10T15:26:05Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1080 T86338 T202167 (duration: 00m 49s)

Mentioned in SAL (#wikimedia-operations) [2019-01-10T15:27:01Z] <marostegui> Deploy schema change on db1067 (s1 master) - T86338 T202167