Page MenuHomePhabricator

Stop writing old for event table migration in extension.json
Closed, ResolvedPublic1 Estimated Story Points

Description

Before we stop writing old on WMF production, the value in extension.json should be changed to no longer write old.

Acceptance criteria
  • Set wgCheckUserEventTablesMigrationStage to SCHEMA_COMPAT_NEW in extension.json

Event Timeline

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

[mediawiki/extensions/CheckUser@master] Set event tables migration to SCHEMA_COMPAT_NEW in extension.json

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

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

[mediawiki/extensions/CheckUser@master] Update comments to reflect event table migration

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

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

[mediawiki/extensions/CheckUser@master] Add UserMerge support for cu_log_event and cu_private_event

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

Change #1038396 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Add UserMerge support for cu_log_event and cu_private_event

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

Change #1038397 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Update comments to reflect event table migration

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

Change #1038398 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Set event tables migration to SCHEMA_COMPAT_NEW in extension.json

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

For QA, you can check that for a variety of actions the database does not store any rows with cuc_only_for_read_old in the cu_changes table.

You can also check that no actions are in cu_changes with cuc_type as RC_LOG.

It is important to note that rows may not meet the above conditions if they were already in the database before you started QA'ing this ticket. As such, you may want to note when you started QA'ing this ticket and filter out rows that were made before that by using cuc_timestamp > YYYYMMDDHHMMSS as a condition in the query.