Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1146: Table '[wiktionary].wikifunctionsclient_usage' doesn't exist
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
  • service.version: 1.45.0-wmf.21
  • timestamp: 2025-10-02T00:39:38.315Z
  • labels.phpversion: 8.1.33
  • trace.id: 3d256b7e-8e3f-4d32-8bcd-c0026f7a2a05
  • Find trace.id in Logstash
labels.normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'frwiktionary.wikifunctionsclient_usage' doesn't exist
Function: MediaWiki\Extension\WikiLambda\WikifunctionsClientStore::deleteWikifunctionsUsage
Query: DELETE FROM `wikifunction
FrameLocationCall
from/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/Database.php(1239)
#0/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/Database.php(1223)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/Database.php(1197)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/Database.php(654)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/Database.php(1772)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->delete(string, array, string)
#5/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(658)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/querybuilder/DeleteQueryBuilder.php(230)Wikimedia\Rdbms\DBConnRef->delete(string, array, string)
#7/srv/mediawiki/php-1.45.0-wmf.21/extensions/WikiLambda/includes/WikifunctionsClientStore.php(99)Wikimedia\Rdbms\DeleteQueryBuilder->execute()
#8/srv/mediawiki/php-1.45.0-wmf.21/extensions/WikiLambda/includes/HookHandler/ClientHooks.php(76)MediaWiki\Extension\WikiLambda\WikifunctionsClientStore->deleteWikifunctionsUsage(MediaWiki\Title\Title)
#9/srv/mediawiki/php-1.45.0-wmf.21/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.45.0-wmf.21/includes/HookContainer/HookRunner.php(3293)MediaWiki\HookContainer\HookContainer->run(string, array)
#11/srv/mediawiki/php-1.45.0-wmf.21/includes/Storage/PageUpdater.php(1736)MediaWiki\HookContainer\HookRunner->onPageSaveComplete(MediaWiki\Page\WikiPage, MediaWiki\User\User, string, int, MediaWiki\Revision\RevisionStoreRecord, MediaWiki\Storage\EditResult)
#12/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/Database.php(2334)MediaWiki\Storage\PageUpdater->MediaWiki\Storage\{closure}(Wikimedia\Rdbms\DatabaseMySQL, string)
#13/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#14/srv/mediawiki/php-1.45.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(754)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#15/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/AtomicSectionUpdate.php(41)Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#16/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/DeferredUpdates.php(459)MediaWiki\Deferred\AtomicSectionUpdate->doUpdate()
#17/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/DeferredUpdates.php(201)MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\AtomicSectionUpdate)
#18/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/DeferredUpdates.php(288)MediaWiki\Deferred\DeferredUpdates::run(MediaWiki\Deferred\AtomicSectionUpdate)
#19/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/DeferredUpdatesScope.php(243)MediaWiki\Deferred\DeferredUpdates::MediaWiki\Deferred\{closure}(MediaWiki\Deferred\AtomicSectionUpdate, int)
#20/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/DeferredUpdatesScope.php(172)MediaWiki\Deferred\DeferredUpdatesScope->processStageQueue(int, int, Closure)
#21/srv/mediawiki/php-1.45.0-wmf.21/includes/deferred/DeferredUpdates.php(307)MediaWiki\Deferred\DeferredUpdatesScope->processUpdates(int, Closure)
#22/srv/mediawiki/php-1.45.0-wmf.21/includes/MediaWikiEntryPoint.php(302)MediaWiki\Deferred\DeferredUpdates::doUpdates(int)
#23/srv/mediawiki/php-1.45.0-wmf.21/includes/MediaWikiEntryPoint.php(187)MediaWiki\MediaWikiEntryPoint->commitMainTransaction()
#24/srv/mediawiki/php-1.45.0-wmf.21/includes/MediaWikiEntryPoint.php(170)MediaWiki\MediaWikiEntryPoint->doPrepareForOutput()
#25/srv/mediawiki/php-1.45.0-wmf.21/includes/MediaWiki.php(87)MediaWiki\MediaWikiEntryPoint->prepareForOutput()
#26/srv/mediawiki/php-1.45.0-wmf.21/includes/api/ApiMain.php(991)MediaWiki::preOutputCommit(MediaWiki\Context\DerivativeContext)
#27/srv/mediawiki/php-1.45.0-wmf.21/includes/api/ApiMain.php(929)MediaWiki\Api\ApiMain->executeActionWithErrorHandling()
#28/srv/mediawiki/php-1.45.0-wmf.21/includes/api/ApiEntryPoint.php(152)MediaWiki\Api\ApiMain->execute()
#29/srv/mediawiki/php-1.45.0-wmf.21/includes/MediaWikiEntryPoint.php(198)MediaWiki\Api\ApiEntryPoint->execute()
#30/srv/mediawiki/php-1.45.0-wmf.21/api.php(44)MediaWiki\MediaWikiEntryPoint->run()
#31/srv/mediawiki/w/api.php(3)require(string)
#32{main}
Notes

Seeing these for the following tables:

frwiktionary.wikifunctionsclient_usage
mgwiktionary.wikifunctionsclient_usage
fiwiktionary.wikifunctionsclient_usage
incubatorwiki.wikifunctionsclient_usage
kowiktionary.wikifunctionsclient_usage
eswiktionary.wikifunctionsclient_usage
jawiktionary.wikifunctionsclient_usage
viwiktionary.wikifunctionsclient_usage
ptwiktionary.wikifunctionsclient_usage
svwiktionary.wikifunctionsclient_usage
metawiki.actor
elwiktionary.wikifunctionsclient_usage
itwiktionary.wikifunctionsclient_usage
nlwiktionary.wikifunctionsclient_usage
cswiktionary.wikifunctionsclient_usage
trwiktionary.wikifunctionsclient_usage
thwiktionary.wikifunctionsclient_usage
tawiktionary.wikifunctionsclient_usage
simplewiktionary.wikifunctionsclient_usage
rowiktionary.wikifunctionsclient_usage
idwiktionary.wikifunctionsclient_usage
hywiktionary.wikifunctionsclient_usage
hiwiktionary.wikifunctionsclient_usage
hewiktionary.wikifunctionsclient_usage
fawiktionary.wikifunctionsclient_usage
cawiktionary.wikifunctionsclient_usage
bgwiktionary.wikifunctionsclient_usage

Looks pretty similar to T403079 - @Jdforrester-WMF?

Details

Request URL
https://fr.wiktionary.org/w/api.php
Related Changes in Gerrit:

Event Timeline

hashar triaged this task as Unbreak Now! priority.Oct 2 2025, 7:33 AM
hashar subscribed.

According to logs, the first entry was at Oct 1, 2025 @ 21:33:38.923.

I think it matches the deployment of 0996f6b2ee8f1302addb182bc6b1bfd489af8bc3 (https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/1172048) which refers to T397401 and T401682.

Change #1193024 had a related patch set uploaded (by Hashar; author: Hashar):

[operations/mediawiki-config@master] Revert "Enable Wikifunctions client mode on Wiktionaries, Part III, and Incubator"

https://gerrit.wikimedia.org/r/1193024

Change #1193024 merged by jenkins-bot:

[operations/mediawiki-config@master] Revert "Enable Wikifunctions client mode on Wiktionaries, Part III, and Incubator"

https://gerrit.wikimedia.org/r/1193024

Mentioned in SAL (#wikimedia-operations) [2025-10-02T08:06:37Z] <awight@deploy2002> Started scap sync-world: Backport for [[gerrit:1193024|Revert "Enable Wikifunctions client mode on Wiktionaries, Part III, and Incubator" (T406185 T397401 T401682)]], [[gerrit:1193022|UX changes for reference context item (T404690)]], [[gerrit:1193009|Nasty fix for main ref change in main+details (T406002)]]

Mentioned in SAL (#wikimedia-operations) [2025-10-02T08:34:11Z] <awight@deploy2002> awight, hashar: Backport for [[gerrit:1193024|Revert "Enable Wikifunctions client mode on Wiktionaries, Part III, and Incubator" (T406185 T397401 T401682)]], [[gerrit:1193022|UX changes for reference context item (T404690)]], [[gerrit:1193009|Nasty fix for main ref change in main+details (T406002)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verif

Mentioned in SAL (#wikimedia-operations) [2025-10-02T08:55:30Z] <awight@deploy2002> Finished scap sync-world: Backport for [[gerrit:1193024|Revert "Enable Wikifunctions client mode on Wiktionaries, Part III, and Incubator" (T406185 T397401 T401682)]], [[gerrit:1193022|UX changes for reference context item (T404690)]], [[gerrit:1193009|Nasty fix for main ref change in main+details (T406002)]] (duration: 48m 54s)

I ended up reverting it with https://gerrit.wikimedia.org/r/1193024 and that solved the spam. I have added a comment on the tasks that originated that deployment. Meanwhile, the log spam is gone and this is resolved as far as the train is concerned.

hashar claimed this task.
Krazy69guero.og renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1146: Table '[wiktionary].wikifunctionsclient_usage' doesn't exist to @Krazy69guero.Oct 6 2025, 4:16 AM
Krazy69guero.og reopened this task as In Progress.
Krazy69guero.og changed Request URL from https://fr.wiktionary.org/w/api.php to https://lwww.krazy69guero.og@gmail.com.
A_smart_kitten renamed this task from @Krazy69guero to Wikimedia\Rdbms\DBQueryError: Error 1146: Table '[wiktionary].wikifunctionsclient_usage' doesn't exist.Oct 6 2025, 5:15 AM
A_smart_kitten closed this task as Resolved.
A_smart_kitten changed Request URL from https://lwww.krazy69guero.og@gmail.com to https://fr.wiktionary.org/w/api.php.