Page MenuHomePhabricator

Make ipblocks_restrictions.ir_value unsigned on wmf wikis
Closed, ResolvedPublic

Description

Apply T297212 to wmf wikis

The column is part of the primary key

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/742820/10/maintenance/archives/patch-ipblocks_restrictions-ir_value.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

Related Objects

Mentioned In
rSCHCH49d59da6acea: change_ir_value_T300382.py: Fixes
rSCHCH95a514eb4d98: change_ir_value_T300382.py: New schema change
Mentioned Here
P20662 dbctl commit (dc=all): 'Repooling after maintenance db1175 (T300382)'
P20655 dbctl commit (dc=all): 'Repooling after maintenance db1175 (T300382)'
P20653 dbctl commit (dc=all): 'Depooling db1175 (T300382)'
P20652 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T300382)'
P20646 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T300382)'
P20645 dbctl commit (dc=all): 'Depooling db1179 (T300382)'
P20644 dbctl commit (dc=all): 'Repooling after maintenance db1166 (T300382)'
P20640 dbctl commit (dc=all): 'Repooling after maintenance db1166 (T300382)'
P20639 dbctl commit (dc=all): 'Depooling db1166 (T300382)'
P20638 dbctl commit (dc=all): 'Repooling after maintenance db1112 (T300382)'
P20635 dbctl commit (dc=all): 'Repooling after maintenance db1112 (T300382)'
P20634 dbctl commit (dc=all): 'Depooling db1112 (T300382)'
P20633 dbctl commit (dc=all): 'Repooling after maintenance db1123 (T300382)'
P20630 dbctl commit (dc=all): 'Repooling after maintenance db1123 (T300382)'
P20629 dbctl commit (dc=all): 'Depooling db1123 (T300382)'
P20576 dbctl commit (dc=all): 'Repooling after maintenance db1181 (T300382)'
P20565 dbctl commit (dc=all): 'Repooling after maintenance db1181 (T300382)'
P20556 dbctl commit (dc=all): 'Depooling db1181 (T300382)'
P20555 dbctl commit (dc=all): 'Repooling after maintenance db1158 (T300382)'
P20551 dbctl commit (dc=all): 'Repooling after maintenance db1158 (T300382)'
P20550 dbctl commit (dc=all): 'Depooling db1158 (T300382)'
P20549 dbctl commit (dc=all): 'Repooling after maintenance db1174 (T300382)'
P20543 dbctl commit (dc=all): 'Repooling after maintenance db1174 (T300382)'
P20537 dbctl commit (dc=all): 'Depooling db1174 (T300382)'
P20536 dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T300382)'
P20532 dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T300382)'
P20530 dbctl commit (dc=all): 'Depooling db1170:3317 (T300382)'
P20529 dbctl commit (dc=all): 'Repooling after maintenance db1127 (T300382)'
P20525 dbctl commit (dc=all): 'Repooling after maintenance db1127 (T300382)'
P20523 dbctl commit (dc=all): 'Depooling db1127 (T300382)'
P20522 dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T300382)'
P20516 dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T300382)'
P20515 dbctl commit (dc=all): 'Depooling db1101:3317 (T300382)'
P20514 dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T300382)'
P20509 dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T300382)'
P20508 dbctl commit (dc=all): 'Depooling db1098:3317 (T300382)'
P20502 dbctl commit (dc=all): 'Depooling db1113:3316 (T300382)'
P20501 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T300382)'
P20497 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T300382)'
P20496 dbctl commit (dc=all): 'Depooling db1168 (T300382)'
P20495 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T300382)'
P20488 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T300382)'
P20487 dbctl commit (dc=all): 'Depooling db1096:3316 (T300382)'
P20486 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T300382)'
P20483 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T300382)'
P20482 dbctl commit (dc=all): 'Depooling db1165 (T300382)'
P20481 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T300382)'
P20473 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T300382)'
P20472 dbctl commit (dc=all): 'Depooling db1180 (T300382)'
P20471 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T300382)'
P20463 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T300382)'
P20460 dbctl commit (dc=all): 'Depooling db1098:3316 (T300382)'
P20459 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T300382)'
P20453 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T300382)'
P20452 dbctl commit (dc=all): 'Depooling db1131 (T300382)'
T297212: Make core database fields which references to page_id unsigned in mysql and sqlite

Event Timeline

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

Mentioned in SAL (#wikimedia-operations) [2022-02-10T09:48:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T300382)', diff saved to https://phabricator.wikimedia.org/P20497 and previous config saved to /var/cache/conftool/dbconfig/20220210-094802-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T10:33:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T300382)', diff saved to https://phabricator.wikimedia.org/P20501 and previous config saved to /var/cache/conftool/dbconfig/20220210-103317-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T10:33:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1113:3316 (T300382)', diff saved to https://phabricator.wikimedia.org/P20502 and previous config saved to /var/cache/conftool/dbconfig/20220210-103324-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T11:20:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20508 and previous config saved to /var/cache/conftool/dbconfig/20220210-112034-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T11:21:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20509 and previous config saved to /var/cache/conftool/dbconfig/20220210-112147-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T12:07:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20514 and previous config saved to /var/cache/conftool/dbconfig/20220210-120701-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T12:07:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20515 and previous config saved to /var/cache/conftool/dbconfig/20220210-120729-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T12:09:42Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20516 and previous config saved to /var/cache/conftool/dbconfig/20220210-120941-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T12:54:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20522 and previous config saved to /var/cache/conftool/dbconfig/20220210-125456-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T12:55:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1127 (T300382)', diff saved to https://phabricator.wikimedia.org/P20523 and previous config saved to /var/cache/conftool/dbconfig/20220210-125503-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T13:08:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T300382)', diff saved to https://phabricator.wikimedia.org/P20525 and previous config saved to /var/cache/conftool/dbconfig/20220210-130818-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T13:53:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T300382)', diff saved to https://phabricator.wikimedia.org/P20529 and previous config saved to /var/cache/conftool/dbconfig/20220210-135332-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T13:54:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20530 and previous config saved to /var/cache/conftool/dbconfig/20220210-135411-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T14:05:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20532 and previous config saved to /var/cache/conftool/dbconfig/20220210-140525-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T14:50:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T300382)', diff saved to https://phabricator.wikimedia.org/P20536 and previous config saved to /var/cache/conftool/dbconfig/20220210-145040-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T14:50:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T300382)', diff saved to https://phabricator.wikimedia.org/P20537 and previous config saved to /var/cache/conftool/dbconfig/20220210-145047-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T15:51:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T300382)', diff saved to https://phabricator.wikimedia.org/P20543 and previous config saved to /var/cache/conftool/dbconfig/20220210-155106-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T16:36:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T300382)', diff saved to https://phabricator.wikimedia.org/P20549 and previous config saved to /var/cache/conftool/dbconfig/20220210-163620-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T16:36:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T300382)', diff saved to https://phabricator.wikimedia.org/P20550 and previous config saved to /var/cache/conftool/dbconfig/20220210-163633-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T16:37:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T300382)', diff saved to https://phabricator.wikimedia.org/P20551 and previous config saved to /var/cache/conftool/dbconfig/20220210-163746-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T17:23:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T300382)', diff saved to https://phabricator.wikimedia.org/P20555 and previous config saved to /var/cache/conftool/dbconfig/20220210-172300-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T17:23:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1181 (T300382)', diff saved to https://phabricator.wikimedia.org/P20556 and previous config saved to /var/cache/conftool/dbconfig/20220210-172307-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T18:23:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T300382)', diff saved to https://phabricator.wikimedia.org/P20565 and previous config saved to /var/cache/conftool/dbconfig/20220210-182326-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-10T19:08:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T300382)', diff saved to https://phabricator.wikimedia.org/P20576 and previous config saved to /var/cache/conftool/dbconfig/20220210-190840-marostegui.json

s7 replicas were done, except db1181 which failed to get drained. I will do that one manually along with the master

s7 replicas were done, except db1181 which failed to get drained. I will do that one manually along with the master

Same for db1174

I have deployed this directly on s8 master as the table only had 16 rows.

Deployed this directly on s4 master as the table only had 19 rows.

Deployed on s1 master (around 1500 rows)

Deploying on s2 master (not lots of rows in general on all the wikis) but with a 60 seconds sleep between wikis

s5 has most of the tables empty, so I am going to deploy on the master as well but with some sleep.

s3 has way too many wikis, so I will deploy it on Monday but with the script.

Mentioned in SAL (#wikimedia-operations) [2022-02-14T06:22:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1123 (T300382)', diff saved to https://phabricator.wikimedia.org/P20629 and previous config saved to /var/cache/conftool/dbconfig/20220214-062219-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T06:32:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1123 (T300382)', diff saved to https://phabricator.wikimedia.org/P20630 and previous config saved to /var/cache/conftool/dbconfig/20220214-063204-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T07:17:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1123 (T300382)', diff saved to https://phabricator.wikimedia.org/P20633 and previous config saved to /var/cache/conftool/dbconfig/20220214-071718-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T07:35:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1112 (T300382)', diff saved to https://phabricator.wikimedia.org/P20634 and previous config saved to /var/cache/conftool/dbconfig/20220214-073544-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T07:45:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T300382)', diff saved to https://phabricator.wikimedia.org/P20635 and previous config saved to /var/cache/conftool/dbconfig/20220214-074529-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T08:30:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T300382)', diff saved to https://phabricator.wikimedia.org/P20638 and previous config saved to /var/cache/conftool/dbconfig/20220214-083043-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T08:30:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1166 (T300382)', diff saved to https://phabricator.wikimedia.org/P20639 and previous config saved to /var/cache/conftool/dbconfig/20220214-083051-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T08:40:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T300382)', diff saved to https://phabricator.wikimedia.org/P20640 and previous config saved to /var/cache/conftool/dbconfig/20220214-084041-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T09:25:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T300382)', diff saved to https://phabricator.wikimedia.org/P20644 and previous config saved to /var/cache/conftool/dbconfig/20220214-092555-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T09:26:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1179 (T300382)', diff saved to https://phabricator.wikimedia.org/P20645 and previous config saved to /var/cache/conftool/dbconfig/20220214-092602-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T09:36:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T300382)', diff saved to https://phabricator.wikimedia.org/P20646 and previous config saved to /var/cache/conftool/dbconfig/20220214-093621-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T10:21:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T300382)', diff saved to https://phabricator.wikimedia.org/P20652 and previous config saved to /var/cache/conftool/dbconfig/20220214-102135-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T10:21:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1175 (T300382)', diff saved to https://phabricator.wikimedia.org/P20653 and previous config saved to /var/cache/conftool/dbconfig/20220214-102142-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T10:31:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T300382)', diff saved to https://phabricator.wikimedia.org/P20655 and previous config saved to /var/cache/conftool/dbconfig/20220214-103154-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-02-14T11:17:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T300382)', diff saved to https://phabricator.wikimedia.org/P20662 and previous config saved to /var/cache/conftool/dbconfig/20220214-111708-marostegui.json