Page MenuHomePhabricator

Populate archive.ar_len on all Wikimedia wikis
Closed, ResolvedPublic

Description

Clone this bug from bug 12188.

archive.ar_len should be populated on all Wikimedia wikis. If for no other reason than it causes inconsistencies (null entries) in revision.rev_len when revisions are restored (really a separate bug, but let's just populate everything anyway and be done with it).

This bug may require a separate bug to actually add this functionality to MediaWiki core's maintenance scripts. I don't think there's a script that does this currently (populateRevisionLength.php could have an --archive flag, maybe). But this bug is for populating archive.ar_len on all Wikimedia wikis.


Version: unspecified
Severity: normal

Details

Reference
bz46183

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 22 2014, 1:21 AM
bzimport set Reference to bz46183.

(In reply to comment #0)

This bug may require a separate bug to actually add this functionality to
MediaWiki core's maintenance scripts. I don't think there's a script that
does this currently (populateRevisionLength.php could have an --archive flag,
maybe). But this bug is for populating archive.ar_len on all Wikimedia wikis.

This is bug 24538.

Rob L.: I don't believe this bug requires a database schema change or the involvement of a DBA. I believe this is simply a matter of running the relevant maintenance script.

Can you please double-check the assigned to field and the relevance of the "schema-change" keyword?

Reedy added a comment.Nov 13 2013, 3:37 PM

mediawiki.org:
rev_len and ar_len population complete [0 revision rows, 36724 archive rows].

real 3m54.716s
user 1m18.765s
sys 0m11.545s

Just needs running everywhere under foreachwiki

Reedy added a comment.Nov 13 2013, 5:20 PM

Running in screen on terbium. Currently upto cawiki

Is now on etwiki. I guess enwiki took a long time ;)

Reedy added a comment.Nov 19 2013, 6:07 PM

Done.

Might be some stale values around (API requests cached in squid/varnish etc) but the populate is complete