Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction
Closed, DuplicatePublicPRODUCTION ERROR

Description

Same as {T314443} (but public task), seeing a lot of these in mediawiki-errors?

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction
Function: MediaWiki\User\UserOptionsManager::saveOptionsInternal
Query: INSERT IGNORE INTO `user_properties` (up_user,
exception.trace
from /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/Database.php(1914)
#0 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/Database.php(1898): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/Database.php(1872): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/Database.php(1248): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/Database.php(2377): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/Database.php(2358): Wikimedia\Rdbms\Database->doInsertNonConflicting(string, array, string)
#5 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->insert(string, array, string, array)
#6 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/database/DBConnRef.php(342): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7 /srv/mediawiki/php-1.39.0-wmf.22/includes/user/UserOptionsManager.php(466): Wikimedia\Rdbms\DBConnRef->insert(string, array, string, array)
#8 /srv/mediawiki/php-1.39.0-wmf.22/includes/user/User.php(2632): MediaWiki\User\UserOptionsManager->saveOptionsInternal(User, Wikimedia\Rdbms\DBConnRef)
#9 /srv/mediawiki/php-1.39.0-wmf.22/includes/auth/AuthManager.php(1913): User->saveSettings()
#10 /srv/mediawiki/php-1.39.0-wmf.22/extensions/CentralAuth/includes/CentralAuthUtilityService.php(125): MediaWiki\Auth\AuthManager->autoCreateUser(User, string, boolean, boolean)
#11 /srv/mediawiki/php-1.39.0-wmf.22/extensions/CentralAuth/includes/User/CentralAuthCreateLocalAccountJob.php(109): MediaWiki\Extension\CentralAuth\CentralAuthUtilityService->autoCreateUser(User)
#12 /srv/mediawiki/php-1.39.0-wmf.22/extensions/EventBus/includes/JobExecutor.php(79): MediaWiki\Extension\CentralAuth\User\CentralAuthCreateLocalAccountJob->run()
#13 /srv/mediawiki/rpc/RunSingleJob.php(77): MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#14 {main}
Impact
Notes