Author: cannon.danielc
Description:
Some relevant queries on the toolserver.
I have been unable to replicate this issue on a local wiki; however, it appears that occasionally edits can be patrolled without the patrolling being logged. A quick query revealed 154 edits on enwikibooks and 2589 edits on dewiki that are marked as patrolled but for which no entry exists in the patrol log (see attached query for enwikibooks).
A quick glance at the time of the edits (in this case all page creations) suggests that these unlogged patrolled edits all occurred at similar times and that, for instance, between 18 and 19 o'clock (UTC) on Nov. 16 all new page creations that were autopatrolled (by sysops) were not logged. My hypothesis would be that this may be due to database replication lag--that is, the page is newly created and automatically marked as patrolled (or someone marks it as patrolled immediately after the page is created); when generating the log, it checks for existence of the page, fails to find it, and aborts adding the log entry. Is it possible that something is working off the slave db that should be working off the master?
I've also come across a few cases where page creations by sysops (that should be autopatrolled) have an entry in the patrol log that indicates the page was manually patrolled. This is likely related to the above problem. I've attached a query illustrating this too.
Version: 1.12.x
Severity: major
URL: http://en.wikipedia.org/wiki/File:68px-Picture_10.png
Attached: