Page MenuHomePhabricator
Create Task
Maniphest T67677

Wikis added recently on beta produces "A database query error has occurred"
Closed, ResolvedPublic
Actions

Description

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}

Version: unspecified
Severity: major
URL: http://hi.wikipedia.beta.wmflabs.org/

Details

Reference
bz65677

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:17 AM
• bzimport added a project: Beta-Cluster-Infrastructure.
• bzimport set Reference to bz65677.
Amire80 created this task.May 23 2014, 2:28 PM
hashar added a comment.May 26 2014, 8:48 AM

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}

hashar added a comment.May 26 2014, 9:04 AM

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.

greg moved this task from To Triage to Done on the Beta-Cluster-Infrastructure board.Mar 5 2015, 4:46 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL