There are some missing properties from the user preferences tables. Reimport them from the backups.
Description
Description
Details
Details
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T340453 [Epic] FY 2023-24 Growth Maintenance Work | |||
| Resolved | KStoller-WMF | T347840 [Epic] Q2 FY 2023-24 Growth Maintenance Work | |||
| Open | None | T54777 user_properties table bloat | |||
| Resolved | • demon | T114208 User skin preference for MonoBook changed to default (Vector) on small and medium wikis (about 95% of wikis) | |||
| Duplicate | • demon | T114899 Recover missing values from user_properties tables |
Event Timeline
Comment Actions
Due to the time that has passed since the values were lost, we are only going to reimport the missing values for now, to avoid annoying users again that may have already changed their preferences.
Comment Actions
Change 244190 had a related patch set uploaded (by Chad):
[WIP] Add script to select old user_properties entries from backup
Comment Actions
After inspecting the current state of the table, we believe that insert will not have any noticible effect, due to changes done since the change took effect. At this time, recovering the tables may have a worse effect in terms of user affection than not doing anything.
We can recover preferences on an individual bases, though, if they have not been changed since the commit.
Comment Actions
Change 244190 abandoned by Chad:
[WIP] Add script to select old user_properties entries from backup
Reason:
Per https://phabricator.wikimedia.org/T114899#1709471
Comment Actions
https://gerrit.wikimedia.org/r/#/c/244190/ was created for this task, and abandoned.
Having a timestamp on user preferences last_modified would had helped on this issue, knowing which preferences are "new" and "old".
Comment Actions
I'm closing this out as it's been about two weeks with no further requests that I've heard for action.