Page MenuHomePhabricator

Make primary key ipblocks.ipb_id unsigned on wmf wikis
Closed, ResolvedPublic

Description

Apply ipblocks part of T297208 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/742800/13/maintenance/archives/patch-ipblocks-ipb_id.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: any time
  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: no change of the existing rules

Progress

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8
  • labtestwiki

Related Objects

Mentioned In
rSCHCHd0830fd8e8c5: change_ipb_id_T306269.py: New schema change
Mentioned Here
T301312: Switchover s1 master (db1118 -> db1163)
P25698 dbctl commit (dc=all): 'Repooling after maintenance db1135 (T306269)'
P25674 dbctl commit (dc=all): 'Repooling after maintenance db1135 (T306269)'
P25672 dbctl commit (dc=all): 'Depooling db1135 (T306269)'
P25659 dbctl commit (dc=all): 'Repooling after maintenance db1134 (T306269)'
P25658 dbctl commit (dc=all): 'Depooling db1134 (T306269)'
P25657 dbctl commit (dc=all): 'Repooling after maintenance db1119 (T306269)'
P25649 dbctl commit (dc=all): 'Repooling after maintenance db1119 (T306269)'
P25648 dbctl commit (dc=all): 'Depooling db1119 (T306269)'
P25647 dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T306269)'
P25621 dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T306269)'
P25619 dbctl commit (dc=all): 'Depooling db1099:3311 (T306269)'
P25580 dbctl commit (dc=all): 'Repooling after maintenance db1184 (T306269)'
P25579 dbctl commit (dc=all): 'Depooling db1184 (T306269)'
P25578 dbctl commit (dc=all): 'Repooling after maintenance db1164 (T306269)'
P25570 dbctl commit (dc=all): 'Repooling after maintenance db1164 (T306269)'
P25569 dbctl commit (dc=all): 'Depooling db1164 (T306269)'
P25568 dbctl commit (dc=all): 'Repooling after maintenance db1106 (T306269)'
P25562 dbctl commit (dc=all): 'Repooling after maintenance db1106 (T306269)'
P25561 dbctl commit (dc=all): 'Depooling db1106 (T306269)'
P25560 dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T306269)'
P25553 dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T306269)'
P25551 dbctl commit (dc=all): 'Depooling db1105:3311 (T306269)'
P25550 dbctl commit (dc=all): 'Repooling after maintenance db1163 (T306269)'
P25539 dbctl commit (dc=all): 'Repooling after maintenance db1163 (T306269)'
P25538 dbctl commit (dc=all): 'Depooling db1163 (T306269)'
P25537 dbctl commit (dc=all): 'Repooling after maintenance db1169 (T306269)'
P25522 dbctl commit (dc=all): 'Repooling after maintenance db1169 (T306269)'
P25521 dbctl commit (dc=all): 'Depooling db1169 (T306269)'
P25336 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T306269)'
P25327 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T306269)'
P25321 dbctl commit (dc=all): 'Depooling db1180 (T306269)'
P25320 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T306269)'
P25313 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T306269)'
P25312 dbctl commit (dc=all): 'Depooling db1098:3316 (T306269)'
P25311 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T306269)'
P25306 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T306269)'
P25305 dbctl commit (dc=all): 'Depooling db1131 (T306269)'
P25304 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T306269)'
P25297 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T306269)'
P25295 dbctl commit (dc=all): 'Depooling db1096:3316 (T306269)'
P25294 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T306269)'
P25282 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T306269)'
P25281 dbctl commit (dc=all): 'Depooling db1113:3316 (T306269)'
P25280 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T306269)'
P25269 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T306269)'
P25268 dbctl commit (dc=all): 'Depooling db1168 (T306269)'
P25267 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T306269)'
P25259 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T306269)'
P25258 dbctl commit (dc=all): 'Depooling db1165 (T306269)'
T297208: Make ipblocks.ipb_id unsigned in mysql

Event Timeline

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

Mentioned in SAL (#wikimedia-operations) [2022-04-19T08:31:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T306269)', diff saved to https://phabricator.wikimedia.org/P25280 and previous config saved to /var/cache/conftool/dbconfig/20220419-083151-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T08:32:02Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1113:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25281 and previous config saved to /var/cache/conftool/dbconfig/20220419-083159-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T08:36:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25282 and previous config saved to /var/cache/conftool/dbconfig/20220419-083623-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T09:21:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25294 and previous config saved to /var/cache/conftool/dbconfig/20220419-092138-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T09:21:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1096:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25295 and previous config saved to /var/cache/conftool/dbconfig/20220419-092146-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T09:27:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25297 and previous config saved to /var/cache/conftool/dbconfig/20220419-092710-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T10:12:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25304 and previous config saved to /var/cache/conftool/dbconfig/20220419-101225-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T10:12:42Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1131 (T306269)', diff saved to https://phabricator.wikimedia.org/P25305 and previous config saved to /var/cache/conftool/dbconfig/20220419-101233-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T10:14:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1131 (T306269)', diff saved to https://phabricator.wikimedia.org/P25306 and previous config saved to /var/cache/conftool/dbconfig/20220419-101433-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T10:59:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1131 (T306269)', diff saved to https://phabricator.wikimedia.org/P25311 and previous config saved to /var/cache/conftool/dbconfig/20220419-105948-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T11:07:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25312 and previous config saved to /var/cache/conftool/dbconfig/20220419-110710-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T11:10:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25313 and previous config saved to /var/cache/conftool/dbconfig/20220419-111046-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T11:56:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T306269)', diff saved to https://phabricator.wikimedia.org/P25320 and previous config saved to /var/cache/conftool/dbconfig/20220419-115601-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T11:56:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1180 (T306269)', diff saved to https://phabricator.wikimedia.org/P25321 and previous config saved to /var/cache/conftool/dbconfig/20220419-115609-marostegui.json

I have also done ruwiki on the master, by warming up the table first it wasn't locked for that long.

Deploying this on s3 master with replication enabled and a sleep. It will take around 8 hours to complete

This has finished

Mentioned in SAL (#wikimedia-operations) [2022-04-19T12:56:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T306269)', diff saved to https://phabricator.wikimedia.org/P25327 and previous config saved to /var/cache/conftool/dbconfig/20220419-125623-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-19T13:41:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T306269)', diff saved to https://phabricator.wikimedia.org/P25336 and previous config saved to /var/cache/conftool/dbconfig/20220419-134139-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T04:41:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1169 (T306269)', diff saved to https://phabricator.wikimedia.org/P25521 and previous config saved to /var/cache/conftool/dbconfig/20220420-044132-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T04:44:43Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T306269)', diff saved to https://phabricator.wikimedia.org/P25522 and previous config saved to /var/cache/conftool/dbconfig/20220420-044443-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T05:29:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T306269)', diff saved to https://phabricator.wikimedia.org/P25537 and previous config saved to /var/cache/conftool/dbconfig/20220420-052958-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T05:30:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1163 (T306269)', diff saved to https://phabricator.wikimedia.org/P25538 and previous config saved to /var/cache/conftool/dbconfig/20220420-053006-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T05:33:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T306269)', diff saved to https://phabricator.wikimedia.org/P25539 and previous config saved to /var/cache/conftool/dbconfig/20220420-053319-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T06:18:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T306269)', diff saved to https://phabricator.wikimedia.org/P25550 and previous config saved to /var/cache/conftool/dbconfig/20220420-061834-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T06:18:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3311 (T306269)', diff saved to https://phabricator.wikimedia.org/P25551 and previous config saved to /var/cache/conftool/dbconfig/20220420-061848-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T06:22:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T306269)', diff saved to https://phabricator.wikimedia.org/P25553 and previous config saved to /var/cache/conftool/dbconfig/20220420-062206-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T07:07:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T306269)', diff saved to https://phabricator.wikimedia.org/P25560 and previous config saved to /var/cache/conftool/dbconfig/20220420-070721-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T07:09:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T306269)', diff saved to https://phabricator.wikimedia.org/P25561 and previous config saved to /var/cache/conftool/dbconfig/20220420-070906-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T07:10:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T306269)', diff saved to https://phabricator.wikimedia.org/P25562 and previous config saved to /var/cache/conftool/dbconfig/20220420-071011-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T07:55:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T306269)', diff saved to https://phabricator.wikimedia.org/P25568 and previous config saved to /var/cache/conftool/dbconfig/20220420-075527-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T07:55:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1164 (T306269)', diff saved to https://phabricator.wikimedia.org/P25569 and previous config saved to /var/cache/conftool/dbconfig/20220420-075535-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T07:57:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1164 (T306269)', diff saved to https://phabricator.wikimedia.org/P25570 and previous config saved to /var/cache/conftool/dbconfig/20220420-075747-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T08:43:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1164 (T306269)', diff saved to https://phabricator.wikimedia.org/P25578 and previous config saved to /var/cache/conftool/dbconfig/20220420-084303-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T08:43:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T306269)', diff saved to https://phabricator.wikimedia.org/P25579 and previous config saved to /var/cache/conftool/dbconfig/20220420-084312-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T08:46:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T306269)', diff saved to https://phabricator.wikimedia.org/P25580 and previous config saved to /var/cache/conftool/dbconfig/20220420-084625-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T10:42:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3311 (T306269)', diff saved to https://phabricator.wikimedia.org/P25619 and previous config saved to /var/cache/conftool/dbconfig/20220420-104214-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T10:44:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T306269)', diff saved to https://phabricator.wikimedia.org/P25621 and previous config saved to /var/cache/conftool/dbconfig/20220420-104437-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T11:29:53Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T306269)', diff saved to https://phabricator.wikimedia.org/P25647 and previous config saved to /var/cache/conftool/dbconfig/20220420-112952-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T11:30:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1119 (T306269)', diff saved to https://phabricator.wikimedia.org/P25648 and previous config saved to /var/cache/conftool/dbconfig/20220420-113000-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T11:32:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T306269)', diff saved to https://phabricator.wikimedia.org/P25649 and previous config saved to /var/cache/conftool/dbconfig/20220420-113219-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T12:17:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T306269)', diff saved to https://phabricator.wikimedia.org/P25657 and previous config saved to /var/cache/conftool/dbconfig/20220420-121737-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T12:17:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1134 (T306269)', diff saved to https://phabricator.wikimedia.org/P25658 and previous config saved to /var/cache/conftool/dbconfig/20220420-121745-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T12:20:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T306269)', diff saved to https://phabricator.wikimedia.org/P25659 and previous config saved to /var/cache/conftool/dbconfig/20220420-122000-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T13:09:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T306269)', diff saved to https://phabricator.wikimedia.org/P25672 and previous config saved to /var/cache/conftool/dbconfig/20220420-130914-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T13:12:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T306269)', diff saved to https://phabricator.wikimedia.org/P25674 and previous config saved to /var/cache/conftool/dbconfig/20220420-131228-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-04-20T13:57:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T306269)', diff saved to https://phabricator.wikimedia.org/P25698 and previous config saved to /var/cache/conftool/dbconfig/20220420-135750-marostegui.json

s1 is done, only pending the master which is blocked on the switchover T301312

s1 is done, only pending the master which is blocked on the switchover T301312

Done

Marostegui updated the task description. (Show Details)