Page MenuHomeMiraheze

Database Error - Fatal exception
Closed, ResolvedPublic

Description

Received this error on our wiki https://idleon.miraheze.org/wiki/Main_Page (https://idleon.info/wiki/Main_Page).

I received other instances of the same error several hours ago, but did not save the text. I ran into this error while attempting to update pages (both preview/submit) and viewing pages.

Database Error
A database query error has occurred. This may indicate a bug in the software.
[1eeb3c4119fdd2f590236045] 2021-12-17 15:44:39: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Event Timeline

Unknown Object (User) added a comment.EditedDec 17 2021, 18:34
Error 1062: Duplicate entry '4468-4357' for key 'PRIMARY' (db13)
Function: Wikimedia\Rdbms\Database::insert
Query: INSERT INTO `cargo_backlinks` (cbl_query_page_id,cbl_result_page_id) VALUES (4468,'4357')
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(2540): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(2520): Wikimedia\Rdbms\Database->doInsert(string, array, string)
#5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->insert(string, array)
#6 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(380): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7 /srv/mediawiki/w/extensions/Cargo/includes/CargoBackLinks.php(45): Wikimedia\Rdbms\DBConnRef->insert(string, array)
#8 /srv/mediawiki/w/extensions/Cargo/includes/parserfunctions/CargoQuery.php(161): CargoBackLinks::setBackLinks(Title, array)
#9 /srv/mediawiki/w/includes/parser/Parser.php(3407): CargoQuery::run(Parser, string, string, string, string, string, string)
#10 /srv/mediawiki/w/includes/parser/Parser.php(3092): Parser->callParserFunction(PPTemplateFrame_Hash, string, array)
#11 /srv/mediawiki/w/includes/parser/PPFrame_Hash.php(273): Parser->braceSubstitution(array, PPTemplateFrame_Hash)
#12 /srv/mediawiki/w/includes/parser/Parser.php(3281): PPFrame_Hash->expand(PPNode_Hash_Tree)
#13 /srv/mediawiki/w/includes/parser/PPFrame_Hash.php(273): Parser->braceSubstitution(array, PPFrame_Hash)
#14 /srv/mediawiki/w/includes/parser/Parser.php(2930): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#15 /srv/mediawiki/w/includes/parser/Parser.php(1598): Parser->replaceVariables(string)
#16 /srv/mediawiki/w/includes/parser/Parser.php(656): Parser->internalParse(string)
#17 /srv/mediawiki/w/includes/content/WikitextContent.php(327): Parser->parse(string, Title, ParserOptions, boolean, boolean, integer)
#18 /srv/mediawiki/w/includes/content/AbstractContent.php(548): WikitextContent->fillParserOutput(Title, integer, ParserOptions, boolean, ParserOutput)
#19 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(263): AbstractContent->getParserOutput(Title, integer, ParserOptions, boolean)
#20 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(235): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#21 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(217): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string, array)
#22 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(154): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#23 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#24 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(197): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#25 /srv/mediawiki/w/includes/poolcounter/PoolWorkArticleView.php(137): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#26 /srv/mediawiki/w/includes/poolcounter/PoolCounterWork.php(162): PoolWorkArticleView->doWork()
#27 /srv/mediawiki/w/includes/page/ParserOutputAccess.php(281): PoolCounterWork->execute()
#28 /srv/mediawiki/w/includes/page/Article.php(691): MediaWiki\Page\ParserOutputAccess->getParserOutput(WikiPage, ParserOptions, MediaWiki\Revision\RevisionStoreCacheRecord, integer)
#29 /srv/mediawiki/w/includes/page/Article.php(506): Article->generateContentOutput(User, ParserOptions, integer, OutputPage, array)
#30 /srv/mediawiki/w/includes/actions/ViewAction.php(80): Article->view()
#31 /srv/mediawiki/w/includes/MediaWiki.php(543): ViewAction->show()
#32 /srv/mediawiki/w/includes/MediaWiki.php(320): MediaWiki->performAction(Article, Title)
#33 /srv/mediawiki/w/includes/MediaWiki.php(930): MediaWiki->performRequest()
#34 /srv/mediawiki/w/includes/MediaWiki.php(564): MediaWiki->main()
#35 /srv/mediawiki/w/index.php(53): MediaWiki->run()
#36 /srv/mediawiki/w/index.php(46): wfIndexMain()
#37 {main}
Bukkit triaged this task as Normal priority.Dec 18 2021, 00:05
Bukkit added projects: MediaWiki, MediaWiki (SRE).

Thank you for the additional details - so it looks like a cargo query with duplicate values... The two page IDs in question (4468 and 4357) appear to be working now, is there anything I should do to monitor/debug further?

Reception123 claimed this task.