jenkins-bot has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/343771 )
Change subject: Remove obsoleted maint scripts in favor of requeueTranscodes.php ...................................................................... Remove obsoleted maint scripts in favor of requeueTranscodes.php The new requeueTranscodes.php handles several cases better: * has a --throttle option to avoid flooding queues * handles cases where transcode table wasn't filled out right * more flexible config options on one script * should handle multiple overlapping cases better Change-Id: I321d4869ac8ea187c2bbf0fbfc0ce0ad3a540630 --- D maintenance/cleanupTranscodes.php D maintenance/moveTranscoded.php D maintenance/resetTranscodes.php D maintenance/retryTranscodes.php 4 files changed, 0 insertions(+), 197 deletions(-) Approvals: jenkins-bot: Verified Jforrester: Looks good to me, approved diff --git a/maintenance/cleanupTranscodes.php b/maintenance/cleanupTranscodes.php deleted file mode 100644 index 6bcf216..0000000 --- a/maintenance/cleanupTranscodes.php +++ /dev/null @@ -1,47 +0,0 @@ -<?php -/** - * cleanup transcodes no longer defined in $wgEnabledTranscodeSet - * - */ -$IP = getenv( 'MW_INSTALL_PATH' ); -if ( $IP === false ) { - $IP = __DIR__ . '/../../..'; -} -require_once "$IP/maintenance/Maintenance.php"; - -class CleanupTranscodes extends Maintenance { - - public function __construct() { - parent::__construct(); - $this->addOption( "key", "remove all transcodes for given key", false, true ); - $this->addOption( "all", "remove all transcodes", false, false ); - $this->mDescription = "cleanup transcodes left over after changing encoding profiles."; - } - public function execute() { - global $wgEnabledTranscodeSet, $wgEnabledAudioTranscodeSet; - $transcodeSet = array_merge( $wgEnabledTranscodeSet, $wgEnabledAudioTranscodeSet ); - - if ( $this->hasOption( "all" ) ) { - $where = []; - } elseif ( $this->hasOption( "key" ) ) { - $where = [ 'transcode_key' => $this->getOption( 'key' ) ]; - } else { - $where = 'transcode_key NOT IN ("'. implode( '", "', $transcodeSet ).'")'; - } - $this->output( "Cleanup transcodes:\n" ); - $dbr = wfGetDB( DB_SLAVE ); - $res = $dbr->select( 'transcode', '*', $where, __METHOD__ ); - foreach ( $res as $row ) { - $this->output( - 'remove: '. $row->transcode_image_name . ' ' . $row->transcode_key . "\n" - ); - $title = Title::newFromText( $row->transcode_image_name, NS_FILE ); - $file = wfLocalFile( $title ); - WebVideoTranscode::removeTranscodes( $file, $row->transcode_key ); - } - $this->output( "Finished!\n" ); - } -} - -$maintClass = 'CleanupTranscodes'; // Tells it to run the class -require_once RUN_MAINTENANCE_IF_MAIN; diff --git a/maintenance/moveTranscoded.php b/maintenance/moveTranscoded.php deleted file mode 100644 index 2434dd4..0000000 --- a/maintenance/moveTranscoded.php +++ /dev/null @@ -1,55 +0,0 @@ -<?php -/** - * move transcoded files from thumb to transcoded container - * - */ -$IP = getenv( 'MW_INSTALL_PATH' ); -if ( $IP === false ) { - $IP = __DIR__ . '/../../..'; -} -require_once "$IP/maintenance/Maintenance.php"; - -class MoveTranscoded extends Maintenance { - - public function __construct() { - parent::__construct(); - $this->mDescription = "move transcoded files from thumb to transcoded container."; - } - public function execute() { - - $this->output( "Move transcoded files:\n" ); - $dbr = wfGetDB( DB_SLAVE ); - $res = $dbr->select( 'transcode', '*', [], __METHOD__ ); - foreach ( $res as $row ) { - $title = Title::newFromText( $row->transcode_image_name, NS_FILE ); - $file = wfLocalFile( $title ); - if ( !$file ) { - continue; - } - $oldPath = $file->getThumbPath( $file->getName() . '.' . $row->transcode_key ); - - $newPath = WebVideoTranscode::getDerivativeFilePath( $file, $row->transcode_key ); - if ( $oldPath != $newPath ) { - if ( $file->repo->fileExists( $oldPath ) ) { - if ( $file->repo->fileExists( $newPath ) ) { - $res = $file->repo->quickPurge( $oldPath ); - if ( !$res ) { - wfDebug( "Could not delete file $oldPath\n" ); - } else { - $this->output( "deleted $oldPath, exists in transcoded container\n" ); - } - } else { - $this->output( " $oldPath => $newPath\n" ); - $file->repo->quickImport( $oldPath, $newPath ); - $file->repo->quickPurge( $oldPath ); - } - } - } - - } - $this->output( "Finished!\n" ); - } -} - -$maintClass = 'MoveTranscoded'; // Tells it to run the class -require_once RUN_MAINTENANCE_IF_MAIN; diff --git a/maintenance/resetTranscodes.php b/maintenance/resetTranscodes.php deleted file mode 100644 index ffb2605..0000000 --- a/maintenance/resetTranscodes.php +++ /dev/null @@ -1,40 +0,0 @@ -<?php -/** - * reset stalled transcodes - * - */ -$IP = getenv( 'MW_INSTALL_PATH' ); -if ( $IP === false ) { - $IP = __DIR__ . '/../../..'; -} -require_once "$IP/maintenance/Maintenance.php"; - -class ResetTranscodes extends Maintenance { - - public function __construct() { - parent::__construct(); - $this->mDescription = "Reset stalled transcodes, that are no longer in the job queue."; - } - public function execute() { - $where = [ - "transcode_time_startwork" => null, - "transcode_time_error" => null - ]; - $dbr = wfGetDB( DB_SLAVE ); - $res = $dbr->select( 'transcode', '*', $where, __METHOD__ ); - foreach ( $res as $row ) { - $title = Title::newFromText( $row->transcode_image_name, NS_FILE ); - // re-insert WebVideoTranscodeJob, - // will only be added if not in queue - // due to deduplication - $job = new WebVideoTranscodeJob( $title, [ - 'transcodeMode' => 'derivative', - 'transcodeKey' => $row->transcode_key, - ] ); - JobQueueGroup::singleton()->push( $job ); - } - } -} - -$maintClass = 'ResetTranscodes'; // Tells it to run the class -require_once ( RUN_MAINTENANCE_IF_MAIN ); diff --git a/maintenance/retryTranscodes.php b/maintenance/retryTranscodes.php deleted file mode 100644 index 5360c2a..0000000 --- a/maintenance/retryTranscodes.php +++ /dev/null @@ -1,55 +0,0 @@ -<?php -/** - * Retry transcodes for a given key or error. - * This script can be used after updating/fixing - * the encoding pipeline to rerun transcodes - * that are known to work now. - * - */ -$IP = getenv( 'MW_INSTALL_PATH' ); -if ( $IP === false ) { - $IP = __DIR__ . '/../../..'; -} -require_once "$IP/maintenance/Maintenance.php"; - -class RetryTranscodes extends Maintenance { - - public function __construct() { - parent::__construct(); - $this->addOption( "key", "retry all failed transcodes for given key", false, true ); - $this->addOption( "error", "retry all failed transcodes matching error substring", false, true ); - $this->mDescription = "retry transcodes for given key or error"; - } - public function execute() { - if ( !$this->hasOption( "error" ) && !$this->hasOption( "key" ) ) { - $this->output( "You have to provide --key and/or --error\n" ); - return; - } - $dbw = wfGetDB( DB_MASTER ); - $cond = []; - $cond[] = 'transcode_time_error IS NOT NULL'; - if ( $this->hasOption( "key" ) ) { - $cond['transcode_key'] = $this->getOption( 'key' ); - } - if ( $this->hasOption( "error" ) ) { - $cond[] = "transcode_error " . $dbw->buildLike( $dbw->anyString(), - $this->getOption( 'error' ), $dbw->anyString() ); - } - do { - $res = $dbw->select( 'transcode', 'transcode_id', - $cond, __METHOD__, [ 'LIMIT' => 100 ] ); - $ids = []; - foreach ( $res as $row ) { - $ids[] = $row->transcode_id; - } - if ( $ids ) { - $dbw->delete( 'transcode', - [ 'transcode_id' => $ids ], __METHOD__ ); - wfWaitForSlaves(); - } - } while ( $ids ); - } -} - -$maintClass = 'RetryTranscodes'; // Tells it to run the class -require_once ( RUN_MAINTENANCE_IF_MAIN ); -- To view, visit https://gerrit.wikimedia.org/r/343771 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I321d4869ac8ea187c2bbf0fbfc0ce0ad3a540630 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/TimedMediaHandler Gerrit-Branch: master Gerrit-Owner: Brion VIBBER <br...@wikimedia.org> Gerrit-Reviewer: Jforrester <jforres...@wikimedia.org> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits