Il giorno 15/mag/07, alle ore 16:18, Paul J Stevens ha scritto:
May 15 15:22:58 carota dbmail/imap4d[73505]: Error [Lock wait timeout
exceeded; try restarting transaction] [UPDATE dbmail_messages SET
recent_flag=0,seen_flag=1,deleted_flag=1 WHERE message_idnr =
248160 AND
status < 2 AND mailbox_idnr = 68]
Next time you see this, try running 'mysqladmin processlist' and
see who is
locking the table.
I did, it was another task of dbmail-imapd doing some kind of
concurrent update on dbmail_users (if i remember correctly it was
updating the last login).
It happens quite regulary when I use Mail (Mac Os X's client) and
Imap. The only solution to solve the problem is killing locally Mail
(as it becomes irresponsive because the imap server does not timeout)
and restart dbmail-imapd on the server. If I don't restart imapd any
subsequent imap access gets hung. If restart it everything gets
blazing fast once again.
Can I help debug it somehow?
I suppose you know this: http://bugs.mysql.com/bug.php?id=10641 and
the solution from the MySQL team?
Maybe I should activate autocommit or something?
Thanks :)
I've been using dbmail since 2 years and never used the support
mailing list, now it seems like i'm abusing it :-)
p.s.:
occasionally the problems happens with outlook as well, but mail
seems much more incline to it. It happens when I'm browsing different
folders at the same time, thus mail's opening 4/5/6 concurrent imap
connections with the same user.
Andrea Brancatelli
[EMAIL PROTECTED]
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
