Topic on Project:Support desk/Flow

[RESOLVED] RunJobs.php hangs on execution

3
Nha4601 (talkcontribs)

RunJobs.php produces no output and does not complete execution when run from the command line.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>cd c:\inetpub\wwwroot\dev24\maintenance

c:\inetpub\wwwroot\dev24\maintenance>php runjobs.php
^C
c:\inetpub\wwwroot\dev24\maintenance>

As you can see, I have to abort execution every time (unless the job queue is 0).

Note: It appears as though another user is having the same issue and documented it on the RunJobs discussion page.


  1. System Configuration:
    • MediaWiki: 1.24.1 (a8eda20) (same issue experienced on 1.23.8)
    • PHP: 5.4.20 (cgi-fcgi)
    • MySQL: 5.6.14
    • Webserver: IIS 7.5, Windows Authentication (Anonymous Authentication disabled)
  2. Wiki is a private corporate wiki - the URL is not web accessible


Log Contents:


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

Any assistance is appreciated!

79.202.101.174 (talkcontribs)
  • Try running the script from your main mediawiki directory (the one with LocalSettings.php inside), e.g.
php maintenance\runjobs.php
  • Additionally, try using a separate LocalSettings.php without caching enabled (CACHE_NONE).

HTH and best regards, Thomas

Nha4601 (talkcontribs)

Thanks Thomas - Problem solved!

  • running script from main mediawiki directory: No effect
  • disabling caching: SOLVED - runjobs.php executes to completion