Page MenuHomePhabricator
Create Task
Maniphest T321126

Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis
Closed, ResolvedPublic
Actions

Description

Add the column 'cul_actor' and the the index from https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CheckUser/+/812411 to wmf wikis.

  1. ALTERs to run: CREATE INDEX and ADD is in https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/48ea3bfb4771fd0e353abfc22b7264900dcf5791/schema/mysql/patch-cu_log-actor.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: running on beta
  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 +/-
add_cul_actor_T321126.py: New schema changeoperations/software/schema-changesmaster+37 -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
· · ·
OpenNoneT321063 Fix CheckUser database schema drifts in production
ResolvedZabeT233004 Update CheckUser for actor and comment table
ResolvedMarosteguiT321126 Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis
· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Nov 29 2022, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T14:00:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T321126)', diff saved to https://phabricator.wikimedia.org/P41723 and previous config saved to /var/cache/conftool/dbconfig/20221129-140018-marostegui.json

Stashbot added a comment.Nov 29 2022, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T14:00:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T321126)', diff saved to https://phabricator.wikimedia.org/P41724 and previous config saved to /var/cache/conftool/dbconfig/20221129-140050-marostegui.json

Stashbot added a comment.Nov 29 2022, 2:03 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T14:03:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T321126)', diff saved to https://phabricator.wikimedia.org/P41725 and previous config saved to /var/cache/conftool/dbconfig/20221129-140311-marostegui.json

Stashbot added a comment.Nov 29 2022, 2:48 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T14:48:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T321126)', diff saved to https://phabricator.wikimedia.org/P41731 and previous config saved to /var/cache/conftool/dbconfig/20221129-144831-marostegui.json

Stashbot added a comment.Nov 29 2022, 2:49 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T14:49:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1169 (T321126)', diff saved to https://phabricator.wikimedia.org/P41732 and previous config saved to /var/cache/conftool/dbconfig/20221129-144952-marostegui.json

Stashbot added a comment.Nov 29 2022, 2:55 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T14:55:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T321126)', diff saved to https://phabricator.wikimedia.org/P41734 and previous config saved to /var/cache/conftool/dbconfig/20221129-145513-marostegui.json

Stashbot added a comment.Nov 29 2022, 3:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T15:40:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T321126)', diff saved to https://phabricator.wikimedia.org/P41743 and previous config saved to /var/cache/conftool/dbconfig/20221129-154033-marostegui.json

Stashbot added a comment.Nov 29 2022, 3:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T15:40:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T321126)', diff saved to https://phabricator.wikimedia.org/P41744 and previous config saved to /var/cache/conftool/dbconfig/20221129-154055-marostegui.json

Stashbot added a comment.Nov 29 2022, 3:43 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T15:43:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T321126)', diff saved to https://phabricator.wikimedia.org/P41745 and previous config saved to /var/cache/conftool/dbconfig/20221129-154316-marostegui.json

Stashbot added a comment.Nov 29 2022, 4:28 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T16:28:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T321126)', diff saved to https://phabricator.wikimedia.org/P41754 and previous config saved to /var/cache/conftool/dbconfig/20221129-162835-marostegui.json

Stashbot added a comment.Nov 29 2022, 4:28 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T16:28:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1186 (T321126)', diff saved to https://phabricator.wikimedia.org/P41755 and previous config saved to /var/cache/conftool/dbconfig/20221129-162857-marostegui.json

Stashbot added a comment.Nov 29 2022, 4:31 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T16:31:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T321126)', diff saved to https://phabricator.wikimedia.org/P41756 and previous config saved to /var/cache/conftool/dbconfig/20221129-163118-marostegui.json

Stashbot added a comment.Nov 29 2022, 5:16 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T17:16:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T321126)', diff saved to https://phabricator.wikimedia.org/P41761 and previous config saved to /var/cache/conftool/dbconfig/20221129-171638-marostegui.json

Stashbot added a comment.Nov 29 2022, 5:17 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T17:17:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1196 (T321126)', diff saved to https://phabricator.wikimedia.org/P41762 and previous config saved to /var/cache/conftool/dbconfig/20221129-171710-marostegui.json

Stashbot added a comment.Nov 29 2022, 5:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T17:19:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T321126)', diff saved to https://phabricator.wikimedia.org/P41764 and previous config saved to /var/cache/conftool/dbconfig/20221129-171931-marostegui.json

Stashbot added a comment.Nov 29 2022, 6:04 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T18:04:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T321126)', diff saved to https://phabricator.wikimedia.org/P41771 and previous config saved to /var/cache/conftool/dbconfig/20221129-180451-marostegui.json

Stashbot added a comment.Nov 29 2022, 6:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T18:06:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2103 (T321126)', diff saved to https://phabricator.wikimedia.org/P41772 and previous config saved to /var/cache/conftool/dbconfig/20221129-180646-marostegui.json

Stashbot added a comment.Nov 29 2022, 6:09 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T18:09:10Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T321126)', diff saved to https://phabricator.wikimedia.org/P41773 and previous config saved to /var/cache/conftool/dbconfig/20221129-180909-marostegui.json

Stashbot added a comment.Nov 29 2022, 6:54 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T18:54:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T321126)', diff saved to https://phabricator.wikimedia.org/P41777 and previous config saved to /var/cache/conftool/dbconfig/20221129-185429-marostegui.json

Stashbot added a comment.Nov 29 2022, 6:56 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T18:56:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2116 (T321126)', diff saved to https://phabricator.wikimedia.org/P41778 and previous config saved to /var/cache/conftool/dbconfig/20221129-185450-marostegui.json

Stashbot added a comment.Nov 29 2022, 6:57 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T18:57:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T321126)', diff saved to https://phabricator.wikimedia.org/P41780 and previous config saved to /var/cache/conftool/dbconfig/20221129-185714-marostegui.json

Stashbot added a comment.Nov 29 2022, 7:42 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T19:42:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T321126)', diff saved to https://phabricator.wikimedia.org/P41786 and previous config saved to /var/cache/conftool/dbconfig/20221129-194235-marostegui.json

Stashbot added a comment.Nov 29 2022, 7:42 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T19:42:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2130 (T321126)', diff saved to https://phabricator.wikimedia.org/P41787 and previous config saved to /var/cache/conftool/dbconfig/20221129-194257-marostegui.json

Stashbot added a comment.Nov 29 2022, 7:45 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T19:45:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T321126)', diff saved to https://phabricator.wikimedia.org/P41788 and previous config saved to /var/cache/conftool/dbconfig/20221129-194520-marostegui.json

Stashbot added a comment.Nov 29 2022, 8:30 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T20:30:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T321126)', diff saved to https://phabricator.wikimedia.org/P41793 and previous config saved to /var/cache/conftool/dbconfig/20221129-203040-marostegui.json

Stashbot added a comment.Nov 29 2022, 8:31 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T20:31:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2145 (T321126)', diff saved to https://phabricator.wikimedia.org/P41794 and previous config saved to /var/cache/conftool/dbconfig/20221129-203135-marostegui.json

Stashbot added a comment.Nov 29 2022, 8:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T20:33:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T321126)', diff saved to https://phabricator.wikimedia.org/P41796 and previous config saved to /var/cache/conftool/dbconfig/20221129-203359-marostegui.json

Stashbot added a comment.Nov 29 2022, 9:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T21:19:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T321126)', diff saved to https://phabricator.wikimedia.org/P41800 and previous config saved to /var/cache/conftool/dbconfig/20221129-211918-marostegui.json

Stashbot added a comment.Nov 29 2022, 9:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T21:19:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2146 (T321126)', diff saved to https://phabricator.wikimedia.org/P41801 and previous config saved to /var/cache/conftool/dbconfig/20221129-211940-marostegui.json

Stashbot added a comment.Nov 29 2022, 9:22 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T21:22:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T321126)', diff saved to https://phabricator.wikimedia.org/P41802 and previous config saved to /var/cache/conftool/dbconfig/20221129-212203-marostegui.json

Stashbot added a comment.Nov 29 2022, 10:07 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T22:07:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T321126)', diff saved to https://phabricator.wikimedia.org/P41806 and previous config saved to /var/cache/conftool/dbconfig/20221129-220723-marostegui.json

Stashbot added a comment.Nov 29 2022, 10:07 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T22:07:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2153 (T321126)', diff saved to https://phabricator.wikimedia.org/P41807 and previous config saved to /var/cache/conftool/dbconfig/20221129-220745-marostegui.json

Stashbot added a comment.Nov 29 2022, 10:10 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T22:10:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T321126)', diff saved to https://phabricator.wikimedia.org/P41808 and previous config saved to /var/cache/conftool/dbconfig/20221129-221008-marostegui.json

Stashbot added a comment.Nov 29 2022, 10:55 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T22:55:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T321126)', diff saved to https://phabricator.wikimedia.org/P41811 and previous config saved to /var/cache/conftool/dbconfig/20221129-225527-marostegui.json

Stashbot added a comment.Nov 29 2022, 10:55 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T22:55:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2167:3311 (T321126)', diff saved to https://phabricator.wikimedia.org/P41812 and previous config saved to /var/cache/conftool/dbconfig/20221129-225549-marostegui.json

Stashbot added a comment.Nov 29 2022, 10:58 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T22:58:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T321126)', diff saved to https://phabricator.wikimedia.org/P41813 and previous config saved to /var/cache/conftool/dbconfig/20221129-225814-marostegui.json

Stashbot added a comment.Nov 29 2022, 11:43 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T23:43:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T321126)', diff saved to https://phabricator.wikimedia.org/P41817 and previous config saved to /var/cache/conftool/dbconfig/20221129-234333-marostegui.json

Stashbot added a comment.Nov 29 2022, 11:43 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T23:43:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2170:3311 (T321126)', diff saved to https://phabricator.wikimedia.org/P41818 and previous config saved to /var/cache/conftool/dbconfig/20221129-234354-marostegui.json

Stashbot added a comment.Nov 29 2022, 11:46 PM

Mentioned in SAL (#wikimedia-operations) [2022-11-29T23:46:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T321126)', diff saved to https://phabricator.wikimedia.org/P41819 and previous config saved to /var/cache/conftool/dbconfig/20221129-234619-marostegui.json

Stashbot added a comment.Nov 30 2022, 12:31 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T00:31:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T321126)', diff saved to https://phabricator.wikimedia.org/P41824 and previous config saved to /var/cache/conftool/dbconfig/20221130-003138-marostegui.json

Stashbot added a comment.Nov 30 2022, 12:31 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T00:31:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T321126)', diff saved to https://phabricator.wikimedia.org/P41825 and previous config saved to /var/cache/conftool/dbconfig/20221130-003149-marostegui.json

Stashbot added a comment.Nov 30 2022, 12:34 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T00:34:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T321126)', diff saved to https://phabricator.wikimedia.org/P41826 and previous config saved to /var/cache/conftool/dbconfig/20221130-003413-marostegui.json

Stashbot added a comment.Nov 30 2022, 1:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T01:19:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T321126)', diff saved to https://phabricator.wikimedia.org/P41832 and previous config saved to /var/cache/conftool/dbconfig/20221130-011933-marostegui.json

Stashbot added a comment.Nov 30 2022, 1:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T01:19:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T321126)', diff saved to https://phabricator.wikimedia.org/P41833 and previous config saved to /var/cache/conftool/dbconfig/20221130-011954-marostegui.json

Stashbot added a comment.Nov 30 2022, 1:22 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T01:22:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T321126)', diff saved to https://phabricator.wikimedia.org/P41834 and previous config saved to /var/cache/conftool/dbconfig/20221130-012218-marostegui.json

Stashbot added a comment.Nov 30 2022, 2:07 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-30T02:07:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T321126)', diff saved to https://phabricator.wikimedia.org/P41840 and previous config saved to /var/cache/conftool/dbconfig/20221130-020737-marostegui.json

Marostegui closed this task as Resolved.Nov 30 2022, 6:50 AM
Marostegui updated the task description. (Show Details)

All done

Maintenance_bot moved this task from In progress to Done on the DBA board.Nov 30 2022, 7:15 AM
Marostegui added a comment.Dec 1 2022, 6:11 AM

Applied to db2173 which was down as part of T322988

Dreamy_Jazz mentioned this in T321391: Add new column cu_log.cul_reason_id and cu_log.cul_reason_plaintext_id to wmf wikis.Jan 9 2023, 5:30 PM
Marostegui updated the task description. (Show Details)Jan 11 2023, 4:49 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