Stop writing old for event table migration on WMF wikis
Closed, ResolvedPublic1 Estimated Story Points
Actions

Assigned To

Authored By

	Dreamy_Jazz
	Mar 21 2024, 6:27 PM

Description

When all interfaces that read from the CheckUser tables have been updated to support reading new (i.e. from cu_log_event and cu_private_event) and are stably doing so, event table migration should be set to stop writing old.

This is needed more quickly because when temporary accounts are enabled on a wiki, writing old will cause exceptions on failed login attempts and password reset requests made while logged out (T353953). This also needs to be done earlier for testwiki to avoid blocking the temporary account deployment to that wiki.

Acceptance criteria

Set $wgCheckUserEventTablesMigrationStage = SCHEMA_COMPAT_NEW; on all group0 wikis
Set $wgCheckUserEventTablesMigrationStage = SCHEMA_COMPAT_NEW; on all group1 wikis
Set $wgCheckUserEventTablesMigrationStage = SCHEMA_COMPAT_NEW; on all WMF wikis

Details

Subject	Repo	Branch	Lines +/-
[CheckUser] Stop writing old for event tables migration on all wikis	operations/mediawiki-config	master	+1 -3
[CheckUser] Stop writing old for event tables migration on group1	operations/mediawiki-config	master	+1 -0
[CheckUser] Stop writing old for event tables migration on group0	operations/mediawiki-config	master	+1 -1

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.

Status	Subtype	Assigned	Task
			· · ·
Resolved	Feature	Dreamy_Jazz	T324907 Create separate tables for log events in CheckUser
Resolved		Dreamy_Jazz	T341830 Create maintenance script to delete entries only for read old
Resolved		Dreamy_Jazz	T346022 Remove modifications of wgCheckUserLogAdditionalRights in code outside CheckUser
Duplicate		Dreamy_Jazz	T368419 Run deleteReadOldRowsInCuChanges.php on WMF wikis
Resolved		Dreamy_Jazz	T360685 Stop writing old for event table migration on WMF wikis
Resolved		Dreamy_Jazz	T360686 Stop writing old on testwiki
Resolved		Dreamy_Jazz	T329189 Add read new support to Special:Investigate for event table migration
Resolved		Dreamy_Jazz	T341827 Add read new support to the CheckUser API
Resolved		Dreamy_Jazz	T361924 Update TemporaryAccountHandler for CheckUser event table migration
Resolved	BUG REPORT	Dreamy_Jazz	T367760 No autoblock is performed when the target account has no CU data for edits but has CU data for log events
			· · ·

Event Timeline

Dreamy_Jazz created this task.Mar 21 2024, 6:27 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 21 2024, 6:27 PM

Dreamy_Jazz added a subtask: T341830: Create maintenance script to delete entries only for read old.Mar 28 2024, 9:49 AM

Dreamy_Jazz removed a subtask: T341830: Create maintenance script to delete entries only for read old.

Dreamy_Jazz added a parent task: T341830: Create maintenance script to delete entries only for read old.

Dreamy_Jazz added a subtask: T329189: Add read new support to Special:Investigate for event table migration.

Dreamy_Jazz added a subtask: T341827: Add read new support to the CheckUser API.

Dreamy_Jazz renamed this task from Stop writing old on WMF wikis to Stop writing old for event table migration on WMF wikis.Mar 28 2024, 10:46 AM

Dreamy_Jazz added a subtask: T361924: Update TemporaryAccountHandler for CheckUser event table migration.Apr 5 2024, 10:29 AM

Dreamy_Jazz closed subtask T341827: Add read new support to the CheckUser API as Resolved.Apr 5 2024, 3:23 PM

Dreamy_Jazz closed subtask T361924: Update TemporaryAccountHandler for CheckUser event table migration as Resolved.Apr 17 2024, 9:13 AM

Dreamy_Jazz added a parent task: T346022: Remove modifications of wgCheckUserLogAdditionalRights in code outside CheckUser.Apr 18 2024, 9:44 AM

Dreamy_Jazz closed subtask T329189: Add read new support to Special:Investigate for event table migration as Resolved.Jun 4 2024, 8:08 AM

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

[operations/mediawiki-config@master] [CheckUser] Stop writing old for event tables migration on group0

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

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

[operations/mediawiki-config@master] [CheckUser] Stop writing old for event tables migration on group1

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

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

[operations/mediawiki-config@master] [CheckUser] Stop writing old for event tables migration on all wikis

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

Dreamy_Jazz set the point value for this task to 1.Jun 4 2024, 10:39 AM

Dreamy_Jazz added projects: Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)), Trust and Safety Product Team.

Dreamy_Jazz moved this task from Priority Backlog to Needs Review on the Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)) board.

Dreamy_Jazz mentioned this in T324907: Create separate tables for log events in CheckUser.Jun 4 2024, 5:43 PM

Dreamy_Jazz closed subtask T360686: Stop writing old on testwiki as Resolved.Jun 5 2024, 3:34 PM

Dreamy_Jazz moved this task from Needs Review to Ready on the Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)) board.Jun 5 2024, 4:36 PM

Dreamy_Jazz moved this task from Ready to In Progress on the Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)) board.

Dreamy_Jazz updated the task description. (Show Details)Jun 5 2024, 4:42 PM

Change #1038740 merged by jenkins-bot:

[operations/mediawiki-config@master] [CheckUser] Stop writing old for event tables migration on group0

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

Mentioned in SAL (#wikimedia-operations) [2024-06-05T20:03:38Z] <urbanecm@deploy1002> Started scap: Backport for [[gerrit:1038740|[CheckUser] Stop writing old for event tables migration on group0 (T360685)]], [[gerrit:1038882|Growth: Use growthexperiments DB list for enabling GrowthExperiments (T364892)]], [[gerrit:1035473|[Beta] Enable CommunityConfiguration extension in all wikis (T364892)]]

Mentioned in SAL (#wikimedia-operations) [2024-06-05T20:06:18Z] <urbanecm@deploy1002> urbanecm and sgimeno and dreamyjazz: Backport for [[gerrit:1038740|[CheckUser] Stop writing old for event tables migration on group0 (T360685)]], [[gerrit:1038882|Growth: Use growthexperiments DB list for enabling GrowthExperiments (T364892)]], [[gerrit:1035473|[Beta] Enable CommunityConfiguration extension in all wikis (T364892)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/M

Dreamy_Jazz updated the task description. (Show Details)Jun 5 2024, 8:15 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-05T20:25:43Z] <urbanecm@deploy1002> Finished scap: Backport for [[gerrit:1038740|[CheckUser] Stop writing old for event tables migration on group0 (T360685)]], [[gerrit:1038882|Growth: Use growthexperiments DB list for enabling GrowthExperiments (T364892)]], [[gerrit:1035473|[Beta] Enable CommunityConfiguration extension in all wikis (T364892)]] (duration: 22m 04s)

Un-assigning and moving back to Ready, as someone else from the team will pick this up next week while I'm away.

Dreamy_Jazz added a subtask: T367760: No autoblock is performed when the target account has no CU data for edits but has CU data for log events.Jun 17 2024, 2:32 PM

Dreamy_Jazz closed subtask T367760: No autoblock is performed when the target account has no CU data for edits but has CU data for log events as Resolved.Jun 24 2024, 1:20 PM

Dreamy_Jazz claimed this task.Jun 25 2024, 10:43 AM

Dreamy_Jazz moved this task from Sprint Melodica (Jun 3 - Jun 14) to Sprint Cajon (Jun 24 - July 5) on the Trust and Safety Product Sprint board.

Dreamy_Jazz edited projects, added Trust and Safety Product Sprint (Sprint Cajon (Jun 24 - July 5)); removed Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)).

Dreamy_Jazz moved this task from Priority Backlog to Ready on the Trust and Safety Product Sprint (Sprint Cajon (Jun 24 - July 5)) board.

Dreamy_Jazz mentioned this in T368419: Run deleteReadOldRowsInCuChanges.php on WMF wikis.Jun 25 2024, 3:23 PM

Dreamy_Jazz added a parent task: T368419: Run deleteReadOldRowsInCuChanges.php on WMF wikis.

Dreamy_Jazz moved this task from Ready to In Progress on the Trust and Safety Product Sprint (Sprint Cajon (Jun 24 - July 5)) board.Jun 25 2024, 5:54 PM

Change #1038741 merged by jenkins-bot:

[operations/mediawiki-config@master] [CheckUser] Stop writing old for event tables migration on group1

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

Mentioned in SAL (#wikimedia-operations) [2024-06-26T13:03:21Z] <logmsgbot> lucaswerkmeister-wmde@deploy1002 Started scap: Backport for [[gerrit:1038741|[CheckUser] Stop writing old for event tables migration on group1 (T360685)]]

Mentioned in SAL (#wikimedia-operations) [2024-06-26T13:05:59Z] <logmsgbot> lucaswerkmeister-wmde@deploy1002 lucaswerkmeister-wmde, dreamyjazz: Backport for [[gerrit:1038741|[CheckUser] Stop writing old for event tables migration on group1 (T360685)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/Mwdebug)

Mentioned in SAL (#wikimedia-operations) [2024-06-26T13:15:31Z] <logmsgbot> lucaswerkmeister-wmde@deploy1002 Finished scap: Backport for [[gerrit:1038741|[CheckUser] Stop writing old for event tables migration on group1 (T360685)]] (duration: 12m 09s)

Change #1038742 merged by jenkins-bot:

[operations/mediawiki-config@master] [CheckUser] Stop writing old for event tables migration on all wikis

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

Mentioned in SAL (#wikimedia-operations) [2024-06-27T13:08:07Z] <urbanecm@deploy1002> Started scap: Backport for [[gerrit:1038742|[CheckUser] Stop writing old for event tables migration on all wikis (T360685)]], [[gerrit:1049970|testwiki: use shellbox-video for scaling video (T356241)]], [[gerrit:1049886|Add VK namespace alias to Azerbaijani Wikibooks (T368237)]]

Mentioned in SAL (#wikimedia-operations) [2024-06-27T13:10:46Z] <urbanecm@deploy1002> urbanecm, dreamrimmer, hnowlan, dreamyjazz: Backport for [[gerrit:1038742|[CheckUser] Stop writing old for event tables migration on all wikis (T360685)]], [[gerrit:1049970|testwiki: use shellbox-video for scaling video (T356241)]], [[gerrit:1049886|Add VK namespace alias to Azerbaijani Wikibooks (T368237)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/Mwdebug)

Mentioned in SAL (#wikimedia-operations) [2024-06-27T13:24:55Z] <urbanecm@deploy1002> Finished scap: Backport for [[gerrit:1038742|[CheckUser] Stop writing old for event tables migration on all wikis (T360685)]], [[gerrit:1049970|testwiki: use shellbox-video for scaling video (T356241)]], [[gerrit:1049886|Add VK namespace alias to Azerbaijani Wikibooks (T368237)]] (duration: 16m 48s)