MediaSearch: Error 1205: Lock wait timeout exceeded; try restarting transaction
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Assigned To

None

Authored By

	Etonkovidova
	Mar 30 2021, 8:39 PM

Description

Error

MediaWiki version: 1.36.0-wmf.36

message

Error 1205: Lock wait timeout exceeded; try restarting transaction (10.64.48.124)
Function: User::loadFromDatabase
Query: SELECT  user_id,user_name,user_real_name,user_email,user_touched,user_token,user_email_authenticated,user_email_token,user_email_token_expires,user_registration,user_editcount,user_actor.actor_id  FROM `user` JOIN `actor` `user_actor` ON ((user_actor.actor_user = user_id))   WHERE user_id = 9189902  LIMIT 1   FOR UPDATE

Impact

The error was displayed in UI when a user was switching from MediaSearch preference to Search in Special:Preferences.

Notes ===is not specific to might to switching preferences from MediaSearch to Search

The total error count at the moment of filing is 50.

Details

Request URL: https://commons.wikimedia.org/wiki/Special:Preferences

Stack Trace

exception.trace

from /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/Database.php(1719)
#0 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/Database.php(1703): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/Database.php(1678): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/Database.php(1244): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/Database.php(1929): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/Database.php(2029): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#6 /srv/mediawiki/php-1.36.0-wmf.36/includes/libs/rdbms/database/DBConnRef.php(331): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7 /srv/mediawiki/php-1.36.0-wmf.36/includes/user/User.php(1331): Wikimedia\Rdbms\DBConnRef->selectRow(array, array, array, string, array, array)
#8 /srv/mediawiki/php-1.36.0-wmf.36/includes/user/User.php(457): User->loadFromDatabase(integer)
#9 /srv/mediawiki/php-1.36.0-wmf.36/includes/user/User.php(4480): User->loadFromId(integer)
#10 /srv/mediawiki/php-1.36.0-wmf.36/includes/specials/SpecialPreferences.php(105): User->getInstanceForUpdate()
#11 /srv/mediawiki/php-1.36.0-wmf.36/includes/specialpage/SpecialPage.php(646): SpecialPreferences->execute(NULL)
#12 /srv/mediawiki/php-1.36.0-wmf.36/includes/specialpage/SpecialPageFactory.php(1382): SpecialPage->run(NULL)
#13 /srv/mediawiki/php-1.36.0-wmf.36/includes/MediaWiki.php(309): MediaWiki\SpecialPage\SpecialPageFactory->executePath(Title, RequestContext)
#14 /srv/mediawiki/php-1.36.0-wmf.36/includes/MediaWiki.php(925): MediaWiki->performRequest()
#15 /srv/mediawiki/php-1.36.0-wmf.36/includes/MediaWiki.php(547): MediaWiki->main()
#16 /srv/mediawiki/php-1.36.0-wmf.36/index.php(53): MediaWiki->run()
#17 /srv/mediawiki/php-1.36.0-wmf.36/index.php(46): wfIndexMain()
#18 /srv/mediawiki/w/index.php(3): require(string)
#19 {main}

Related Objects

Mentioned Here: T278650: Loading or saving preferences is taking too long on Commons

Event Timeline

Etonkovidova created this task.Mar 30 2021, 8:39 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 30 2021, 8:39 PM

Etonkovidova renamed this task from Error 1205: Lock wait timeout exceeded; try restarting transaction (10.64.48.124)Function: User::loadFromDatabaseQuery: SELECT user_id,user_name,user_real_name,user_email,user_touched,user_token,user_email_authenticated,user_email_token,user_email_token_expires,user_registration,user_editcount,user_actor.actor_id FROM `user` JOIN `actor` `user_actor` ON ((user_actor.actor_user = user_id)) WHERE user_id = 9189902 LIMIT 1 FOR UPDATE to MediaSearch: Error 1205: Lock wait timeout exceeded; try restarting transaction .Mar 30 2021, 8:40 PM

Etonkovidova updated the task description. (Show Details)Mar 30 2021, 9:44 PM

In T278887#6958867, @Umherirrender wrote:

Possibly related: T278650: Loading or saving preferences is taking too long on Commons

It seems the case, yes. All Error 1205: Lock wait timeout exceeded; try restarting transaction are on commonswiki.

Etonkovidova closed this task as a duplicate of T278650: Loading or saving preferences is taking too long on Commons.Mar 30 2021, 9:52 PM

	F34198141: Screen Shot 2021-03-30 at 1.23.11 PM.png
	Mar 30 2021, 8:39 PM

MediaSearch: Error 1205: Lock wait timeout exceeded; try restarting transaction Closed, DuplicatePublicPRODUCTION ERRORActions