29require __DIR__ .
'/../commandLine.inc';
31if ( count(
$args ) < 1 ) {
32 echo
"Usage: php recompressTracked.php [options] <cluster> [... <cluster>...]
33Moves blobs indexed by trackBlobs.php to a specified list of destination clusters,
34and recompresses them in the process. Restartable.
37 --procs <procs> Set the number of child processes (default 1)
38 --copy-only Copy only, do not update the text table. Restart
39 without this option to complete.
40 --debug-log <file> Log debugging data to the specified file
41 --info-log <file> Log progress messages to the specified file
42 --critical-log <file> Log error messages to the specified file
81 'no-count' =>
'noCount',
82 'procs' =>
'numProcs',
83 'copy-only' =>
'copyOnly',
85 'replica-id' =>
'replicaId',
86 'debug-log' =>
'debugLog',
87 'info-log' =>
'infoLog',
88 'critical-log' =>
'criticalLog',
96 $jobOptions = [
'destClusters' =>
$args ];
97 foreach ( self::$cmdLineOptionMap as $cmdOption => $classOption ) {
98 if ( isset(
$options[$cmdOption] ) ) {
99 $jobOptions[$classOption] =
$options[$cmdOption];
103 return new self( $jobOptions );
111 if ( !$this->isChild ) {
112 $GLOBALS[
'wgDebugLogPrefix'] =
"RCT M: ";
113 } elseif ( $this->replicaId !==
false ) {
114 $GLOBALS[
'wgDebugLogPrefix'] =
"RCT {$this->replicaId}: ";
116 $this->pageBlobClass = function_exists(
'xdiff_string_bdiff' ) ?
117 'DiffHistoryBlob' :
'ConcatenatedGzipHistoryBlob';
118 $this->orphanBlobClass =
'ConcatenatedGzipHistoryBlob';
123 if ( $this->debugLog ) {
124 $this->
logToFile( $msg, $this->debugLog );
130 if ( $this->infoLog ) {
131 $this->
logToFile( $msg, $this->infoLog );
137 if ( $this->criticalLog ) {
138 $this->
logToFile( $msg, $this->criticalLog );
144 if ( $this->replicaId !==
false ) {
145 $header .=
"({$this->replicaId})";
148 LegacyLogger::emit( sprintf(
"%-50s %s\n",
$header, $msg ), $file );
159 $pos = $dbw->getMasterPos();
160 $dbr->masterPosWait( $pos, 100000 );
167 if ( $this->isChild ) {
195 if ( !
$dbr->tableExists(
'blob_tracking' ) ) {
196 $this->
critical(
"Error: blob_tracking table does not exist" );
200 $row =
$dbr->selectRow(
'blob_tracking',
'*',
'', __METHOD__ );
202 $this->
info(
"Warning: blob_tracking table contains no rows, skipping this wiki." );
218 foreach ( self::$cmdLineOptionMap as $cmdOption => $classOption ) {
219 if ( $cmdOption ==
'replica-id' ) {
221 } elseif ( in_array( $cmdOption, self::$optionsWithArgs ) && isset( $this->$classOption ) ) {
223 } elseif ( $this->$classOption ) {
224 $cmd .=
" --$cmdOption";
229 ' ' . call_user_func_array(
'wfEscapeShellArg', $this->destClusters );
231 $this->replicaPipes = $this->replicaProcs = [];
236 [
'file',
'php://stdout',
'w' ],
237 [
'file',
'php://stderr',
'w' ]
239 MediaWiki\suppressWarnings();
240 $proc = proc_open(
"$cmd --replica-id $i", $spec, $pipes );
241 MediaWiki\restoreWarnings();
243 $this->
critical(
"Error opening replica DB process: $cmd" );
246 $this->replicaProcs[$i] = $proc;
247 $this->replicaPipes[$i] = $pipes[0];
249 $this->prevReplicaId = -1;
256 $this->
info(
"Waiting for replica DB processes to finish..." );
261 $status = proc_close( $this->replicaProcs[$i] );
263 $this->
critical(
"Warning: child #$i exited with status $status" );
266 $this->
info(
"Done." );
274 $args = func_get_args();
276 $numPipes = stream_select( $x = [], $pipes, $y = [], 3600 );
278 $this->
critical(
"Error waiting to write to replica DBs. Aborting" );
282 $replicaId = ( $i + $this->prevReplicaId + 1 ) % $this->numProcs;
301 $cmd = implode(
' ',
$args );
302 fwrite( $this->replicaPipes[
$replicaId],
"$cmd\n" );
312 if ( $this->noCount ) {
313 $numPages =
'[unknown]';
315 $numPages =
$dbr->selectField(
'blob_tracking',
316 'COUNT(DISTINCT bt_page)',
317 # A condition is required so that
this query uses the index
322 if ( $this->copyOnly ) {
323 $this->
info(
"Copying pages..." );
325 $this->
info(
"Moving pages..." );
328 $res =
$dbr->select(
'blob_tracking',
332 'bt_page > ' .
$dbr->addQuotes( $startId )
337 'ORDER BY' =>
'bt_page',
338 'LIMIT' => $this->batchSize,
341 if ( !
$res->numRows() ) {
344 foreach (
$res as $row ) {
345 $startId = $row->bt_page;
346 $this->
dispatch(
'doPage', $row->bt_page );
349 $this->
report(
'pages', $i, $numPages );
351 $this->
report(
'pages', $i, $numPages );
352 if ( $this->copyOnly ) {
353 $this->
info(
"All page copies queued." );
355 $this->
info(
"All page moves queued." );
365 function report( $label, $current, $end ) {
367 if ( $current == $end || $this->numBatches >= $this->reportingInterval ) {
368 $this->numBatches = 0;
369 $this->
info(
"$label: $current / $end" );
370 MediaWikiServices::getInstance()->getDBLoadBalancerFactory()->waitForReplication();
381 if ( $this->noCount ) {
382 $numOrphans =
'[unknown]';
384 $numOrphans =
$dbr->selectField(
'blob_tracking',
385 'COUNT(DISTINCT bt_text_id)',
386 [
'bt_moved' => 0,
'bt_page' => 0 ],
388 if ( !$numOrphans ) {
392 if ( $this->copyOnly ) {
393 $this->
info(
"Copying orphans..." );
395 $this->
info(
"Moving orphans..." );
399 $res =
$dbr->select(
'blob_tracking',
404 'bt_text_id > ' .
$dbr->addQuotes( $startId )
409 'ORDER BY' =>
'bt_text_id',
410 'LIMIT' => $this->batchSize
413 if ( !
$res->numRows() ) {
417 foreach (
$res as $row ) {
418 $startId = $row->bt_text_id;
419 $ids[] = $row->bt_text_id;
425 while ( count( $ids ) > $this->orphanBatchSize ) {
426 $args = array_slice( $ids, 0, $this->orphanBatchSize );
427 $ids = array_slice( $ids, $this->orphanBatchSize );
428 array_unshift(
$args,
'doOrphanList' );
429 call_user_func_array( [ $this,
'dispatch' ],
$args );
431 if ( count( $ids ) ) {
433 array_unshift(
$args,
'doOrphanList' );
434 call_user_func_array( [ $this,
'dispatch' ],
$args );
437 $this->
report(
'orphans', $i, $numOrphans );
439 $this->
report(
'orphans', $i, $numOrphans );
440 $this->
info(
"All orphans queued." );
447 $this->
debug(
'starting' );
450 while ( !feof( STDIN ) ) {
451 $line = rtrim( fgets( STDIN ) );
457 $cmd = array_shift(
$args );
468 MediaWikiServices::getInstance()->getDBLoadBalancerFactory()->waitForReplication();
478 $title = Title::newFromID( $pageId );
480 $titleText = $title->getPrefixedText();
482 $titleText =
'[deleted]';
487 if ( !$this->copyOnly ) {
495 $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
498 [
'blob_tracking',
'text' ],
501 'bt_page' => $pageId,
502 'bt_text_id > ' .
$dbr->addQuotes( $startId ),
504 'bt_new_url IS NULL',
509 'ORDER BY' =>
'bt_text_id',
510 'LIMIT' => $this->batchSize
513 if ( !
$res->numRows() ) {
518 foreach (
$res as $row ) {
519 $startId = $row->bt_text_id;
520 if ( $lastTextId == $row->bt_text_id ) {
524 $lastTextId = $row->bt_text_id;
527 if ( $text ===
false ) {
528 $this->
critical(
"Error loading {$row->bt_rev_id}/{$row->bt_text_id}" );
533 if ( !$trx->addItem( $text, $row->bt_text_id ) ) {
534 $this->
debug(
"$titleText: committing blob with " . $trx->getSize() .
" items" );
537 $lbFactory->waitForReplication();
542 $this->
debug(
"$titleText: committing blob with " . $trx->getSize() .
" items" );
560 if ( $this->copyOnly ) {
561 $this->
critical(
"Internal error: can't call moveTextRow() in --copy-only mode" );
565 $dbw->begin( __METHOD__ );
566 $dbw->update(
'text',
569 'old_flags' =>
'external,utf-8',
576 $dbw->update(
'blob_tracking',
578 [
'bt_text_id' => $textId ],
581 $dbw->commit( __METHOD__ );
596 $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
599 $conds = array_merge( $conds, [
601 'bt_new_url IS NOT NULL'
604 $res =
$dbr->select(
'blob_tracking',
606 array_merge( $conds, [
'bt_text_id > ' .
$dbr->addQuotes( $startId ) ] ),
609 'ORDER BY' =>
'bt_text_id',
610 'LIMIT' => $this->batchSize,
613 if ( !
$res->numRows() ) {
616 $this->
debug(
'Incomplete: ' .
$res->numRows() .
' rows' );
617 foreach (
$res as $row ) {
618 $startId = $row->bt_text_id;
619 $this->
moveTextRow( $row->bt_text_id, $row->bt_new_url );
620 if ( $row->bt_text_id % 10 == 0 ) {
621 $lbFactory->waitForReplication();
632 $cluster = next( $this->destClusters );
633 if ( $cluster ===
false ) {
634 $cluster = reset( $this->destClusters );
658 if ( !$this->copyOnly ) {
665 $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
667 [
'text',
'blob_tracking' ],
668 [
'old_id',
'old_text',
'old_flags' ],
670 'old_id' => $textIds,
678 foreach (
$res as $row ) {
680 if ( $text ===
false ) {
681 $this->
critical(
"Error: cannot load revision text for old_id={$row->old_id}" );
685 if ( !$trx->addItem( $text, $row->old_id ) ) {
686 $this->
debug(
"[orphan]: committing blob with " . $trx->getSize() .
" rows" );
689 $lbFactory->waitForReplication();
692 $this->
debug(
"[orphan]: committing blob with " . $trx->getSize() .
" rows" );
730 $this->cgz =
new $class;
732 $hash = $this->cgz->addItem( $text );
733 $this->referrers[$textId] = $hash;
734 $this->texts[$textId] = $text;
736 return $this->cgz->isHappy();
740 return count( $this->texts );
748 $this->cgz =
new $class;
749 $this->referrers = [];
750 foreach ( $this->texts as $textId => $text ) {
751 $hash = $this->cgz->addItem( $text );
752 $this->referrers[$textId] = $hash;
762 $originalCount = count( $this->texts );
763 if ( !$originalCount ) {
776 $dbw->begin( __METHOD__ );
777 $res = $dbw->select(
'blob_tracking',
778 [
'bt_text_id',
'bt_moved' ],
779 [
'bt_text_id' => array_keys( $this->referrers ) ],
780 __METHOD__, [
'FOR UPDATE' ] );
782 foreach (
$res as $row ) {
783 if ( $row->bt_moved ) {
784 # This row has already been moved, remove it
785 $this->parent->debug(
"TRX: conflict detected in old_id={$row->bt_text_id}" );
786 unset( $this->texts[$row->bt_text_id] );
793 if ( !count( $this->texts ) ) {
795 if ( $originalCount > 1 ) {
797 $this->parent->critical(
798 "Warning: concurrent operation detected, are there two conflicting " .
799 "processes running, doing the same job?" );
808 $targetCluster = $this->parent->getTargetCluster();
809 $store = $this->parent->store;
810 $targetDB = $store->getMaster( $targetCluster );
811 $targetDB->clearFlag(
DBO_TRX );
812 $targetDB->begin( __METHOD__ );
813 $baseUrl = $this->parent->store->store( $targetCluster,
serialize( $this->cgz ) );
816 foreach ( $this->referrers as $textId => $hash ) {
817 $url = $baseUrl .
'/' . $hash;
818 $dbw->update(
'blob_tracking',
819 [
'bt_new_url' => $url ],
821 'bt_text_id' => $textId,
822 'bt_moved' => 0, # Check
for concurrent conflicting update
828 $targetDB->commit( __METHOD__ );
831 $dbw->commit( __METHOD__ );
834 if ( !$this->parent->copyOnly ) {
835 foreach ( $this->referrers as $textId => $hash ) {
836 $url = $baseUrl .
'/' . $hash;
837 $this->parent->moveTextRow( $textId, $url );
$GLOBALS['wgAutoloadClasses']['LocalisationUpdate']
wfDebug( $text, $dest='all', array $context=[])
Sends a line to the debug log if enabled or, optionally, to a comment in output.
wfGetDB( $db, $groups=[], $wiki=false)
Get a Database object.
wfHostname()
Fetch server name for use in error reporting etc.
wfEscapeShellArg()
Version of escapeshellarg() that works better on Windows.
wfGetLBFactory()
Get the load balancer factory object.
wfWikiID()
Get an ASCII string identifying this wiki This is used as a prefix in memcached keys.
Class to represent a recompression operation for a single CGZ blob.
ConcatenatedGzipHistoryBlob $cgz
RecompressTracked $parent
addItem( $text, $textId)
Add text.
recompress()
Recompress text after some aberrant modification.
__construct( $parent, $blobClass)
Create a transaction from a RecompressTracked object.
Concatenated gzip (CGZ) storage Improves compression ratio by concatenating like objects before gzipp...
DB accessable external objects.
Maintenance script that moves blobs indexed by trackBlobs.php to a specified list of destination clus...
executeChild()
Main entry point for worker processes.
moveTextRow( $textId, $url)
Atomic move operation.
dispatch()
Dispatch a command to the next available replica DB.
report( $label, $current, $end)
Display a progress report.
execute()
Execute parent or child depending on the isChild option.
getExtDB( $cluster)
Gets a DB master connection for the given external cluster name.
doOrphanList( $textIds)
Move an orphan text_id to the new cluster.
doAllOrphans()
Move all orphan text to the new clusters.
static newFromCommandLine( $args, $options)
finishIncompleteMoves( $conds)
Moves are done in two phases: bt_new_url and then bt_moved.
doPage( $pageId)
Move tracked text in a given page.
syncDBs()
Wait until the selected replica DB has caught up to the master.
static getOptionsWithArgs()
startReplicaProcs()
Start the worker processes.
getTargetCluster()
Returns the name of the next target cluster.
executeParent()
Execute the parent process.
doAllPages()
Move all tracked pages to the new clusters.
killReplicaProcs()
Gracefully terminate the child processes.
dispatchToReplica( $replicaId, $args)
Dispatch a command to a specified replica DB.
checkTrackingTable()
Make sure the tracking table exists and isn't empty.
static getRevisionText( $row, $prefix='old_', $wiki=false)
Get revision text associated with an old or archive row.
the array() calling protocol came about after MediaWiki 1.4rc1.
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped & $options
Status::newGood()` to allow deletion, and then `return false` from the hook function. Ensure you consume the 'ChangeTagAfterDelete' hook to carry out custom deletion actions. $tag:name of the tag $user:user initiating the action & $status:Status object. See above. 'ChangeTagsListActive':Allows you to nominate which of the tags your extension uses are in active use. & $tags:list of all active tags. Append to this array. 'ChangeTagsAfterUpdateTags':Called after tags have been updated with the ChangeTags::updateTags function. Params:$addedTags:tags effectively added in the update $removedTags:tags effectively removed in the update $prevTags:tags that were present prior to the update $rc_id:recentchanges table id $rev_id:revision table id $log_id:logging table id $params:tag params $rc:RecentChange being tagged when the tagging accompanies the action or null $user:User who performed the tagging when the tagging is subsequent to the action or null 'ChangeTagsAllowedAdd':Called when checking if a user can add tags to a change. & $allowedTags:List of all the tags the user is allowed to add. Any tags the user wants to add( $addTags) that are not in this array will cause it to fail. You may add or remove tags to this array as required. $addTags:List of tags user intends to add. $user:User who is adding the tags. 'ChangeUserGroups':Called before user groups are changed. $performer:The User who will perform the change $user:The User whose groups will be changed & $add:The groups that will be added & $remove:The groups that will be removed 'Collation::factory':Called if $wgCategoryCollation is an unknown collation. $collationName:Name of the collation in question & $collationObject:Null. Replace with a subclass of the Collation class that implements the collation given in $collationName. 'ConfirmEmailComplete':Called after a user 's email has been confirmed successfully. $user:user(object) whose email is being confirmed 'ContentAlterParserOutput':Modify parser output for a given content object. Called by Content::getParserOutput after parsing has finished. Can be used for changes that depend on the result of the parsing but have to be done before LinksUpdate is called(such as adding tracking categories based on the rendered HTML). $content:The Content to render $title:Title of the page, as context $parserOutput:ParserOutput to manipulate 'ContentGetParserOutput':Customize parser output for a given content object, called by AbstractContent::getParserOutput. May be used to override the normal model-specific rendering of page content. $content:The Content to render $title:Title of the page, as context $revId:The revision ID, as context $options:ParserOptions for rendering. To avoid confusing the parser cache, the output can only depend on parameters provided to this hook function, not on global state. $generateHtml:boolean, indicating whether full HTML should be generated. If false, generation of HTML may be skipped, but other information should still be present in the ParserOutput object. & $output:ParserOutput, to manipulate or replace 'ContentHandlerDefaultModelFor':Called when the default content model is determined for a given title. May be used to assign a different model for that title. $title:the Title in question & $model:the model name. Use with CONTENT_MODEL_XXX constants. 'ContentHandlerForModelID':Called when a ContentHandler is requested for a given content model name, but no entry for that model exists in $wgContentHandlers. Note:if your extension implements additional models via this hook, please use GetContentModels hook to make them known to core. $modeName:the requested content model name & $handler:set this to a ContentHandler object, if desired. 'ContentModelCanBeUsedOn':Called to determine whether that content model can be used on a given page. This is especially useful to prevent some content models to be used in some special location. $contentModel:ID of the content model in question $title:the Title in question. & $ok:Output parameter, whether it is OK to use $contentModel on $title. Handler functions that modify $ok should generally return false to prevent further hooks from further modifying $ok. 'ContribsPager::getQueryInfo':Before the contributions query is about to run & $pager:Pager object for contributions & $queryInfo:The query for the contribs Pager 'ContribsPager::reallyDoQuery':Called before really executing the query for My Contributions & $data:an array of results of all contribs queries $pager:The ContribsPager object hooked into $offset:Index offset, inclusive $limit:Exact query limit $descending:Query direction, false for ascending, true for descending 'ContributionsLineEnding':Called before a contributions HTML line is finished $page:SpecialPage object for contributions & $ret:the HTML line $row:the DB row for this line & $classes:the classes to add to the surrounding< li > & $attribs:associative array of other HTML attributes for the< li > element. Currently only data attributes reserved to MediaWiki are allowed(see Sanitizer::isReservedDataAttribute). 'ContributionsToolLinks':Change tool links above Special:Contributions $id:User identifier $title:User page title & $tools:Array of tool links $specialPage:SpecialPage instance for context and services. Can be either SpecialContributions or DeletedContributionsPage. Extensions should type hint against a generic SpecialPage though. 'ConvertContent':Called by AbstractContent::convert when a conversion to another content model is requested. Handler functions that modify $result should generally return false to disable further attempts at conversion. $content:The Content object to be converted. $toModel:The ID of the content model to convert to. $lossy: boolean indicating whether lossy conversion is allowed. & $result:Output parameter, in case the handler function wants to provide a converted Content object. Note that $result->getContentModel() must return $toModel. 'CustomEditor':When invoking the page editor Return true to allow the normal editor to be used, or false if implementing a custom editor, e.g. for a special namespace, etc. $article:Article being edited $user:User performing the edit 'DatabaseOraclePostInit':Called after initialising an Oracle database $db:the DatabaseOracle object 'DeletedContribsPager::reallyDoQuery':Called before really executing the query for Special:DeletedContributions Similar to ContribsPager::reallyDoQuery & $data:an array of results of all contribs queries $pager:The DeletedContribsPager object hooked into $offset:Index offset, inclusive $limit:Exact query limit $descending:Query direction, false for ascending, true for descending 'DeletedContributionsLineEnding':Called before a DeletedContributions HTML line is finished. Similar to ContributionsLineEnding $page:SpecialPage object for DeletedContributions & $ret:the HTML line $row:the DB row for this line & $classes:the classes to add to the surrounding< li > & $attribs:associative array of other HTML attributes for the< li > element. Currently only data attributes reserved to MediaWiki are allowed(see Sanitizer::isReservedDataAttribute). 'DifferenceEngineAfterLoadNewText':called in DifferenceEngine::loadNewText() after the new revision 's content has been loaded into the class member variable $differenceEngine->mNewContent but before returning true from this function. $differenceEngine:DifferenceEngine object 'DifferenceEngineLoadTextAfterNewContentIsLoaded':called in DifferenceEngine::loadText() after the new revision 's content has been loaded into the class member variable $differenceEngine->mNewContent but before checking if the variable 's value is null. This hook can be used to inject content into said class member variable. $differenceEngine:DifferenceEngine object 'DifferenceEngineMarkPatrolledLink':Allows extensions to change the "mark as patrolled" link which is shown both on the diff header as well as on the bottom of a page, usually wrapped in a span element which has class="patrollink". $differenceEngine:DifferenceEngine object & $markAsPatrolledLink:The "mark as patrolled" link HTML(string) $rcid:Recent change ID(rc_id) for this change(int) 'DifferenceEngineMarkPatrolledRCID':Allows extensions to possibly change the rcid parameter. For example the rcid might be set to zero due to the user being the same as the performer of the change but an extension might still want to show it under certain conditions. & $rcid:rc_id(int) of the change or 0 $differenceEngine:DifferenceEngine object $change:RecentChange object $user:User object representing the current user 'DifferenceEngineNewHeader':Allows extensions to change the $newHeader variable, which contains information about the new revision, such as the revision 's author, whether the revision was marked as a minor edit or not, etc. $differenceEngine:DifferenceEngine object & $newHeader:The string containing the various #mw-diff-otitle[1-5] divs, which include things like revision author info, revision comment, RevisionDelete link and more $formattedRevisionTools:Array containing revision tools, some of which may have been injected with the DiffRevisionTools hook $nextlink:String containing the link to the next revision(if any) $status
if(count( $args)< 1) $job