Page MenuHomePhabricator
Create Task
Maniphest T310011

Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis
Open, MediumPublic
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:

  • s1 (all done, pending the master db1163)
  • s2 (all done, pending the master db1162)
  • s3 (all done, pending the master db1123)
  • s4 (all done, pending the master db1160)
  • s5 (all done, pending the master db1130)
  • s6
  • s7
  • s8 See T310011#7997611
  • labtestwiki

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.Tue, Jun 14, 8:38 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T08:38:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T310011)', diff saved to https://phabricator.wikimedia.org/P29717 and previous config saved to /var/cache/conftool/dbconfig/20220614-083807-marostegui.json

Stashbot added a comment.Tue, Jun 14, 9:23 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T09:23:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T310011)', diff saved to https://phabricator.wikimedia.org/P29720 and previous config saved to /var/cache/conftool/dbconfig/20220614-092322-marostegui.json

Stashbot added a comment.Tue, Jun 14, 9:23 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T09:23:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1175 (T310011)', diff saved to https://phabricator.wikimedia.org/P29721 and previous config saved to /var/cache/conftool/dbconfig/20220614-092330-marostegui.json

Stashbot added a comment.Tue, Jun 14, 9:32 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T09:32:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T310011)', diff saved to https://phabricator.wikimedia.org/P29722 and previous config saved to /var/cache/conftool/dbconfig/20220614-093240-marostegui.json

Stashbot added a comment.Tue, Jun 14, 10:17 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T10:17:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T310011)', diff saved to https://phabricator.wikimedia.org/P29726 and previous config saved to /var/cache/conftool/dbconfig/20220614-101755-marostegui.json

Stashbot added a comment.Tue, Jun 14, 10:40 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T10:40:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1112 (T310011)', diff saved to https://phabricator.wikimedia.org/P29729 and previous config saved to /var/cache/conftool/dbconfig/20220614-104021-marostegui.json

Stashbot added a comment.Tue, Jun 14, 11:05 AM

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

Stashbot added a comment.Tue, Jun 14, 11:50 AM

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

Stashbot added a comment.Tue, Jun 14, 12:03 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T12:03:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1157 (T310011)', diff saved to https://phabricator.wikimedia.org/P29737 and previous config saved to /var/cache/conftool/dbconfig/20220614-120323-marostegui.json

Stashbot added a comment.Tue, Jun 14, 12:41 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-14T12:41:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T310011)', diff saved to https://phabricator.wikimedia.org/P29738 and previous config saved to /var/cache/conftool/dbconfig/20220614-124139-marostegui.json

Stashbot added a comment.Tue, Jun 14, 1:26 PM

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

Marostegui updated the task description. (Show Details)Wed, Jun 15, 5:33 AM

Going for s1

Stashbot added a comment.Wed, Jun 15, 6:01 AM

Mentioned in SAL (#wikimedia-operations) [2022-06-15T06:01:53Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3311 (T310011)', diff saved to https://phabricator.wikimedia.org/P29746 and previous config saved to /var/cache/conftool/dbconfig/20220615-060153-marostegui.json

Stashbot added a comment.Wed, Jun 15, 6:38 AM

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

Stashbot added a comment.Wed, Jun 15, 7:23 AM

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

Stashbot added a comment.Wed, Jun 15, 7:50 AM

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

Stashbot added a comment.Wed, Jun 15, 8:27 AM

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

Stashbot added a comment.Wed, Jun 15, 9:12 AM

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

Stashbot added a comment.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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)Wed, Jun 15, 12:46 PM
Stashbot added a comment.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Wed, Jun 15, 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.Thu, Jun 16, 11:58 AM

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

Marostegui updated the task description. (Show Details)Thu, Jun 16, 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.Tue, Jun 21, 9:13 AM

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

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

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

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

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

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

s8 is done entirely including the master

Marostegui updated the task description. (Show Details)Wed, Jun 22, 5:57 AM
Stashbot added a comment.Tue, Jun 28, 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)Tue, Jun 28, 7:05 AM
Content licensed under Creative Commons Attribution-ShareAlike 3.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