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

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 7 2023, 9:12 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-07T21:12:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2138:3314 (T328817)', diff saved to https://phabricator.wikimedia.org/P45293 and previous config saved to /var/cache/conftool/dbconfig/20230307-211159-marostegui.json

Stashbot added a comment.Mar 7 2023, 9:21 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-07T21:21:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2147 (T328817)', diff saved to https://phabricator.wikimedia.org/P45298 and previous config saved to /var/cache/conftool/dbconfig/20230307-212138-marostegui.json

Stashbot added a comment.Mar 7 2023, 9:33 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-07T21:33:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T328817)', diff saved to https://phabricator.wikimedia.org/P45300 and previous config saved to /var/cache/conftool/dbconfig/20230307-213334-marostegui.json

Stashbot added a comment.Mar 7 2023, 10:18 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-07T22:18:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T328817)', diff saved to https://phabricator.wikimedia.org/P45312 and previous config saved to /var/cache/conftool/dbconfig/20230307-221854-marostegui.json

Stashbot added a comment.Mar 7 2023, 10:19 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-07T22:19:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2155 (T328817)', diff saved to https://phabricator.wikimedia.org/P45313 and previous config saved to /var/cache/conftool/dbconfig/20230307-221931-marostegui.json

Stashbot added a comment.Mar 7 2023, 11:19 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-07T23:19:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T328817)', diff saved to https://phabricator.wikimedia.org/P45326 and previous config saved to /var/cache/conftool/dbconfig/20230307-231957-marostegui.json

Stashbot added a comment.Mar 8 2023, 12:05 AM

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

Stashbot added a comment.Mar 8 2023, 12:05 AM

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

Stashbot added a comment.Mar 8 2023, 12:17 AM

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

Stashbot added a comment.Mar 8 2023, 1:03 AM

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

Stashbot added a comment.Mar 8 2023, 1:03 AM

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

Stashbot added a comment.Mar 8 2023, 1:14 AM

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

Stashbot added a comment.Mar 8 2023, 1:59 AM

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

• Marostegui updated the task description. (Show Details)Mar 8 2023, 7:47 AM

Going for s1

Stashbot added a comment.Mar 8 2023, 8:04 AM

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

Stashbot added a comment.Mar 8 2023, 8:16 AM

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

Stashbot added a comment.Mar 8 2023, 9:01 AM

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

Stashbot added a comment.Mar 8 2023, 9:01 AM

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

Stashbot added a comment.Mar 8 2023, 9:12 AM

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

Stashbot added a comment.Mar 8 2023, 9:57 AM

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

Stashbot added a comment.Mar 8 2023, 9:58 AM

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

Stashbot added a comment.Mar 8 2023, 10:08 AM

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

Stashbot added a comment.Mar 8 2023, 10:53 AM

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

Stashbot added a comment.Mar 8 2023, 11:03 AM

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

Stashbot added a comment.Mar 8 2023, 11:13 AM

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

Stashbot added a comment.Mar 8 2023, 11:59 AM

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

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