Page MenuHomeMiraheze

Receiving error [7f11f1fa394d8af6bf68b747] 2022-06-29 19:51:43: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"
Closed, InvalidPublic

Description

URL: https://thepolicyhub.org.uk

When saving a Cargo query I'm getting the error [7f11f1fa394d8af6bf68b747] 2022-06-29 19:51:43: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Occasionally it will save successfully without the error. I have started the process of recreating the Policies database (the database I was querying on), which I am regretting because it is very slow at the moment.

Should I report this to the Extension creator or is it Miraheze issue?

[[EDIT]] - Seems to be when trying to output to CSV

Thanks,
Michael

Note: This is the cargo query

{{#cargo_query:

tables=Policies
fields=Policy

,Category
,SubCategory=Policies[subcategory]
,Description=Policies[description]
,CharterItem=Policies[charteritem]
,KeyPolicyid=Policies[keypolicyid]
,Stream=Policies[stream]
,Approval=Policies[approval]
,OriginalPolicy=Policies[originalpolicy]
,Status=Policies[status]
,PolicyPaper=Policies[policypaper]
,SupportDocs1=Policies[supportdocs1]
,SupportDocs2=Policies[supportdocs2]
,SupportDocs3=Policies[supportdocs3]
,UpdatedBy=Policies[updatedby]
,DateUpdated=Policies[dateupdated]

limit=840
format=csv
link text=Export all Policies

}}

Event Timeline

Reception123 triaged this task as Normal priority.Jun 30 2022, 05:46
Unknown Object (User) added a comment.Aug 2 2022, 20:38

Hello, is this still happening? If so, can you please copy the error and paste it here again next time it happens? Thanks!

Yes the error still occurs. I opened the page and made a minor change and then saved and got the error -

[0e348124694e7c755bfc0518] 2022-08-02 21:21:19: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

The changes were saved though.

I edited the file again and set back the change I'd made and I got the error again when I saved - again the changes were saved.

I then opened in edit and saved for a 3rd time and it saved without an error. (note no changes had been made to the page this time)

Unknown Object (User) added a comment.Aug 13 2022, 22:28
Error 1062: Duplicate entry '7193-5546' for key 'PRIMARY' (db101)
Function: Wikimedia\Rdbms\Database::insert
Query: INSERT INTO `cargo_backlinks` (cbl_query_page_id,cbl_result_page_id) VALUES (7193,'5546')
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(150): CargoBackLinks::setBackLinks(Title, array)
#9 /srv/mediawiki/w/includes/parser/Parser.php(3413): CargoQuery::run(Parser, string, string, 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, integer)
#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/Revision/RenderedRevision.php(267): MediaWiki\Content\Renderer\ContentRenderer->getParserOutput(WikitextContent, Title, integer, ParserOptions, boolean)
#19 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(238): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#20 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(221): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string, array)
#21 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(158): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#22 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#23 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(200): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#24 /srv/mediawiki/w/includes/poolcounter/PoolWorkArticleView.php(137): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#25 /srv/mediawiki/w/includes/poolcounter/PoolCounterWork.php(162): PoolWorkArticleView->doWork()
#26 /srv/mediawiki/w/includes/page/ParserOutputAccess.php(302): PoolCounterWork->execute()
Unknown Object (User) closed this task as Invalid.Aug 14 2022, 22:19
Unknown Object (User) claimed this task.
Unknown Object (User) added a project: Upstream.

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