summaryrefslogtreecommitdiff
path: root/maintenance/nextJobDB.php
blob: 6af5cbecec46b2beb034cb143c4cc264d8a19cf3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<?php
/**
 * Pick a database that has pending jobs
 *
 * @file
 * @ingroup Maintenance
 */

$options = array( 'type'  );

require_once( 'commandLine.inc' );

$type = isset($options['type'])
		? $options['type']
		: false;

$mckey = $type === false
            ? "jobqueue:dbs"
            : "jobqueue:dbs:$type";

$pendingDBs = $wgMemc->get( $mckey );
if ( !$pendingDBs ) {
	$pendingDBs = array();
	# Cross-reference DBs by master DB server
	$dbsByMaster = array();
	foreach ( $wgLocalDatabases as $db ) {
		$lb = wfGetLB( $db );
		$dbsByMaster[$lb->getServerName(0)][] = $db;
	}

	foreach ( $dbsByMaster as $master => $dbs ) {
		$dbConn = wfGetDB( DB_MASTER, array(), $dbs[0] );
		$stype = $dbConn->addQuotes($type);

		# Padding row for MySQL bug
		$sql = "(SELECT '-------------------------------------------')";
		foreach ( $dbs as $dbName ) {
			if ( $sql != '' ) {
				$sql .= ' UNION ';
			}
			if ($type === false)
				$sql .= "(SELECT '$dbName' FROM `$dbName`.job LIMIT 1)";
			else
				$sql .= "(SELECT '$dbName' FROM `$dbName`.job WHERE job_cmd=$stype LIMIT 1)";
		}
		$res = $dbConn->query( $sql, 'nextJobDB.php' );
		$row = $dbConn->fetchRow( $res ); // discard padding row
		while ( $row = $dbConn->fetchRow( $res ) ) {
			$pendingDBs[] = $row[0];
		}
	}

	$wgMemc->set( $mckey, $pendingDBs, 300 );
}

if ( $pendingDBs ) {
	echo $pendingDBs[mt_rand(0, count( $pendingDBs ) - 1)];
}