Database error

Jump to navigation Jump to search

To avoid creating high database load, this query was aborted because the duration exceeded the limit. If you are reading many items at once, try doing multiple smaller operations instead.

[ZiaKb3dEqb1L4s6jvZQ4YgADUxI] /wiki/index.php/Psalm_45 Wikimedia\Rdbms\DBQueryTimeoutError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

A database query timeout has occurred.
Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT IFNULL(cl1.cl_sortkey, REPLACE(CONCAT(CASE `wikipage`.page_namespace WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User_talk:' WHEN 4 THEN 'ChoralWiki:' WHEN 5 THEN 'ChoralWiki_talk:' WHEN 6 THEN 'File:' WHEN 7 THEN 'File_talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template_talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help_talk:' WHEN 14 THEN 'Category:' WHEN 15 THEN 'Category_talk:' WHEN 100 THEN 'Request:' WHEN 101 THEN 'Request_talk:' WHEN 102 THEN 'Archived:' WHEN 103 THEN 'Archived_talk:' WHEN 106 THEN 'Form:' WHEN 107 THEN 'Form_talk:' END, `wikipage`.page_title), '_', ' ')) AS `sortkey`,pl.pl_title AS `sel_title`,pl.pl_namespace AS `sel_ns`,`wikipage`.page_namespace AS `page_namespace`,`wikipage`.page_id AS `page_id`,`wikipage`.page_title AS `page_title` FROM `wikipagelinks` `pl`,`wikipage` JOIN `wikicategorylinks` `cl1` ON ((`wikipage`.page_id = cl1.cl_from AND cl1.cl_to = 'Works_that_link_to_text_pages')) LEFT OUTER JOIN `wikicategorylinks` `ecl1` ON ((`wikipage`.page_id = ecl1.cl_from AND ecl1.cl_to ='Works_with_all_editions_withdrawn')) LEFT OUTER JOIN `wikicategorylinks` `ecl2` ON ((`wikipage`.page_id = ecl2.cl_from AND ecl2.cl_to ='Works_with_no_edition')) LEFT OUTER JOIN `wikicategorylinks` `ecl3` ON ((`wikipage`.page_id = ecl3.cl_from AND ecl3.cl_to ='Works_with_no_valid_edition')) WHERE `wikipage`.page_is_redirect = 0 AND ecl1.cl_to IS NULL AND ecl2.cl_to IS NULL AND ecl3.cl_to IS NULL AND (`wikipage`.page_id=pl.pl_from AND ((pl.pl_namespace=0 AND pl.pl_title LIKE 'Psalm_45_text_page'))) GROUP BY page_title ORDER BY sortkey ASC LIMIT 2000
Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - Psalm_45
Error: 1969 Query execution was interrupted (max_statement_time exceeded)

Backtrace:

from /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/Database.php(1614)
#0 /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/Database.php(1711): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /home/cpdlorg/public_html/wiki/includes/libs/rdbms/database/DBConnRef.php(326): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /home/cpdlorg/public_html/wiki/extensions/DynamicPageList3/includes/Query.php(382): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolCounterWorkViaCallback.php(74): MediaWiki\Extension\DynamicPageList3\Query::MediaWiki\Extension\DynamicPageList3\{closure}()
#8 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolCounterWork.php(162): PoolCounterWorkViaCallback->doWork()
#9 /home/cpdlorg/public_html/wiki/extensions/DynamicPageList3/includes/Query.php(400): PoolCounterWork->execute()
#10 /home/cpdlorg/public_html/wiki/extensions/DynamicPageList3/includes/Parse.php(212): MediaWiki\Extension\DynamicPageList3\Query->buildAndSelect(boolean, NULL, string)
#11 /home/cpdlorg/public_html/wiki/extensions/DynamicPageList3/includes/Hooks.php(276): MediaWiki\Extension\DynamicPageList3\Parse->parse(string, Parser, NULL, NULL, boolean)
#12 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(3437): MediaWiki\Extension\DynamicPageList3\Hooks::dplParserFunction(Parser, string, string, string, string, string, string, string, string, string, string, string, string, string, string, string)
#13 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(3122): Parser->callParserFunction(PPTemplateFrame_Hash, string, array)
#14 /home/cpdlorg/public_html/wiki/includes/parser/PPFrame_Hash.php(275): Parser->braceSubstitution(array, PPTemplateFrame_Hash)
#15 /home/cpdlorg/public_html/wiki/includes/parser/PPTemplateFrame_Hash.php(97): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#16 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(3310): PPTemplateFrame_Hash->cachedExpand(string, PPNode_Hash_Tree)
#17 /home/cpdlorg/public_html/wiki/includes/parser/PPFrame_Hash.php(275): Parser->braceSubstitution(array, PPFrame_Hash)
#18 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(2951): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#19 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(1609): Parser->replaceVariables(string)
#20 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(723): Parser->internalParse(string)
#21 /home/cpdlorg/public_html/wiki/includes/content/WikitextContentHandler.php(301): Parser->parse(string, Title, ParserOptions, boolean, boolean, integer)
#22 /home/cpdlorg/public_html/wiki/includes/content/ContentHandler.php(1721): WikitextContentHandler->fillParserOutput(WikitextContent, MediaWiki\Content\Renderer\ContentParseParams, ParserOutput)
#23 /home/cpdlorg/public_html/wiki/includes/content/Renderer/ContentRenderer.php(47): ContentHandler->getParserOutput(WikitextContent, MediaWiki\Content\Renderer\ContentParseParams)
#24 /home/cpdlorg/public_html/wiki/includes/Revision/RenderedRevision.php(266): MediaWiki\Content\Renderer\ContentRenderer->getParserOutput(WikitextContent, Title, integer, ParserOptions, boolean)
#25 /home/cpdlorg/public_html/wiki/includes/Revision/RenderedRevision.php(237): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#26 /home/cpdlorg/public_html/wiki/includes/Revision/RevisionRenderer.php(221): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string, array)
#27 /home/cpdlorg/public_html/wiki/includes/Revision/RevisionRenderer.php(158): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#28 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#29 /home/cpdlorg/public_html/wiki/includes/Revision/RenderedRevision.php(199): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#30 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolWorkArticleView.php(91): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#31 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolWorkArticleViewCurrent.php(97): PoolWorkArticleView->renderRevision()
#32 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolCounterWork.php(162): PoolWorkArticleViewCurrent->doWork()
#33 /home/cpdlorg/public_html/wiki/includes/page/ParserOutputAccess.php(299): PoolCounterWork->execute()
#34 /home/cpdlorg/public_html/wiki/includes/page/Article.php(714): MediaWiki\Page\ParserOutputAccess->getParserOutput(WikiPage, ParserOptions, MediaWiki\Revision\RevisionStoreCacheRecord, integer)
#35 /home/cpdlorg/public_html/wiki/includes/page/Article.php(528): Article->generateContentOutput(User, ParserOptions, integer, OutputPage, array)
#36 /home/cpdlorg/public_html/wiki/includes/actions/ViewAction.php(78): Article->view()
#37 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(542): ViewAction->show()
#38 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(322): MediaWiki->performAction(Article, Title)
#39 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(904): MediaWiki->performRequest()
#40 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(562): MediaWiki->main()
#41 /home/cpdlorg/public_html/wiki/index.php(50): MediaWiki->run()
#42 /home/cpdlorg/public_html/wiki/index.php(46): wfIndexMain()
#43 {main}