Page MenuHomePhabricator

Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis
Open, MediumPublic

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

Related Objects

Event Timeline

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

s8 is done entirely including the master