Page MenuHomePhabricator
Create Task
Maniphest T328817

Drop cuc_user and cuc_user_text from cu_changes in wmf wikis
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/c50a5cbcfdaa391af94419d995deb2730bc3dba9/schema/mysql/patch-cu_changes-drop-cuc_user.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: no, as this drops data
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster doesn't have checkuser
  6. If the data should be made available on the labs replicas and/or dumps: Everything is private

Progress

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

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
cuc_user_cuc_user_text_T328817.py: All databasesoperations/software/schema-changesmaster+1 -1
cuc_user_cuc_user_text_T328817.py: New schema changeoperations/software/schema-changesmaster+36 -0
Customize query in gerrit

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
ResolvedZabeT233004 Update CheckUser for actor and comment table
Resolved• MarosteguiT328817 Drop cuc_user and cuc_user_text from cu_changes in wmf wikis
· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Mar 8 2023, 11:59 AM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T11:59:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2146 (T328817)', diff saved to https://phabricator.wikimedia.org/P45476 and previous config saved to /var/cache/conftool/dbconfig/20230308-115924-marostegui.json

Stashbot added a comment.Mar 8 2023, 12:10 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T12:10:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T328817)', diff saved to https://phabricator.wikimedia.org/P45479 and previous config saved to /var/cache/conftool/dbconfig/20230308-121009-marostegui.json

Stashbot added a comment.Mar 8 2023, 12:55 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T12:55:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T328817)', diff saved to https://phabricator.wikimedia.org/P45493 and previous config saved to /var/cache/conftool/dbconfig/20230308-125527-marostegui.json

Stashbot added a comment.Mar 8 2023, 12:55 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T12:55:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2153 (T328817)', diff saved to https://phabricator.wikimedia.org/P45494 and previous config saved to /var/cache/conftool/dbconfig/20230308-125548-marostegui.json

Stashbot added a comment.Mar 8 2023, 1:06 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T13:06:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T328817)', diff saved to https://phabricator.wikimedia.org/P45495 and previous config saved to /var/cache/conftool/dbconfig/20230308-130613-marostegui.json

Stashbot added a comment.Mar 8 2023, 1:51 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T13:51:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T328817)', diff saved to https://phabricator.wikimedia.org/P45506 and previous config saved to /var/cache/conftool/dbconfig/20230308-135132-marostegui.json

Stashbot added a comment.Mar 8 2023, 1:51 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T13:51:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2167:3311 (T328817)', diff saved to https://phabricator.wikimedia.org/P45507 and previous config saved to /var/cache/conftool/dbconfig/20230308-135153-marostegui.json

Stashbot added a comment.Mar 8 2023, 2:04 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T14:04:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T328817)', diff saved to https://phabricator.wikimedia.org/P45509 and previous config saved to /var/cache/conftool/dbconfig/20230308-140405-marostegui.json

Stashbot added a comment.Mar 8 2023, 2:49 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T14:49:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T328817)', diff saved to https://phabricator.wikimedia.org/P45521 and previous config saved to /var/cache/conftool/dbconfig/20230308-144924-marostegui.json

Stashbot added a comment.Mar 8 2023, 2:49 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T14:49:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2170:3311 (T328817)', diff saved to https://phabricator.wikimedia.org/P45522 and previous config saved to /var/cache/conftool/dbconfig/20230308-144934-marostegui.json

Stashbot added a comment.Mar 8 2023, 3:01 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T15:01:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T328817)', diff saved to https://phabricator.wikimedia.org/P45524 and previous config saved to /var/cache/conftool/dbconfig/20230308-150150-marostegui.json

Stashbot added a comment.Mar 8 2023, 3:47 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T15:47:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T328817)', diff saved to https://phabricator.wikimedia.org/P45527 and previous config saved to /var/cache/conftool/dbconfig/20230308-154709-marostegui.json

Stashbot added a comment.Mar 8 2023, 3:47 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T15:47:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2173 (T328817)', diff saved to https://phabricator.wikimedia.org/P45529 and previous config saved to /var/cache/conftool/dbconfig/20230308-154736-marostegui.json

Stashbot added a comment.Mar 8 2023, 4:02 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:02:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T328817)', diff saved to https://phabricator.wikimedia.org/P45530 and previous config saved to /var/cache/conftool/dbconfig/20230308-160221-marostegui.json

Stashbot added a comment.Mar 8 2023, 4:47 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:47:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T328817)', diff saved to https://phabricator.wikimedia.org/P45539 and previous config saved to /var/cache/conftool/dbconfig/20230308-164746-marostegui.json

Stashbot added a comment.Mar 8 2023, 4:48 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:48:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T328817)', diff saved to https://phabricator.wikimedia.org/P45540 and previous config saved to /var/cache/conftool/dbconfig/20230308-164807-marostegui.json

Stashbot added a comment.Mar 8 2023, 4:59 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:59:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T328817)', diff saved to https://phabricator.wikimedia.org/P45542 and previous config saved to /var/cache/conftool/dbconfig/20230308-165955-marostegui.json

Stashbot added a comment.Mar 8 2023, 5:45 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T17:45:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T328817)', diff saved to https://phabricator.wikimedia.org/P45557 and previous config saved to /var/cache/conftool/dbconfig/20230308-174514-marostegui.json

Stashbot added a comment.Mar 8 2023, 5:45 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T17:45:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T328817)', diff saved to https://phabricator.wikimedia.org/P45558 and previous config saved to /var/cache/conftool/dbconfig/20230308-174535-marostegui.json

Stashbot added a comment.Mar 8 2023, 5:58 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T17:58:10Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T328817)', diff saved to https://phabricator.wikimedia.org/P45561 and previous config saved to /var/cache/conftool/dbconfig/20230308-175810-marostegui.json

Stashbot added a comment.Mar 8 2023, 6:43 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-08T18:43:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T328817)', diff saved to https://phabricator.wikimedia.org/P45573 and previous config saved to /var/cache/conftool/dbconfig/20230308-184328-marostegui.json

• Marostegui closed this task as Resolved.Mar 9 2023, 6:37 AM
• Marostegui updated the task description. (Show Details)

All done

Maintenance_bot moved this task from In progress to Done on the DBA board.Mar 9 2023, 7:15 AM
• Dreamy_Jazz added a comment.Mar 13 2023, 12:50 PM

Thanks!

• Dreamy_Jazz subscribed.Mar 13 2023, 12:50 PM
• Dreamy_Jazz mentioned this in T343175: Remove old fields 'cuc_user' and 'cuc_user_text' as well as index 'cuc_user_ip_time' from a few production wikis.Jul 31 2023, 11:37 PM
Ladsgroup subscribed.Nov 28 2024, 10:22 PM

This was missed in all of s6 in codfw. I'm running it now.

Stashbot added a comment.Nov 28 2024, 10:22 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-28T22:22:51Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2151 (T328817)', diff saved to https://phabricator.wikimedia.org/P71376 and previous config saved to /var/cache/conftool/dbconfig/20241128-222250-ladsgroup.json

Stashbot added a comment.Nov 28 2024, 10:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-28T22:27:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T328817)', diff saved to https://phabricator.wikimedia.org/P71377 and previous config saved to /var/cache/conftool/dbconfig/20241128-222751-ladsgroup.json

Stashbot added a comment.Nov 28 2024, 11:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-28T23:13:13Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T328817)', diff saved to https://phabricator.wikimedia.org/P71385 and previous config saved to /var/cache/conftool/dbconfig/20241128-231312-ladsgroup.json

Stashbot added a comment.Nov 28 2024, 11:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-28T23:13:51Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2158 (T328817)', diff saved to https://phabricator.wikimedia.org/P71386 and previous config saved to /var/cache/conftool/dbconfig/20241128-231350-ladsgroup.json

Stashbot added a comment.Nov 28 2024, 11:16 PM

Mentioned in SAL (#wikimedia-operations) [2024-11-28T23:16:51Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T328817)', diff saved to https://phabricator.wikimedia.org/P71387 and previous config saved to /var/cache/conftool/dbconfig/20241128-231650-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 12:02 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T00:02:12Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T328817)', diff saved to https://phabricator.wikimedia.org/P71392 and previous config saved to /var/cache/conftool/dbconfig/20241129-000211-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 12:02 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T00:02:34Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2169 (T328817)', diff saved to https://phabricator.wikimedia.org/P71393 and previous config saved to /var/cache/conftool/dbconfig/20241129-000234-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 12:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T00:05:34Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2169 (T328817)', diff saved to https://phabricator.wikimedia.org/P71394 and previous config saved to /var/cache/conftool/dbconfig/20241129-000533-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 12:50 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T00:50:54Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2169 (T328817)', diff saved to https://phabricator.wikimedia.org/P71397 and previous config saved to /var/cache/conftool/dbconfig/20241129-005054-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 12:51 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T00:51:17Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2180 (T328817)', diff saved to https://phabricator.wikimedia.org/P71398 and previous config saved to /var/cache/conftool/dbconfig/20241129-005117-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 12:53 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T00:53:29Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T328817)', diff saved to https://phabricator.wikimedia.org/P71399 and previous config saved to /var/cache/conftool/dbconfig/20241129-005328-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 1:38 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T01:38:50Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T328817)', diff saved to https://phabricator.wikimedia.org/P71402 and previous config saved to /var/cache/conftool/dbconfig/20241129-013850-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 1:39 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T01:39:13Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2193 (T328817)', diff saved to https://phabricator.wikimedia.org/P71403 and previous config saved to /var/cache/conftool/dbconfig/20241129-013912-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 1:41 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T01:41:24Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2193 (T328817)', diff saved to https://phabricator.wikimedia.org/P71404 and previous config saved to /var/cache/conftool/dbconfig/20241129-014124-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 2:26 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T02:26:45Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2193 (T328817)', diff saved to https://phabricator.wikimedia.org/P71407 and previous config saved to /var/cache/conftool/dbconfig/20241129-022645-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 2:28 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T02:28:23Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2217 (T328817)', diff saved to https://phabricator.wikimedia.org/P71408 and previous config saved to /var/cache/conftool/dbconfig/20241129-022822-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 2:31 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T02:31:19Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2217 (T328817)', diff saved to https://phabricator.wikimedia.org/P71409 and previous config saved to /var/cache/conftool/dbconfig/20241129-023118-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 3:16 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T03:16:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2217 (T328817)', diff saved to https://phabricator.wikimedia.org/P71412 and previous config saved to /var/cache/conftool/dbconfig/20241129-031642-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 3:17 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T03:17:05Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2224 (T328817)', diff saved to https://phabricator.wikimedia.org/P71413 and previous config saved to /var/cache/conftool/dbconfig/20241129-031705-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 3:20 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T03:20:03Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2224 (T328817)', diff saved to https://phabricator.wikimedia.org/P71414 and previous config saved to /var/cache/conftool/dbconfig/20241129-032002-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 4:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T04:05:24Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2224 (T328817)', diff saved to https://phabricator.wikimedia.org/P71417 and previous config saved to /var/cache/conftool/dbconfig/20241129-040523-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 4:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T04:05:47Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2229 (T328817)', diff saved to https://phabricator.wikimedia.org/P71418 and previous config saved to /var/cache/conftool/dbconfig/20241129-040547-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 4:08 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T04:08:48Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2229 (T328817)', diff saved to https://phabricator.wikimedia.org/P71419 and previous config saved to /var/cache/conftool/dbconfig/20241129-040846-ladsgroup.json

Stashbot added a comment.Nov 29 2024, 4:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-11-29T04:54:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2229 (T328817)', diff saved to https://phabricator.wikimedia.org/P71422 and previous config saved to /var/cache/conftool/dbconfig/20241129-045409-ladsgroup.json

• Marostegui added a comment.Nov 29 2024, 6:12 AM
In T328817#10366492, @Ladsgroup wrote:

This was missed in all of s6 in codfw. I'm running it now.

This is so weird. I wonder if it was missing in a host and got accidentally recloned everywhere without it. Thank you though

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 · Credits