Write maintenance script to recover lost moderation logs
Closed, ResolvedPublic
Actions

Description

Deployment needs to be coordinated with T89428: Flow logging is broken.

Details

	Subject	Repo	Branch	Lines +/-
	Backfill moderation (delete, suppress) logging that was dropped	mediawiki/extensions/Flow	master	+110 -2

Customize query in gerrit

Revisions and Commits

rEFLW extension-Flow
	rEFLWa6d1fcff3721 WIP: Backfill moderation (delete, suppress) logging that was dropped
	rEFLW4fa2dbf56367 Backfill moderation (delete, suppress) logging that was dropped
	rEFLW58886409694a Backfill moderation (delete, suppress) logging that was dropped
	rEFLW243040d3e34d Backfill moderation (delete, suppress) logging that was dropped
rMEXT MediaWiki Extensions
	rMEXT67b4cc790e0b Updated mediawiki/extensions Project: mediawiki/extensions/Flow…

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		EBernhardson	T89428 Flow logging is broken
		Resolved		• Mattflaschen-WMF	T89504 Write maintenance script to recover lost moderation logs

Event Timeline

• Mattflaschen-WMF created this task.Feb 13 2015, 10:31 PM

• Mattflaschen-WMF claimed this task.

• Mattflaschen-WMF raised the priority of this task from to Unbreak Now!.

• Mattflaschen-WMF updated the task description. (Show Details)

• Mattflaschen-WMF added projects: Patch-For-Review, Collaboration-Team-Sprint-Q-2015-02-25, StructuredDiscussions.

• Mattflaschen-WMF removed a project: Patch-For-Review.

• Mattflaschen-WMF set Security to None.

• Mattflaschen-WMF added subscribers: gerritbot, Aklapper, • Mattflaschen-WMF.

I realized when testing this that the dates were wrong. I can think of a couple approaches:

Use LogEntry->setTimestamp when the revision's date (not really necessary for normal logging, but a general way to deal with this problem).
Pass an optional timestamp field that is only used for scripts like this (e.g. in the metadata parameter)

I think #1 is cleaner, but I'm open to suggestions.

Change 191543 had a related patch set uploaded (by Mattflaschen):
WIP: Backfill moderation (delete, suppress) logging that was dropped

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

Patch-For-Review

generally we should be setting any timestamp about a revision to match the timestamp within the revision, in additon to being cleaner we have had off by one errors in tests because of the timestamps differing.

• DannyH moved this task from Sprint Q - ends Feb 25 to In Development on the Collaboration-Team-Sprint-Q-2015-02-25 board.Feb 20 2015, 6:39 PM

EBernhardson moved this task from In Development to Code Review on the Collaboration-Team-Sprint-Q-2015-02-25 board.Feb 24 2015, 8:03 PM

Change 191543 merged by jenkins-bot:
Backfill moderation (delete, suppress) logging that was dropped

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

• Mattflaschen-WMF closed this task as Resolved by committing rEFLW243040d3e34d: Backfill moderation (delete, suppress) logging that was dropped.Feb 24 2015, 8:40 PM

• Mattflaschen-WMF added a commit: rEFLW243040d3e34d: Backfill moderation (delete, suppress) logging that was dropped.

Diffusion added a commit: rMEXT67b4cc790e0b: Updated mediawiki/extensions Project: mediawiki/extensions/Flow….Mar 11 2015, 4:40 AM

• Mattflaschen-WMF added a commit: rEFLW58886409694a: Backfill moderation (delete, suppress) logging that was dropped.Apr 28 2016, 2:39 AM

• Mattflaschen-WMF added a commit: rEFLW4fa2dbf56367: Backfill moderation (delete, suppress) logging that was dropped.