Title
mediawiki_content_current exports silently omit all pages edited between the snapshot cutoff and dump generation time (enwiki 2026-07-01: ~3,560 pages missing per partition file)
Tags: Dumps-generation
Summary
The mediawiki_content_current XML export for enwiki dated 2026-07-01 (generated 2026-07-05, ~03:47–04:47 UTC per file timestamps) is missing every page that was edited on or after the snapshot cutoff (2026-07-01T00:00:00Z) but before generation time — even {F92830481}though each of these pages has a valid pre-cutoff revision that a point-in-time snapshot should contain.
The result is a dump that never leaks post-cutoff content (internally consistent), but silently omits tens of thousands of pages — biased toward exactly the pages consumers most expect a "current" export to include: current events, new releases, actively maintained articles, and bot-updated pages.
Steps to reproduce
- Download and decompress from https://dumps.wikimedia.org/other/mediawiki_content_current/enwiki/2026-07-01/xml/bzip2/ the file enwiki-2026-07-01-p73796143p78432142.xml.bz2 (page-id range p73796358–p78432142).
- Search for page id 77315100 ([[The Devil Wears Prada 2]]): ` grep '<id>77315100</id>' enwiki-2026-07-01-p73796358p78432142.xml ` → no match. The page's title is also absent from the file. Adjacent page ids (77315097, 77315098, 77315101, 77315102, 77315103, 77315105) are present, so the file is not truncated at that point.
- Compare with the classic dump of the same date: ` grep '<id>77315100</id>' enwiki-20260701-pages-articles27.xml-p75975910p77475909 ` → present.
- The page is also present in the previous month's mediawiki_content_current export (enwiki-2026-06-01-p75985506p80463446.xml), and existed on-wiki throughout, with an ordinary edit history and no moves/deletes/merges in the relevant window.
Scale
Diffing the page-id sets of the new-style file p73796358p78432142 against the
overlapping classic pages-articles file for the same date yields 3,560 page
ids present in the classic dump but absent from the new export (list
attached: dropped.ids). The missing pages span all namespaces (main, Draft,
Template, Wikipedia, File, Category) and all topics. Extrapolated across the
full id space, this is plausibly on the order of tens of thousands of pages
wiki-wide, though edit activity is not uniform across id ranges.
Root-cause evidence
Every missing page checked so far was edited between 2026-07-01T00:00:00Z and
the 2026-07-05 generation run:
- The Devil Wears Prada 2 (pageid 77315100): edited 2026-07-01 14:06, 20:23, 20:25 UTC and daily thereafter. Last pre-cutoff revision: 2026-06-30 20:08 UTC — a valid snapshot state existed and was not emitted.
- Supergirl (2026) (pageid 63890530): high-frequency post-release updates; absent from p60523479p65058432 while adjacent ids are present.
- Llanthomas Castle Mound: a low-traffic article (~4 pageviews/day) with no edits between 15 June and 30 June, then an editing burst starting 2026-07-01 06:44 UTC. Its 15 June revision should have been in the snapshot; the page is absent. This rules out any traffic/popularity-based explanation — the only common factor is a post-cutoff edit.
- Bot-maintained pages that are rewritten daily (e.g. WP 1.0 Editorial Team "articles by quality log" pages) appear in the missing set, as predicted if the criterion is "edited after cutoff".
The maximum revision timestamp anywhere in the affected file is
2026-06-30T23:59:52Z, confirming a hard midnight-UTC cutoff and that no
post-cutoff revisions leak into the dump.
Hypothesized mechanism
The export appears to be generated by filtering rev_timestamp < cutoff
against a table that holds only the latest revision per page. For a page
edited after the cutoff, the pre-cutoff row has already been overwritten, so
the filter matches nothing and the page is dropped from the output entirely —
instead of being rolled back to (or retained at) its as-of-cutoff revision.
If that is correct, every monthly export of this dataset omits every page
edited between the snapshot date and the generation run (a ~4-day window for
this dump), and validation focused on "no post-cutoff content" would not
detect it.
Expected behavior
Either (a) each page appears at its latest revision with
rev_timestamp < 2026-07-01T00:00:00Z, or (b) if a true point-in-time
snapshot is not feasible from a latest-only table, pages edited after the
cutoff should be included at their current revision rather than silently
omitted — and the dataset documentation should state the chosen semantics.
Actual behavior
Pages edited between 2026-07-01T00:00:00Z and generation time are entirely
absent from the export, with no error, marker, or documentation of the
omission.
Attachments
- dropped.ids — 3,560 page ids present in enwiki-20260701-pages-articles but absent from enwiki-2026-07-01-p73796358p78432142.xml (overlapping id range only).
Environment / notes
- Dataset: other/mediawiki_content_current/enwiki/2026-07-01/xml/bzip2/
- _SUCCESS marker dated 05-Jul-2026 04:47; per-file mtimes 03:47–04:47 UTC.
- Same-date classic dump (enwiki/20260701/, pages-articles / pages-meta-current) is not affected and was used as the reference.
- Happy to provide additional samples, the comparison scripts, or run further checks on request.