- The ALTER TABLEs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GlobalBlocking/+/f5e396266f288c9732bc8ed65709324a9b207be6/sql/mysql/patch-add-gb_by_central_id.sql
- Where to run those changes: centralauth database only
- When to run those changes: when dba has time
- If the schema change is backwards compatible: yes, only adds a nullable column
- If the schema change has been tested already on some of the test/beta wikis. Usually, as a last test, change should be applied to testwiki first: Tested locally
- If it involves new columns or tables, if the data should be made available on the labs replicas and/or dumps: Yes
Description
Details
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | PRODUCTION ERROR | Zabe | T298707 "InvalidArgumentException: Blocker must be a local user" from GlobalBlocking | ||
Open | Zabe | T299371 Migrate globalblocks table to use central ids instead of usernames | |||
Resolved | Marostegui | T299827 Add gb_by_central_id column to globalblocks table | |||
Resolved | None | T300988 Recreate views for globalblocks table |
Event Timeline
Mentioned in SAL (#wikimedia-releng) [2022-01-22T13:40:31Z] <taavi> apply T299827 on deployment-prep centralauth database
Change 756346 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/software/schema-changes@master] add_gb_by_central_id_T299827.py: New schema change
@Zabe "If it involves new columns or tables, if the data should be made available on the labs replicas and/or dumps or not because they contain private or sensitive data: No" "no" meaning it doesn't contain private data or "no" it shouldn't be replicated to labs hosts.
I am assuming it is "No, there's no private data, so it can be replicated just as it is" but please confirm.
Thanks!
Change 756346 merged by Marostegui:
[operations/software/schema-changes@master] add_gb_by_central_id_T299827.py: New schema change
Change 756948 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/software/schema-changes@master] add_gb_by_central_id_T299827.py: Fixes
Change 756948 merged by Marostegui:
[operations/software/schema-changes@master] add_gb_by_central_id_T299827.py: Fixes
Mentioned in SAL (#wikimedia-operations) [2022-01-25T09:38:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19106 and previous config saved to /var/cache/conftool/dbconfig/20220125-093806-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T09:39:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19108 and previous config saved to /var/cache/conftool/dbconfig/20220125-093912-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T10:24:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19116 and previous config saved to /var/cache/conftool/dbconfig/20220125-102426-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T10:24:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19117 and previous config saved to /var/cache/conftool/dbconfig/20220125-102448-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T11:21:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19126 and previous config saved to /var/cache/conftool/dbconfig/20220125-112111-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T12:06:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19132 and previous config saved to /var/cache/conftool/dbconfig/20220125-120625-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T12:06:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1127 (T299827)', diff saved to https://phabricator.wikimedia.org/P19133 and previous config saved to /var/cache/conftool/dbconfig/20220125-120632-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T12:13:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T299827)', diff saved to https://phabricator.wikimedia.org/P19134 and previous config saved to /var/cache/conftool/dbconfig/20220125-121343-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T12:58:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T299827)', diff saved to https://phabricator.wikimedia.org/P19141 and previous config saved to /var/cache/conftool/dbconfig/20220125-125857-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T12:59:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19142 and previous config saved to /var/cache/conftool/dbconfig/20220125-125923-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T13:00:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19143 and previous config saved to /var/cache/conftool/dbconfig/20220125-130032-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T13:45:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T299827)', diff saved to https://phabricator.wikimedia.org/P19154 and previous config saved to /var/cache/conftool/dbconfig/20220125-134547-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T13:46:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T299827)', diff saved to https://phabricator.wikimedia.org/P19155 and previous config saved to /var/cache/conftool/dbconfig/20220125-134557-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T13:47:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T299827)', diff saved to https://phabricator.wikimedia.org/P19156 and previous config saved to /var/cache/conftool/dbconfig/20220125-134704-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T14:32:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T299827)', diff saved to https://phabricator.wikimedia.org/P19168 and previous config saved to /var/cache/conftool/dbconfig/20220125-143218-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T14:32:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T299827)', diff saved to https://phabricator.wikimedia.org/P19169 and previous config saved to /var/cache/conftool/dbconfig/20220125-143232-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T14:33:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T299827)', diff saved to https://phabricator.wikimedia.org/P19170 and previous config saved to /var/cache/conftool/dbconfig/20220125-143338-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T15:18:53Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T299827)', diff saved to https://phabricator.wikimedia.org/P19180 and previous config saved to /var/cache/conftool/dbconfig/20220125-151852-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T15:19:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1181 (T299827)', diff saved to https://phabricator.wikimedia.org/P19181 and previous config saved to /var/cache/conftool/dbconfig/20220125-151900-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T15:20:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T299827)', diff saved to https://phabricator.wikimedia.org/P19182 and previous config saved to /var/cache/conftool/dbconfig/20220125-152006-marostegui.json
Mentioned in SAL (#wikimedia-operations) [2022-01-25T16:05:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T299827)', diff saved to https://phabricator.wikimedia.org/P19195 and previous config saved to /var/cache/conftool/dbconfig/20220125-160522-marostegui.json