Page MenuHomePhabricator
Create Task
Maniphest T22468

User::invalidateCache throws 1205: Lock wait timeout exceeded
Closed, ResolvedPublic
Actions

Description

Loading 4 pages in the French Wikipedia just a few minutes ago (logged in with Wikimedia SUL), I got the following error on the last 2 tabs that were opened (logging pasted into #wikimedia-tech by domas):
Tue Sep 1 20:10:03 UTC 2009 srv151 frwiki User::invalidateCache 10.0.6.21 1205 Lock wait timeout exceeded; Try restarting transaction (10.0.6.21) UPDATE user SET user_touched = '20090901200957' WHERE user_id = '115175'
Tue Sep 1 20:10:04 UTC 2009 srv120 frwiki User::invalidateCache 10.0.6.21 1205 Lock wait timeout exceeded; Try restarting transaction (10.0.6.21) UPDATE user SET user_touched = '20090901200958' WHERE user_id = '115175'

<domas> we don't have too many of these. So we didn't really bother yet :) But I keep seeing these locks. Resolving them would be nice

Links to pages (if at all important):

Version: 1.21.x
Severity: normal

Details

Reference
bz20468

Related Objects
Search...

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:50 PM
• bzimport added a project: MediaWiki-libs-Rdbms.
• bzimport set Reference to bz20468.
• bzimport added a subscriber: Unknown Object (MLST).
siebrand created this task.Sep 1 2009, 8:20 PM
Reedy added a comment.Apr 11 2011, 12:57 PM

r85783

Reedy added a comment.Apr 11 2011, 6:29 PM

Reopened r85809

Reedy added a comment.May 2 2011, 8:30 PM

Limited the calls actually doing a damned database update in r87292

MarkAHershberger added a comment.May 3 2011, 1:04 PM

http://svn.wikimedia.org/doc/classUser_a124949b4a526ad6885f7f98816d3862d_icgraph.png

• brion added a comment.Jun 7 2011, 8:59 PM

r85783 is marked as a FIXME for the unclear parameter and question as to whether this actually takes effect.

• brion added a comment.Jun 7 2011, 8:59 PM

Rather... r87292 is marked fixme. :P

MarkAHershberger added a comment.Jun 15 2011, 7:40 PM

(In reply to comment #6)

Rather... r87292 is marked fixme. :P

reverted now.

MarkAHershberger added a comment.Dec 20 2011, 9:08 PM

Changing default assignee per IRC

Nikerabbit added a comment.Nov 6 2012, 10:13 AM

Just got this:

A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: UPDATE user SET user_touched = '20121106100930' WHERE user_id = '205569' AND (user_touched < '20121106100930')
Function: User::invalidateCache
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.0.6.47)

aaron added a comment.Nov 26 2013, 6:15 PM

I don't see much of this in the logs. Assuming commit d3281c2 fixes this.

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