Last modified: 2012-11-06 19:47:27 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T43649, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 41649 - Clean up corrupted entries from page history restore bug
Clean up corrupted entries from page history restore bug
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: High normal (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-11-01 18:37 UTC by Rob Lanphier
Modified: 2012-11-06 19:47 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Rob Lanphier 2012-11-01 18:37:03 UTC
Bug 41615 caused some corruption of metadata associated with deleted articles.  The original bug has been fixed, but some of the corruption remains, and should be cleaned up.
Comment 1 Asher Feldman 2012-11-01 19:43:01 UTC
I'm going through the binlogs for all 500+ wikis that were running wmf3 for WikiPage::doDeleteArticleReal queries and will provide to Aaron for cleanup.
Comment 2 Rob Lanphier 2012-11-02 21:13:32 UTC
Asher has provided this to Aaron.  Aaron is going to try to have the script ready to run today or early next week, and then run it some time after that.
Comment 3 Aaron Schulz 2012-11-06 19:28:43 UTC
Script run. Fixed 6 commons pages, 1 wikidata one, and 1 test2wiki one (a test for this exact bug by rob). Most deleted pages where not restored in the small time frame it seems.

One of the itwiki binlog dump entries had no corresponding log INSERT, so I had to ignore that line, which is unlikely to matter.
Comment 4 Aaron Schulz 2012-11-06 19:31:25 UTC
Affected page IDs:
15222088 => 22572598
22484760 => 22572599
21989370 => 22485107
10571590 => 22494267
22480211 => 22572600
12915804 => 22492542

For the second column, one can use http://commons.wikimedia.org/wiki/?curid=<x> to view those pages (for commons). Most of them seem like they should be deleted again as cruft...
Comment 5 Aaron Schulz 2012-11-06 19:36:37 UTC
(In reply to comment #4)
> Most of them seem like they should be deleted again as cruft...

Well, more like half or less.
Comment 6 Tomasz W. Kozlowski 2012-11-06 19:41:06 UTC
I deleted two of those pages (one was deleted before as a violation of no FOP
in Japan, and the other was a badly placed link); the rest was just fine.
Comment 7 Trijnstel 2012-11-06 19:47:27 UTC
Not fully restored; I miss one edit: https://commons.wikimedia.org/w/index.php?title=User:Zev_Rothkoff&action=history

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links