Page MenuHomePhabricator
Create Task
Maniphest T233004

Update CheckUser for actor and comment table
Closed, ResolvedPublic
Actions

Description

Current CheckUser extension does not use actor table and comment table.

Related tasks:

Details

ProjectBranchLines +/-Subject
mediawiki/extensions/CheckUsermaster+321 -8Drop default from cuc_actor and cuc_comment_id
operations/mediawiki-configmaster+0 -11stop setting checkuser actor/comment migration variables
mediawiki/extensions/CheckUsermaster+42 -116Remove CheckUserActorMigration as cu_changes actor migration is done
mediawiki/extensions/CheckUsermaster+325 -10Remove cuc_comment from cu_changes
mediawiki/extensions/CheckUserwmf/1.40.0-wmf.21+10 -21Remove cul_reason comment table migration code
mediawiki/extensions/CheckUsermaster+67 -70Remove CheckUserCommentStore as cu_changes comment migration is done
mediawiki/extensions/Flowmaster+8 -4Use core's CommentStore
mediawiki/extensions/CheckUsermaster+30 -83Remove CheckUserLogCommentStore as cu_log comment migration is done
mediawiki/extensions/CheckUsermaster+13 -48Drop cuc_comment_id migration variable
mediawiki/extensions/CheckUsermaster+266 -10Remove default from cu_log comment table ID fields
mediawiki/extensions/CheckUsermaster+341 -28Remove cuc_user and cuc_user_text from cu_changes
mediawiki/extensions/CheckUsermaster+160 -53Remove cul_reason column from cu_log
operations/mediawiki-configmaster+1 -0Stop writing to cuc_comment_id in group0 wikis
mediawiki/extensions/CheckUsermaster+58 -151Remove cul_reason comment table migration code
mediawiki/extensions/CheckUsermaster+115 -276Drop cuc_actor migration code
operations/mediawiki-configmaster+1 -4Stop writing to cuc_comment everywhere
operations/mediawiki-configmaster+1 -4Disable write old for CheckUserLog reason everywhere
operations/mediawiki-configmaster+1 -4Stop writing to cuc_user and cuc_user_text everywhere
operations/mediawiki-configmaster+1 -0Stop writing to cuc_comment in group1 wikis
operations/mediawiki-configmaster+1 -0Stop writing to cuc_user and cuc_user_text in group1 wikis
operations/mediawiki-configmaster+1 -1Disable write old for CheckUserLog reason on group 0
operations/mediawiki-configmaster+1 -0Stop writing to cuc_comment in testwiki
operations/mediawiki-configmaster+1 -0Stop writing to cuc_user and cuc_user_text in group0 wikis
operations/mediawiki-configmaster+1 -1Disable write old for CheckUserLog reason field for testwiki
operations/mediawiki-configmaster+1 -0Stop writing to cuc_user and cuc_user_text in testwiki
mediawiki/extensions/CheckUsermaster+282 -5Drop default value from cul_actor
mediawiki/extensions/CheckUsermaster+18 -2Add support to turn off write old for cu_log reason migration
mediawiki/extensions/CheckUsermaster+284 -4Specify default for cul_reason to support turning off write old
mediawiki/extensions/Flowmaster+10 -4Update for CheckUser comment migration
mediawiki/extensions/CheckUsermaster+12 -4Add write new support for cuc_comment_id migration
mediawiki/extensions/AccountInfomaster+2 -2Update for CheckUser actor migration
operations/mediawiki-configmaster+0 -3Stop setting cul_actor migration var
mediawiki/extensions/CheckUsermaster+43 -90Drop cul_user and cul_user_text from cu_log
operations/mediawiki-configmaster+1 -1Enable write new for CheckUserLog comment fields everywhere
operations/mediawiki-configmaster+2 -2Enable write new for CheckUserLog comment fields on group 0 and 1
mediawiki/extensions/CheckUsermaster+23 -9Add write new support for cuc_actor migration
operations/mediawiki-configmaster+1 -1Enable write new for CheckUserLog comment fields on testwikis
operations/mediawiki-configmaster+0 -1Start reading from cuc_comment_id on wikidatawiki
mediawiki/extensions/LoginNotifymaster+18 -17Update for CheckUser actor migration
mediawiki/extensions/CheckUsermaster+2 -2Drop cul_user from 'selectFields' in CheckUserLogPager
mediawiki/extensions/CheckUsermaster+20 -122Drop cul_actor migration code
operations/mediawiki-configmaster+2 -6Start reading from cuc_comment_id everywhere except wikidatawiki
mediawiki/extensions/CheckUserwmf/1.40.0-wmf.19+12 -5Add ability to start from cuc_id to populateCucComment
mediawiki/extensions/CheckUsermaster+12 -5Add ability to start from cuc_id to populateCucComment
mediawiki/extensions/CheckUsermaster+149 -15Add read new support for cu_log comment ID columns
operations/mediawiki-configmaster+1 -1Write to cul_reason[_plaintext]_id everywhere
operations/mediawiki-configmaster+4 -0Start reading from cuc_comment_id from a few wikis
operations/mediawiki-configmaster+1 -0Start reading from cuc_comment_id on testwiki
operations/mediawiki-configmaster+1 -7Start reading from cuc_actor everywhere
operations/mediawiki-configmaster+2 -0Revert "Revert "Start writing to cul_reason[_plaintext]_id on group0 and group1 wikis""
operations/mediawiki-configmaster+1 -6Stop writing to cul_user and cul_user_text everywhere
mediawiki/extensions/CheckUsermaster+121 -17Add read new support for cu_log comment ID columns
operations/mediawiki-configmaster+2 -0Start writing to cul_reason[_plaintext]_id on group0 and group1 wikis
operations/mediawiki-configmaster+1 -0Start writing to cul_reason_id and cul_reason_plaintext_id on testwiki
mediawiki/extensions/CheckUsermaster+31 -16Add read new support for cuc_comment_id
mediawiki/extensions/CheckUsermaster+157 -1Add maintenance script to populate cu_log comment ID columns
operations/mediawiki-configmaster+4 -0Stop writing to cul_user and cul_user_text on a few wikis
operations/mediawiki-configmaster+1 -0Stop writing to cul_user and cul_user_text on testwiki
operations/mediawiki-configmaster+2 -0Start reading from cuc_actor on group0 and group1 wikis
operations/mediawiki-configmaster+1 -7Start reading from cul_actor everywhere
operations/mediawiki-configmaster+4 -0Start reading from cuc_actor on test wikis
operations/mediawiki-configmaster+1 -0Start reading from cul_actor on group1 wikis
operations/mediawiki-configmaster+4 -0Start reading from cul_actor on remaining test wikis and group0 wikis
mediawiki/extensions/CheckUsermaster+2 -1SECURITY: api: Only add actor table to table list when querying from it
mediawiki/extensions/CheckUsermaster+143 -22Investigate: Add read new support for cuc_actor
mediawiki/extensions/CheckUsermaster+11 -4Pager: clarify which table the 'use index' option is for
mediawiki/extensions/CheckUsermaster+44 -16Pager: Add read new support for cuc_actor
mediawiki/extensions/CheckUsermaster+11 -2Hooks: Add read new support for cuc_actor
mediawiki/extensions/CheckUsermaster+17 -8ApiQueryCheckUser: Add read new support for cuc_actor
operations/mediawiki-configmaster+1 -7Start writing to cuc_comment_id everywhere
mediawiki/extensions/CheckUsermaster+17 -6Add write new support for cul_actor
operations/mediawiki-configmaster+2 -0Start writing to cuc_comment_id on group0 and group1 wikis
mediawiki/extensions/CheckUsermaster+1 -1Use correct migration variable
mediawiki/extensions/CheckUserREL1_39+1 -1Use correct migration variable
operations/mediawiki-configmaster+1 -0Start reading from cul_actor on testwiki
mediawiki/extensions/CheckUsermaster+147 -0Add population script for cuc_comment_id
mediawiki/extensions/CheckUsermaster+1 -1Change cu_changes comment migration to write both
operations/mediawiki-configmaster+4 -0Start writing to cuc_comment_id on test wikis
operations/mediawiki-configmaster+3 -0Pin cu_changes comment migration to old schema
mediawiki/extensions/CheckUserREL1_39+1 -1Update populateCulActor.php update key
mediawiki/extensions/CheckUsermaster+1 -1Update populateCulActor.php update key
mediawiki/extensions/CheckUsermaster+17 -2Add comment migration code for SCHEMA_COMPAT_WRITE_BOTH
mediawiki/extensions/CheckUsermaster+54 -0Introduce CheckUserCommentStore
mediawiki/extensions/AbuseFilterREL1_38+9 -0Send CheckUser the IP address on account creation
mediawiki/extensions/AbuseFilterREL1_35+309 -0Send CheckUser the IP address on account creation
mediawiki/coremaster+233 -90Split a base class out of CommentStore
mediawiki/extensions/CheckUsermaster+320 -8Add default values to cul_user(_text)
mediawiki/extensions/CheckUsermaster+17 -8SpecialCheckUser: add support for actor migration read new
mediawiki/extensions/CheckUsermaster+57 -17Add read new support for cul_actor
mediawiki/extensions/CheckUsermaster+6 -6Query actor table instead of user table
mediawiki/extensions/CheckUserREL1_39+3 -2populateCulActor: fetch user name from user id
mediawiki/extensions/CheckUserREL1_38+140 -0populateCulActor: fetch user name from user id
mediawiki/extensions/CheckUsermaster+3 -2populateCulActor: fetch user name from user id
operations/mediawiki-configmaster+1 -5Start writing to cul_actor everywhere
operations/mediawiki-configmaster+4 -0Start writing to cul_actor on test wikis
operations/mediawiki-configmaster+0 -4Start writing to cuc_actor everywhere
operations/mediawiki-configmaster+0 -3Start writing to cuc_actor on s8
operations/mediawiki-configmaster+3 -0Pin wgCheckUserLogReasonMigrationStage to read and write old
operations/mediawiki-configmaster+8 -4Start writing to cuc_actor everywhere except s4 and s8
operations/mediawiki-configmaster+3 -0Start writing to cuc_actor on test wikis
mediawiki/extensions/AbuseFiltermaster+13 -4Send CheckUser the IP address on account creation
mediawiki/extensions/CheckUsermaster+140 -1Add population script for cul_actor
mediawiki/extensions/CheckUsermaster+1 -1Change cu_log actor migration to write both
operations/mediawiki-configmaster+3 -0Pin cu_log actor migration to old schema
mediawiki/extensions/CheckUsermaster+35 -5Add checkuser log actor migration code for SCHEMA_COMPAT_WRITE_BOTH
mediawiki/extensions/CheckUsermaster+333 -2Add cul_actor to cu_log
mediawiki/extensions/CheckUsermaster+12 -0Add cuc_actor and cuc_comment_id in sqlite aswell
operations/mediawiki-configmaster+1 -90Stop writing to cuc_actor on all wikis
operations/mediawiki-configmaster+82 -0Revert "Start writing to cuc_actor everywhere except s4 and s8"
operations/mediawiki-configmaster+0 -82Start writing to cuc_actor everywhere except s4 and s8
mediawiki/extensions/CheckUsermaster+66 -0Add CheckUserActorMigration service
mediawiki/extensions/CheckUserwmf/1.39.0-wmf.12+2 -2Acquire fresh actor id
operations/mediawiki-configmaster+90 -6Revert "Revert "Start writing to cuc_actor in s3, kcgwiki and labtestwiki""
mediawiki/extensions/CheckUserwmf/1.39.0-wmf.13+2 -2Acquire fresh actor id
mediawiki/extensions/CheckUsermaster+2 -2Acquire fresh actor id
operations/mediawiki-configmaster+6 -90Revert "Start writing to cuc_actor in s3, kcgwiki and labtestwiki"
operations/mediawiki-configmaster+90 -6Start writing to cuc_actor in s3, kcgwiki and labtestwiki
operations/mediawiki-configmaster+3 -0Start writing to cuc_actor in test wikis
operations/mediawiki-configmaster+2 -0Revert "Revert "Start writing to cuc_actor in guwwiki and shnwikivoyage""
mediawiki/extensions/CheckUsermaster+5 -1Acquire fresh actor id for anons
operations/mediawiki-configmaster+2 -0Start writing to cuc_actor in guwwiki and shnwikivoyage
mediawiki/extensions/CheckUsermaster+147 -1Add population script for cuc_actor
mediawiki/extensions/CheckUsermaster+1 -1Change actor migration to write both
operations/mediawiki-configmaster+5 -0Pin CheckUser actor migration to old schema
mediawiki/extensions/CheckUsermaster+7 -3Use ActorStore to fetch actor id
mediawiki/extensions/CheckUsermaster+97 -19Add actor migration code for SCHEMA_COMPAT_WRITE_BOTH
mediawiki/extensions/CheckUsermaster+208 -38Schema change: Add columns cuc_log_id and ActorMigrate, CommentStore related
mediawiki/extensions/CheckUsermaster+31 -2Add actor and comment columns to cu_changes
Show related patches 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
· · ·
OpenNoneT227047 Complete actor table and comment table migration
OpenNoneT6716 Edit summary box should be a multiline input
StalledNoneT174043 Deploy Multi-Content Revisions
OpenNoneT174022 Implement multi-content revisions
OpendanielT196087 Refactored implementation of MCR page update interface
OpenNoneT204741 Remove undo and restore functionality from SubmitEntityAction
ResolvedZabeT233004 Update CheckUser for actor and comment table
Resolved• LadsgroupT303603 Add actor and comment columns to cu_changes
ResolvedBUG REPORTZabeT306045 Column 'cuc_actor' cannot be null (localhost) when logging in with incorrect creds
ResolvedPRODUCTION ERRORZabeT309148 Wikimedia\Rdbms\DBQueryError: Error 1048: Column 'cuc_actor' cannot be nullFunction: MediaWiki\CheckUser\Hooks::updateCheckUserDataQuery: INSERT INTO `cu_changes` (cuc_namespace,cuc_title,cuc_minor,cuc_user,cuc_user_text,cuc_
ResolvedDreamy_JazzT309454 cul_reason in cu_log should use the comment table
DeclinedNoneT309982 Add cu_log.cul_reason_id, cu_log.cul_reason_plaintext_id and cu_log.cul_actor to the cu_log table
ResolvedPRODUCTION ERRORZabeT316661 CannotCreateActorException: Cannot create an actor for a usable name that is not an existing user: user_name="Contact Form on Meta"
ResolvedNoneT321391 Add new column cu_log.cul_reason_id and cu_log.cul_reason_plaintext_id to wmf wikis
ResolvedMarosteguiT321126 Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis
ResolvedZabeT325484 Run PopulateCulActor on all wikis
ResolvedMarosteguiT326011 Add default values to cul_user and cul_user_text
ResolvedNoneT326330 Update sqoop for CheckUser table
ResolvedZabeT327290 Run PopulateCulComment on all wikis
ResolvedMarosteguiT328086 Drop cul_user and cul_user_text from cu_log on wmf wikis
ResolvedMarosteguiT328236 Add default value to cul_reason on WMF wikis
ResolvedMarosteguiT328373 Drop default value from cul_actor on wmf wikis
ResolvedMarosteguiT328807 Drop cul_reason from cu_log on wmf wikis
ResolvedMarosteguiT328817 Drop cuc_user and cuc_user_text from cu_changes in wmf wikis
ResolvedMarosteguiT328828 Remove default on cul_reason_id and cul_reason_plaintext_id in the cu_log table on wmf wikis
ResolvedDreamy_JazzT328849 Error 1265: Data truncated for column 'cul_reason_id' at row 1
ResolvedBUG REPORTDreamy_JazzT328851 Removal of columns causes sqlite updates that have temporary tables to fail
ResolvedBUG REPORTDreamy_JazzT328855 Removal of columns causes 1.39 postgres updates to fail
ResolvedPRODUCTION ERRORZabeT329151 Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cul_reason' in 'field list'Function: IndexPager::buildQueryInfo (MediaWiki\CheckUser\CheckUser\Pagers\CheckUserLogPager)Query: SELECT cul_id,cul_timestamp,cul_reason,
ResolvedMarosteguiT329260 Drop cuc_comment from cu_changes in wmf wikis
ResolvedMarosteguiT329684 Drop default value from cuc_actor and cuc_comment_id on wmf wikis
· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
gerritbot added a comment.Feb 1 2023, 10:29 PM

Change 885898 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop writing to cuc_comment_id in group0 wikis

https://gerrit.wikimedia.org/r/885898

gerritbot added a comment.Feb 1 2023, 10:34 PM

Change 885898 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop writing to cuc_comment_id in group0 wikis

https://gerrit.wikimedia.org/r/885898

Stashbot added a comment.Feb 1 2023, 10:36 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T22:36:03Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:885898|Stop writing to cuc_comment_id in group0 wikis (T233004)]]

Stashbot added a comment.Feb 1 2023, 10:38 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T22:38:01Z] <zabe@deploy1002> zabe: Backport for [[gerrit:885898|Stop writing to cuc_comment_id in group0 wikis (T233004)]] synced to the testservers: mwdebug1002.eqiad.wmnet, mwdebug2001.codfw.wmnet, mwdebug2002.codfw.wmnet, mwdebug1001.eqiad.wmnet

Stashbot added a comment.Feb 1 2023, 10:49 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T22:49:06Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:885898|Stop writing to cuc_comment_id in group0 wikis (T233004)]] (duration: 13m 03s)

gerritbot added a comment.Feb 1 2023, 11:25 PM

Change 885908 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop writing to cuc_user and cuc_user_text in group1 wikis

https://gerrit.wikimedia.org/r/885908

gerritbot added a comment.Feb 1 2023, 11:36 PM

Change 885908 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop writing to cuc_user and cuc_user_text in group1 wikis

https://gerrit.wikimedia.org/r/885908

Stashbot added a comment.Feb 1 2023, 11:37 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T23:37:37Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:885908|Stop writing to cuc_user and cuc_user_text in group1 wikis (T233004)]]

Stashbot added a comment.Feb 1 2023, 11:39 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T23:39:28Z] <zabe@deploy1002> zabe: Backport for [[gerrit:885908|Stop writing to cuc_user and cuc_user_text in group1 wikis (T233004)]] synced to the testservers: mwdebug2002.codfw.wmnet, mwdebug2001.codfw.wmnet, mwdebug1002.eqiad.wmnet, mwdebug1001.eqiad.wmnet

Stashbot added a comment.Feb 1 2023, 11:45 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-01T23:45:45Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:885908|Stop writing to cuc_user and cuc_user_text in group1 wikis (T233004)]] (duration: 08m 07s)

gerritbot added a comment.Feb 2 2023, 12:02 AM

Change 885911 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Drop cuc_actor migration code

https://gerrit.wikimedia.org/r/885911

gerritbot added a comment.Feb 2 2023, 6:26 PM

Change 886127 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop writing to cuc_comment in group1 wikis

https://gerrit.wikimedia.org/r/886127

gerritbot added a comment.Feb 2 2023, 6:34 PM

Change 886127 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop writing to cuc_comment in group1 wikis

https://gerrit.wikimedia.org/r/886127

Stashbot added a comment.Feb 2 2023, 6:34 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T18:34:26Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:886127|Stop writing to cuc_comment in group1 wikis (T233004)]]

Stashbot added a comment.Feb 2 2023, 6:36 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T18:36:23Z] <zabe@deploy1002> zabe: Backport for [[gerrit:886127|Stop writing to cuc_comment in group1 wikis (T233004)]] synced to the testservers: mwdebug2002.codfw.wmnet, mwdebug1002.eqiad.wmnet, mwdebug2001.codfw.wmnet, mwdebug1001.eqiad.wmnet

Stashbot added a comment.Feb 2 2023, 6:42 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T18:42:45Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:886127|Stop writing to cuc_comment in group1 wikis (T233004)]] (duration: 08m 19s)

gerritbot added a comment.Feb 2 2023, 6:51 PM

Change 886135 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop writing to cuc_user and cuc_user_text everywhere

https://gerrit.wikimedia.org/r/886135

gerritbot added a comment.Feb 2 2023, 8:01 PM

Change 886135 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop writing to cuc_user and cuc_user_text everywhere

https://gerrit.wikimedia.org/r/886135

Stashbot added a comment.Feb 2 2023, 8:01 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T20:01:29Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:886135|Stop writing to cuc_user and cuc_user_text everywhere (T233004)]]

Stashbot added a comment.Feb 2 2023, 8:03 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T20:03:18Z] <zabe@deploy1002> zabe: Backport for [[gerrit:886135|Stop writing to cuc_user and cuc_user_text everywhere (T233004)]] synced to the testservers: mwdebug1001.eqiad.wmnet, mwdebug2002.codfw.wmnet, mwdebug1002.eqiad.wmnet, mwdebug2001.codfw.wmnet

Stashbot added a comment.Feb 2 2023, 8:11 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T20:11:09Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:886135|Stop writing to cuc_user and cuc_user_text everywhere (T233004)]] (duration: 09m 39s)

gerritbot added a comment.Feb 2 2023, 8:12 PM

Change 886149 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop writing to cuc_comment everywhere

https://gerrit.wikimedia.org/r/886149

gerritbot added a comment.Feb 2 2023, 9:05 PM

Change 885359 merged by jenkins-bot:

[operations/mediawiki-config@master] Disable write old for CheckUserLog reason everywhere

https://gerrit.wikimedia.org/r/885359

Stashbot added a comment.Feb 2 2023, 9:06 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T21:06:04Z] <brennen@deploy1002> Started scap: Backport for [[gerrit:885359|Disable write old for CheckUserLog reason everywhere (T233004)]]

Stashbot added a comment.Feb 2 2023, 9:07 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T21:07:48Z] <brennen@deploy1002> brennen and dreamyjazz: Backport for [[gerrit:885359|Disable write old for CheckUserLog reason everywhere (T233004)]] synced to the testservers: mwdebug2001.codfw.wmnet, mwdebug1002.eqiad.wmnet, mwdebug1001.eqiad.wmnet, mwdebug2002.codfw.wmnet

Stashbot added a comment.Feb 2 2023, 9:18 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T21:18:07Z] <brennen@deploy1002> Finished scap: Backport for [[gerrit:885359|Disable write old for CheckUserLog reason everywhere (T233004)]] (duration: 12m 02s)

gerritbot added a comment.Feb 2 2023, 9:50 PM

Change 886149 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop writing to cuc_comment everywhere

https://gerrit.wikimedia.org/r/886149

Stashbot added a comment.Feb 2 2023, 9:50 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T21:50:39Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:886149|Stop writing to cuc_comment everywhere (T233004)]]

Stashbot added a comment.Feb 2 2023, 9:52 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T21:52:26Z] <zabe@deploy1002> zabe: Backport for [[gerrit:886149|Stop writing to cuc_comment everywhere (T233004)]] synced to the testservers: mwdebug1002.eqiad.wmnet, mwdebug1001.eqiad.wmnet, mwdebug2002.codfw.wmnet, mwdebug2001.codfw.wmnet

Stashbot added a comment.Feb 2 2023, 9:58 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-02T21:58:38Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:886149|Stop writing to cuc_comment everywhere (T233004)]] (duration: 07m 58s)

gerritbot added a comment.Feb 2 2023, 10:02 PM

Change 886162 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Remove cul_reason comment migration code

https://gerrit.wikimedia.org/r/886162

gerritbot added a comment.Feb 2 2023, 10:24 PM

Change 886165 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Remove cul_reason column from cu_log

https://gerrit.wikimedia.org/r/886165

gerritbot added a comment.Feb 3 2023, 12:48 AM

Change 885911 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop cuc_actor migration code

https://gerrit.wikimedia.org/r/885911

ReleaseTaggerBot edited projects, added MW-1.40-notes (1.40.0-wmf.22; 2023-02-06); removed MW-1.40-notes (1.40.0-wmf.21; 2023-01-30).Feb 3 2023, 1:00 AM
Dreamy_Jazz removed a subtask: T324907: Create separate tables for log events in CheckUser.Feb 3 2023, 1:01 AM
gerritbot added a comment.Feb 3 2023, 1:51 AM

Change 886162 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove cul_reason comment table migration code

https://gerrit.wikimedia.org/r/886162

gerritbot added a comment.Feb 3 2023, 8:02 PM

Change 886165 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove cul_reason column from cu_log

https://gerrit.wikimedia.org/r/886165

Dreamy_Jazz added a subtask: T328807: Drop cul_reason from cu_log on wmf wikis.Feb 3 2023, 8:27 PM
gerritbot added a comment.Feb 3 2023, 9:09 PM

Change 886426 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Remove cuc_user and cuc_user_text from cu_changes

https://gerrit.wikimedia.org/r/886426

gerritbot added a comment.Feb 3 2023, 11:00 PM

Change 886426 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove cuc_user and cuc_user_text from cu_changes

https://gerrit.wikimedia.org/r/886426

gerritbot added a comment.Feb 3 2023, 11:06 PM

Change 886431 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Remove default from cu_log comment table ID fields

https://gerrit.wikimedia.org/r/886431

Zabe added a subtask: T328817: Drop cuc_user and cuc_user_text from cu_changes in wmf wikis.Feb 3 2023, 11:09 PM
gerritbot added a comment.Feb 4 2023, 1:56 AM

Change 886431 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove default from cu_log comment table ID fields

https://gerrit.wikimedia.org/r/886431

Dreamy_Jazz added a subtask: T328828: Remove default on cul_reason_id and cul_reason_plaintext_id in the cu_log table on wmf wikis.Feb 4 2023, 2:18 AM
gerritbot added a comment.Feb 4 2023, 8:43 PM

Change 886454 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Drop cuc_comment_id migration variable

https://gerrit.wikimedia.org/r/886454

Dreamy_Jazz added a subtask: T328849: Error 1265: Data truncated for column 'cul_reason_id' at row 1.Feb 4 2023, 9:33 PM
Dreamy_Jazz added a subtask: T328851: Removal of columns causes sqlite updates that have temporary tables to fail.Feb 4 2023, 9:48 PM
Dreamy_Jazz closed subtask T328849: Error 1265: Data truncated for column 'cul_reason_id' at row 1 as Resolved.Feb 4 2023, 11:26 PM
Dreamy_Jazz closed subtask T328851: Removal of columns causes sqlite updates that have temporary tables to fail as Resolved.Feb 5 2023, 12:32 AM
Dreamy_Jazz added a subtask: T328855: Removal of columns causes 1.39 postgres updates to fail.Feb 5 2023, 12:43 AM
gerritbot added a comment.Feb 5 2023, 1:17 AM

Change 886454 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop cuc_comment_id migration variable

https://gerrit.wikimedia.org/r/886454

Dreamy_Jazz closed subtask T328855: Removal of columns causes 1.39 postgres updates to fail as Resolved.Feb 5 2023, 1:18 AM
Maintenance_bot removed a project: Patch-For-Review.Feb 5 2023, 1:30 AM
gerritbot added a comment.Feb 5 2023, 1:34 AM

Change 886465 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Remove CheckUserLogCommentStore as cu_log comment migration is done

https://gerrit.wikimedia.org/r/886465

gerritbot added a project: Patch-For-Review.Feb 5 2023, 1:34 AM
gerritbot added a comment.Feb 5 2023, 2:14 AM

Change 886465 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove CheckUserLogCommentStore as cu_log comment migration is done

https://gerrit.wikimedia.org/r/886465

Maintenance_bot removed a project: Patch-For-Review.Feb 5 2023, 2:30 AM
gerritbot added a comment.Feb 5 2023, 4:05 PM

Change 886474 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/Flow@master] Use core's CommentStore

https://gerrit.wikimedia.org/r/886474

gerritbot added a project: Patch-For-Review.Feb 5 2023, 4:05 PM

Change 886475 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Remove CheckUserCommentStore as cu_changes comment migration is done

https://gerrit.wikimedia.org/r/886475

gerritbot added a comment.Feb 5 2023, 4:30 PM

Change 886476 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] stop setting checkuser actor/comment migartion variables

https://gerrit.wikimedia.org/r/886476

gerritbot added a comment.Feb 5 2023, 7:21 PM

Change 886474 merged by jenkins-bot:

[mediawiki/extensions/Flow@master] Use core's CommentStore

https://gerrit.wikimedia.org/r/886474

gerritbot added a comment.Feb 5 2023, 7:21 PM

Change 886475 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove CheckUserCommentStore as cu_changes comment migration is done

https://gerrit.wikimedia.org/r/886475

Zabe mentioned this in T329000: +2 in mediawiki/ for Dreamy Jazz.Feb 7 2023, 1:56 AM
• EChetty closed subtask T326330: Update sqoop for CheckUser table as Resolved.Feb 7 2023, 11:10 AM
Zabe added a subtask: T329151: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cul_reason' in 'field list'Function: IndexPager::buildQueryInfo (MediaWiki\CheckUser\CheckUser\Pagers\CheckUserLogPager)Query: SELECT cul_id,cul_timestamp,cul_reason,.Feb 8 2023, 10:16 AM
gerritbot added a comment.Feb 8 2023, 10:30 AM

Change 887748 had a related patch set uploaded (by Zabe; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@wmf/1.40.0-wmf.21] Remove cul_reason comment table migration code

https://gerrit.wikimedia.org/r/887748

gerritbot added a comment.Feb 8 2023, 10:49 AM

Change 887748 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@wmf/1.40.0-wmf.21] Remove cul_reason comment table migration code

https://gerrit.wikimedia.org/r/887748

Stashbot added a comment.Feb 8 2023, 10:49 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-08T10:49:46Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:887748|Remove cul_reason comment table migration code (T233004 T329151)]]

Stashbot mentioned this in T329151: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cul_reason' in 'field list'Function: IndexPager::buildQueryInfo (MediaWiki\CheckUser\CheckUser\Pagers\CheckUserLogPager)Query: SELECT cul_id,cul_timestamp,cul_reason,.Feb 8 2023, 10:49 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-08T10:51:36Z] <zabe@deploy1002> zabe: Backport for [[gerrit:887748|Remove cul_reason comment table migration code (T233004 T329151)]] synced to the testservers: mwdebug2001.codfw.wmnet, mwdebug1002.eqiad.wmnet, mwdebug1001.eqiad.wmnet, mwdebug2002.codfw.wmnet

Stashbot added a comment.Feb 8 2023, 10:57 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-08T10:57:52Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:887748|Remove cul_reason comment table migration code (T233004 T329151)]] (duration: 08m 05s)

Zabe closed subtask T329151: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cul_reason' in 'field list'Function: IndexPager::buildQueryInfo (MediaWiki\CheckUser\CheckUser\Pagers\CheckUserLogPager)Query: SELECT cul_id,cul_timestamp,cul_reason, as Resolved.Feb 8 2023, 10:58 AM
Marostegui closed subtask T328807: Drop cul_reason from cu_log on wmf wikis as Resolved.Feb 8 2023, 1:04 PM
Marostegui closed subtask T328828: Remove default on cul_reason_id and cul_reason_plaintext_id in the cu_log table on wmf wikis as Resolved.
gerritbot added a comment.Feb 8 2023, 10:13 PM

Change 887839 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Remove CheckUserActorMigration as cu_changes actor migration is done

https://gerrit.wikimedia.org/r/887839

gerritbot added a comment.Feb 8 2023, 10:39 PM

Change 887844 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Remove cuc_comment from cu_changes

https://gerrit.wikimedia.org/r/887844

gerritbot added a comment.Feb 8 2023, 11:31 PM

Change 887844 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove cuc_comment from cu_changes

https://gerrit.wikimedia.org/r/887844

ReleaseTaggerBot edited projects, added MW-1.40-notes (1.40.0-wmf.23; 2023-02-13); removed MW-1.40-notes (1.40.0-wmf.22; 2023-02-06).Feb 9 2023, 12:00 AM
Zabe added a subtask: T329260: Drop cuc_comment from cu_changes in wmf wikis.Feb 9 2023, 8:49 AM
Dreamy_Jazz added a subtask: T329494: Replace usage of deprecated ActorMigration in AbstractCheckUserPager.Feb 13 2023, 10:45 AM
gerritbot added a comment.Feb 13 2023, 11:06 AM

Change 887839 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Remove CheckUserActorMigration as cu_changes actor migration is done

https://gerrit.wikimedia.org/r/887839

gerritbot added a comment.Feb 13 2023, 10:51 PM

Change 886476 merged by jenkins-bot:

[operations/mediawiki-config@master] stop setting checkuser actor/comment migration variables

https://gerrit.wikimedia.org/r/886476

Stashbot added a comment.Feb 13 2023, 10:51 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-13T22:51:53Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:886476|stop setting checkuser actor/comment migration variables (T233004)]]

Stashbot added a comment.Feb 13 2023, 10:53 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-13T22:53:34Z] <zabe@deploy1002> zabe: Backport for [[gerrit:886476|stop setting checkuser actor/comment migration variables (T233004)]] synced to the testservers: mwdebug1002.eqiad.wmnet, mwdebug2002.codfw.wmnet, mwdebug1001.eqiad.wmnet, mwdebug2001.codfw.wmnet

Stashbot added a comment.Feb 13 2023, 10:59 PM

Mentioned in SAL (#wikimedia-operations) [2023-02-13T22:59:40Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:886476|stop setting checkuser actor/comment migration variables (T233004)]] (duration: 07m 46s)

gerritbot added a comment.Feb 14 2023, 4:21 PM

Change 889168 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/CheckUser@master] Drop default from cuc_actor and cuc_comment

https://gerrit.wikimedia.org/r/889168

gerritbot added a comment.Feb 14 2023, 6:00 PM

Change 889168 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop default from cuc_actor and cuc_comment_id

https://gerrit.wikimedia.org/r/889168

ReleaseTaggerBot edited projects, added MW-1.40-notes (1.40.0-wmf.24; 2023-02-20); removed MW-1.40-notes (1.40.0-wmf.23; 2023-02-13).Feb 14 2023, 7:00 PM
Zabe closed this task as Resolved.Feb 14 2023, 9:43 PM
Zabe added a subtask: T329684: Drop default value from cuc_actor and cuc_comment_id on wmf wikis.

\o/

Dreamy_Jazz added a comment.Feb 14 2023, 10:03 PM

\o/

• Niharika added a subscriber: • Niharika.Feb 15 2023, 12:33 AM

\o/

Marostegui closed subtask T328817: Drop cuc_user and cuc_user_text from cu_changes in wmf wikis as Resolved.Thu, Mar 9, 6:37 AM
Marostegui closed subtask T329684: Drop default value from cuc_actor and cuc_comment_id on wmf wikis as Resolved.Mon, Mar 13, 12:25 PM
Marostegui closed subtask T329260: Drop cuc_comment from cu_changes in wmf wikis as Resolved.Tue, Mar 14, 1:15 PM
Izno removed a subtask: T329494: Replace usage of deprecated ActorMigration in AbstractCheckUserPager.Tue, Mar 14, 5:50 PM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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