Simetrical schreef:
On Thu, Jun 26, 2008 at 11:24 AM, Roan Kattouw
<roan.kattouw(a)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)