Page MenuHomePhabricator
Create Task
Maniphest T310011

Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis
Closed, ResolvedPublic
Actions

Description

Apply T300575 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CheckUser/+/787931/4/schema/mysql/patch-cu_changes-cuc_timestamp.sql
  2. Where to run those changes: all wikis
  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: there is no checkuser on beta cluster
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress:

Details

ProjectBranchLines +/-Subject
operations/software/schema-changesmaster+39 -0change_cuc_timestamp_T310011.py: New schema change
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.Jun 15 2022, 9:12 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T09:12:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1119 (T310011)', diff saved to https://phabricator.wikimedia.org/P29771 and previous config saved to /var/cache/conftool/dbconfig/20220615-091257-marostegui.json

Stashbot added a comment.Jun 15 2022, 9:45 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T09:45:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T310011)', diff saved to https://phabricator.wikimedia.org/P29773 and previous config saved to /var/cache/conftool/dbconfig/20220615-094532-marostegui.json

Stashbot added a comment.Jun 15 2022, 10:30 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T10:30:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T310011)', diff saved to https://phabricator.wikimedia.org/P29778 and previous config saved to /var/cache/conftool/dbconfig/20220615-103048-marostegui.json

Stashbot added a comment.Jun 15 2022, 10:31 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T10:31:02Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T310011)', diff saved to https://phabricator.wikimedia.org/P29779 and previous config saved to /var/cache/conftool/dbconfig/20220615-103101-marostegui.json

Stashbot added a comment.Jun 15 2022, 11:04 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T11:04:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T310011)', diff saved to https://phabricator.wikimedia.org/P29787 and previous config saved to /var/cache/conftool/dbconfig/20220615-110435-marostegui.json

Stashbot added a comment.Jun 15 2022, 11:49 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T11:49:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T310011)', diff saved to https://phabricator.wikimedia.org/P29801 and previous config saved to /var/cache/conftool/dbconfig/20220615-114950-marostegui.json

Stashbot added a comment.Jun 15 2022, 12:16 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T12:16:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T310011)', diff saved to https://phabricator.wikimedia.org/P29807 and previous config saved to /var/cache/conftool/dbconfig/20220615-121620-marostegui.json

Marostegui updated the task description. (Show Details)Jun 15 2022, 12:46 PM
Stashbot added a comment.Jun 15 2022, 12:48 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T12:48:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T310011)', diff saved to https://phabricator.wikimedia.org/P29813 and previous config saved to /var/cache/conftool/dbconfig/20220615-124810-marostegui.json

Stashbot added a comment.Jun 15 2022, 1:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T13:33:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T310011)', diff saved to https://phabricator.wikimedia.org/P29826 and previous config saved to /var/cache/conftool/dbconfig/20220615-133326-marostegui.json

Stashbot added a comment.Jun 15 2022, 1:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T13:33:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1134 (T310011)', diff saved to https://phabricator.wikimedia.org/P29827 and previous config saved to /var/cache/conftool/dbconfig/20220615-133334-marostegui.json

Stashbot added a comment.Jun 15 2022, 2:05 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T14:05:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T310011)', diff saved to https://phabricator.wikimedia.org/P29834 and previous config saved to /var/cache/conftool/dbconfig/20220615-140505-marostegui.json

Stashbot added a comment.Jun 15 2022, 2:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T14:50:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T310011)', diff saved to https://phabricator.wikimedia.org/P29839 and previous config saved to /var/cache/conftool/dbconfig/20220615-145020-marostegui.json

Stashbot added a comment.Jun 15 2022, 2:50 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T14:50:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1128 (T310011)', diff saved to https://phabricator.wikimedia.org/P29840 and previous config saved to /var/cache/conftool/dbconfig/20220615-145028-marostegui.json

Stashbot added a comment.Jun 15 2022, 3:23 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T15:23:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T310011)', diff saved to https://phabricator.wikimedia.org/P29841 and previous config saved to /var/cache/conftool/dbconfig/20220615-152315-marostegui.json

Stashbot added a comment.Jun 15 2022, 4:08 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T16:08:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T310011)', diff saved to https://phabricator.wikimedia.org/P29844 and previous config saved to /var/cache/conftool/dbconfig/20220615-160830-marostegui.json

Stashbot added a comment.Jun 15 2022, 4:08 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T16:08:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1118 (T310011)', diff saved to https://phabricator.wikimedia.org/P29845 and previous config saved to /var/cache/conftool/dbconfig/20220615-160838-marostegui.json

Stashbot added a comment.Jun 15 2022, 4:42 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T16:42:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T310011)', diff saved to https://phabricator.wikimedia.org/P29847 and previous config saved to /var/cache/conftool/dbconfig/20220615-164222-marostegui.json

Stashbot added a comment.Jun 15 2022, 5:27 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T17:27:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T310011)', diff saved to https://phabricator.wikimedia.org/P29851 and previous config saved to /var/cache/conftool/dbconfig/20220615-172738-marostegui.json

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

Mentioned in SAL (#wikimedia-operations) [2022-06-15T18:21:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1169 (T310011)', diff saved to https://phabricator.wikimedia.org/P29853 and previous config saved to /var/cache/conftool/dbconfig/20220615-182140-marostegui.json

Stashbot added a comment.Jun 15 2022, 7:01 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T19:01:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T310011)', diff saved to https://phabricator.wikimedia.org/P29854 and previous config saved to /var/cache/conftool/dbconfig/20220615-190140-marostegui.json

Stashbot added a comment.Jun 15 2022, 7:46 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T19:46:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T310011)', diff saved to https://phabricator.wikimedia.org/P29857 and previous config saved to /var/cache/conftool/dbconfig/20220615-194655-marostegui.json

Stashbot added a comment.Jun 15 2022, 7:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T19:47:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1132 (T310011)', diff saved to https://phabricator.wikimedia.org/P29858 and previous config saved to /var/cache/conftool/dbconfig/20220615-194703-marostegui.json

Stashbot added a comment.Jun 15 2022, 8:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T20:47:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T310011)', diff saved to https://phabricator.wikimedia.org/P29859 and previous config saved to /var/cache/conftool/dbconfig/20220615-204717-marostegui.json

Stashbot added a comment.Jun 15 2022, 9:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T21:32:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T310011)', diff saved to https://phabricator.wikimedia.org/P29862 and previous config saved to /var/cache/conftool/dbconfig/20220615-213233-marostegui.json

Stashbot added a comment.Jun 15 2022, 9:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T21:32:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T310011)', diff saved to https://phabricator.wikimedia.org/P29863 and previous config saved to /var/cache/conftool/dbconfig/20220615-213241-marostegui.json

Stashbot added a comment.Jun 15 2022, 10:03 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T22:03:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T310011)', diff saved to https://phabricator.wikimedia.org/P29864 and previous config saved to /var/cache/conftool/dbconfig/20220615-220329-marostegui.json

Stashbot added a comment.Jun 15 2022, 10:48 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T22:48:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T310011)', diff saved to https://phabricator.wikimedia.org/P29867 and previous config saved to /var/cache/conftool/dbconfig/20220615-224845-marostegui.json

Marostegui added a comment.Jun 16 2022, 11:58 AM

s1 was done, db1132 wasn't due to traffic. I will do it manually

Marostegui updated the task description. (Show Details)Jun 16 2022, 12:32 PM

s1 is done, pending the master.
So we need to decide what to do with s8 (T310011#7997611), I am fine dropping the default and so is @Umherirrender (T310011#7999579). That would leave wikidata with the same value as the rest of the sections.
I will work on that

Stashbot added a comment.Jun 21 2022, 9:13 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-21T09:13:19Z] <marostegui> dbmaint s8@codfw T310011

Stashbot added a comment.Jun 21 2022, 9:20 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-21T09:20:23Z] <marostegui> dbmaint s8@eqiad T310011

Stashbot added a comment.Jun 22 2022, 5:52 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-22T05:52:30Z] <marostegui> dbmaint s8@eqiad T310011

Marostegui added a comment.Jun 22 2022, 5:57 AM

s8 is done entirely including the master

Marostegui updated the task description. (Show Details)Jun 22 2022, 5:57 AM
Stashbot added a comment.Jun 28 2022, 7:02 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-28T07:02:37Z] <marostegui> dbmaint s7@eqiad T310011

Marostegui updated the task description. (Show Details)Jun 28 2022, 7:05 AM
Marostegui added a comment.Jul 8 2022, 12:44 PM

Old s4 master, db1160, done

Marostegui updated the task description. (Show Details)Jul 8 2022, 12:44 PM
Stashbot added a comment.Jul 12 2022, 6:12 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-12T06:12:46Z] <marostegui> dbmaint s3@eqiad T310011

Marostegui added a comment.Jul 12 2022, 6:15 AM

Running this in the old s3 master

Marostegui updated the task description. (Show Details)Jul 12 2022, 6:22 AM

Old s3 master (db1123) done

Stashbot added a comment.Aug 9 2022, 6:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-08-09T06:19:15Z] <Amir1> dbmaint s5@eqiad (T312863 T312984 T310011 T310485)

Stashbot mentioned this in T312863: Schema change to change primary key of templatelinks.Aug 9 2022, 6:19 AM
Stashbot mentioned this in T312984: Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis.
Ladsgroup updated the task description. (Show Details)Aug 10 2022, 7:55 AM
Stashbot mentioned this in T298555: Fix mismatching field type of logging.log_timestamp on wmf wikis.Aug 11 2022, 6:06 AM
Stashbot mentioned this in T60674: Drop page.page_restrictions column from Wikimedia wikis.
Stashbot mentioned this in T303603: Add actor and comment columns to cu_changes.
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.

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

Ladsgroup updated the task description. (Show Details)Aug 11 2022, 9:54 AM
Stashbot mentioned this in T301312: Switchover s1 master (db1118 -> db1163).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 added a comment.Aug 16 2022, 6:24 AM

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 closed this task as Resolved.Aug 16 2022, 1:15 PM
Ladsgroup updated the task description. (Show Details)
Maintenance_bot moved this task from In progress to Done on the DBA board.Aug 16 2022, 1:29 PM
Marostegui added a comment.Aug 17 2022, 9:09 AM

Thanks for finishing this Amir!

Umherirrender mentioned this in T321063: Fix CheckUser database schema drifts in production.Oct 18 2022, 7:09 PM
Stashbot added a comment.Feb 1 2023, 6:45 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T06:45:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T310011)', diff saved to https://phabricator.wikimedia.org/P43520 and previous config saved to /var/cache/conftool/dbconfig/20230201-064311-ladsgroup.json

Stashbot added a comment.Feb 1 2023, 6:48 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T06:48:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T310011)', diff saved to https://phabricator.wikimedia.org/P43521 and previous config saved to /var/cache/conftool/dbconfig/20230201-064828-ladsgroup.json

Stashbot added a comment.Feb 1 2023, 7:33 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T07:33:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T310011)', diff saved to https://phabricator.wikimedia.org/P43524 and previous config saved to /var/cache/conftool/dbconfig/20230201-073348-ladsgroup.json

Content licensed under Creative Commons Attribution-ShareAlike 4.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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