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.

[Zim__eHoOZHYAC09dW2ZwgAAQgE] /wiki/index.php/ChoralWiki:Miscategorized_articles 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 `wikipage`.page_namespace AS `page_namespace`,`wikipage`.page_id AS `page_id`,`wikipage`.page_title AS `page_title` FROM `wikipage` LEFT OUTER JOIN `wikicategorylinks` `ecl1` ON ((`wikipage`.page_id = ecl1.cl_from AND ecl1.cl_to ='Sheet_music')) LEFT OUTER JOIN `wikicategorylinks` `ecl2` ON ((`wikipage`.page_id = ecl2.cl_from AND ecl2.cl_to ='Hymn_tunes')) LEFT OUTER JOIN `wikicategorylinks` `ecl3` ON ((`wikipage`.page_id = ecl3.cl_from AND ecl3.cl_to ='Hymn_meters')) LEFT OUTER JOIN `wikicategorylinks` `ecl4` ON ((`wikipage`.page_id = ecl4.cl_from AND ecl4.cl_to ='Composers')) LEFT OUTER JOIN `wikicategorylinks` `ecl5` ON ((`wikipage`.page_id = ecl5.cl_from AND ecl5.cl_to ='Composers_(unhosted)')) LEFT OUTER JOIN `wikicategorylinks` `ecl6` ON ((`wikipage`.page_id = ecl6.cl_from AND ecl6.cl_to ='Translators')) LEFT OUTER JOIN `wikicategorylinks` `ecl7` ON ((`wikipage`.page_id = ecl7.cl_from AND ecl7.cl_to ='Lyricists')) LEFT OUTER JOIN `wikicategorylinks` `ecl8` ON ((`wikipage`.page_id = ecl8.cl_from AND ecl8.cl_to ='Compilers-Editors')) LEFT OUTER JOIN `wikicategorylinks` `ecl9` ON ((`wikipage`.page_id = ecl9.cl_from AND ecl9.cl_to ='Choral_ensembles')) LEFT OUTER JOIN `wikicategorylinks` `ecl10` ON ((`wikipage`.page_id = ecl10.cl_from AND ecl10.cl_to ='Text_pages')) LEFT OUTER JOIN `wikicategorylinks` `ecl11` ON ((`wikipage`.page_id = ecl11.cl_from AND ecl11.cl_to ='Texts')) LEFT OUTER JOIN `wikicategorylinks` `ecl12` ON ((`wikipage`.page_id = ecl12.cl_from AND ecl12.cl_to ='Chronological_lists')) LEFT OUTER JOIN `wikicategorylinks` `ecl13` ON ((`wikipage`.page_id = ecl13.cl_from AND ecl13.cl_to ='Composer_works_lists')) LEFT OUTER JOIN `wikicategorylinks` `ecl14` ON ((`wikipage`.page_id = ecl14.cl_from AND ecl14.cl_to ='Music_publications')) LEFT OUTER JOIN `wikicategorylinks` `ecl15` ON ((`wikipage`.page_id = ecl15.cl_from AND ecl15.cl_to ='Disambiguation')) LEFT OUTER JOIN `wikicategorylinks` `ecl16` ON ((`wikipage`.page_id = ecl16.cl_from AND ecl16.cl_to ='Disambiguation_of_works')) LEFT OUTER JOIN `wikicategorylinks` `ecl17` ON ((`wikipage`.page_id = ecl17.cl_from AND ecl17.cl_to ='Larger_works')) LEFT OUTER JOIN `wikicategorylinks` `ecl18` ON ((`wikipage`.page_id = ecl18.cl_from AND ecl18.cl_to ='Delete_requests')) LEFT OUTER JOIN `wikicategorylinks` `ecl19` ON ((`wikipage`.page_id = ecl19.cl_from AND ecl19.cl_to ='Pages_awaiting_cleanup')) LEFT OUTER JOIN `wikicategorylinks` `ecl20` ON ((`wikipage`.page_id = ecl20.cl_from AND ecl20.cl_to ='Permanently_broken_links')) LEFT OUTER JOIN `wikicategorylinks` `ecl21` ON ((`wikipage`.page_id = ecl21.cl_from AND ecl21.cl_to ='Edition_records')) WHERE `wikipage`.page_is_redirect = 0 AND `wikipage`.page_namespace = 0 AND ecl1.cl_to IS NULL AND ecl2.cl_to IS NULL AND ecl3.cl_to IS NULL AND ecl4.cl_to IS NULL AND ecl5.cl_to IS NULL AND ecl6.cl_to IS NULL AND ecl7.cl_to IS NULL AND ecl8.cl_to IS NULL AND ecl9.cl_to IS NULL AND ecl10.cl_to IS NULL AND ecl11.cl_to IS NULL AND ecl12.cl_to IS NULL AND ecl13.cl_to IS NULL AND ecl14.cl_to IS NULL AND ecl15.cl_to IS NULL AND ecl16.cl_to IS NULL AND ecl17.cl_to IS NULL AND ecl18.cl_to IS NULL AND ecl19.cl_to IS NULL AND ecl20.cl_to IS NULL AND ecl21.cl_to IS NULL LIMIT 2000
Function: MediaWiki\Extension\DynamicPageList3\Query::buildAndSelect - ChoralWiki:Miscategorized_articles
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(213): MediaWiki\Extension\DynamicPageList3\Parse->parse(string, Parser, NULL, NULL, boolean)
#12 /home/cpdlorg/public_html/wiki/extensions/DynamicPageList3/includes/Hooks.php(192): MediaWiki\Extension\DynamicPageList3\Hooks::executeTag(string, array, Parser, PPFrame_Hash)
#13 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(4017): MediaWiki\Extension\DynamicPageList3\Hooks::dplTag(string, array, Parser, PPFrame_Hash)
#14 /home/cpdlorg/public_html/wiki/includes/parser/PPFrame_Hash.php(353): Parser->extensionSubstitution(array, PPFrame_Hash, boolean)
#15 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(2951): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#16 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(1609): Parser->replaceVariables(string)
#17 /home/cpdlorg/public_html/wiki/includes/parser/Parser.php(723): Parser->internalParse(string)
#18 /home/cpdlorg/public_html/wiki/includes/content/WikitextContentHandler.php(301): Parser->parse(string, Title, ParserOptions, boolean, boolean, integer)
#19 /home/cpdlorg/public_html/wiki/includes/content/ContentHandler.php(1721): WikitextContentHandler->fillParserOutput(WikitextContent, MediaWiki\Content\Renderer\ContentParseParams, ParserOutput)
#20 /home/cpdlorg/public_html/wiki/includes/content/Renderer/ContentRenderer.php(47): ContentHandler->getParserOutput(WikitextContent, MediaWiki\Content\Renderer\ContentParseParams)
#21 /home/cpdlorg/public_html/wiki/includes/Revision/RenderedRevision.php(266): MediaWiki\Content\Renderer\ContentRenderer->getParserOutput(WikitextContent, Title, integer, ParserOptions, boolean)
#22 /home/cpdlorg/public_html/wiki/includes/Revision/RenderedRevision.php(237): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#23 /home/cpdlorg/public_html/wiki/includes/Revision/RevisionRenderer.php(221): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string, array)
#24 /home/cpdlorg/public_html/wiki/includes/Revision/RevisionRenderer.php(158): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#25 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#26 /home/cpdlorg/public_html/wiki/includes/Revision/RenderedRevision.php(199): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#27 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolWorkArticleView.php(91): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#28 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolWorkArticleViewCurrent.php(97): PoolWorkArticleView->renderRevision()
#29 /home/cpdlorg/public_html/wiki/includes/poolcounter/PoolCounterWork.php(162): PoolWorkArticleViewCurrent->doWork()
#30 /home/cpdlorg/public_html/wiki/includes/page/ParserOutputAccess.php(299): PoolCounterWork->execute()
#31 /home/cpdlorg/public_html/wiki/includes/page/Article.php(714): MediaWiki\Page\ParserOutputAccess->getParserOutput(WikiPage, ParserOptions, MediaWiki\Revision\RevisionStoreCacheRecord, integer)
#32 /home/cpdlorg/public_html/wiki/includes/page/Article.php(528): Article->generateContentOutput(User, ParserOptions, integer, OutputPage, array)
#33 /home/cpdlorg/public_html/wiki/includes/actions/ViewAction.php(78): Article->view()
#34 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(542): ViewAction->show()
#35 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(322): MediaWiki->performAction(Article, Title)
#36 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(904): MediaWiki->performRequest()
#37 /home/cpdlorg/public_html/wiki/includes/MediaWiki.php(562): MediaWiki->main()
#38 /home/cpdlorg/public_html/wiki/index.php(50): MediaWiki->run()
#39 /home/cpdlorg/public_html/wiki/index.php(46): wfIndexMain()
#40 {main}