*/
require_once __DIR__ . '/Maintenance.php';
+
use MediaWiki\MediaWikiServices;
+use Wikimedia\Rdbms\ILBFactory;
/**
* Maintenance script that rebuilds recent changes from scratch.
$this->fatalError( "Both 'from' and 'to' must be given, or neither" );
}
- $this->rebuildRecentChangesTablePass1();
- $this->rebuildRecentChangesTablePass2();
- $this->rebuildRecentChangesTablePass3();
- $this->rebuildRecentChangesTablePass4();
- $this->rebuildRecentChangesTablePass5();
+ $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
+ $this->rebuildRecentChangesTablePass1( $lbFactory );
+ $this->rebuildRecentChangesTablePass2( $lbFactory );
+ $this->rebuildRecentChangesTablePass3( $lbFactory );
+ $this->rebuildRecentChangesTablePass4( $lbFactory );
+ $this->rebuildRecentChangesTablePass5( $lbFactory );
if ( !( $this->hasOption( 'from' ) && $this->hasOption( 'to' ) ) ) {
$this->purgeFeeds();
}
/**
* Rebuild pass 1: Insert `recentchanges` entries for page revisions.
*/
- private function rebuildRecentChangesTablePass1() {
+ private function rebuildRecentChangesTablePass1( ILBFactory $lbFactory ) {
$dbw = $this->getDB( DB_MASTER );
$commentStore = CommentStore::getStore();
);
foreach ( array_chunk( $rcids, $this->getBatchSize() ) as $rcidBatch ) {
$dbw->delete( 'recentchanges', [ 'rc_id' => $rcidBatch ], __METHOD__ );
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
$this->output( "Loading from page and revision tables...\n" );
+ $actorMigration->getInsertValues( $dbw, 'rc_user', $user ),
__METHOD__
);
+
+ $rcid = $dbw->insertId();
+ $dbw->update(
+ 'change_tag',
+ [ 'ct_rc_id' => $rcid ],
+ [ 'ct_rev_id' => $row->rev_id ],
+ __METHOD__
+ );
+
if ( ( ++$inserted % $this->getBatchSize() ) == 0 ) {
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
}
}
* Rebuild pass 2: Enhance entries for page revisions with references to the previous revision
* (rc_last_oldid, rc_new etc.) and size differences (rc_old_len, rc_new_len).
*/
- private function rebuildRecentChangesTablePass2() {
+ private function rebuildRecentChangesTablePass2( ILBFactory $lbFactory ) {
$dbw = $this->getDB( DB_MASTER );
$this->output( "Updating links and size differences...\n" );
$lastSize = $size;
if ( ( ++$updated % $this->getBatchSize() ) == 0 ) {
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
}
}
/**
* Rebuild pass 3: Insert `recentchanges` entries for action logs.
*/
- private function rebuildRecentChangesTablePass3() {
+ private function rebuildRecentChangesTablePass3( ILBFactory $lbFactory ) {
global $wgLogTypes, $wgLogRestrictions;
$dbw = $this->getDB( DB_MASTER );
'rc_title' => $row->log_title,
'rc_minor' => 0,
'rc_bot' => 0,
- 'rc_patrolled' => 1,
+ 'rc_patrolled' => $row->log_type == 'upload' ? 0 : 2,
'rc_new' => 0,
'rc_this_oldid' => 0,
'rc_last_oldid' => 0,
__METHOD__
);
+ $rcid = $dbw->insertId();
+ $dbw->update(
+ 'change_tag',
+ [ 'ct_rc_id' => $rcid ],
+ [ 'ct_log_id' => $row->log_id ],
+ __METHOD__
+ );
+
if ( ( ++$inserted % $this->getBatchSize() ) == 0 ) {
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
}
}
/**
* Rebuild pass 4: Mark bot and autopatrolled entries.
*/
- private function rebuildRecentChangesTablePass4() {
+ private function rebuildRecentChangesTablePass4( ILBFactory $lbFactory ) {
global $wgUseRCPatrol, $wgMiserMode;
$dbw = $this->getDB( DB_MASTER );
[ 'ug_group' => $botgroups ],
__METHOD__,
[ 'DISTINCT' ],
- [ 'user_group' => [ 'JOIN', 'user_id = ug_user' ] ] + $userQuery['joins']
+ [ 'user_groups' => [ 'JOIN', 'user_id = ug_user' ] ] + $userQuery['joins']
);
$botusers = [];
[ 'rc_id' => $rcidBatch ],
__METHOD__
);
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
}
}
[ 'ug_group' => $autopatrolgroups ],
__METHOD__,
[ 'DISTINCT' ],
- [ 'user_group' => [ 'JOIN', 'user_id = ug_user' ] ] + $userQuery['joins']
+ [ 'user_groups' => [ 'JOIN', 'user_id = ug_user' ] ] + $userQuery['joins']
);
foreach ( $res as $obj ) {
foreach ( $actorQuery['orconds'] as $cond ) {
$dbw->update(
'recentchanges',
- [ 'rc_patrolled' => 1 ],
+ [ 'rc_patrolled' => 2 ],
[
$cond,
'rc_timestamp > ' . $dbw->addQuotes( $dbw->timestamp( $this->cutoffFrom ) ),
'rc_timestamp < ' . $dbw->addQuotes( $dbw->timestamp( $this->cutoffTo ) ),
+ 'rc_patrolled' => 0
],
__METHOD__
);
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
}
}
* Rebuild pass 5: Delete duplicate entries where we generate both a page revision and a log entry
* for a single action (upload only, at the moment, but potentially also move, protect, ...).
*/
- private function rebuildRecentChangesTablePass5() {
+ private function rebuildRecentChangesTablePass5( ILBFactory $lbFactory ) {
$dbw = wfGetDB( DB_MASTER );
$this->output( "Removing duplicate revision and logging entries...\n" );
);
if ( ( ++$updates % $this->getBatchSize() ) == 0 ) {
- wfGetLBFactory()->waitForReplication();
+ $lbFactory->waitForReplication();
}
}
}