Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry for key 'itr_itemid_id_revision_id'
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry '12512487-1105737919' for key 'itr_itemid_id_revision_id'
Function: MediaWiki\Extension\DiscussionTools\ThreadItemStore::insertThreadItems
Query: INSERT INTO `discussion
exception.trace
from /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/Database.php(1523)
#0 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/Database.php(1507): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/Database.php(1481): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/Database.php(854): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/Database.php(1755): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.41.0-wmf.1/extensions/DiscussionTools/includes/ThreadItemStore.php(560): Wikimedia\Rdbms\Database->insert(string, array, string)
#5 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/Database.php(2610): MediaWiki\Extension\DiscussionTools\ThreadItemStore->MediaWiki\Extension\DiscussionTools\{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
#6 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure, string)
#7 /srv/mediawiki/php-1.41.0-wmf.1/includes/libs/rdbms/database/DBConnRef.php(680): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#8 /srv/mediawiki/php-1.41.0-wmf.1/extensions/DiscussionTools/includes/ThreadItemStore.php(571): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure, string)
#9 /srv/mediawiki/php-1.41.0-wmf.1/extensions/DiscussionTools/includes/Hooks/DataUpdatesHooks.php(48): MediaWiki\Extension\DiscussionTools\ThreadItemStore->insertThreadItems(MediaWiki\Revision\RevisionStoreRecord, MediaWiki\Extension\DiscussionTools\ContentThreadItemSet)
#10 /srv/mediawiki/php-1.41.0-wmf.1/includes/deferred/MWCallableUpdate.php(38): MediaWiki\Extension\DiscussionTools\Hooks\DataUpdatesHooks->MediaWiki\Extension\DiscussionTools\Hooks\{closure}()
#11 /srv/mediawiki/php-1.41.0-wmf.1/includes/deferred/DeferredUpdates.php(473): MWCallableUpdate->doUpdate()
#12 /srv/mediawiki/php-1.41.0-wmf.1/includes/deferred/RefreshSecondaryDataUpdate.php(103): DeferredUpdates::attemptUpdate(MWCallableUpdate, Wikimedia\Rdbms\LBFactoryMulti)
#13 /srv/mediawiki/php-1.41.0-wmf.1/includes/deferred/DeferredUpdates.php(473): RefreshSecondaryDataUpdate->doUpdate()
#14 /srv/mediawiki/php-1.41.0-wmf.1/includes/Storage/DerivedPageDataUpdater.php(1836): DeferredUpdates::attemptUpdate(RefreshSecondaryDataUpdate, Wikimedia\Rdbms\LBFactoryMulti)
#15 /srv/mediawiki/php-1.41.0-wmf.1/includes/page/WikiPage.php(2145): MediaWiki\Storage\DerivedPageDataUpdater->doSecondaryDataUpdates(array)
#16 /srv/mediawiki/php-1.41.0-wmf.1/includes/jobqueue/jobs/RefreshLinksJob.php(244): WikiPage->doSecondaryDataUpdates(array)
#17 /srv/mediawiki/php-1.41.0-wmf.1/includes/jobqueue/jobs/RefreshLinksJob.php(153): RefreshLinksJob->runForTitle(MediaWiki\Title\Title)
#18 /srv/mediawiki/php-1.41.0-wmf.1/extensions/EventBus/includes/JobExecutor.php(79): RefreshLinksJob->run()
#19 /srv/mediawiki/rpc/RunSingleJob.php(77): MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#20 {main}
Impact
Notes
  • Normally a low background level of these, but;
  • 1800+ in the last 1 hour
  • Started at around 21:56 UTC
  • Preceded by a spike in:
Argument 2 passed to MediaWiki\Extension\Translate\PageTranslation\TranslationPage::__construct() must be an instance of WikiPageMessageGroup, null given, called in /srv/mediawiki/php-1.41.0-wmf.1/extensions/Translate/src/PageTranslation/TranslatablePage.php on line 276

Details

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