Page MenuHomePhabricator

Add new column cuc_only_for_read_old to cu_changes for migration purposes to wmf wikis
Closed, ResolvedPublic

Description

A new column named cuc_only_for_read_old will be used to indicate whether a row in cu_changes exists in either cu_log_event or cu_private_event, with a value of 1 indicating that it does. When the value is 1 the row will not be selected if also reading from the new tables.

This column will be removed once the migration in T324907 has been completed and is intended to be temporary. Without this temporary column CheckUser would not know whether a given row in cu_changes exists in the other tables.

  1. ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/022f35b72c3b379394483101d78a78c761677a35/schema/mysql/patch-cu_changes-add-cuc_only_for_read_old.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: checkuser is not on beta cluster - Will test on checkuser-beta-wiki.wmcloud.org shortly.
  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

StatusSubtypeAssignedTask
ResolvedSecurityZabe
ResolvedSecurityDreamy_Jazz
ResolvedSecurityDreamy_Jazz
ResolvedSecurityDreamy_Jazz
OpenBUG REPORTNone
OpenBUG REPORTNone
OpenBUG REPORTNone
OpenDreamy_Jazz
OpenNone
OpenNone
OpenNone
OpenFeatureDreamy_Jazz
DuplicateNone
OpenFeatureNone
OpenFeatureNone
OpenFeatureNone
ResolvedFeatureDreamy_Jazz
ResolvedFeatureDreamy_Jazz
ResolvedFeatureDreamy_Jazz
OpenFeatureNone
OpenFeatureNone
ResolvedBUG REPORTDreamy_Jazz
OpenFeatureNone
OpenFeatureNone
ResolvedGlaisher
OpenNone
ResolvedFeatureDreamy_Jazz
ResolvedGlaisher
Resolved Niharika
ResolvedNone
ResolvedFeatureDreamy_Jazz
DeclinedNone
ResolvedFeatureDreamy_Jazz
ResolvedFeatureDreamy_Jazz
DuplicateNone
OpenNone
DuplicateNone
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
OpenFeatureNone
ResolvedDreamy_Jazz
OpenBUG REPORTNone
ResolvedBUG REPORTDreamy_Jazz
OpenNone
OpenFeatureNone
DeclinedFeatureNone
OpenFeatureNone
OpenDreamy_Jazz
Resolvedkostajh
OpenNone
OpenNone
Resolvedtstarling
OpenNone
OpenTchanders
OpenFeatureDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedMarostegui
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedBUG REPORTDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedBUG REPORTDreamy_Jazz
ResolvedBUG REPORTDreamy_Jazz

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Done s3 eqiad with replication

Mentioned in SAL (#wikimedia-operations) [2023-03-08T08:55:48Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2106 (T329203)', diff saved to https://phabricator.wikimedia.org/P45422 and previous config saved to /var/cache/conftool/dbconfig/20230308-085546-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T08:56:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2110 (T329203)', diff saved to https://phabricator.wikimedia.org/P45423 and previous config saved to /var/cache/conftool/dbconfig/20230308-085608-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T09:07:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2110 (T329203)', diff saved to https://phabricator.wikimedia.org/P45428 and previous config saved to /var/cache/conftool/dbconfig/20230308-090739-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T09:53:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2110 (T329203)', diff saved to https://phabricator.wikimedia.org/P45439 and previous config saved to /var/cache/conftool/dbconfig/20230308-095259-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T09:53:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2119 (T329203)', diff saved to https://phabricator.wikimedia.org/P45440 and previous config saved to /var/cache/conftool/dbconfig/20230308-095320-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T10:05:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2119 (T329203)', diff saved to https://phabricator.wikimedia.org/P45444 and previous config saved to /var/cache/conftool/dbconfig/20230308-100502-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T10:50:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2119 (T329203)', diff saved to https://phabricator.wikimedia.org/P45453 and previous config saved to /var/cache/conftool/dbconfig/20230308-105022-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T10:50:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2136 (T329203)', diff saved to https://phabricator.wikimedia.org/P45454 and previous config saved to /var/cache/conftool/dbconfig/20230308-105043-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T11:01:22Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2136 (T329203)', diff saved to https://phabricator.wikimedia.org/P45457 and previous config saved to /var/cache/conftool/dbconfig/20230308-110121-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T11:46:42Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2136 (T329203)', diff saved to https://phabricator.wikimedia.org/P45470 and previous config saved to /var/cache/conftool/dbconfig/20230308-114642-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T11:46:53Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2137:3314 (T329203)', diff saved to https://phabricator.wikimedia.org/P45471 and previous config saved to /var/cache/conftool/dbconfig/20230308-114652-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T11:58:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2137:3314 (T329203)', diff saved to https://phabricator.wikimedia.org/P45473 and previous config saved to /var/cache/conftool/dbconfig/20230308-115815-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T12:43:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2137:3314 (T329203)', diff saved to https://phabricator.wikimedia.org/P45487 and previous config saved to /var/cache/conftool/dbconfig/20230308-124334-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T12:43:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2138:3314 (T329203)', diff saved to https://phabricator.wikimedia.org/P45488 and previous config saved to /var/cache/conftool/dbconfig/20230308-124344-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T12:55:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2138:3314 (T329203)', diff saved to https://phabricator.wikimedia.org/P45492 and previous config saved to /var/cache/conftool/dbconfig/20230308-125515-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T13:40:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2138:3314 (T329203)', diff saved to https://phabricator.wikimedia.org/P45504 and previous config saved to /var/cache/conftool/dbconfig/20230308-134034-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T13:49:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2147 (T329203)', diff saved to https://phabricator.wikimedia.org/P45505 and previous config saved to /var/cache/conftool/dbconfig/20230308-134945-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T14:01:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T329203)', diff saved to https://phabricator.wikimedia.org/P45508 and previous config saved to /var/cache/conftool/dbconfig/20230308-140115-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T14:46:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T329203)', diff saved to https://phabricator.wikimedia.org/P45519 and previous config saved to /var/cache/conftool/dbconfig/20230308-144634-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T14:47:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2155 (T329203)', diff saved to https://phabricator.wikimedia.org/P45520 and previous config saved to /var/cache/conftool/dbconfig/20230308-144659-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T15:47:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T329203)', diff saved to https://phabricator.wikimedia.org/P45528 and previous config saved to /var/cache/conftool/dbconfig/20230308-154724-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:32:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2155 (T329203)', diff saved to https://phabricator.wikimedia.org/P45536 and previous config saved to /var/cache/conftool/dbconfig/20230308-163249-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:33:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2172 (T329203)', diff saved to https://phabricator.wikimedia.org/P45537 and previous config saved to /var/cache/conftool/dbconfig/20230308-163311-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T16:45:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T329203)', diff saved to https://phabricator.wikimedia.org/P45538 and previous config saved to /var/cache/conftool/dbconfig/20230308-164545-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T17:31:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2172 (T329203)', diff saved to https://phabricator.wikimedia.org/P45551 and previous config saved to /var/cache/conftool/dbconfig/20230308-173104-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T17:31:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2179 (T329203)', diff saved to https://phabricator.wikimedia.org/P45552 and previous config saved to /var/cache/conftool/dbconfig/20230308-173125-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T17:42:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T329203)', diff saved to https://phabricator.wikimedia.org/P45555 and previous config saved to /var/cache/conftool/dbconfig/20230308-174208-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-08T18:27:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2179 (T329203)', diff saved to https://phabricator.wikimedia.org/P45568 and previous config saved to /var/cache/conftool/dbconfig/20230308-182726-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T06:45:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2109 (T329203)', diff saved to https://phabricator.wikimedia.org/P45615 and previous config saved to /var/cache/conftool/dbconfig/20230309-064538-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T07:23:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2109 (T329203)', diff saved to https://phabricator.wikimedia.org/P45626 and previous config saved to /var/cache/conftool/dbconfig/20230309-072319-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T08:08:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2109 (T329203)', diff saved to https://phabricator.wikimedia.org/P45638 and previous config saved to /var/cache/conftool/dbconfig/20230309-080837-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T08:08:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2127 (T329203)', diff saved to https://phabricator.wikimedia.org/P45639 and previous config saved to /var/cache/conftool/dbconfig/20230309-080858-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T08:46:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2127 (T329203)', diff saved to https://phabricator.wikimedia.org/P45650 and previous config saved to /var/cache/conftool/dbconfig/20230309-084601-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T09:31:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2127 (T329203)', diff saved to https://phabricator.wikimedia.org/P45660 and previous config saved to /var/cache/conftool/dbconfig/20230309-093120-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T10:06:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2149 (T329203)', diff saved to https://phabricator.wikimedia.org/P45664 and previous config saved to /var/cache/conftool/dbconfig/20230309-100611-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T10:42:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T329203)', diff saved to https://phabricator.wikimedia.org/P45669 and previous config saved to /var/cache/conftool/dbconfig/20230309-104220-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T11:27:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T329203)', diff saved to https://phabricator.wikimedia.org/P45676 and previous config saved to /var/cache/conftool/dbconfig/20230309-112739-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T11:28:05Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2156 (T329203)', diff saved to https://phabricator.wikimedia.org/P45677 and previous config saved to /var/cache/conftool/dbconfig/20230309-112804-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T11:54:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T329203)', diff saved to https://phabricator.wikimedia.org/P45682 and previous config saved to /var/cache/conftool/dbconfig/20230309-115445-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T12:40:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T329203)', diff saved to https://phabricator.wikimedia.org/P45692 and previous config saved to /var/cache/conftool/dbconfig/20230309-124004-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T12:40:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2177 (T329203)', diff saved to https://phabricator.wikimedia.org/P45693 and previous config saved to /var/cache/conftool/dbconfig/20230309-124025-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T13:19:52Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T329203)', diff saved to https://phabricator.wikimedia.org/P45697 and previous config saved to /var/cache/conftool/dbconfig/20230309-131951-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T14:05:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T329203)', diff saved to https://phabricator.wikimedia.org/P45703 and previous config saved to /var/cache/conftool/dbconfig/20230309-140510-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2023-03-09T15:11:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db2163 (T329203)', diff saved to https://phabricator.wikimedia.org/P45707 and previous config saved to /var/cache/conftool/dbconfig/20230309-151100-marostegui.json