Recurring Fatal exception of type "Wikimedia\Rdbms\DBQueryError" on pages using Cargo Query - usually it goes through after refreshing a few times, but it nearly always pops up on a brand new page load/cache clear - i.e. frequently for new users, and for recurring users after/during edits.
Some pages frequently showing this error:
https://tsb.miraheze.org/wiki/Aspects
https://tsb.miraheze.org/wiki/Actions
https://tsb.miraheze.org/wiki/Sagas
Sorry for the delay, I was out of town.
As of today, this is still an issue, latest error message: ca385d74cc5a2dacc4682ab8] 2022-08-08 17:13:55: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"
Hello, I apologise for the delay with this. Can you please provide another error you get?
Due to the delay, the one above would no longer be in logs, so in order to look it up in logs, I would need the hash you recieve once again (the hash is the random string of characters in the error message)
No problem.
Here is another error. [45eae375b55e503fea168552] 2022-08-14 21:19:29: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"
I received this after attempting to add another table to page https://tsb.miraheze.org/wiki/Sagas
As before, refreshing the page clears it up, but similar error messages have appeared for new visitors who have thought the page was simply down/etc
Error 1062: Duplicate entry '588-652' for key 'PRIMARY' (db141) Function: Wikimedia\Rdbms\Database::insert Query: INSERT INTO `cargo_backlinks` (cbl_query_page_id,cbl_result_page_id) VALUES (588,'652') from /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1606) #0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1590): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string) #1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1564): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string) #2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1173): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #3 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(2352): Wikimedia\Rdbms\Database->query(string, string, integer) #4 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(2332): Wikimedia\Rdbms\Database->doInsert(string, array, string) #5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(69): Wikimedia\Rdbms\Database->insert(string, array) #6 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(375): Wikimedia\Rdbms\DBConnRef->__call(string, array) #7 /srv/mediawiki/w/extensions/Cargo/includes/CargoBackLinks.php(54): Wikimedia\Rdbms\DBConnRef->insert(string, array) #8 /srv/mediawiki/w/extensions/Cargo/includes/parserfunctions/CargoQuery.php(180): CargoBackLinks::setBackLinks(Title, array) #9 /srv/mediawiki/w/includes/parser/Parser.php(3413): CargoQuery::run(Parser, string, string, string, string, string, string) #10 /srv/mediawiki/w/includes/parser/Parser.php(3096): Parser->callParserFunction(PPFrame_Hash, string, array) #11 /srv/mediawiki/w/includes/parser/PPFrame_Hash.php(276): Parser->braceSubstitution(array, PPFrame_Hash) #12 /srv/mediawiki/w/includes/parser/Parser.php(2932): PPFrame_Hash->expand(PPNode_Hash_Tree, integer) #13 /srv/mediawiki/w/includes/parser/Parser.php(1579): Parser->replaceVariables(string) #14 /srv/mediawiki/w/includes/parser/Parser.php(697): Parser->internalParse(string) #15 /srv/mediawiki/w/includes/content/WikitextContentHandler.php(294): Parser->parse(string, Title, ParserOptions, boolean, boolean, NULL) #16 /srv/mediawiki/w/includes/content/ContentHandler.php(1705): WikitextContentHandler->fillParserOutput(WikitextContent, MediaWiki\Content\Renderer\ContentParseParams, ParserOutput) #17 /srv/mediawiki/w/includes/content/Renderer/ContentRenderer.php(47): ContentHandler->getParserOutput(WikitextContent, MediaWiki\Content\Renderer\ContentParseParams) #18 /srv/mediawiki/w/includes/EditPage.php(4254): MediaWiki\Content\Renderer\ContentRenderer->getParserOutput(WikitextContent, Title, NULL, ParserOptions) #19 /srv/mediawiki/w/includes/EditPage.php(4157): EditPage->doPreviewParse(WikitextContent) #20 /srv/mediawiki/w/includes/EditPage.php(2926): EditPage->getPreviewText() #21 /srv/mediawiki/w/includes/EditPage.php(728): EditPage->showEditForm() #22 /srv/mediawiki/w/includes/actions/EditAction.php(71): EditPage->edit() #23 /srv/mediawiki/w/includes/actions/SubmitAction.php(38): EditAction->show() #24 /srv/mediawiki/w/includes/MediaWiki.php(543): SubmitAction->show() #25 /srv/mediawiki/w/includes/MediaWiki.php(321): MediaWiki->performAction(Article, Title) #26 /srv/mediawiki/w/includes/MediaWiki.php(912): MediaWiki->performRequest() #27 /srv/mediawiki/w/includes/MediaWiki.php(563): MediaWiki->main() #28 /srv/mediawiki/w/index.php(53): MediaWiki->run() #29 /srv/mediawiki/w/index.php(46): wfIndexMain() #30 {main}
Unfortunately there is nothing we can do. This has been reported numerous times before, and there is an upstream task about it. Apologies for the inconvenience, but until upstream resolves it nothing can be done from our end.
Upstream task: https://phabricator.wikimedia.org/T305684