Create a schema migration configuration value for writing to and reading from cu_private_event_no_actor
Closed, DeclinedPublic1 Estimated Story Points
Actions

Description

A configuration value is needed to be able to control the migration stage of using the cu_private_event_no_actor table in Special:CheckUser.

The Special:CheckUser code will read from the cu_private_event_no_actor table if SCHEMA_COMPAT_READ_NEW is set in the config. The CheckUserInsert service will write to this table if SCHEMA_COMPAT_WRITE_NEW is set in the config.

Acceptance criteria

Create the CheckUserPrivateEventNoActorMigrationStage configuration value which will be set to SCHEMA_COMPAT_OLD for the time being

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Add wgCheckUserPrivateEventNoActorMigrationStage	mediawiki/extensions/CheckUser	master	+4 -0

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Declined		Dreamy_Jazz	T359337 Create a schema migration configuration value for writing to and reading from cu_private_event_no_actor
		Declined		Dreamy_Jazz	T359309 Create cu_private_event_no_actor table

Event Timeline

Dreamy_Jazz created this task.Mar 6 2024, 1:07 PM

Restricted Application removed a project: Patch-For-Review. · View Herald TranscriptMar 6 2024, 1:07 PM

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

[mediawiki/extensions/CheckUser@master] Add wgCheckUserPrivateEventNoActorMigrationStage

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

gerritbot added a project: Patch-For-Review.Mar 6 2024, 1:12 PM

Dreamy_Jazz added a subtask: T359309: Create cu_private_event_no_actor table.Mar 6 2024, 1:12 PM

Dreamy_Jazz moved this task from Priority Backlog to In Progress on the Trust and Safety Product Sprint (Sprint Piano (Feb 19th - 1st March)) board.Mar 6 2024, 2:03 PM

Dreamy_Jazz moved this task from In Progress to Needs review on the Trust and Safety Product Sprint (Sprint Piano (Feb 19th - 1st March)) board.

Dreamy_Jazz set the point value for this task to 1.Mar 7 2024, 5:16 PM

Dreamy_Jazz closed subtask T359309: Create cu_private_event_no_actor table as Declined.Mar 8 2024, 1:43 PM

Change 1009249 abandoned by Dreamy Jazz:

[mediawiki/extensions/CheckUser@master] Add wgCheckUserPrivateEventNoActorMigrationStage

Reason:

The table is no longer being added.

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

Per DBA feedback, we will make the cupe_actor column NULLable and then use that.

Dreamy_Jazz removed a parent task: T353953: Don't use actor IDs for private CheckUser events when these actions are performed by IP addresses.Mar 12 2024, 4:57 PM

Create a schema migration configuration value for writing to and reading from cu_private_event_no_actorClosed, DeclinedPublic1 Estimated Story PointsActions