Page MenuHomePhabricator
Create Task
Maniphest T368571

Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transactionFunction: Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer::insertNonExistingRecordsIntoPrimary
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Description

Error
labels.normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction
Function: Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer::insertNonExistingRecordsIntoPrimary
error.stack_trace
from /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/Database.php(1198)
#0 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/Database.php(1182): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/Database.php(1156): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/Database.php(643): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/Database.php(1476): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->insert(string, array, string, array)
#5 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/database/DBConnRef.php(407): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.43.0-wmf.11/includes/libs/rdbms/querybuilder/InsertQueryBuilder.php(343): Wikimedia\Rdbms\DBConnRef->insert(string, array, string, array)
#7 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/Util/ReplicaPrimaryAwareRecordIdsAcquirer.php(282): Wikimedia\Rdbms\InsertQueryBuilder->execute()
#8 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/Util/ReplicaPrimaryAwareRecordIdsAcquirer.php(155): Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer->insertNonExistingRecordsIntoPrimary(array)
#9 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/Util/ReplicaPrimaryAwareRecordIdsAcquirer.php(105): Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer->insertNonExistingRecords(array, NULL)
#10 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermInLangIdsAcquirer.php(162): Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer->acquireIds(array)
#11 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermInLangIdsAcquirer.php(125): Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsAcquirer->acquireTextIds(array, Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer)
#12 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermInLangIdsAcquirer.php(409): Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsAcquirer->mapToTextIds(array, Wikibase\Lib\Store\Sql\Terms\Util\ReplicaPrimaryAwareRecordIdsAcquirer)
#13 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermInLangIdsAcquirer.php(56): Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsAcquirer->mapTermsArrayToTermIds(array)
#14 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermStoreWriterBase.php(152): Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsAcquirer->acquireTermInLangIds(array, Closure)
#15 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermStoreWriterBase.php(62): Wikibase\Lib\Store\Sql\Terms\DatabaseTermStoreWriterBase->acquireAndInsertTerms(Wikibase\DataModel\Entity\ItemId, Wikibase\DataModel\Term\Fingerprint)
#16 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseItemTermStoreWriter.php(23): Wikibase\Lib\Store\Sql\Terms\DatabaseTermStoreWriterBase->store(Wikibase\DataModel\Entity\ItemId, Wikibase\DataModel\Term\Fingerprint)
#17 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/lib/includes/Store/ItemTermStoreWriterAdapter.php(32): Wikibase\Lib\Store\Sql\Terms\DatabaseItemTermStoreWriter->storeTerms(Wikibase\DataModel\Entity\ItemId, Wikibase\DataModel\Term\Fingerprint)
#18 /srv/mediawiki/php-1.43.0-wmf.11/extensions/Wikibase/repo/includes/Content/DataUpdateAdapter.php(60): Wikibase\Lib\Store\ItemTermStoreWriterAdapter->saveTermsOfEntity(Wikibase\DataModel\Entity\Item)
#19 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdates.php(486): Wikibase\Repo\Content\DataUpdateAdapter->doUpdate()
#20 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/RefreshSecondaryDataUpdate.php(112): MediaWiki\Deferred\DeferredUpdates::attemptUpdate(Wikibase\Repo\Content\DataUpdateAdapter)
#21 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdates.php(486): MediaWiki\Deferred\RefreshSecondaryDataUpdate->doUpdate()
#22 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdates.php(198): MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\RefreshSecondaryDataUpdate)
#23 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdates.php(285): MediaWiki\Deferred\DeferredUpdates::run(MediaWiki\Deferred\RefreshSecondaryDataUpdate)
#24 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdatesScope.php(266): MediaWiki\Deferred\DeferredUpdates::MediaWiki\Deferred\{closure}(MediaWiki\Deferred\RefreshSecondaryDataUpdate, integer)
#25 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdatesScope.php(198): MediaWiki\Deferred\DeferredUpdatesScope->processStageQueue(integer, integer, Closure)
#26 /srv/mediawiki/php-1.43.0-wmf.11/includes/deferred/DeferredUpdates.php(304): MediaWiki\Deferred\DeferredUpdatesScope->processUpdates(integer, Closure)
#27 /srv/mediawiki/php-1.43.0-wmf.11/includes/MediaWikiEntryPoint.php(673): MediaWiki\Deferred\DeferredUpdates::doUpdates()
#28 /srv/mediawiki/php-1.43.0-wmf.11/includes/MediaWikiEntryPoint.php(496): MediaWiki\MediaWikiEntryPoint->restInPeace()
#29 /srv/mediawiki/php-1.43.0-wmf.11/includes/MediaWikiEntryPoint.php(454): MediaWiki\MediaWikiEntryPoint->doPostOutputShutdown()
#30 /srv/mediawiki/php-1.43.0-wmf.11/includes/MediaWikiEntryPoint.php(209): MediaWiki\MediaWikiEntryPoint->postOutputShutdown()
#31 /srv/mediawiki/php-1.43.0-wmf.11/api.php(44): MediaWiki\MediaWikiEntryPoint->run()
#32 /srv/mediawiki/w/api.php(3): require(string)
#33 {main}
Impact

Rolled back train due to higher than normal error rate

Notes

Details

Request URL
https://www.wikidata.org/w/api.php

Related Objects

Event Timeline

jeena created this task.Jun 26 2024, 7:07 PM
jeena triaged this task as Unbreak Now! priority.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 26 2024, 7:07 PM
jeena added a parent task: T366956: 1.43.0-wmf.11 deployment blockers.Jun 26 2024, 7:08 PM
• Agusbou2015 subscribed.Jun 26 2024, 7:11 PM
Ladsgroup added projects: Wikidata, wmde-wikidata-tech.Jun 26 2024, 7:11 PM
Ladsgroup added subscribers: ItamarWMDE, Lucas_Werkmeister_WMDE.
Ladsgroup subscribed.Jun 26 2024, 7:17 PM

I'm not seeing any change that could have caused it (https://www.mediawiki.org/wiki/MediaWiki_1.43/wmf.11#Wikibase) Maybe it was a time-wise coincidence (see also T365055: [REPO][SW] DatabaseTermStoreWriterBase::acquireAndInsertTerms() shouldn't lock all rows for the item)

jeena lowered the priority of this task from Unbreak Now! to Needs Triage.Jun 26 2024, 7:36 PM

Thanks @Ladsgroup. I've been monitoring since then and I think you are right.

jeena removed a parent task: T366956: 1.43.0-wmf.11 deployment blockers.Jun 26 2024, 7:37 PM
Michael subscribed.Jun 26 2024, 7:41 PM
ArthurTaylor subscribed.Jun 27 2024, 7:25 AM
ItamarWMDE closed this task as a duplicate of T283198: [LIB] Database deadlock in Wikibase\Lib\Store\Sql\Terms\Util\ReplicaMasterAwareRecordIdsAcquirer::insertNonExistingRecordsIntoMaster query.Jul 18 2024, 12:42 PM
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