Page MenuHomePhabricator
Create Task
Maniphest T391885

Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'testwiki.wikifunctionsclient_usage' doesn't existFunction: MediaWiki\Extension\WikiLambda\WikifunctionsClientStore::deleteWikifunctionsUsageQuery: DELETE FROM `wikifunctionscli
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'testwiki.wikifunctionsclient_usage' doesn't exist
Function: MediaWiki\Extension\WikiLambda\WikifunctionsClientStore::deleteWikifunctionsUsage
Query: DELETE FROM `wikifunctionscli
FrameLocationCall
from/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1232)
#0/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1216)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1190)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1740)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->delete(string, array, string)
#5/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(581)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/querybuilder/DeleteQueryBuilder.php(230)Wikimedia\Rdbms\DBConnRef->delete(string, array, string)
#7/srv/mediawiki/php-1.44.0-wmf.24/extensions/WikiLambda/includes/WikifunctionsClientStore.php(69)Wikimedia\Rdbms\DeleteQueryBuilder->execute()
#8/srv/mediawiki/php-1.44.0-wmf.24/extensions/WikiLambda/includes/HookHandler/ClientHooks.php(75)MediaWiki\Extension\WikiLambda\WikifunctionsClientStore->deleteWikifunctionsUsage(MediaWiki\Title\Title)
#9/srv/mediawiki/php-1.44.0-wmf.24/includes/HookContainer/HookContainer.php(155)MediaWiki\Extension\WikiLambda\HookHandler\ClientHooks->onPageSaveComplete(MediaWiki\Page\WikiPage, MediaWiki\User\User, string, int, MediaWiki\Revision\RevisionStoreRecord, MediaWiki\Storage\EditResult)
#10/srv/mediawiki/php-1.44.0-wmf.24/includes/HookContainer/HookRunner.php(2962)MediaWiki\HookContainer\HookContainer->run(string, array)
#11/srv/mediawiki/php-1.44.0-wmf.24/includes/Storage/PageUpdater.php(1700)MediaWiki\HookContainer\HookRunner->onPageSaveComplete(MediaWiki\Page\WikiPage, MediaWiki\User\User, string, int, MediaWiki\Revision\RevisionStoreRecord, MediaWiki\Storage\EditResult)
#12/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(2293)MediaWiki\Storage\PageUpdater->MediaWiki\Storage\{closure}(Wikimedia\Rdbms\DatabaseMySQL, string)
#13/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#14/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(661)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#15/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/AtomicSectionUpdate.php(41)Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#16/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/DeferredUpdates.php(459)MediaWiki\Deferred\AtomicSectionUpdate->doUpdate()
#17/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/DeferredUpdates.php(201)MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\AtomicSectionUpdate)
#18/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/DeferredUpdates.php(288)MediaWiki\Deferred\DeferredUpdates::run(MediaWiki\Deferred\AtomicSectionUpdate)
#19/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/DeferredUpdatesScope.php(243)MediaWiki\Deferred\DeferredUpdates::MediaWiki\Deferred\{closure}(MediaWiki\Deferred\AtomicSectionUpdate, int)
#20/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/DeferredUpdatesScope.php(172)MediaWiki\Deferred\DeferredUpdatesScope->processStageQueue(int, int, Closure)
#21/srv/mediawiki/php-1.44.0-wmf.24/includes/deferred/DeferredUpdates.php(307)MediaWiki\Deferred\DeferredUpdatesScope->processUpdates(int, Closure)
#22/srv/mediawiki/php-1.44.0-wmf.24/includes/MediaWikiEntryPoint.php(306)MediaWiki\Deferred\DeferredUpdates::doUpdates(int)
#23/srv/mediawiki/php-1.44.0-wmf.24/includes/MediaWikiEntryPoint.php(191)MediaWiki\MediaWikiEntryPoint->commitMainTransaction()
#24/srv/mediawiki/php-1.44.0-wmf.24/includes/MediaWikiEntryPoint.php(174)MediaWiki\MediaWikiEntryPoint->doPrepareForOutput()
#25/srv/mediawiki/php-1.44.0-wmf.24/includes/MediaWiki.php(90)MediaWiki\MediaWikiEntryPoint->prepareForOutput()
#26/srv/mediawiki/php-1.44.0-wmf.24/includes/api/ApiMain.php(975)MediaWiki::preOutputCommit(MediaWiki\Context\DerivativeContext)
#27/srv/mediawiki/php-1.44.0-wmf.24/includes/api/ApiMain.php(918)MediaWiki\Api\ApiMain->executeActionWithErrorHandling()
#28/srv/mediawiki/php-1.44.0-wmf.24/includes/api/ApiEntryPoint.php(152)MediaWiki\Api\ApiMain->execute()
#29/srv/mediawiki/php-1.44.0-wmf.24/includes/MediaWikiEntryPoint.php(202)MediaWiki\Api\ApiEntryPoint->execute()
#30/srv/mediawiki/php-1.44.0-wmf.24/api.php(44)MediaWiki\MediaWikiEntryPoint->run()
#31/srv/mediawiki/w/api.php(3)require(string)
#32{main}
Impact
Notes

Details

Request URL
https://test.wikipedia.org/w/api.php

Event Timeline

Reedy created this task.Apr 14 2025, 6:24 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 14 2025, 6:24 PM
Stashbot added a comment.Apr 14 2025, 6:27 PM

Mentioned in SAL (#wikimedia-operations) [2025-04-14T18:27:01Z] <James_F> Run mwscript sql --wiki=testwiki /srv/mediawiki-staging/php-1.44.0-wmf.24/extensions/WikiLambda/sql/mysql/table-usage.sql for T391885

Jdforrester-WMF closed this task as Resolved.Apr 14 2025, 6:27 PM
Jdforrester-WMF claimed this task.
Jdforrester-WMF subscribed.

Oops, sorry!

Maintenance_bot added a project: Abstract Wikipedia team.Apr 14 2025, 6:30 PM
dancy reopened this task as Open.May 28 2025, 8:44 PM
dancy subscribed.

I am periodically seeing similar errors:

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'bnwiktionary.wikifunctionsclient_usage' doesn't exist
Function: MediaWiki\Extension\WikiLambda\WikifunctionsClientStore::fetchWikifunctionsUsage
Query: SELECT  wfcu_targetPage AS
FrameLocationCall
from/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/Database.php(1232)
#0/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/Database.php(1216)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/Database.php(1190)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/Database.php(1367)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/Database.php(1341)Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->selectFieldValues(array, string, array, string, array, array)
#6/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/database/DBConnRef.php(344)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7/srv/mediawiki/php-1.45.0-wmf.3/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(798)Wikimedia\Rdbms\DBConnRef->selectFieldValues(array, string, array, string, array, array)
#8/srv/mediawiki/php-1.45.0-wmf.3/extensions/WikiLambda/includes/WikifunctionsClientStore.php(58)Wikimedia\Rdbms\SelectQueryBuilder->fetchFieldValues()
#9/srv/mediawiki/php-1.45.0-wmf.3/extensions/WikiLambda/includes/Jobs/WikifunctionsRecentChangesInsertJob.php(53)MediaWiki\Extension\WikiLambda\WikifunctionsClientStore->fetchWikifunctionsUsage(string)
#10/srv/mediawiki/php-1.45.0-wmf.3/extensions/EventBus/includes/JobExecutor.php(88)MediaWiki\Extension\WikiLambda\Jobs\WikifunctionsRecentChangesInsertJob->run()
#11/srv/mediawiki/rpc/RunSingleJob.php(60)MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#12{main}
Notes

Variations:
mlwiktionary.wikifunctionsclient_usage
igwiktionary.wikifunctionsclient_usage
dvwiktionary.wikifunctionsclient_usage
bnwiktionary.wikifunctionsclient_usage

Etonkovidova subscribed.Jun 7 2025, 1:42 AM

For wmf.4 there are 57 errors reported (only for rdbms channel, there might be other related errors in different channels ) - https://logstash.wikimedia.org/goto/31a7f07eb5ffc39da17d04326dcfe9ba. All errors have been reported on mlwiktionary.

Jdforrester-WMF closed this task as Resolved.Jun 8 2025, 6:33 PM
In T391885#10892865, @Etonkovidova wrote:

For wmf.4 there are 57 errors reported (only for rdbms channel, there might be other related errors in different channels ) - https://logstash.wikimedia.org/goto/31a7f07eb5ffc39da17d04326dcfe9ba. All errors have been reported on mlwiktionary.

Bah, totally my fault; I didn't create the DB tables. Ran foreachwikiindblist wikifunctionsclient sql /srv/mediawiki-staging/php-1.45.0-wmf.4/extensions/WikiLambda/sql/mysql/table-usage.sql twice, and the second time it failed on all wikis as the table already existed). Sorry!

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits