Recover Flow data on officewiki
Closed, ResolvedPublic
Actions

Description

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

	Subject	Repo	Branch	Lines +/-
	Bump Flow cache version to 4.7.	mediawiki/extensions/Flow	master	+1 -1
	Bump Flow cache to 4.7	operations/mediawiki-config	master	+1 -1

Mentioned In: rMEXT52f10cf8a46e: Updated mediawiki/extensions Project: mediawiki/extensions/Flow…
rEFLW1a5ffc05707e: Bump Flow cache version to 4.7.
rOMWC1e28cf78e64e: Bump Flow cache to 4.7

• Mattflaschen-WMF raised the priority of this task from to Needs Triage.

Per email, @EBernhardson is already working on this.

• Mattflaschen-WMF triaged this task as Unbreak Now! priority.Apr 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.

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

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

Changed the config patch to bump it instead.

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

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