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: wikibugs-l@lists.wikimedia.org
        ReportedBy: overlo...@gmail.com


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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to