Page MenuHomePhabricator
Create Task
Maniphest T354336

Add columns cul_result_id and cul_result_plaintext_id to cu_log
Closed, ResolvedPublic
Actions

Description

Two new columns named cul_result_id and cul_result_plaintext_id will be used to hold a comment ID that references the comment table. These columns will be used by the feature added in T190666 that will allow a checkuser to optionally provide a result for the check. These rows will be by default 0 and updated to a valid comment ID if the checkuser specifies a result within a limited timeframe.

  1. ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/d1ec8fc2c21c4ff24cb2f8ec404aadbd5e2c8347/schema/mysql/patch-cu_log-add-cul_result_id.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 but has been deployed on a mwvagrant instance on https://checkuser-beta-wiki.wmcloud.org
  6. If the data should be made available on the labs replicas and/or dumps: Everything is private

Progress

  • s1
    • codfw
    • eqiad
  • s2
    • codfw
    • eqiad
  • s3
    • codfw
    • eqiad
  • s4
    • codfw
    • eqiad
  • s5
    • codfw
    • eqiad
  • s6
    • codfw
    • eqiad
  • s7
    • codfw
    • eqiad
  • s8
    • codfw
    • eqiad
  • labtestwiki (clouddb2002-dev)

Details

TitleReferenceAuthorSource BranchDest Branch
add_cul_result_id_T354336.py: New schema changerepos/sre/schema-changes!2marosteguiT354336main
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.Jan 24 2024, 8:53 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T20:53:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T354336)', diff saved to https://phabricator.wikimedia.org/P55567 and previous config saved to /var/cache/conftool/dbconfig/20240124-205327-marostegui.json

Stashbot added a comment.Jan 24 2024, 8:53 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T20:53:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1238 (T354336)', diff saved to https://phabricator.wikimedia.org/P55568 and previous config saved to /var/cache/conftool/dbconfig/20240124-205350-marostegui.json

Stashbot added a comment.Jan 24 2024, 8:56 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T20:56:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1238 (T354336)', diff saved to https://phabricator.wikimedia.org/P55569 and previous config saved to /var/cache/conftool/dbconfig/20240124-205600-marostegui.json

Stashbot added a comment.Jan 24 2024, 9:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T21:41:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1238 (T354336)', diff saved to https://phabricator.wikimedia.org/P55572 and previous config saved to /var/cache/conftool/dbconfig/20240124-214120-marostegui.json

Stashbot added a comment.Jan 24 2024, 9:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T21:41:42Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1241 (T354336)', diff saved to https://phabricator.wikimedia.org/P55573 and previous config saved to /var/cache/conftool/dbconfig/20240124-214141-marostegui.json

Stashbot added a comment.Jan 24 2024, 9:43 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T21:43:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1241 (T354336)', diff saved to https://phabricator.wikimedia.org/P55574 and previous config saved to /var/cache/conftool/dbconfig/20240124-214351-marostegui.json

Stashbot added a comment.Jan 24 2024, 10:29 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T22:29:10Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1241 (T354336)', diff saved to https://phabricator.wikimedia.org/P55577 and previous config saved to /var/cache/conftool/dbconfig/20240124-222910-marostegui.json

Stashbot added a comment.Jan 24 2024, 10:29 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T22:29:33Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1242 (T354336)', diff saved to https://phabricator.wikimedia.org/P55578 and previous config saved to /var/cache/conftool/dbconfig/20240124-222932-marostegui.json

Stashbot added a comment.Jan 24 2024, 10:31 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T22:31:43Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T354336)', diff saved to https://phabricator.wikimedia.org/P55579 and previous config saved to /var/cache/conftool/dbconfig/20240124-223142-marostegui.json

Stashbot added a comment.Jan 24 2024, 11:17 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T23:17:02Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T354336)', diff saved to https://phabricator.wikimedia.org/P55582 and previous config saved to /var/cache/conftool/dbconfig/20240124-231701-marostegui.json

Stashbot added a comment.Jan 24 2024, 11:17 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T23:17:24Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1243 (T354336)', diff saved to https://phabricator.wikimedia.org/P55583 and previous config saved to /var/cache/conftool/dbconfig/20240124-231723-marostegui.json

Stashbot added a comment.Jan 24 2024, 11:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-24T23:19:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T354336)', diff saved to https://phabricator.wikimedia.org/P55584 and previous config saved to /var/cache/conftool/dbconfig/20240124-231933-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:04 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T00:04:53Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T354336)', diff saved to https://phabricator.wikimedia.org/P55587 and previous config saved to /var/cache/conftool/dbconfig/20240125-000452-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T00:05:21Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1247 (T354336)', diff saved to https://phabricator.wikimedia.org/P55588 and previous config saved to /var/cache/conftool/dbconfig/20240125-000515-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:07 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T00:07:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T354336)', diff saved to https://phabricator.wikimedia.org/P55589 and previous config saved to /var/cache/conftool/dbconfig/20240125-000726-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T00:52:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T354336)', diff saved to https://phabricator.wikimedia.org/P55592 and previous config saved to /var/cache/conftool/dbconfig/20240125-005245-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:53 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T00:53:08Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1248 (T354336)', diff saved to https://phabricator.wikimedia.org/P55593 and previous config saved to /var/cache/conftool/dbconfig/20240125-005307-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T00:54:17Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T354336)', diff saved to https://phabricator.wikimedia.org/P55594 and previous config saved to /var/cache/conftool/dbconfig/20240125-005417-marostegui.json

Stashbot added a comment.Jan 25 2024, 1:39 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T01:39:37Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T354336)', diff saved to https://phabricator.wikimedia.org/P55597 and previous config saved to /var/cache/conftool/dbconfig/20240125-013936-marostegui.json

Stashbot added a comment.Jan 25 2024, 1:40 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T01:39:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1249 (T354336)', diff saved to https://phabricator.wikimedia.org/P55598 and previous config saved to /var/cache/conftool/dbconfig/20240125-013958-marostegui.json

Stashbot added a comment.Jan 25 2024, 1:42 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T01:42:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T354336)', diff saved to https://phabricator.wikimedia.org/P55599 and previous config saved to /var/cache/conftool/dbconfig/20240125-014208-marostegui.json

Stashbot added a comment.Jan 25 2024, 2:27 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T02:27:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T354336)', diff saved to https://phabricator.wikimedia.org/P55602 and previous config saved to /var/cache/conftool/dbconfig/20240125-022727-marostegui.json

Marostegui updated the task description. (Show Details)Jan 25 2024, 5:51 AM
Stashbot added a comment.Jan 25 2024, 5:56 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T05:56:26Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2106 (T354336)', diff saved to https://phabricator.wikimedia.org/P55603 and previous config saved to /var/cache/conftool/dbconfig/20240125-055626-marostegui.json

Stashbot added a comment.Jan 25 2024, 5:58 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T05:58:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2106 (T354336)', diff saved to https://phabricator.wikimedia.org/P55604 and previous config saved to /var/cache/conftool/dbconfig/20240125-055837-marostegui.json

Stashbot added a comment.Jan 25 2024, 6:43 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T06:43:58Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2106 (T354336)', diff saved to https://phabricator.wikimedia.org/P55620 and previous config saved to /var/cache/conftool/dbconfig/20240125-064357-marostegui.json

Stashbot added a comment.Jan 25 2024, 6:44 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T06:44:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2110 (T354336)', diff saved to https://phabricator.wikimedia.org/P55621 and previous config saved to /var/cache/conftool/dbconfig/20240125-064420-marostegui.json

Stashbot added a comment.Jan 25 2024, 6:55 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T06:55:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2110 (T354336)', diff saved to https://phabricator.wikimedia.org/P55626 and previous config saved to /var/cache/conftool/dbconfig/20240125-065535-marostegui.json

Stashbot added a comment.Jan 25 2024, 7:43 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T07:43:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2110 (T354336)', diff saved to https://phabricator.wikimedia.org/P55646 and previous config saved to /var/cache/conftool/dbconfig/20240125-074312-marostegui.json

Stashbot added a comment.Jan 25 2024, 7:43 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T07:43:35Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2119 (T354336)', diff saved to https://phabricator.wikimedia.org/P55647 and previous config saved to /var/cache/conftool/dbconfig/20240125-074334-marostegui.json

Stashbot added a comment.Jan 25 2024, 7:45 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T07:45:47Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2119 (T354336)', diff saved to https://phabricator.wikimedia.org/P55648 and previous config saved to /var/cache/conftool/dbconfig/20240125-074546-marostegui.json

Stashbot added a comment.Jan 25 2024, 8:31 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T08:31:06Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2119 (T354336)', diff saved to https://phabricator.wikimedia.org/P55652 and previous config saved to /var/cache/conftool/dbconfig/20240125-083106-marostegui.json

Stashbot added a comment.Jan 25 2024, 9:32 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T09:32:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2137:3314 (T354336)', diff saved to https://phabricator.wikimedia.org/P55653 and previous config saved to /var/cache/conftool/dbconfig/20240125-093208-marostegui.json

Stashbot added a comment.Jan 25 2024, 10:17 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T10:17:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2137:3314 (T354336)', diff saved to https://phabricator.wikimedia.org/P55656 and previous config saved to /var/cache/conftool/dbconfig/20240125-101728-marostegui.json

Stashbot added a comment.Jan 25 2024, 10:17 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T10:17:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2138:3314 (T354336)', diff saved to https://phabricator.wikimedia.org/P55657 and previous config saved to /var/cache/conftool/dbconfig/20240125-101750-marostegui.json

Stashbot added a comment.Jan 25 2024, 10:20 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T10:20:03Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138:3314 (T354336)', diff saved to https://phabricator.wikimedia.org/P55658 and previous config saved to /var/cache/conftool/dbconfig/20240125-102002-marostegui.json

Stashbot added a comment.Jan 25 2024, 11:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T11:05:22Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138:3314 (T354336)', diff saved to https://phabricator.wikimedia.org/P55662 and previous config saved to /var/cache/conftool/dbconfig/20240125-110521-marostegui.json

Stashbot added a comment.Jan 25 2024, 11:07 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T11:07:14Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T354336)', diff saved to https://phabricator.wikimedia.org/P55663 and previous config saved to /var/cache/conftool/dbconfig/20240125-110714-marostegui.json

Stashbot added a comment.Jan 25 2024, 11:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T11:52:34Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T354336)', diff saved to https://phabricator.wikimedia.org/P55666 and previous config saved to /var/cache/conftool/dbconfig/20240125-115233-marostegui.json

Stashbot added a comment.Jan 25 2024, 11:53 AM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T11:53:23Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2155 (T354336)', diff saved to https://phabricator.wikimedia.org/P55667 and previous config saved to /var/cache/conftool/dbconfig/20240125-115322-marostegui.json

Stashbot added a comment.Jan 25 2024, 12:53 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T12:53:54Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T354336)', diff saved to https://phabricator.wikimedia.org/P55669 and previous config saved to /var/cache/conftool/dbconfig/20240125-125353-marostegui.json

Stashbot added a comment.Jan 25 2024, 1:39 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T13:39:14Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T354336)', diff saved to https://phabricator.wikimedia.org/P55675 and previous config saved to /var/cache/conftool/dbconfig/20240125-133913-marostegui.json

Stashbot added a comment.Jan 25 2024, 1:39 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T13:39:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2172 (T354336)', diff saved to https://phabricator.wikimedia.org/P55676 and previous config saved to /var/cache/conftool/dbconfig/20240125-133935-marostegui.json

Stashbot added a comment.Jan 25 2024, 1:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T13:41:48Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T354336)', diff saved to https://phabricator.wikimedia.org/P55677 and previous config saved to /var/cache/conftool/dbconfig/20240125-134147-marostegui.json

Stashbot added a comment.Jan 25 2024, 2:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T14:27:07Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T354336)', diff saved to https://phabricator.wikimedia.org/P55683 and previous config saved to /var/cache/conftool/dbconfig/20240125-142706-marostegui.json

Stashbot added a comment.Jan 25 2024, 2:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T14:27:30Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2179 (T354336)', diff saved to https://phabricator.wikimedia.org/P55684 and previous config saved to /var/cache/conftool/dbconfig/20240125-142729-marostegui.json

Stashbot added a comment.Jan 25 2024, 3:28 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T15:28:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T354336)', diff saved to https://phabricator.wikimedia.org/P55687 and previous config saved to /var/cache/conftool/dbconfig/20240125-152801-marostegui.json

Stashbot added a comment.Jan 25 2024, 4:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-01-25T16:13:21Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T354336)', diff saved to https://phabricator.wikimedia.org/P55691 and previous config saved to /var/cache/conftool/dbconfig/20240125-161320-marostegui.json

Marostegui updated the task description. (Show Details)Jan 25 2024, 5:52 PM

It is done everywhere, but I am not going to close yet as I need to double check that no hosts were left behind
So far I've checked:

  • s1
  • s2
  • s4
  • s6
  • s8

Pending:

  • s3
  • s5
  • s7
Marostegui closed this task as Resolved.Jan 29 2024, 6:00 AM
In T354336#9489163, @Marostegui wrote:

It is done everywhere, but I am not going to close yet as I need to double check that no hosts were left behind
So far I've checked:

  • s1
  • s2
  • s4
  • s6
  • s8

Pending:

  • s3
  • s5
  • s7

s3, s5 and s7 are done.

Maintenance_bot moved this task from In progress to Done on the DBA board.Jan 29 2024, 6:29 AM
Dreamy_Jazz added a comment.Jan 29 2024, 10:53 AM

Thanks!

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