Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'centralauth.discussiontools_item_revisions' doesn't exist
Open, Needs TriagePublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'centralauth.discussiontools_item_revisions' doesn't exist
Function: MediaWiki\Extension\DiscussionTools\ThreadItemStore::insertThreadItems
Query: SELECT  itr_id  FROM `discussion
FrameLocationCall
from/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(1232)
#0/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(1216)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(1190)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(1367)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(1318)Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
#5/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(780)Wikimedia\Rdbms\Database->selectField(array, string, array, string, array, array)
#6/srv/mediawiki/php-1.44.0-wmf.25/extensions/DiscussionTools/includes/ThreadItemStore.php(739)Wikimedia\Rdbms\SelectQueryBuilder->fetchField()
#7/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/Database.php(2293)MediaWiki\Extension\DiscussionTools\ThreadItemStore->MediaWiki\Extension\DiscussionTools\{closure}(Wikimedia\Rdbms\DatabaseMySQL, string)
#8/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->doAtomicSection(string, Closure, string)
#9/srv/mediawiki/php-1.44.0-wmf.25/includes/libs/rdbms/database/DBConnRef.php(661)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#10/srv/mediawiki/php-1.44.0-wmf.25/extensions/DiscussionTools/includes/ThreadItemStore.php(803)Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure, string)
#11/srv/mediawiki/php-1.44.0-wmf.25/extensions/DiscussionTools/includes/Hooks/DataUpdatesHooks.php(50)MediaWiki\Extension\DiscussionTools\ThreadItemStore->insertThreadItems(MediaWiki\Revision\RevisionStoreRecord, MediaWiki\Extension\DiscussionTools\ContentThreadItemSet)
#12/srv/mediawiki/php-1.44.0-wmf.25/includes/deferred/MWCallableUpdate.php(52)MediaWiki\Extension\DiscussionTools\Hooks\DataUpdatesHooks->MediaWiki\Extension\DiscussionTools\Hooks\{closure}(string)
#13/srv/mediawiki/php-1.44.0-wmf.25/includes/deferred/DeferredUpdates.php(459)MediaWiki\Deferred\MWCallableUpdate->doUpdate()
#14/srv/mediawiki/php-1.44.0-wmf.25/includes/deferred/RefreshSecondaryDataUpdate.php(112)MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\MWCallableUpdate)
#15/srv/mediawiki/php-1.44.0-wmf.25/includes/deferred/DeferredUpdates.php(459)MediaWiki\Deferred\RefreshSecondaryDataUpdate->doUpdate()
#16/srv/mediawiki/php-1.44.0-wmf.25/includes/Storage/DerivedPageDataUpdater.php(1833)MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\RefreshSecondaryDataUpdate)
#17/srv/mediawiki/php-1.44.0-wmf.25/includes/page/WikiPage.php(1895)MediaWiki\Storage\DerivedPageDataUpdater->doSecondaryDataUpdates(array)
#18/srv/mediawiki/php-1.44.0-wmf.25/includes/jobqueue/jobs/RefreshLinksJob.php(304)MediaWiki\Page\WikiPage->doSecondaryDataUpdates(array)
#19/srv/mediawiki/php-1.44.0-wmf.25/includes/jobqueue/jobs/RefreshLinksJob.php(214)MediaWiki\JobQueue\Jobs\RefreshLinksJob->runForTitle(MediaWiki\Title\Title)
#20/srv/mediawiki/php-1.44.0-wmf.25/extensions/EventBus/includes/JobExecutor.php(88)MediaWiki\JobQueue\Jobs\RefreshLinksJob->run()
#21/srv/mediawiki/rpc/RunSingleJob.php(60)MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#22{main}
Impact
Notes

Details

Request URL
https://mw-jobrunner.discovery.wmnet/rpc/RunSingleJob.php

Event Timeline

matmarex subscribed.

It looks like something in core is giving DiscussionTools a reference to the wrong database. The handle is retriever from $this->dbProvider->getPrimaryDatabase(), and these queries are not supposed to run against centralauth.

matmarex renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'centralauth.discussiontools_item_revisions' doesn't existFunction: MediaWiki\Extension\DiscussionTools\ThreadItemStore::insertThreadItemsQuery: SELECT itr_id FROM `discussion to Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'centralauth.discussiontools_item_revisions' doesn't exist.Apr 21 2025, 5:34 PM
Krinkle subscribed.

Ack. Tagging accordingly since DiscussionTools maintainers (Editing-team) can't do much here until the Rdbms issue is understood/resolved.