Simetrical schreef:
On Thu, Jun 26, 2008 at 11:24 AM, Roan Kattouw roan.kattouw@home.nl wrote:
The error seems pretty straightforward to me: the software is trying to get a lock on the user table and has to wait too long for that. Unless this is some kind of new structural problem at Wikimedia, you just have to retry your request and hope for the best.
However, this message can be symptomatic of some other problem if it occurs too frequently. It could indicate that something is slowing down queries such that they take too long (and hold locks too long). It could also mean that the API is running queries that are unnecessarily prone to locking. Or maybe misusing transactions somehow or something, I don't know.
Wait a minute, though, is the API running an update on the user table every time someone logs in? If so, why?
I'm 100% sure the API does no write queries to the user table, as there were no write queries in the API until I started writing them. This must be something in the initialization process that maybe updates the timestamp of last login/activity or something else. It could also be an extension.
Especially UPDATE user SET user_name . . . why should anything other than Special:RenameUser be touching user_name *ever*?
I'm pretty sure it's not meant to change user_name, it seems to be just a poorly-written query.
Roan Kattouw (Catrope)