Page MenuHomeMiraheze
Create Task
Maniphest T9702

Wikimedia\Rdbms\DBQueryError when running certain SMW queries on rosettacode
Closed, ResolvedPublic
Actions

Description

Query: [[Category:Programming Tasks]] [[Category:!BQN]] [[Category:!Omit/BQN]]

Error: [dbef064bd632639c5d5e4358] 2022-08-26 19:34:53: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

I don't have any further detail than that. Discussion at https://discord.com/channels/1011262808001880065/1011285763046002718

Related Objects

Event Timeline

MikeMol created this task.Aug 26 2022, 19:36
Herald added subscribers: Agent_Isai, Universal_Omega, Reception123. · View Herald TranscriptAug 26 2022, 19:36
Reception123 triaged this task as Normal priority.Aug 26 2022, 20:00
Reception123 added projects: MediaWiki (SRE), Extensions.
Error 1044: Access denied for user 'mediawiki'@'%' to database 'rosettacodewiki' (db131)
Function: SMW\SQLStore\TableBuilder\TemporaryTableBuilder::create
Query: CREATE TEMPORARY TABLE `t5`( id INT UNSIGNED KEY ) ENGINE=MEMORY
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/DBConnRef.php(69): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(287): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/MediaWiki/Connection/Database.php(379): Wikimedia\Rdbms\DBConnRef->query(string, string, boolean)
#6 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/MediaWiki/Connection/Database.php(291): SMW\MediaWiki\Connection\Database->executeQuery(Wikimedia\Rdbms\DBConnRef, string, string, boolean)
#7 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/TableBuilder/TemporaryTableBuilder.php(59): SMW\MediaWiki\Connection\Database->query(string, string, boolean)
#8 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/HierarchyTempTableBuilder.php(111): SMW\SQLStore\TableBuilder\TemporaryTableBuilder->create(string)
#9 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(355): SMW\SQLStore\QueryEngine\HierarchyTempTableBuilder->fillTempTable(string, string, string, integer)
#10 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(132): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->hierarchy(SMW\SQLStore\QueryEngine\QuerySegment)
#11 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(146): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->segment(SMW\SQLStore\QueryEngine\QuerySegment)
#12 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(122): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->table(SMW\SQLStore\QueryEngine\QuerySegment)
#13 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(146): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->segment(SMW\SQLStore\QueryEngine\QuerySegment)
#14 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(122): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->table(SMW\SQLStore\QueryEngine\QuerySegment)
#15 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(228): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->segment(SMW\SQLStore\QueryEngine\QuerySegment)
#16 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(125): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->conjunction(SMW\SQLStore\QueryEngine\QuerySegment)
#17 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(146): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->segment(SMW\SQLStore\QueryEngine\QuerySegment)
#18 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(122): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->table(SMW\SQLStore\QueryEngine\QuerySegment)
#19 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QuerySegmentListProcessor.php(115): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->segment(SMW\SQLStore\QueryEngine\QuerySegment)
#20 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/QueryEngine/QueryEngine.php(199): SMW\SQLStore\QueryEngine\QuerySegmentListProcessor->process(integer)
#21 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/SQLStore.php(388): SMW\SQLStore\QueryEngine\QueryEngine->getQueryResult(SMWQuery)
#22 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/SQLStore/SQLStore.php(376): SMW\SQLStore\SQLStore->fetchQueryResult(SMWQuery)
#23 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/MediaWiki/Specials/SpecialAsk.php(719): SMW\SQLStore\SQLStore->getQueryResult(SMWQuery)
#24 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/MediaWiki/Specials/SpecialAsk.php(451): SMW\MediaWiki\Specials\SpecialAsk->fetchQueryResult(array)
#25 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/MediaWiki/Specials/SpecialAsk.php(315): SMW\MediaWiki\Specials\SpecialAsk->fetchResults(SMW\Query\ResultPrinters\TableResultPrinter, NULL, SMW\Utils\UrlArgs)
#26 /srv/mediawiki/w/extensions/SemanticMediaWiki/src/MediaWiki/Specials/SpecialAsk.php(170): SMW\MediaWiki\Specials\SpecialAsk->makeHTMLResult()
#27 /srv/mediawiki/w/includes/specialpage/SpecialPage.php(671): SMW\MediaWiki\Specials\SpecialAsk->execute(NULL)
#28 /srv/mediawiki/w/includes/specialpage/SpecialPageFactory.php(1378): SpecialPage->run(NULL)
#29 /srv/mediawiki/w/includes/MediaWiki.php(315): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#30 /srv/mediawiki/w/includes/MediaWiki.php(912): MediaWiki->performRequest()
#31 /srv/mediawiki/w/includes/MediaWiki.php(563): MediaWiki->main()
#32 /srv/mediawiki/w/index.php(53): MediaWiki->run()
#33 /srv/mediawiki/w/index.php(46): wfIndexMain()
#34 {main}
Routhwick added a subscriber: Routhwick.Aug 26 2022, 20:23

A similar run-in was reported by this contributor early last month at T9515.

MikeMol added a comment.Aug 26 2022, 20:35

We've disabled the key affected component of our site, but would obviously prefer to have it enabled. So the urgency isn't very high toward a quickfix, and if it's desirable, you can use our wiki to reproduce it trivially.

Go to https://rosettacode.org/wiki/Special:Ask and enter "[[Category:Programming Tasks]] [[Category:!BQN]] [[Category:!Omit/BQN]]" as the search condition, and then hit "Find Results".

Universal_Omega added a comment.EditedAug 26 2022, 20:58

I think I have now fixed this by granting the CREATE TEMPORARY TABLES permission in mariadb, but please let us know if it worked. Thanks!

Universal_Omega closed this task as Resolved.Aug 26 2022, 21:00
Universal_Omega claimed this task.
Universal_Omega added projects: Database, Production Error.

Please re-open if the issue does indeed still persist. Thanks!

MikeMol added a comment.Aug 26 2022, 21:58

I no longer see that error. Thanks!