Last modified: 2014-06-15 23:15:26 UTC
I am running MW 1.23.0 on centos with following environment: PHP 5.4.27 (fpm-fcgi) MySQL 5.6.17. User report the wiki stop from update template. Then I realized that php runJobs.php stop working after I upgrade MW to 1.23.0. I tried to run php runJobs.php --globals, and script stop here: [mPreprocessorClass] => Preprocessor_DOM ) [wgTitle] => [wgDeferredUpdateList] => Array ( ) [func] => DuoshuoExtension [profName] => Setup.php-extensions-DuoshuoExtension [wgServerName] => [wgFullyInitialised] => 1 [wgSharedSchema] => ) Which looks like a extension called Duoshuo blocked the runJobs.php. Unfortunately this is an important extension, I can not stop it. May I please to know what is wgSharedSchema, and how to modify the extension to fix this problem? Extension page: https://github.com/duoshuo/duoshuo-mediawiki/blob/master/Duoshuo/Duoshuo.php
I tried to removed all extension and this time the runjob.php stop here: *RECURSION* [user:RequestContext:private] => User Object ( [mId] => [mName] => [mRealName] => [mPassword] => [mNewpassword] => [mNewpassTime] => [mEmail] => [mTouched] => [mToken] => [mEmailAuthenticated] => [mEmailToken] => [mEmailTokenExpires] => [mRegistration] => [mEditCount] => [mGroups] => [mOptionOverrides] => [mPasswordExpires:protected] => [mOptionsLoaded] => [mLoadedItems:User:private] => Array ( ) [mFrom] => session [mNewtalk] => -1 [mDatePreference] => [mBlockedby] => -1 [mHash] => [mRights] => [mBlockreason] => [mEffectiveGroups] => [mImplicitGroups] => [mFormerGroups] => [mBlockedGlobally] => [mLocked] => [mHideName] => [mOptions] => [mRequest:User:private] => FauxRequest Object ( [wasPosted:FauxRequest:private] => [session:FauxRequest:private] => Array ( ) [data:protected] => Array ( ) [headers:protected] => Array ( ) [response:WebRequest:private] => [ip:WebRequest:private] => [protocol:protected] => http ) [mBlock] => [mAllowUsertalk] => [mBlockedFromCreateAccount:User:private] => [mWatchedItems:User:private] => Array ( ) ) [lang:RequestContext:private] => [skin:RequestContext:private] => [config:RequestContext:private] => ) ) [wgParser] => StubObject Object ( [mGlobal] => wgParser [mClass] => Parser [mParams] => Array ( [0] => Array ( [class] => Parser ) ) ) [wgTitle] => [wgDeferredUpdateList] => Array ( ) [wgFullyInitialised] => 1 [wgSharedSchema] => )
Might be a question for https://www.mediawiki.org/wiki/Project:Support_desk
> > Which looks like a extension called Duoshuo blocked the runJobs.php. > Unfortunately this is an important extension, I can not stop it. May I > please to know what is wgSharedSchema, and how to modify the extension to > fix this problem? > I don't think that conclusion is justified based on what you said here. --globals is unlikely to get you interesting debugging output. If you really want debugging output to see where it stops, do php runJobs.php --profiler trace ---- What happens when you run it just normally php runJobs.php What's the output of php showJobs.php what about php showJobs.php --group ----- (In reply to Andre Klapper from comment #2) > Might be a question for https://www.mediawiki.org/wiki/Project:Support_desk probably.
There are not any result of php runJobs.php： [root@moegirl-1 maintenance]# php runJobs.php [root@moegirl-1 maintenance]# A interesting thing I found is that php showJobs.php got 0 result. But http://zh.moegirl.org/api.php?action=query&meta=siteinfo&siprop=statistics shows there are 449 jobs. There are no result of php showJobs.php --group [root@moegirl-1 maintenance]# php showJobs.php --group [root@moegirl-1 maintenance]# By php runJobs.php --profiler trace It show as: 0.000042 -0.9 < LoadBalancer::getConnection 6.9 > DatabaseBase::query 0.8 > query: SELECT job_id,job_cmd,job_namespace,job_title,job_t imestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sh aN FROM `job` WHERE job_cmd = 'X' LIMIT N,...,N 0.000199 0.4 < query: SELECT job_id,job_cmd,job_namespace,job_title,job_t imestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sh aN FROM `job` WHERE job_cmd = 'X' LIMIT N,...,N 0.000228 -0.6 < DatabaseBase::query 0.2 > DatabaseBase::query 0.8 > query: SELECT job_id,job_cmd,job_namespace,job_title,job_t imestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sh aN FROM `job` WHERE job_cmd = 'X') ORDER BY job_random ASC LIMIT N 0.000206 0.5 < query: SELECT job_id,job_cmd,job_namespace,job_title,job_t imestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sh aN FROM `job` WHERE job_cmd = 'X') ORDER BY job_random ASC LIMIT N 0.000236 -0.6 < DatabaseBase::query -0.2 > DatabaseBase::query 0.8 > query: SELECT job_id,job_cmd,job_namespace,job_title,job_t imestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sh aN FROM `job` WHERE job_cmd = 'X') ORDER BY job_random DESC LIMIT N 0.000217 0.5 < query: SELECT job_id,job_cmd,job_namespace,job_title,job_t imestamp,job_params,job_random,job_attempts,job_token,job_token_timestamp,job_sh aN FROM `job` WHERE job_cmd = 'X') ORDER BY job_random DESC LIMIT N 0.000255 -0.6 < DatabaseBase::query 0.001315 -10.9 < JobQueue::pop 0.2 > JobQueueAggregator::notifyQueueEmpty 0.000022 -0.5 < JobQueueAggregator::notifyQueueEmpty 14.1 > DeferredUpdates::doUpdates 0.000024 -0.5 < DeferredUpdates::doUpdates
What version of MediaWiki did you upgrade from?
upgrade from mediawiki-1.22.6
I "TRUNCATE" the job table then rerun php runJobs.php, everything works fine now. I guess the job table was damaged while upgrading. Thank you Bawolff! Thank you for your help
