updateSpecialPages.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';
 
use MediaWiki\MainConfigNames;
use MediaWiki\SpecialPage\QueryPage;
 
class UpdateSpecialPages extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->addOption( 'list', 'List special page names' );
        $this->addOption( 'only', 'Only update "page"; case sensitive, ' .
            'check correct case by calling this script with --list. ' .
            'Ex: --only=BrokenRedirects', false, true );
        $this->addOption( 'override', 'Also update pages that have updates disabled' );
    }
 
    public function execute() {
        $dbw = $this->getDB( DB_PRIMARY );
        $config = $this->getConfig();
        $specialPageFactory = $this->getServiceContainer()->getSpecialPageFactory();
 
        $this->doSpecialPageCacheUpdates( $dbw );
 
        $queryCacheLimit = (int)$config->get( MainConfigNames::QueryCacheLimit );
        $disabledQueryPages = QueryPage::getDisabledQueryPages( $config );
        foreach ( QueryPage::getPages() as $page ) {
            [ , $special ] = $page;
            $limit = $page[2] ?? $queryCacheLimit;
 
            # --list : just show the name of pages
            if ( $this->hasOption( 'list' ) ) {
                $this->output( "$special [QueryPage]\n" );
                continue;
            }
 
            if ( !$this->hasOption( 'override' )
                && isset( $disabledQueryPages[$special] )
            ) {
                $this->output( sprintf( "%-30s [QueryPage] disabled\n", $special ) );
                continue;
            }
 
            $specialObj = $specialPageFactory->getPage( $special );
            if ( !$specialObj ) {
                $this->output( "No such special page: $special\n" );
                return;
            }
            if ( $specialObj instanceof QueryPage ) {
                $queryPage = $specialObj;
            } else {
                $class = get_class( $specialObj );
                $this->fatalError( "$class is not an instance of QueryPage.\n" );
            }
 
            if ( !$this->hasOption( 'only' ) || $this->getOption( 'only' ) === $queryPage->getName() ) {
                $this->output( sprintf( '%-30s [QueryPage] ', $special ) );
                if ( $queryPage->isExpensive() ) {
                    $t1 = microtime( true );
                    # Do the query
                    $num = $queryPage->recache( $limit );
                    $t2 = microtime( true );
                    if ( $num === false ) {
                        $this->output( "FAILED: database error\n" );
                    } else {
                        $this->output( "got $num rows in " );
 
                        $elapsed = $t2 - $t1;
                        $hours = intval( $elapsed / 3600 );
                        $minutes = intval( (int)$elapsed % 3600 / 60 );
                        $seconds = $elapsed - $hours * 3600 - $minutes * 60;
                        if ( $hours ) {
                            $this->output( $hours . 'h ' );
                        }
                        if ( $minutes ) {
                            $this->output( $minutes . 'm ' );
                        }
                        $this->output( sprintf( "%.2fs\n", $seconds ) );
                    }
                    # Reopen any connections that have closed
                    $this->reopenAndWaitForReplicas();
                } else {
                    // Check if this page was expensive before and now cheap
                    $cached = $queryPage->getCachedTimestamp();
                    if ( $cached ) {
                        $queryPage->deleteAllCachedData();
                        $this->reopenAndWaitForReplicas();
                        $this->output( "cheap, but deleted cached data\n" );
                    } else {
                        $this->output( "cheap, skipped\n" );
                    }
                }
                if ( $this->hasOption( 'only' ) ) {
                    break;
                }
            }
        }
    }
 
    private function reopenAndWaitForReplicas() {
        $lbFactory = $this->getServiceContainer()->getDBLoadBalancerFactory();
        $lb = $lbFactory->getMainLB();
        if ( !$lb->pingAll() ) {
            $this->output( "\n" );
            do {
                $this->error( "Connection failed, reconnecting in 10 seconds..." );
                sleep( 10 );
                $this->waitForReplication();
            } while ( !$lb->pingAll() );
            $this->output( "Reconnected\n\n" );
        }
        $this->waitForReplication();
    }
 
    public function doSpecialPageCacheUpdates( $dbw ) {
        foreach ( $this->getConfig()->get( MainConfigNames::SpecialPageCacheUpdates ) as $special => $call ) {
            # --list : just show the name of pages
            if ( $this->hasOption( 'list' ) ) {
                $this->output( "$special [callback]\n" );
                continue;
            }
 
            if ( !$this->hasOption( 'only' ) || $this->getOption( 'only' ) === $special ) {
                if ( !is_callable( $call ) ) {
                    $this->error( "Uncallable function $call!" );
                    continue;
                }
                $this->output( sprintf( '%-30s [callback] ', $special ) );
                $t1 = microtime( true );
                $call( $dbw );
                $t2 = microtime( true );
 
                $this->output( "completed in " );
                $elapsed = $t2 - $t1;
                $hours = intval( $elapsed / 3600 );
                $minutes = intval( (int)$elapsed % 3600 / 60 );
                $seconds = $elapsed - $hours * 3600 - $minutes * 60;
                if ( $hours ) {
                    $this->output( $hours . 'h ' );
                }
                if ( $minutes ) {
                    $this->output( $minutes . 'm ' );
                }
                $this->output( sprintf( "%.2fs\n", $seconds ) );
                # Wait for the replica DB to catch up
                $this->reopenAndWaitForReplicas();
            }
        }
    }
}
 
$maintClass = UpdateSpecialPages::class;
require_once RUN_MAINTENANCE_IF_MAIN;