Last modified: 2013-11-26 18:15:52 UTC
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): * http://fr.wikipedia.org/wiki/The_Beatles * http://fr.wikipedia.org/wiki/Marilyn_Monroe * http://fr.wikipedia.org/wiki/%C3%89mile_Zola * http://fr.wikipedia.org/wiki/Paris
r85783
Reopened r85809
Limited the calls actually doing a damned database update in r87292
http://svn.wikimedia.org/doc/classUser_a124949b4a526ad6885f7f98816d3862d_icgraph.png
r85783 is marked as a FIXME for the unclear parameter and question as to whether this actually takes effect.
Rather... r87292 is marked fixme. :P
(In reply to comment #6) > Rather... r87292 is marked fixme. :P reverted now.
Changing default assignee per IRC
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)
I don't see much of this in the logs. Assuming commit d3281c2 fixes this.
