rebuildData.php freezes at certain page IDs

From semantic-mediawiki.org

Thanks - I was also having problems with the MediaWiki runjobs.php hanging on execution - Support thread. I thought the two issues may be related - and it turns out they were.

  • Disabling caching (CACHE_NONE) allowed both maintenance scripts to run to completion.
13:47, 21 January 2015

For the sake of completion, above run-time error was referring to the Jobclass (copied from the thread).

0.0312   1.5M  Start command line script runjobs.php
0.0468   1.8M  [caches] main: WinCacheBagOStuff, message: WinCacheBagOStuff, parser: WinCacheBagOStuff
0.0624   3.0M  [caches] LocalisationCache: using store LCStoreCDB
0.0780   4.0M  Fully initialised
0.1092   5.0M  Connected to database 0 at 127.0.0.1
0.1092   5.0M  Query mwdev (1) (slave): SELECT /* JobQueueDB::doGetSiblingQueuesWithJobs  */  DISTINCT job_cmd  FROM `job`   WHERE job_cmd IN ('refreshLinks','refreshLinks2','htmlCacheUpdate','sendMail','enotifNotify','fixDoubleRedirect','uploadFromUrl','AssembleUploadChunks','PublishStashedFile','null')   
0.1092   5.0M  LoadBalancer::reuseConnection: this connection was not opened as a foreign connection
0.1092   5.0M  Query mwdev (2) (slave): SELECT /* JobQueueDB::claimRandom  */  job_id,job_cmd,job_namespace,job_title,job_timestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sha1  FROM `job`   WHERE job_cmd = 'refreshLinks' AND job_token = ''  LIMIT 88,1  
0.1092   5.0M  Query mwdev (3) (slave): SELECT /* JobQueueDB::claimRandom  */  job_id,job_cmd,job_namespace,job_title,job_timestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sha1  FROM `job`   WHERE job_cmd = 'refreshLinks' AND job_token = '' AND (job_random >= '18174153')  ORDER BY job_random ASC LIMIT 1  
0.1092   5.0M  DatabaseBase::query: Writes done: UPDATE `job` SET job_token = 'X'
0.1092   5.0M  Query mwdev (4) (slave): UPDATE /* JobQueueDB::claimRandom  */  `job` SET job_token = '2d61852a9a7731265203632d5f49e0f1',job_token_timestamp = '20150108174628',job_attempts = job_attempts+1 WHERE job_cmd = 'refreshLinks' AND job_id = '235' AND job_token = ''
0.1716   5.0M  LoadBalancer::reuseConnection: this connection was not opened as a foreign connection
13:57, 21 January 2015
 

I'm not sure what the CACHE_NONE has to do with rebuildData but maybe we try to add a --no-cache option [0].

[0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/749

14:06, 21 January 2015