Last modified: 2014-05-26 09:04:03 UTC
If I go to http://hi.wikipedia.beta.wmflabs.org/ , I get the following error in the browser: MediaWiki internal error. Original exception: [6ccdf071] / Exception from line 1163 of /srv/common-local/php-master/includes/db/Database.php: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,fpc_override,fpc_level,fpc_expiry,fp_pending_since,fp_stable,fp_reviewed FROM `page` LEFT JOIN `flaggedpages` ON ((fp_page_id = page_id)) LEFT JOIN `flaggedpage_config` ON ((fpc_page_id = page_id)) WHERE page_namespace = '3' AND page_title = 'Amire80' LIMIT 1 Function: FlaggableWikiPage::pageData Error: 1146 Table 'hiwiki.flaggedpages' doesn't exist (10.68.16.193) Backtrace: #0 /srv/common-local/php-master/includes/db/Database.php(1129): DatabaseBase->reportQueryError(string, integer, string, string, boolean) #1 /srv/common-local/php-master/includes/db/Database.php(1596): DatabaseBase->query(string, string) #2 /srv/common-local/php-master/includes/db/Database.php(1685): DatabaseBase->select(array, array, array, string, array, array) #3 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(366): DatabaseBase->selectRow(array, array, array, string, array, array) #4 /srv/common-local/php-master/includes/WikiPage.php(335): FlaggableWikiPage->pageData(DatabaseMysqli, array, array) #5 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(382): WikiPage->pageDataFromTitle(DatabaseMysqli, Title) #6 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggedRevs.hooks.php(391): FlaggableWikiPage->loadPageData(string) #7 [internal function]: FlaggedRevsHooks::maybeMakeEditReviewed(WikiPage, Revision, boolean, User) #8 /srv/common-local/php-master/includes/Hooks.php(206): call_user_func_array(string, array) #9 /srv/common-local/php-master/includes/GlobalFunctions.php(4001): Hooks::run(string, array, NULL) #10 /srv/common-local/php-master/includes/WikiPage.php(1963): wfRunHooks(string, array) #11 /srv/common-local/php-master/includes/WikiPage.php(1651): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User) #12 /srv/common-local/php-master/extensions/NewUserMessage/NewUserMessage.class.php(230): WikiPage->doEdit(string, string, integer, boolean, User) #13 /srv/common-local/php-master/extensions/NewUserMessage/NewUserMessage.class.php(177): NewUserMessage::leaveUserMessage(User, WikiPage, string, string, string, string, User, integer) #14 /srv/common-local/php-master/extensions/NewUserMessage/NewUserMessage.class.php(191): NewUserMessage::createNewUserMessage(User) #15 [internal function]: NewUserMessage::createNewUserMessageAutoCreated(User) #16 /srv/common-local/php-master/includes/Hooks.php(206): call_user_func_array(string, array) #17 /srv/common-local/php-master/includes/GlobalFunctions.php(4001): Hooks::run(string, array, NULL) #18 /srv/common-local/php-master/extensions/CentralAuth/CentralAuthHooks.php(867): wfRunHooks(string, array) #19 /srv/common-local/php-master/extensions/CentralAuth/CentralAuthHooks.php(581): CentralAuthHooks::attemptAddUser(User) #20 [internal function]: CentralAuthHooks::onUserLoadFromSession(User, NULL) #21 /srv/common-local/php-master/includes/Hooks.php(206): call_user_func_array(string, array) #22 /srv/common-local/php-master/includes/GlobalFunctions.php(4001): Hooks::run(string, array, NULL) #23 /srv/common-local/php-master/includes/User.php(1094): wfRunHooks(string, array) #24 /srv/common-local/php-master/includes/User.php(343): User->loadFromSession() #25 /srv/common-local/php-master/includes/User.php(1932): User->load() #26 /srv/common-local/php-master/includes/User.php(3058): User->getId() #27 /srv/common-local/php-master/includes/Wiki.php(542): User->isLoggedIn() #28 /srv/common-local/php-master/includes/Wiki.php(452): MediaWiki->main() #29 /srv/common-local/php-master/index.php(46): MediaWiki->run() #30 /srv/common-local/w/index.php(3): require(string) #31 {main} Exception caught inside exception handler: [5f2be35b] / Exception from line 1163 of /srv/common-local/php-master/includes/db/Database.php: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,fpc_override,fpc_level,fpc_expiry,fp_pending_since,fp_stable,fp_reviewed FROM `page` LEFT JOIN `flaggedpages` ON ((fp_page_id = page_id)) LEFT JOIN `flaggedpage_config` ON ((fpc_page_id = page_id)) WHERE page_namespace = '0' AND page_title = 'मुखपृष्ठ' LIMIT 1 Function: FlaggableWikiPage::pageData Error: 1146 Table 'hiwiki.flaggedpages' doesn't exist (10.68.17.94) Backtrace: #0 /srv/common-local/php-master/includes/db/Database.php(1129): DatabaseBase->reportQueryError(string, integer, string, string, boolean) #1 /srv/common-local/php-master/includes/db/Database.php(1596): DatabaseBase->query(string, string) #2 /srv/common-local/php-master/includes/db/Database.php(1685): DatabaseBase->select(array, array, array, string, array, array) #3 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(366): DatabaseBase->selectRow(array, array, array, string, array, array) #4 /srv/common-local/php-master/includes/WikiPage.php(335): FlaggableWikiPage->pageData(DatabaseMysqli, array, array) #5 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(382): WikiPage->pageDataFromTitle(DatabaseMysqli, Title) #6 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(289): FlaggableWikiPage->loadPageData() #7 /srv/common-local/php-master/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(244): FlaggableWikiPage->getStabilitySettings() #8 /srv/common-local/php-master/extensions/FlaggedRevs/frontend/FlaggablePageView.php(239): FlaggableWikiPage->isReviewable() #9 /srv/common-local/php-master/extensions/FlaggedRevs/frontend/FlaggedRevsUI.hooks.php(73): FlaggablePageView->displayTag() #10 [internal function]: FlaggedRevsUIHooks::onBeforePageDisplay(OutputPage, SkinVector) #11 /srv/common-local/php-master/includes/Hooks.php(206): call_user_func_array(string, array) #12 /srv/common-local/php-master/includes/GlobalFunctions.php(4001): Hooks::run(string, array, NULL) #13 /srv/common-local/php-master/includes/OutputPage.php(2137): wfRunHooks(string, array) #14 /srv/common-local/php-master/includes/exception/MWException.php(195): OutputPage->output() #15 /srv/common-local/php-master/includes/exception/MWException.php(238): MWException->reportHTML() #16 /srv/common-local/php-master/includes/exception/MWExceptionHandler.php(45): MWException->report() #17 /srv/common-local/php-master/includes/exception/MWExceptionHandler.php(141): MWExceptionHandler::report(DBQueryError) #18 /srv/common-local/php-master/includes/Wiki.php(466): MWExceptionHandler::handle(DBQueryError) #19 /srv/common-local/php-master/index.php(46): MediaWiki->run() #20 /srv/common-local/w/index.php(3): require(string) #21 {main}
A few wikis have been added to the all-labs.dblist with: https://gerrit.wikimedia.org/r/#/c/129210/ but they have not been added to the Jenkins job that takes care of upgrading the databases on beta. Relevant doc for later additions: https://wikitech.wikimedia.org/wiki/Nova_Resource:Deployment-prep/Add_a_wiki I have the wikis to the Jenkins job with https://gerrit.wikimedia.org/r/#/c/135402/ . fawiki is still failing though: hashar@deployment-bastion:~$ sudo su - mwdeploy mwdeploy@deployment-bastion:~$ mwscript update.php --wiki=fawiki --quick #!/usr/bin/env php MediaWiki 1.24alpha Updater Going to run database updates for fawiki Depending on the size of your database this may take a while! ...securepoll_votes table does not exist, skipping modify field patch. ...echo_subscription doesn't exist. ...ipblocks table does not exist, skipping new field patch. ...ipblocks table does not exist, skipping new field patch. ...already have interwiki table [59855d99] [no req] Exception from line 341 of /mnt/srv/scap-stage-dir/php-master/includes/installer/MysqlUpdater.php: Missing rc_timestamp field of recentchanges table. Should not happen. Backtrace: #0 [internal function]: MysqlUpdater->doIndexUpdate() #1 /mnt/srv/scap-stage-dir/php-master/includes/installer/DatabaseUpdater.php(441): call_user_func_array(array, array) #2 /mnt/srv/scap-stage-dir/php-master/includes/installer/DatabaseUpdater.php(402): DatabaseUpdater->runUpdates(array, boolean) #3 /mnt/srv/scap-stage-dir/php-master/maintenance/update.php(163): DatabaseUpdater->doUpdates(array) #4 /mnt/srv/scap-stage-dir/php-master/maintenance/doMaintenance.php(109): UpdateMediaWiki->execute() #5 /mnt/srv/scap-stage-dir/php-master/maintenance/update.php(206): require_once(string) #6 /mnt/srv/scap-stage-dir/multiversion/MWScript.php(97): require_once(string) #7 {main}
turns out fawiki was not installed properly so: (mw@localhost) [fawiki]> drop database fawiki; Query OK, 4 rows affected (0.30 sec) Creating database fawiki for fa.fawiki (فارسی) Initialising tables [2ca8d598] [no req] Exception from line 3790 of /mnt/srv/scap-stage-dir/php-master/includes/db/Database.php: Could not open "/mnt/srv/scap-stage-dir/php-master/extensions/Math/db/math.sql". Backtrace: #0 /mnt/srv/scap-stage-dir/php-master/extensions/WikimediaMaintenance/addWiki.php(100): DatabaseBase->sourceFile(string) #1 /mnt/srv/scap-stage-dir/php-master/maintenance/doMaintenance.php(109): AddWiki->execute() #2 /mnt/srv/scap-stage-dir/php-master/extensions/WikimediaMaintenance/addWiki.php(275): require_once(string) #3 /mnt/srv/scap-stage-dir/multiversion/MWScript.php(97): require_once(string) #4 {main} $ Not yet :D I ran the updater again: mwdeploy@deployment-bastion:~$ mwscript update.php --wiki=fawiki --quick That creates a bunch of other tables and passed. Logged the Math error independently as bug 65761.
