Page MenuHomePhabricator

Error 1213 from MediaWiki\Storage\NameTableStore::store, Deadlock found when trying to get lock; try restarting transaction INSERT IGNORE INTO `change_tag_def`
Closed, DuplicatePublic

Description

Seen in https://integration.wikimedia.org/ci/job/wmf-quibble-selenium-php74-docker/34597/console

17:45:16 mw-dberror.log:Fri May 5 15:44:57 UTC 2023	6ea8063caf53	wikidb	Error 1213 from MediaWiki\Storage\NameTableStore::store, Deadlock found when trying to get lock; try restarting transaction INSERT IGNORE INTO `change_tag_def` (ctd_name,ctd_user_defined,ctd_count) VALUES ('mobile web edit',0,0) localhost:/workspace/db/quibble-mysql-yu4dgqrz/socket
17:45:16 mw-dberror.log:#0 /workspace/src/includes/libs/rdbms/database/Database.php(1454): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
17:45:16 mw-dberror.log:#1 /workspace/src/includes/libs/rdbms/database/Database.php(821): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
17:45:16 mw-dberror.log:#2 /workspace/src/includes/libs/rdbms/database/Database.php(1759): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
17:45:16 mw-dberror.log:#3 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->insert(string, array, string, array)
17:45:16 mw-dberror.log:#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(406): Wikimedia\Rdbms\DBConnRef->__call(string, array)
17:45:16 mw-dberror.log:#5 /workspace/src/includes/Storage/NameTableStore.php(409): Wikimedia\Rdbms\DBConnRef->insert(string, array, string, array)
17:45:16 mw-dberror.log:#6 /workspace/src/includes/libs/rdbms/database/Database.php(2609): MediaWiki\Storage\NameTableStore->MediaWiki\Storage\{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
17:45:16 mw-dberror.log:#7 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure, string)
17:45:16 mw-dberror.log:#8 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(674): Wikimedia\Rdbms\DBConnRef->__call(string, array)
17:45:16 mw-dberror.log:#9 /workspace/src/includes/Storage/NameTableStore.php(430): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure, string)
17:45:16 mw-dberror.log:#10 /workspace/src/includes/Storage/NameTableStore.php(168): MediaWiki\Storage\NameTableStore->store(string)
17:45:16 mw-dberror.log:#11 /workspace/src/includes/changetags/ChangeTags.php(472): MediaWiki\Storage\NameTableStore->acquireId(string)
17:45:16 mw-dberror.log:#12 /workspace/src/includes/changetags/ChangeTags.php(335): ChangeTags::updateTags(array, array, integer, integer, string, NULL, RecentChange)
17:45:16 mw-dberror.log:#13 /workspace/src/includes/changes/RecentChange.php(488): ChangeTags::addTags(array, integer, integer, string, NULL, RecentChange)
17:45:16 mw-dberror.log:#14 /workspace/src/extensions/Wikibase/client/includes/Changes/InjectRCRecordsJob.php(265): RecentChange->save()
17:45:16 mw-dberror.log:#15 /workspace/src/includes/jobqueue/JobRunner.php(363): Wikibase\Client\Changes\InjectRCRecordsJob->run()
17:45:16 mw-dberror.log:#16 /workspace/src/includes/jobqueue/JobRunner.php(324): JobRunner->doExecuteJob(Wikibase\Client\Changes\InjectRCRecordsJob)
17:45:16 mw-dberror.log:#17 /workspace/src/includes/jobqueue/JobRunner.php(228): JobRunner->executeJob(Wikibase\Client\Changes\InjectRCRecordsJob)
17:45:16 mw-dberror.log:#18 /workspace/src/includes/MediaWiki.php(1199): JobRunner->run(array)
17:45:16 mw-dberror.log:#19 /workspace/src/includes/MediaWiki.php(650): MediaWiki->triggerSyncJobs(integer)
17:45:16 mw-dberror.log:#20 /workspace/src/includes/deferred/TransactionRoundDefiningUpdate.php(26): MediaWiki->{closure}()
17:45:16 mw-dberror.log:#21 /workspace/src/includes/deferred/DeferredUpdates.php(473): TransactionRoundDefiningUpdate->doUpdate()
17:45:16 mw-dberror.log:#22 /workspace/src/includes/deferred/DeferredUpdates.php(398): DeferredUpdates::attemptUpdate(TransactionRoundDefiningUpdate, Wikimedia\Rdbms\LBFactorySimple)
17:45:16 mw-dberror.log:#23 /workspace/src/includes/deferred/DeferredUpdates.php(213): DeferredUpdates::run(TransactionRoundDefiningUpdate, Wikimedia\Rdbms\LBFactorySimple, MediaWiki\Logger\LegacyLogger, BufferingStatsdDataFactory, MediaWiki\JobQueue\JobQueueGroupFactory, string)
17:45:16 mw-dberror.log:#24 /workspace/src/includes/deferred/DeferredUpdatesScope.php(267): DeferredUpdates::{closure}(TransactionRoundDefiningUpdate, integer)
17:45:16 mw-dberror.log:#25 /workspace/src/includes/deferred/DeferredUpdatesScope.php(196): DeferredUpdatesScope->processStageQueue(integer, integer, Closure)
17:45:16 mw-dberror.log:#26 /workspace/src/includes/deferred/DeferredUpdates.php(234): DeferredUpdatesScope->processUpdates(integer, Closure)
17:45:16 mw-dberror.log:#27 /workspace/src/includes/MediaWiki.php(1125): DeferredUpdates::doUpdates()
17:45:16 mw-dberror.log:#28 /workspace/src/includes/MediaWiki.php(856): MediaWiki->restInPeace()
17:45:16 mw-dberror.log:#29 /workspace/src/includes/MediaWiki.php(604): MediaWiki->doPostOutputShutdown()
17:45:16 mw-dberror.log:#30 /workspace/src/index.php(50): MediaWiki->run()
17:45:16 mw-dberror.log:#31 /workspace/src/index.php(46): wfIndexMain()
17:45:16 mw-dberror.log:#32 {main}
17:45:16 mw-dberror.log:Fri May 5 15:44:57 UTC 2023	6ea8063caf53	wikidb	Error 1305 from MediaWiki\Storage\NameTableStore::store, SAVEPOINT wikimedia_rdbms_atomic1 does not exist ROLLBACK TO SAVEPOINT `wikimedia_rdbms_atomic1` localhost:/workspace/db/quibble-mysql-yu4dgqrz/socket
17:45:16 mw-dberror.log:#0 /workspace/src/includes/libs/rdbms/database/Database.php(1454): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
17:45:16 mw-dberror.log:#1 /workspace/src/includes/libs/rdbms/database/Database.php(821): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
17:45:16 mw-dberror.log:#2 /workspace/src/includes/libs/rdbms/database/Database.php(2571): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
17:45:16 mw-dberror.log:#3 /workspace/src/includes/libs/rdbms/database/Database.php(2613): Wikimedia\Rdbms\Database->cancelAtomic(string, Wikimedia\Rdbms\AtomicSectionIdentifier)
17:45:16 mw-dberror.log:#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure, string)
17:45:16 mw-dberror.log:#5 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(674): Wikimedia\Rdbms\DBConnRef->__call(string, array)
17:45:16 mw-dberror.log:#6 /workspace/src/includes/Storage/NameTableStore.php(430): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure, string)
17:45:16 mw-dberror.log:#7 /workspace/src/includes/Storage/NameTableStore.php(168): MediaWiki\Storage\NameTableStore->store(string)
17:45:16 mw-dberror.log:#8 /workspace/src/includes/changetags/ChangeTags.php(472): MediaWiki\Storage\NameTableStore->acquireId(string)
17:45:16 mw-dberror.log:#9 /workspace/src/includes/changetags/ChangeTags.php(335): ChangeTags::updateTags(array, array, integer, integer, string, NULL, RecentChange)
17:45:16 mw-dberror.log:#10 /workspace/src/includes/changes/RecentChange.php(488): ChangeTags::addTags(array, integer, integer, string, NULL, RecentChange)
17:45:16 mw-dberror.log:#11 /workspace/src/extensions/Wikibase/client/includes/Changes/InjectRCRecordsJob.php(265): RecentChange->save()
17:45:16 mw-dberror.log:#12 /workspace/src/includes/jobqueue/JobRunner.php(363): Wikibase\Client\Changes\InjectRCRecordsJob->run()
17:45:16 mw-dberror.log:#13 /workspace/src/includes/jobqueue/JobRunner.php(324): JobRunner->doExecuteJob(Wikibase\Client\Changes\InjectRCRecordsJob)
17:45:16 mw-dberror.log:#14 /workspace/src/includes/jobqueue/JobRunner.php(228): JobRunner->executeJob(Wikibase\Client\Changes\InjectRCRecordsJob)
17:45:16 mw-dberror.log:#15 /workspace/src/includes/MediaWiki.php(1199): JobRunner->run(array)
17:45:16 mw-dberror.log:#16 /workspace/src/includes/MediaWiki.php(650): MediaWiki->triggerSyncJobs(integer)
17:45:16 mw-dberror.log:#17 /workspace/src/includes/deferred/TransactionRoundDefiningUpdate.php(26): MediaWiki->{closure}()
17:45:16 mw-dberror.log:#18 /workspace/src/includes/deferred/DeferredUpdates.php(473): TransactionRoundDefiningUpdate->doUpdate()
17:45:16 mw-dberror.log:#19 /workspace/src/includes/deferred/DeferredUpdates.php(398): DeferredUpdates::attemptUpdate(TransactionRoundDefiningUpdate, Wikimedia\Rdbms\LBFactorySimple)
17:45:16 mw-dberror.log:#20 /workspace/src/includes/deferred/DeferredUpdates.php(213): DeferredUpdates::run(TransactionRoundDefiningUpdate, Wikimedia\Rdbms\LBFactorySimple, MediaWiki\Logger\LegacyLogger, BufferingStatsdDataFactory, MediaWiki\JobQueue\JobQueueGroupFactory, string)
17:45:16 mw-dberror.log:#21 /workspace/src/includes/deferred/DeferredUpdatesScope.php(267): DeferredUpdates::{closure}(TransactionRoundDefiningUpdate, integer)
17:45:16 mw-dberror.log:#22 /workspace/src/includes/deferred/DeferredUpdatesScope.php(196): DeferredUpdatesScope->processStageQueue(integer, integer, Closure)
17:45:16 mw-dberror.log:#23 /workspace/src/includes/deferred/DeferredUpdates.php(234): DeferredUpdatesScope->processUpdates(integer, Closure)
17:45:16 mw-dberror.log:#24 /workspace/src/includes/MediaWiki.php(1125): DeferredUpdates::doUpdates()
17:45:16 mw-dberror.log:#25 /workspace/src/includes/MediaWiki.php(856): MediaWiki->restInPeace()
17:45:16 mw-dberror.log:#26 /workspace/src/includes/MediaWiki.php(604): MediaWiki->doPostOutputShutdown()
17:45:16 mw-dberror.log:#27 /workspace/src/index.php(50): MediaWiki->run()
17:45:16 mw-dberror.log:#28 /workspace/src/index.php(46): wfIndexMain()
17:45:16 mw-dberror.log:#29 {main}

Looks like these tests were running at the time these errors were written to the log:

17:44:53 [0-0] RUNNING in chrome - /tests/selenium/specs/diff.js
17:44:54 [0-1] RUNNING in chrome - /tests/selenium/specs/editor_wikitext_nosave.js
17:44:54 [0-2] RUNNING in chrome - /tests/selenium/specs/mainmenu_loggedin.js
17:44:54 [0-3] RUNNING in chrome - /tests/selenium/specs/references.js
17:44:54 [0-0] PASSED in chrome - /tests/selenium/specs/diff.js
17:44:55 [0-4] RUNNING in chrome - /tests/selenium/specs/search_loggedin.js
17:44:56 [0-3] PASSED in chrome - /tests/selenium/specs/references.js
17:44:56 [0-5] RUNNING in chrome - /tests/selenium/specs/user_page.js
17:44:57 [0-2] Nearby item will only appear in main menu if $wgMFNearby is configured