Page MenuHomePhabricator
Create Task
Maniphest T355609

Make cuc_id a bigint
Open, MediumPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CheckUser/+/986190/4/schema/mysql/patch-cu_changes-modify-cuc_id-bigint.sql
  2. Where to run those changes: all
  3. When to run those changes: At 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: checkuser is not on beta cluster
  6. If the data should be made available on the labs replicas and/or dumps: Everything is private

Progress

  • s1
    • eqiad (pending dc master)
    • codfw (pending dc master)
  • s2
    • eqiad (pending dc master)
    • codfw (pending dc master)
  • s3
    • eqiad (pending dc master)
    • codfw (pending dc master)
  • s4
    • eqiad (pending dc master)
    • codfw (pending dc master)
  • s5
    • eqiad (pending dc master)
    • codfw (pending dc master)
  • s6
    • eqiad (pending dc master)
    • codfw (pending dc master T355739)
  • s7
    • eqiad (pending dc master)
    • codfw (pending dc master)
  • s8
    • eqiad (pending dc master)
    • codfw
  • labtestwiki (clouddb2002-dev.codfw.wmnet)

Details

TitleReferenceAuthorSource BranchDest Branch
change_cuc_id_T355609.py: New schema changerepos/sre/schema-changes!4marosteguiT355609main
Customize query in GitLab

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.Feb 21 2024, 5:56 PM

Mentioned in SAL (#wikimedia-operations) [2024-02-21T17:56:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T355609)', diff saved to https://phabricator.wikimedia.org/P57610 and previous config saved to /var/cache/conftool/dbconfig/20240221-175601-marostegui.json

Stashbot added a comment.Feb 21 2024, 6:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-02-21T18:41:22Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T355609)', diff saved to https://phabricator.wikimedia.org/P57617 and previous config saved to /var/cache/conftool/dbconfig/20240221-184120-marostegui.json

Stashbot added a comment.Feb 21 2024, 6:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-02-21T18:41:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2188 (T355609)', diff saved to https://phabricator.wikimedia.org/P57618 and previous config saved to /var/cache/conftool/dbconfig/20240221-184144-marostegui.json

Stashbot added a comment.Feb 21 2024, 7:06 PM

Mentioned in SAL (#wikimedia-operations) [2024-02-21T19:06:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T355609)', diff saved to https://phabricator.wikimedia.org/P57622 and previous config saved to /var/cache/conftool/dbconfig/20240221-190637-marostegui.json

Stashbot added a comment.Feb 21 2024, 7:51 PM

Mentioned in SAL (#wikimedia-operations) [2024-02-21T19:51:57Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T355609)', diff saved to https://phabricator.wikimedia.org/P57628 and previous config saved to /var/cache/conftool/dbconfig/20240221-195157-marostegui.json

• Marostegui updated the task description. (Show Details)Feb 22 2024, 6:40 AM

This is done everywhere. Now pending the masters, which require switchovers, those will happen naturally in the next few weeks and/or during the DC switchover.

• Marostegui updated the task description. (Show Details)Feb 27 2024, 6:54 AM
Zabe added a comment.Feb 28 2024, 1:10 PM
In T355609#9566332, @Marostegui wrote:

This is done everywhere. Now pending the masters, which require switchovers, those will happen naturally in the next few weeks and/or during the DC switchover.

Was this applied to s8 replicas?

• Marostegui added a comment.Feb 28 2024, 1:40 PM
In T355609#9583457, @Zabe wrote:
In T355609#9566332, @Marostegui wrote:

This is done everywhere. Now pending the masters, which require switchovers, those will happen naturally in the next few weeks and/or during the DC switchover.

Was this applied to s8 replicas?

Replicas yes and primary codfw master. What is pending is eqiad dc master.

Zabe added a comment.Feb 29 2024, 11:48 AM
In T355609#9583509, @Marostegui wrote:
In T355609#9583457, @Zabe wrote:
In T355609#9566332, @Marostegui wrote:

This is done everywhere. Now pending the masters, which require switchovers, those will happen naturally in the next few weeks and/or during the DC switchover.

Was this applied to s8 replicas?

Replicas yes and primary codfw master. What is pending is eqiad dc master.

Alright, thanks:)

• Marostegui added a comment.Mar 20 2024, 4:43 PM

Going for s3 codfw master

• Marostegui updated the task description. (Show Details)Mar 20 2024, 5:07 PM
• Marostegui added a comment.Mar 20 2024, 5:11 PM

Going for s5 codfw master.

• Marostegui updated the task description. (Show Details)Mar 20 2024, 5:17 PM
Stashbot added a comment.Mar 20 2024, 5:20 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-20T17:20:31Z] <marostegui@cumin1002> START - Cookbook sre.hosts.downtime for 10:00:00 on 16 hosts with reason: Schema change T355609

Stashbot added a comment.Mar 20 2024, 5:20 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-20T17:20:47Z] <marostegui@cumin1002> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 10:00:00 on 16 hosts with reason: Schema change T355609

Stashbot added a comment.Mar 20 2024, 5:21 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-20T17:21:38Z] <marostegui> dbmaint deploy schema change s8 codfw T355609

Stashbot added a comment.Mar 20 2024, 5:22 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-20T17:22:38Z] <marostegui@cumin1002> START - Cookbook sre.hosts.downtime for 10:00:00 on 13 hosts with reason: Schema change T355609

Stashbot added a comment.Mar 20 2024, 5:23 PM

Mentioned in SAL (#wikimedia-operations) [2024-03-20T17:23:01Z] <marostegui@cumin1002> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 10:00:00 on 13 hosts with reason: Schema change T355609

• Marostegui added a comment.Mar 20 2024, 5:27 PM

Starting it on s8 codfw master with replication enabled.

• Marostegui updated the task description. (Show Details)Mar 20 2024, 6:07 PM
Stashbot added a comment.Mar 21 2024, 6:29 AM

Mentioned in SAL (#wikimedia-operations) [2024-03-21T06:29:17Z] <marostegui> dbmaint deploy schema change s1 codfw T355609

• Marostegui updated the task description. (Show Details)Mar 21 2024, 7:27 AM

All codfw hosts are done. Pending now eqiad primary masters, which require switchovers.

Stashbot added a comment.Thu, Apr 4, 5:23 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T05:23:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1167 (T355609)', diff saved to https://phabricator.wikimedia.org/P59409 and previous config saved to /var/cache/conftool/dbconfig/20240404-052338-marostegui.json

Stashbot added a comment.Thu, Apr 4, 6:12 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T06:12:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T355609)', diff saved to https://phabricator.wikimedia.org/P59415 and previous config saved to /var/cache/conftool/dbconfig/20240404-061234-marostegui.json

Stashbot added a comment.Thu, Apr 4, 6:57 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T06:57:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T355609)', diff saved to https://phabricator.wikimedia.org/P59421 and previous config saved to /var/cache/conftool/dbconfig/20240404-065758-marostegui.json

Stashbot added a comment.Thu, Apr 4, 7:43 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T07:43:14Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1172 (T355609)', diff saved to https://phabricator.wikimedia.org/P59426 and previous config saved to /var/cache/conftool/dbconfig/20240404-074313-marostegui.json

Stashbot added a comment.Thu, Apr 4, 8:31 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T08:31:48Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T355609)', diff saved to https://phabricator.wikimedia.org/P59433 and previous config saved to /var/cache/conftool/dbconfig/20240404-083147-marostegui.json

ABran-WMF mentioned this in T361786: Switchover s1 master (db2112 -> db2203).Thu, Apr 4, 8:52 AM
Stashbot added a comment.Thu, Apr 4, 9:17 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T09:17:10Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T355609)', diff saved to https://phabricator.wikimedia.org/P59443 and previous config saved to /var/cache/conftool/dbconfig/20240404-091709-marostegui.json

Stashbot added a comment.Thu, Apr 4, 9:17 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T09:17:34Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1177 (T355609)', diff saved to https://phabricator.wikimedia.org/P59444 and previous config saved to /var/cache/conftool/dbconfig/20240404-091732-marostegui.json

ABran-WMF mentioned this in T355422: Productionize db2196-db2220.Thu, Apr 4, 9:21 AM
Stashbot added a comment.Thu, Apr 4, 10:06 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T10:06:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T355609)', diff saved to https://phabricator.wikimedia.org/P59450 and previous config saved to /var/cache/conftool/dbconfig/20240404-100612-marostegui.json

Stashbot added a comment.Thu, Apr 4, 10:51 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T10:51:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T355609)', diff saved to https://phabricator.wikimedia.org/P59455 and previous config saved to /var/cache/conftool/dbconfig/20240404-105135-marostegui.json

Stashbot added a comment.Thu, Apr 4, 10:51 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T10:51:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1178 (T355609)', diff saved to https://phabricator.wikimedia.org/P59456 and previous config saved to /var/cache/conftool/dbconfig/20240404-105158-marostegui.json

Stashbot added a comment.Thu, Apr 4, 11:40 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T11:40:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T355609)', diff saved to https://phabricator.wikimedia.org/P59457 and previous config saved to /var/cache/conftool/dbconfig/20240404-114012-marostegui.json

Stashbot added a comment.Thu, Apr 4, 12:25 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T12:25:35Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T355609)', diff saved to https://phabricator.wikimedia.org/P59465 and previous config saved to /var/cache/conftool/dbconfig/20240404-122535-marostegui.json

Stashbot added a comment.Thu, Apr 4, 12:25 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T12:25:58Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1192 (T355609)', diff saved to https://phabricator.wikimedia.org/P59466 and previous config saved to /var/cache/conftool/dbconfig/20240404-122557-marostegui.json

Stashbot added a comment.Thu, Apr 4, 1:15 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T13:15:05Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1192 (T355609)', diff saved to https://phabricator.wikimedia.org/P59472 and previous config saved to /var/cache/conftool/dbconfig/20240404-131504-marostegui.json

Stashbot added a comment.Thu, Apr 4, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T14:00:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1192 (T355609)', diff saved to https://phabricator.wikimedia.org/P59481 and previous config saved to /var/cache/conftool/dbconfig/20240404-140027-marostegui.json

Stashbot added a comment.Thu, Apr 4, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T14:00:50Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1193 (T355609)', diff saved to https://phabricator.wikimedia.org/P59482 and previous config saved to /var/cache/conftool/dbconfig/20240404-140050-marostegui.json

Stashbot added a comment.Thu, Apr 4, 2:50 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T14:50:41Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1193 (T355609)', diff saved to https://phabricator.wikimedia.org/P59496 and previous config saved to /var/cache/conftool/dbconfig/20240404-145041-marostegui.json

Stashbot added a comment.Thu, Apr 4, 3:36 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T15:36:04Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1193 (T355609)', diff saved to https://phabricator.wikimedia.org/P59517 and previous config saved to /var/cache/conftool/dbconfig/20240404-153603-marostegui.json

Stashbot added a comment.Thu, Apr 4, 3:36 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T15:36:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1203 (T355609)', diff saved to https://phabricator.wikimedia.org/P59518 and previous config saved to /var/cache/conftool/dbconfig/20240404-153626-marostegui.json

Stashbot added a comment.Thu, Apr 4, 4:28 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T16:28:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1203 (T355609)', diff saved to https://phabricator.wikimedia.org/P59533 and previous config saved to /var/cache/conftool/dbconfig/20240404-162801-marostegui.json

Stashbot added a comment.Thu, Apr 4, 5:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T17:13:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1203 (T355609)', diff saved to https://phabricator.wikimedia.org/P59543 and previous config saved to /var/cache/conftool/dbconfig/20240404-171324-marostegui.json

Stashbot added a comment.Thu, Apr 4, 5:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T17:13:52Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1211 (T355609)', diff saved to https://phabricator.wikimedia.org/P59544 and previous config saved to /var/cache/conftool/dbconfig/20240404-171347-marostegui.json

Stashbot added a comment.Thu, Apr 4, 6:09 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T18:09:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1211 (T355609)', diff saved to https://phabricator.wikimedia.org/P59551 and previous config saved to /var/cache/conftool/dbconfig/20240404-180913-marostegui.json

Stashbot added a comment.Thu, Apr 4, 6:54 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T18:54:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1211 (T355609)', diff saved to https://phabricator.wikimedia.org/P59563 and previous config saved to /var/cache/conftool/dbconfig/20240404-185436-marostegui.json

Stashbot added a comment.Thu, Apr 4, 6:55 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T18:54:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1214 (T355609)', diff saved to https://phabricator.wikimedia.org/P59564 and previous config saved to /var/cache/conftool/dbconfig/20240404-185458-marostegui.json

Stashbot added a comment.Thu, Apr 4, 7:47 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T19:47:40Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1214 (T355609)', diff saved to https://phabricator.wikimedia.org/P59570 and previous config saved to /var/cache/conftool/dbconfig/20240404-194739-marostegui.json

Stashbot added a comment.Thu, Apr 4, 8:33 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T20:33:03Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1214 (T355609)', diff saved to https://phabricator.wikimedia.org/P59578 and previous config saved to /var/cache/conftool/dbconfig/20240404-203302-marostegui.json

Stashbot added a comment.Thu, Apr 4, 9:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T21:12:49Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1226 (T355609)', diff saved to https://phabricator.wikimedia.org/P59584 and previous config saved to /var/cache/conftool/dbconfig/20240404-211248-marostegui.json

Stashbot added a comment.Thu, Apr 4, 9:55 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T21:55:58Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1226 (T355609)', diff saved to https://phabricator.wikimedia.org/P59594 and previous config saved to /var/cache/conftool/dbconfig/20240404-215557-marostegui.json

Stashbot added a comment.Thu, Apr 4, 10:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-04T22:41:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1226 (T355609)', diff saved to https://phabricator.wikimedia.org/P59602 and previous config saved to /var/cache/conftool/dbconfig/20240404-224119-marostegui.json

• Marostegui updated the task description. (Show Details)Fri, Apr 5, 5:21 AM
• Marostegui updated the task description. (Show Details)Tue, Apr 9, 6:17 AM
Stashbot added a comment.Thu, Apr 18, 10:18 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-18T10:18:42Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1183 (T355609)', diff saved to https://phabricator.wikimedia.org/P60899 and previous config saved to /var/cache/conftool/dbconfig/20240418-101841-marostegui.json

Stashbot added a comment.Thu, Apr 18, 10:26 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-18T10:26:10Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1183 (T355609)', diff saved to https://phabricator.wikimedia.org/P60901 and previous config saved to /var/cache/conftool/dbconfig/20240418-102609-marostegui.json

• Marostegui updated the task description. (Show Details)Thu, Apr 18, 10:27 AM
Stashbot added a comment.Thu, Apr 18, 11:11 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-18T11:11:33Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1183 (T355609)', diff saved to https://phabricator.wikimedia.org/P60909 and previous config saved to /var/cache/conftool/dbconfig/20240418-111132-marostegui.json

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