Page MenuHomePhabricator

Recover Flow data on officewiki
Closed, ResolvedPublic

Description

We have actual DB backups for this wiki for the relevant time period, so it's a different (but simpler) process.

Event Timeline

Mattflaschen-WMF updated the task description. (Show Details)
Mattflaschen-WMF raised the priority of this task from to Needs Triage.
Mattflaschen-WMF assigned this task to EBernhardson.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 23 2015, 3:37 AM
Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptApr 23 2015, 3:38 AM

Collected information to update with

select concat( '"', concat_ws( '","', lower(hex(rev_id)), rev_content, rev_flags), '"') from flow_revision;

Ran the output of that through repair_missing_from_csv.php after tweaking the header so it was as expected instead of the query that was run

Updated 2268 revisions

Officewiki database is now as it should be, just needs a cache bump to clear anything out of cache that is incorrect.

EBernhardson closed this task as Resolved.Apr 23 2015, 6:46 PM

Change 206175 had a related patch set uploaded (by Mattflaschen):
Remove Flow cache version override

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

Change 206183 had a related patch set uploaded (by Mattflaschen):
Bump Flow cache version to 4.7.

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

Changed the config patch to bump it instead.

Change 206175 merged by jenkins-bot:
Bump Flow cache to 4.7

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

Change 206183 merged by jenkins-bot:
Bump Flow cache version to 4.7.

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

Restricted Application added a subscriber: TerraCodes. · View Herald TranscriptAug 12 2016, 11:53 AM