Page MenuHomeMiraheze
Create Task
Maniphest T9002

Fatal DB exception on arhetwiki
Closed, ResolvedPublic
Actions

Description

Wiki: arhetwiki

Noticed this fatal DB exception [dc3042872e6bff887cf59ca8] 2022-03-28 02:09:16: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" when trying to load Special:AllPages on arhetwiki following its undeletion. I'm guessing this error existed from before, possibly related to a local extension configuration issue or a database table slot issue. Could a member of the SRE please kindly run a stack trace on this when they get a chance?

Event Timeline

Dmehus created this task.Mar 28 2022, 02:12
Herald added subscribers: Agent_Isai, Unknown Object (User), RhinosF1. · View Herald TranscriptMar 28 2022, 02:12
Dmehus added projects: MediaWiki (SRE), MediaWiki.Mar 28 2022, 02:12
Herald added a subscriber: Reception123. · View Herald TranscriptMar 28 2022, 02:12
Dmehus triaged this task as Normal priority.Mar 28 2022, 02:13
Dmehus moved this task from Backlog to Short Term on the MediaWiki (SRE) board.
Dmehus moved this task from Backlog to Bugs on the MediaWiki board.

Triaging as normal as wiki is at least partially accessible

Reception123 added a comment.Apr 8 2022, 06:08
Error 1176: Key 'page_name_title' doesn't exist in table 'page' (db111)
Function: SpecialAllPages::showChunk
Query: SELECT  page_namespace,page_title,page_is_redirect,page_id  FROM `page`  FORCE INDEX (page_name_title)  WHERE page_namespace = 0 AND (page_title >= '')  ORDER BY page_title LIMIT 346
mediawiki_exception_trace
from /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1809)
#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1793): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1768): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1327): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(2012): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(string, array, array, string, array)
#5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(324): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/w/includes/specials/SpecialAllPages.php(234): Wikimedia\Rdbms\DBConnRef->select(string, array, array, string, array)
#7 /srv/mediawiki/w/includes/specials/SpecialAllPages.php(186): SpecialAllPages->showChunk(integer, string, string, boolean)
#8 /srv/mediawiki/w/includes/specials/SpecialAllPages.php(107): SpecialAllPages->showToplevel(integer, NULL, NULL, boolean)
#9 /srv/mediawiki/w/includes/specialpage/SpecialPage.php(647): SpecialAllPages->execute(NULL)
#10 /srv/mediawiki/w/includes/specialpage/SpecialPageFactory.php(1366): SpecialPage->run(NULL)
#11 /srv/mediawiki/w/includes/MediaWiki.php(314): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#12 /srv/mediawiki/w/includes/MediaWiki.php(930): MediaWiki->performRequest()
#13 /srv/mediawiki/w/includes/MediaWiki.php(564): MediaWiki->main()
#14 /srv/mediawiki/w/index.php(53): MediaWiki->run()
#15 /srv/mediawiki/w/index.php(46): wfIndexMain()
#16 {main}
Reception123 closed this task as Resolved.EditedApr 8 2022, 06:20
Reception123 claimed this task.

Fixed, caused by patch-page-rename-name_title-index.sql not having been run on the wiki for some reason.

Thanks to @Universal_Omega for the help.

Dmehus awarded a token.Apr 10 2022, 05:41