Page MenuHomeMiraheze

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

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

Reception123 triaged this task as Normal priority.Aug 26 2022, 20:00
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}

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

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".

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 claimed this task.

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

I no longer see that error. Thanks!