https://bugzilla.wikimedia.org/show_bug.cgi?id=22392
Summary: Revisions existing in both archive and revision
tables.
Product: Wikimedia
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: trivial
Priority: Normal
Component: General/Unknown
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=7076)
--> (https://bugzilla.wikimedia.org/attachment.cgi?id=7076)
Example dupe
When doing some investigating for FT2 for bug 18104, I took a dump of rev_id's
from revision and ar_rev_id, sorted then for giggles ran uniq -d on it to find
some duplicates. Out of my ~17M row sample (~16M from rev, ~550k from archive),
I came across about 2000 instances where a given revision id was found in both
rev_id and ar_rev_id.
>From the example it seems either the row wasn't cleared from revision on
delete, or it wasn't remove from archive on restore since the information is
the same.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
