Page MenuHomeMiraheze

Fatal exception of type "Wikimedia \ Rdbms \ DBQueryError" occurring on shiropediawiki
Closed, ResolvedPublic

Description

On https://shiropedia.miraheze.org/wiki/%E5%9F%8E%E3%83%9A%E3%83%87%E3%82%A3%E3%82%A2:%E8%AD%B0%E8%AB%96%E6%89%80:

Database error
A database query error has occurred. This may be a software bug.
[e7b815edd965e95f57c8d58e] 2020-11-01 09:33:47: Fatal exception of type "Wikimedia \ Rdbms \ DBQueryError"

Event Timeline

RhinosF1 renamed this task from Database error occurs to Fatal exception of type "Wikimedia \ Rdbms \ DBQueryError" occurring on shiropediawiki.Sun, Nov 1, 09:35
RhinosF1 triaged this task as Normal priority.
RhinosF1 updated the task description. (Show Details)
Dmehus raised the priority of this task from Normal to High.Mon, Nov 9, 21:37
Dmehus added a subscriber: Dmehus.

Can probably escalate this to high priority as it's a database / production error

Zppix added a subscriber: Zppix.

Ignore the above comment

Thanks, @Zppix, for reopening this ticket. I wondered if this task was appropriately closed.

Reception123 claimed this task.
Reception123 added a subscriber: Paladox.

This issue now seems to be resolved since myself and @Paladox are both able to access the page without seeing any error.

If the error persists, please feel free to reopen

You can confirm that this problem has not been solved yet by practicing rudimentary things such as looking at the diff from the page history.
This is a DPL problem, and if you enter a parameter that displays the user name such as adduser or addauthor, such as "addlasteditor = true", an error will occur. Investigate the cause and resolve it.

Assuming DPL is DynamicPageList, I noticed this issue yesterday on another customer wiki and @Paladox ran the trace. I'll try and post the trace results later today

If it is a DPL problem, it is likely upstream (i.e. for the developers to resolve). Unfortunately, Miraheze does not maintain every extension we have installed.

Universal_Omega lowered the priority of this task from High to Normal.Wed, Nov 18, 07:29
Universal_Omega edited projects, added Extensions; removed MediaWiki.

This is a DPL3 issue and not something we can solve at the moment, therefore not a high priority task.
For the record, the log reads:

2020-11-18 07:25:26 mw4 shiropediawiki: [b004753a561c960f43984063] /w/index.php?title=%E5%9F%8E%E3%83%9A%E3%83%87%E3%82%A3%E3%82%A2:%E8%AD%B0%E8%AB%96%E6%89%80&oldid=3252   Wikimedia\Rdbms\DBQueryError from line 1699 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: Error 1054: Unknown column 'rev.rev_user' in 'field list' (db11.miraheze.org)
Function: DPL\Query::buildAndSelect
Query: SELECT DISTINCT rev.rev_timestamp,rev.rev_user,rev.rev_user_text,rev.rev_comment,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title`  FROM `revision` `rev`,`page` INNER JOIN `categorylinks` `cl1` ON ((`page`.page_id = cl1.cl_from AND cl1.cl_to = '進行中の議論'))   WHERE ((`page`.page_title like'%議論所/%')) AND (`page`.page_id = rev.rev_page) AND (rev.rev_timestamp = (SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page = rev.rev_page)) AND `page`.page_is_redirect = 0 AND `page`.page_namespace = 4 AND (`page`.page_id = rev.rev_page) AND (`page`.page_id = rev.rev_page) AND (rev.rev_timestamp = (SELECT MAX(rev_aux_max.rev_timestamp) FROM `revision` AS rev_aux_max WHERE rev_aux_max.rev_page = rev.rev_page)) AND (NOT (`page`.page_title like'議論所/秀逸記事審査認定課'))  ORDER BY rev.rev_timestamp DESC LIMIT 500

#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(286): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /srv/mediawiki/w/extensions/DynamicPageList3/classes/Query.php(306): Wikimedia\Rdbms\DBConnRef->query(string, string)
#6 /srv/mediawiki/w/extensions/DynamicPageList3/classes/Parse.php(220): DPL\Query->buildAndSelect(boolean)
#7 /srv/mediawiki/w/extensions/DynamicPageList3/DynamicPageListHooks.php(252): DPL\Parse->parse(string, Parser, NULL, NULL, boolean)
#8 /srv/mediawiki/w/extensions/DynamicPageList3/DynamicPageListHooks.php(231): DynamicPageListHooks::executeTag(string, array, Parser, PPFrame_Hash)
#9 /srv/mediawiki/w/includes/parser/Parser.php(3922): DynamicPageListHooks::dplTag(string, array, Parser, PPFrame_Hash)
#10 /srv/mediawiki/w/includes/parser/PPFrame_Hash.php(330): Parser->extensionSubstitution(array, PPFrame_Hash)
#11 /srv/mediawiki/w/includes/parser/Parser.php(2887): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#12 /srv/mediawiki/w/includes/parser/Parser.php(1556): Parser->replaceVariables(string)
#13 /srv/mediawiki/w/includes/parser/Parser.php(651): Parser->internalParse(string)
#14 /srv/mediawiki/w/includes/content/WikitextContent.php(374): Parser->parse(string, Title, ParserOptions, boolean, boolean, integer)
#15 /srv/mediawiki/w/includes/content/AbstractContent.php(590): WikitextContent->fillParserOutput(Title, integer, ParserOptions, boolean, ParserOutput)
#16 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(263): AbstractContent->getParserOutput(Title, integer, ParserOptions, boolean)
#17 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(235): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#18 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(215): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string)
#19 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(152): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#20 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#21 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(197): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#22 /srv/mediawiki/w/includes/poolcounter/PoolWorkArticleView.php(216): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#23 /srv/mediawiki/w/includes/poolcounter/PoolCounterWork.php(162): PoolWorkArticleView->doWork()
#24 /srv/mediawiki/w/includes/page/Article.php(810): PoolCounterWork->execute()
#25 /srv/mediawiki/w/includes/actions/ViewAction.php(74): Article->view()
#26 /srv/mediawiki/w/includes/MediaWiki.php(527): ViewAction->show()
#27 /srv/mediawiki/w/includes/MediaWiki.php(313): MediaWiki->performAction(Article, Title)
#28 /srv/mediawiki/w/includes/MediaWiki.php(940): MediaWiki->performRequest()
#29 /srv/mediawiki/w/includes/MediaWiki.php(543): MediaWiki->main()
#30 /srv/mediawiki/w/index.php(53): MediaWiki->run()
#31 /srv/mediawiki/w/index.php(46): wfIndexMain()
#32 {main}
Universal_Omega added a project: Upstream.

Submitted merge request upstream to fix DPL3 entirly. If it is not merged upstream I will end up fully maintaining a forked version of the extension, as it is a very useful extension to have.