Page MenuHomePhabricator
Create Task
Maniphest T321391

Add new column cu_log.cul_reason_id and cu_log.cul_reason_plaintext_id to wmf wikis
Closed, ResolvedPublic
Actions

Description

In rECHUd24e689913dc341d0b82aaa41d375b8ca1e4ff32 the columns 'cul_reason_id' and 'cul_reason_plaintext_id' were added so that the reason for the check would use the comment table. A config is pinned on WMF wikis with the schema migration value of reading and writing to old in rOMWCa454d3bc56c344fa62625f7c292ea087bddfebe5. Currently no code in CheckUser attempts to write or read from these columns. https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CheckUser/+/820835 is waiting for review and would write to these columns if the schema config variable allowed it.

  1. ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/4ed2e7953890e0823c67e392876f2e132f8e6959/schema/mysql/patch-cu_log-comment_table_for_reason.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: Has been merged for a few months and changes were in release 1.39. 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
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8
  • labtestwiki

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
ResolvedNoneT321391 Add new column cu_log.cul_reason_id and cu_log.cul_reason_plaintext_id to wmf wikis
· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Jan 12 2023, 1:15 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T01:15:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T321391)', diff saved to https://phabricator.wikimedia.org/P43056 and previous config saved to /var/cache/conftool/dbconfig/20230112-011526-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:00 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T02:00:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T321391)', diff saved to https://phabricator.wikimedia.org/P43059 and previous config saved to /var/cache/conftool/dbconfig/20230112-020046-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T02:51:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3311 (T321391)', diff saved to https://phabricator.wikimedia.org/P43060 and previous config saved to /var/cache/conftool/dbconfig/20230112-025153-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:54 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T02:54:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T321391)', diff saved to https://phabricator.wikimedia.org/P43061 and previous config saved to /var/cache/conftool/dbconfig/20230112-025417-marostegui.json

Stashbot added a comment.Jan 12 2023, 3:39 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T03:39:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T321391)', diff saved to https://phabricator.wikimedia.org/P43064 and previous config saved to /var/cache/conftool/dbconfig/20230112-033937-marostegui.json

Stashbot added a comment.Jan 12 2023, 3:39 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T03:39:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3311 (T321391)', diff saved to https://phabricator.wikimedia.org/P43065 and previous config saved to /var/cache/conftool/dbconfig/20230112-033958-marostegui.json

Stashbot added a comment.Jan 12 2023, 3:42 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T03:42:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T321391)', diff saved to https://phabricator.wikimedia.org/P43066 and previous config saved to /var/cache/conftool/dbconfig/20230112-034221-marostegui.json

Stashbot added a comment.Jan 12 2023, 4:27 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T04:27:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T321391)', diff saved to https://phabricator.wikimedia.org/P43069 and previous config saved to /var/cache/conftool/dbconfig/20230112-042741-marostegui.json

Stashbot added a comment.Jan 12 2023, 4:27 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T04:27:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T321391)', diff saved to https://phabricator.wikimedia.org/P43070 and previous config saved to /var/cache/conftool/dbconfig/20230112-042757-marostegui.json

Stashbot added a comment.Jan 12 2023, 4:30 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T04:30:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T321391)', diff saved to https://phabricator.wikimedia.org/P43071 and previous config saved to /var/cache/conftool/dbconfig/20230112-043020-marostegui.json

Stashbot added a comment.Jan 12 2023, 5:15 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T05:15:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T321391)', diff saved to https://phabricator.wikimedia.org/P43074 and previous config saved to /var/cache/conftool/dbconfig/20230112-051539-marostegui.json

Stashbot added a comment.Jan 12 2023, 5:16 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T05:16:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1107 (T321391)', diff saved to https://phabricator.wikimedia.org/P43075 and previous config saved to /var/cache/conftool/dbconfig/20230112-051601-marostegui.json

Stashbot added a comment.Jan 12 2023, 5:18 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T05:18:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1107 (T321391)', diff saved to https://phabricator.wikimedia.org/P43076 and previous config saved to /var/cache/conftool/dbconfig/20230112-051823-marostegui.json

Stashbot added a comment.Jan 12 2023, 6:03 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T06:03:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1107 (T321391)', diff saved to https://phabricator.wikimedia.org/P43079 and previous config saved to /var/cache/conftool/dbconfig/20230112-060343-marostegui.json

Stashbot added a comment.Jan 12 2023, 6:04 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T06:04:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1119 (T321391)', diff saved to https://phabricator.wikimedia.org/P43080 and previous config saved to /var/cache/conftool/dbconfig/20230112-060404-marostegui.json

Stashbot added a comment.Jan 12 2023, 6:06 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T06:06:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T321391)', diff saved to https://phabricator.wikimedia.org/P43081 and previous config saved to /var/cache/conftool/dbconfig/20230112-060627-marostegui.json

Stashbot added a comment.Jan 12 2023, 6:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T06:51:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T321391)', diff saved to https://phabricator.wikimedia.org/P43084 and previous config saved to /var/cache/conftool/dbconfig/20230112-065147-marostegui.json

Stashbot added a comment.Jan 12 2023, 6:52 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T06:52:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1128 (T321391)', diff saved to https://phabricator.wikimedia.org/P43085 and previous config saved to /var/cache/conftool/dbconfig/20230112-065208-marostegui.json

Stashbot added a comment.Jan 12 2023, 6:54 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T06:54:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T321391)', diff saved to https://phabricator.wikimedia.org/P43086 and previous config saved to /var/cache/conftool/dbconfig/20230112-065430-marostegui.json

Stashbot added a comment.Jan 12 2023, 7:39 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T07:39:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T321391)', diff saved to https://phabricator.wikimedia.org/P43089 and previous config saved to /var/cache/conftool/dbconfig/20230112-073949-marostegui.json

Stashbot added a comment.Jan 12 2023, 7:40 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T07:40:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1132 (T321391)', diff saved to https://phabricator.wikimedia.org/P43090 and previous config saved to /var/cache/conftool/dbconfig/20230112-074010-marostegui.json

Stashbot added a comment.Jan 12 2023, 7:42 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T07:42:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T321391)', diff saved to https://phabricator.wikimedia.org/P43091 and previous config saved to /var/cache/conftool/dbconfig/20230112-074232-marostegui.json

Stashbot added a comment.Jan 12 2023, 8:28 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T08:27:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T321391)', diff saved to https://phabricator.wikimedia.org/P43094 and previous config saved to /var/cache/conftool/dbconfig/20230112-082752-marostegui.json

Stashbot added a comment.Jan 12 2023, 8:28 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T08:28:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1134 (T321391)', diff saved to https://phabricator.wikimedia.org/P43095 and previous config saved to /var/cache/conftool/dbconfig/20230112-082813-marostegui.json

Stashbot added a comment.Jan 12 2023, 8:31 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T08:31:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T321391)', diff saved to https://phabricator.wikimedia.org/P43096 and previous config saved to /var/cache/conftool/dbconfig/20230112-083135-marostegui.json

Stashbot added a comment.Jan 12 2023, 9:16 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T09:16:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T321391)', diff saved to https://phabricator.wikimedia.org/P43099 and previous config saved to /var/cache/conftool/dbconfig/20230112-091654-marostegui.json

Stashbot added a comment.Jan 12 2023, 9:17 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T09:17:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T321391)', diff saved to https://phabricator.wikimedia.org/P43100 and previous config saved to /var/cache/conftool/dbconfig/20230112-091716-marostegui.json

Stashbot added a comment.Jan 12 2023, 9:19 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T09:19:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T321391)', diff saved to https://phabricator.wikimedia.org/P43101 and previous config saved to /var/cache/conftool/dbconfig/20230112-091937-marostegui.json

Stashbot added a comment.Jan 12 2023, 10:04 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T10:04:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T321391)', diff saved to https://phabricator.wikimedia.org/P43104 and previous config saved to /var/cache/conftool/dbconfig/20230112-100456-marostegui.json

Stashbot added a comment.Jan 12 2023, 10:06 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T10:06:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1163 (T321391)', diff saved to https://phabricator.wikimedia.org/P43105 and previous config saved to /var/cache/conftool/dbconfig/20230112-100616-marostegui.json

Stashbot added a comment.Jan 12 2023, 10:08 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T10:08:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T321391)', diff saved to https://phabricator.wikimedia.org/P43106 and previous config saved to /var/cache/conftool/dbconfig/20230112-100839-marostegui.json

Stashbot added a comment.Jan 12 2023, 10:53 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T10:53:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T321391)', diff saved to https://phabricator.wikimedia.org/P43109 and previous config saved to /var/cache/conftool/dbconfig/20230112-105358-marostegui.json

Stashbot added a comment.Jan 12 2023, 10:54 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T10:54:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1169 (T321391)', diff saved to https://phabricator.wikimedia.org/P43110 and previous config saved to /var/cache/conftool/dbconfig/20230112-105430-marostegui.json

Stashbot added a comment.Jan 12 2023, 10:56 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T10:56:53Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T321391)', diff saved to https://phabricator.wikimedia.org/P43111 and previous config saved to /var/cache/conftool/dbconfig/20230112-105652-marostegui.json

Stashbot added a comment.Jan 12 2023, 11:42 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T11:42:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T321391)', diff saved to https://phabricator.wikimedia.org/P43114 and previous config saved to /var/cache/conftool/dbconfig/20230112-114212-marostegui.json

Stashbot added a comment.Jan 12 2023, 11:43 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T11:43:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T321391)', diff saved to https://phabricator.wikimedia.org/P43115 and previous config saved to /var/cache/conftool/dbconfig/20230112-114302-marostegui.json

Stashbot added a comment.Jan 12 2023, 11:45 AM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T11:45:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T321391)', diff saved to https://phabricator.wikimedia.org/P43116 and previous config saved to /var/cache/conftool/dbconfig/20230112-114524-marostegui.json

Stashbot added a comment.Jan 12 2023, 12:30 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T12:30:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T321391)', diff saved to https://phabricator.wikimedia.org/P43121 and previous config saved to /var/cache/conftool/dbconfig/20230112-123045-marostegui.json

Stashbot added a comment.Jan 12 2023, 12:31 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T12:31:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1186 (T321391)', diff saved to https://phabricator.wikimedia.org/P43122 and previous config saved to /var/cache/conftool/dbconfig/20230112-123106-marostegui.json

Stashbot added a comment.Jan 12 2023, 12:33 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T12:33:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T321391)', diff saved to https://phabricator.wikimedia.org/P43123 and previous config saved to /var/cache/conftool/dbconfig/20230112-123328-marostegui.json

Stashbot added a comment.Jan 12 2023, 1:18 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T13:18:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T321391)', diff saved to https://phabricator.wikimedia.org/P43128 and previous config saved to /var/cache/conftool/dbconfig/20230112-131847-marostegui.json

Stashbot added a comment.Jan 12 2023, 1:19 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T13:19:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1196 (T321391)', diff saved to https://phabricator.wikimedia.org/P43129 and previous config saved to /var/cache/conftool/dbconfig/20230112-131908-marostegui.json

Stashbot added a comment.Jan 12 2023, 1:21 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T13:21:30Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T321391)', diff saved to https://phabricator.wikimedia.org/P43130 and previous config saved to /var/cache/conftool/dbconfig/20230112-132130-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:06 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T14:06:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T321391)', diff saved to https://phabricator.wikimedia.org/P43133 and previous config saved to /var/cache/conftool/dbconfig/20230112-140649-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:07 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T14:07:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1206 (T321391)', diff saved to https://phabricator.wikimedia.org/P43134 and previous config saved to /var/cache/conftool/dbconfig/20230112-140659-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:09 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T14:09:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T321391)', diff saved to https://phabricator.wikimedia.org/P43135 and previous config saved to /var/cache/conftool/dbconfig/20230112-140921-marostegui.json

Stashbot added a comment.Jan 12 2023, 2:54 PM

Mentioned in SAL (#wikimedia-operations) [2023-01-12T14:54:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T321391)', diff saved to https://phabricator.wikimedia.org/P43138 and previous config saved to /var/cache/conftool/dbconfig/20230112-145441-marostegui.json

Marostegui updated the task description. (Show Details)Jan 12 2023, 3:35 PM
Marostegui closed this task as Resolved.Jan 12 2023, 5:57 PM
Marostegui updated the task description. (Show Details)

All done

Dreamy_Jazz added a comment.Jan 12 2023, 8:35 PM

Thanks!

Dreamy_Jazz mentioned this in T328828: Remove default on cul_reason_id and cul_reason_plaintext_id in the cu_log table on wmf wikis.Feb 4 2023, 8:32 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 · Credits