Page MenuHomePhabricator
Create Task
Maniphest T60674

Drop page.page_restrictions column from Wikimedia wikis
Closed, ResolvedPublic
Actions

Description

Note: Needs recreating the views

Progress:

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

Details

Reference
bz58674
SubjectRepoBranchLines +/-
dbproxy: Repool clouddb101(3|4|5|6)operations/puppetproduction+25 -25
dbproxy: Repool the old batch, Depool the new oneoperations/puppetproduction+50 -50
Depool clouddb10(17|18|19|20)operations/puppetproduction+25 -25
Remove page_restrictions field from maintain-viewsoperations/puppetproduction+1 -2
Add drop_page_restrictions_T60674.pyoperations/software/schema-changesmaster+36 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.May 31 2022, 1:58 AM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T01:58:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1147 (T60674)', diff saved to https://phabricator.wikimedia.org/P29172 and previous config saved to /var/cache/conftool/dbconfig/20220531-015850-ladsgroup.json

JJMC89 mentioned this in T217364: Intermittent 1356 "references invalid table(s) or column(s)" errors with "page" view on enwiki.web.db.svc.eqiad.wmflabs.May 31 2022, 6:06 AM
Ladsgroup updated the task description. (Show Details)May 31 2022, 12:02 PM
Stashbot added a comment.May 31 2022, 1:25 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T13:25:33Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1109 (T60674)', diff saved to https://phabricator.wikimedia.org/P29194 and previous config saved to /var/cache/conftool/dbconfig/20220531-132530-ladsgroup.json

Stashbot added a comment.May 31 2022, 1:51 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T13:51:57Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1109 (T60674)', diff saved to https://phabricator.wikimedia.org/P29199 and previous config saved to /var/cache/conftool/dbconfig/20220531-135157-ladsgroup.json

Stashbot added a comment.May 31 2022, 2:37 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T14:37:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1109 (T60674)', diff saved to https://phabricator.wikimedia.org/P29209 and previous config saved to /var/cache/conftool/dbconfig/20220531-143712-ladsgroup.json

Stashbot added a comment.May 31 2022, 2:37 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T14:37:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3318 (T60674)', diff saved to https://phabricator.wikimedia.org/P29211 and previous config saved to /var/cache/conftool/dbconfig/20220531-143720-ladsgroup.json

Stashbot added a comment.May 31 2022, 3:04 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T15:04:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T60674)', diff saved to https://phabricator.wikimedia.org/P29213 and previous config saved to /var/cache/conftool/dbconfig/20220531-150411-ladsgroup.json

Stashbot added a comment.May 31 2022, 3:49 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T15:49:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T60674)', diff saved to https://phabricator.wikimedia.org/P29224 and previous config saved to /var/cache/conftool/dbconfig/20220531-154928-ladsgroup.json

Stashbot added a comment.May 31 2022, 4:13 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T16:13:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3318 (T60674)', diff saved to https://phabricator.wikimedia.org/P29230 and previous config saved to /var/cache/conftool/dbconfig/20220531-161329-ladsgroup.json

Stashbot added a comment.May 31 2022, 4:37 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T16:37:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T60674)', diff saved to https://phabricator.wikimedia.org/P29235 and previous config saved to /var/cache/conftool/dbconfig/20220531-163737-ladsgroup.json

Stashbot added a comment.May 31 2022, 4:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T16:40:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T60674)', diff saved to https://phabricator.wikimedia.org/P29236 and previous config saved to /var/cache/conftool/dbconfig/20220531-164026-ladsgroup.json

Stashbot added a comment.May 31 2022, 5:25 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T17:25:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T60674)', diff saved to https://phabricator.wikimedia.org/P29243 and previous config saved to /var/cache/conftool/dbconfig/20220531-172541-ladsgroup.json

Stashbot added a comment.May 31 2022, 5:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T17:47:56Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1114 (T60674)', diff saved to https://phabricator.wikimedia.org/P29247 and previous config saved to /var/cache/conftool/dbconfig/20220531-174753-ladsgroup.json

Stashbot added a comment.May 31 2022, 6:13 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T18:13:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1114 (T60674)', diff saved to https://phabricator.wikimedia.org/P29249 and previous config saved to /var/cache/conftool/dbconfig/20220531-181354-ladsgroup.json

Stashbot added a comment.May 31 2022, 6:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T18:59:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1114 (T60674)', diff saved to https://phabricator.wikimedia.org/P29255 and previous config saved to /var/cache/conftool/dbconfig/20220531-185909-ladsgroup.json

Stashbot added a comment.May 31 2022, 6:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T18:59:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1126 (T60674)', diff saved to https://phabricator.wikimedia.org/P29256 and previous config saved to /var/cache/conftool/dbconfig/20220531-185917-ladsgroup.json

Stashbot added a comment.May 31 2022, 7:25 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T19:25:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T60674)', diff saved to https://phabricator.wikimedia.org/P29257 and previous config saved to /var/cache/conftool/dbconfig/20220531-192535-ladsgroup.json

Stashbot added a comment.May 31 2022, 8:10 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T20:10:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T60674)', diff saved to https://phabricator.wikimedia.org/P29262 and previous config saved to /var/cache/conftool/dbconfig/20220531-201051-ladsgroup.json

Stashbot added a comment.May 31 2022, 8:11 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T20:11:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1178 (T60674)', diff saved to https://phabricator.wikimedia.org/P29263 and previous config saved to /var/cache/conftool/dbconfig/20220531-201059-ladsgroup.json

Stashbot added a comment.May 31 2022, 8:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T20:40:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T60674)', diff saved to https://phabricator.wikimedia.org/P29266 and previous config saved to /var/cache/conftool/dbconfig/20220531-204054-ladsgroup.json

Stashbot added a comment.May 31 2022, 9:26 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T21:26:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T60674)', diff saved to https://phabricator.wikimedia.org/P29271 and previous config saved to /var/cache/conftool/dbconfig/20220531-212610-ladsgroup.json

Stashbot added a comment.May 31 2022, 9:26 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T21:26:39Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1167 (T60674)', diff saved to https://phabricator.wikimedia.org/P29272 and previous config saved to /var/cache/conftool/dbconfig/20220531-212623-ladsgroup.json

Stashbot added a comment.May 31 2022, 10:09 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T22:09:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T60674)', diff saved to https://phabricator.wikimedia.org/P29274 and previous config saved to /var/cache/conftool/dbconfig/20220531-220930-ladsgroup.json

Stashbot added a comment.May 31 2022, 11:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-05-31T23:19:33Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T60674)', diff saved to https://phabricator.wikimedia.org/P29282 and previous config saved to /var/cache/conftool/dbconfig/20220531-231933-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 12:04 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T00:04:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T60674)', diff saved to https://phabricator.wikimedia.org/P29289 and previous config saved to /var/cache/conftool/dbconfig/20220601-000448-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 12:27 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T00:27:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1111 (T60674)', diff saved to https://phabricator.wikimedia.org/P29291 and previous config saved to /var/cache/conftool/dbconfig/20220601-002701-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 12:55 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T00:55:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1111 (T60674)', diff saved to https://phabricator.wikimedia.org/P29293 and previous config saved to /var/cache/conftool/dbconfig/20220601-005537-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 1:40 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T01:40:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1111 (T60674)', diff saved to https://phabricator.wikimedia.org/P29296 and previous config saved to /var/cache/conftool/dbconfig/20220601-014053-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 2:03 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T02:03:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1172 (T60674)', diff saved to https://phabricator.wikimedia.org/P29297 and previous config saved to /var/cache/conftool/dbconfig/20220601-020339-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 2:28 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T02:28:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T60674)', diff saved to https://phabricator.wikimedia.org/P29298 and previous config saved to /var/cache/conftool/dbconfig/20220601-022851-ladsgroup.json

Stashbot added a comment.Jun 1 2022, 3:14 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-01T03:14:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T60674)', diff saved to https://phabricator.wikimedia.org/P29301 and previous config saved to /var/cache/conftool/dbconfig/20220601-031406-ladsgroup.json

MusikAnimal mentioned this in T309586: Error with Xtools.Jun 1 2022, 6:43 PM
Stashbot added a comment.Jun 2 2022, 6:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-02T18:14:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T60674)', diff saved to https://phabricator.wikimedia.org/P29356 and previous config saved to /var/cache/conftool/dbconfig/20220602-181434-ladsgroup.json

Stashbot added a comment.Jun 2 2022, 6:21 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-02T18:21:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T60674)', diff saved to https://phabricator.wikimedia.org/P29357 and previous config saved to /var/cache/conftool/dbconfig/20220602-182145-ladsgroup.json

Stashbot added a comment.Jun 2 2022, 7:07 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-02T19:07:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T60674)', diff saved to https://phabricator.wikimedia.org/P29360 and previous config saved to /var/cache/conftool/dbconfig/20220602-190701-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jun 3 2022, 10:46 AM
Stashbot added a comment.Jun 14 2022, 10:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T10:19:34Z] <marostegui> dbmaint s6@eqiad T60674

• Marostegui added a comment.Jun 14 2022, 10:19 AM

s6 old master (db1173) done

• Marostegui updated the task description. (Show Details)Jun 14 2022, 10:20 AM
Cjzee9191 subscribed.Jun 14 2022, 4:02 PM
Ladsgroup updated the task description. (Show Details)Jul 7 2022, 12:32 PM
Ladsgroup updated the task description. (Show Details)Jul 12 2022, 2:55 PM
Vahurzpu subscribed.Jul 22 2022, 5:57 PM
Stashbot mentioned this in T298555: Fix mismatching field type of logging.log_timestamp on wmf wikis.Aug 11 2022, 6:06 AM

Mentioned in SAL (#wikimedia-operations) [2022-08-11T06:06:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depool db1162 (T314368 T298555 T312863 T310011 T309311 T60674 T298560 T303603 T310485)', diff saved to https://phabricator.wikimedia.org/P32352 and previous config saved to /var/cache/conftool/dbconfig/20220811-060625-ladsgroup.json

Stashbot mentioned this in T303603: Add actor and comment columns to cu_changes.Aug 11 2022, 6:06 AM
Stashbot mentioned this in T314368: Switchover s2 master (db1162 -> db1122).
Stashbot mentioned this in T298560: Fix mismatching field type of revision.rev_timestamp on wmf wikis.
Stashbot mentioned this in T309311: Make user_editcount unsigned in production.
Stashbot mentioned this in T310011: Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis.
Stashbot mentioned this in T312863: Schema change to change primary key of templatelinks.
Ladsgroup updated the task description. (Show Details)Aug 11 2022, 9:56 AM
Stashbot added a comment.Aug 16 2022, 6:23 AM

Mentioned in SAL (#wikimedia-operations) [2022-08-16T06:23:50Z] <ladsgroup@cumin1001> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on db1163.eqiad.wmnet with reason: Maint work on old s1 master (T312984 T312863 T310011 T309311 T60674 T298560 T298555 T310485 T301312)

Stashbot mentioned this in T312984: Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis.Aug 16 2022, 6:23 AM
Stashbot mentioned this in T301312: Switchover s1 master (db1118 -> db1163).

Mentioned in SAL (#wikimedia-operations) [2022-08-16T06:24:04Z] <ladsgroup@cumin1001> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on db1163.eqiad.wmnet with reason: Maint work on old s1 master (T312984 T312863 T310011 T309311 T60674 T298560 T298555 T310485 T301312)

Ladsgroup updated the task description. (Show Details)Aug 16 2022, 8:59 AM
Stashbot added a comment.Aug 18 2022, 6:11 AM

Mentioned in SAL (#wikimedia-operations) [2022-08-18T06:11:37Z] <Amir1> dbmaint@s8 eqiad (T314369 T312863 T309311 T60674 T303603 T310485)

Stashbot mentioned this in T314369: Switchover s8 master (db1104 -> db1109).Aug 18 2022, 6:11 AM
Ladsgroup updated the task description. (Show Details)Aug 18 2022, 7:22 AM
Ladsgroup closed this task as Resolved.Aug 18 2022, 7:25 AM
Ladsgroup updated the task description. (Show Details)
Maintenance_bot moved this task from In progress to Done on the DBA board.Aug 18 2022, 7:29 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and 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