summaryrefslogtreecommitdiff
path: root/maintenance/purgeStaleMemcachedText.php
blob: c4f5006fbedff6eaf58366851beb4fe1b6b9a1e9 (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
<?php

require_once( dirname( __FILE__ ) . '/commandLine.inc' );

function purgeStaleMemcachedText() {
	global $wgMemc, $wgDBname;
	$db = wfGetDB( DB_MASTER );
	$maxTextId = $db->selectField( 'text', 'max(old_id)' );
	$latestReplicatedTextId = $db->selectField( array( 'recentchanges', 'revision' ), 'rev_text_id', 
		array( 'rev_id = rc_this_oldid', "rc_timestamp < '20101225183000'"),  'purgeStaleMemcachedText', 
		array( 'ORDER BY' => 'rc_timestamp DESC' ) );
	$latestReplicatedTextId -= 100; # A bit of paranoia

	echo "Going to purge text entries from $latestReplicatedTextId to $maxTextId in $wgDBname\n";

	for ( $i = $latestReplicatedTextId; $i < $maxTextId; $i++ ) {
		$key = wfMemcKey( 'revisiontext', 'textid', $i );
		
		while (1) {
			if (! $wgMemc->delete( $key ) ) {
				echo "Memcache delete for $key returned false\n";
			}
			if ( $wgMemc->get( $key ) ) {
				echo "There's still content in $key!\n";
			} else {
				break;
			}
		}
		
	}
}

purgeStaleMemcachedText();