The following issue has been RESOLVED. ====================================================================== http://dbmail.org/mantis/view.php?id=659 ====================================================================== Reported By: tss Assigned To: paul ====================================================================== Project: DBMail Issue ID: 659 Category: IMAP daemon Reproducibility: always Severity: major Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.3.0 ====================================================================== Date Submitted: 01-Dec-07 18:22 CET Last Modified: 16-Dec-07 15:24 CET ====================================================================== Summary: IMAP state breaks with stress testing Description: I've updated my imaptest tool to track all kinds of state. You can reproduce this easily with it. See http://imapwiki.org/ImapTest
dbmail apparently removes messages from its internal view without notifying IMAP clients of the change, so the clients suddenly see the message change under it. For example: 2.24 FETCH 1:33 (UID FLAGS ENVELOPE INTERNALDATE BODYSTRUCTURE) * 1 FETCH (INTERNALDATE "01-Dec-2007 19:13:27 +0200" FLAGS (\Seen \Answered \Deleted) UID 5246 BODYSTRUCTURE ("text" "plain" ("charset" "us-ascii") NIL NIL "7BIT" 1002 26 NIL ("inline" NIL) NIL NIL) ENVELOPE ("Mon, 19 May 2003 17:22:37 +1000" "Re: [Dovecot] DRAC support?" (("Charlie Allom" NIL "charlie" "rubberduck.com")) (("Charlie Allom" NIL "charlie" "rubberduck.com")) (("Charlie Allom" NIL "charlie" "rubberduck.com")) ((NIL NIL "dovecot" "procontrol.fi")) NIL NIL "<[EMAIL PROTECTED]>" "<[EMAIL PROTECTED]>")) .. 2.24 OK FETCH completed 2.25 FETCH 12 (BODY.PEEK[]) * 12 FETCH (BODY[] {5344} .. ) 2.25 OK FETCH completed 2.26 CHECK * 1 RECENT 2.26 OK CHECK completed 2.27 FETCH 1:33 (UID FLAGS ENVELOPE INTERNALDATE BODYSTRUCTURE) * 1 FETCH (INTERNALDATE "01-Dec-2007 19:13:28 +0200" FLAGS (\Seen) UID 5251 BODYSTRUCTURE ("text" "plain" NIL NIL NIL "7bit" 1516 34 NIL NIL NIL NIL) ENVELOPE ("Mon, 19 May 2003 15:50:56 +0300" "Re: [Dovecot] ssl still not working" (("Timo Sirainen" NIL "tss" "iki.fi")) (("Timo Sirainen" NIL "tss" "iki.fi")) (("Timo Sirainen" NIL "tss" "iki.fi")) (("Dovecot List" NIL "dovecot" "procontrol.fi")) NIL NIL "<[EMAIL PROTECTED]>" "<[EMAIL PROTECTED]>")) As you can see, there are no EXPUNGEs but the two FETCHes report completely different results for the first message. Not related to above, but I get a lot of these as well: dbmail-imapd[32459]: Error:[sql] dbmysql.c,db_query(+294): [Deadlock found when trying to get lock; try restarting transaction] [UPDATE dbmail_messages SET status=2 WHERE mailbox_idnr = 1 AND deleted_flag=1 AND status < 2] ====================================================================== ---------------------------------------------------------------------- paul - 02-Dec-07 11:48 ---------------------------------------------------------------------- Thanks Timo. imaptest is just what I need! My first impression is that the isolation levels need to be considered. There are currently no explicit isolation levels set in the transactions which may very well account for both problems reported. ---------------------------------------------------------------------- paul - 04-Dec-07 16:12 ---------------------------------------------------------------------- Work in progress report: I've done a load of changes testing with postgres. Imaptest doesn't show any breakage any more (clients=100) Hurah. But for mysql it needs some more work... ---------------------------------------------------------------------- paul - 16-Dec-07 15:24 ---------------------------------------------------------------------- fixed in 2.3.0 Issue History Date Modified Username Field Change ====================================================================== 01-Dec-07 18:22 tss New Issue 02-Dec-07 11:48 paul Note Added: 0002438 02-Dec-07 11:48 paul Assigned To => paul 02-Dec-07 11:48 paul Status new => acknowledged 02-Dec-07 11:48 paul Projection none => major rework 02-Dec-07 11:48 paul ETA none => > 1 month 03-Dec-07 17:55 froeske Issue Monitored: froeske 04-Dec-07 16:12 paul Note Added: 0002439 16-Dec-07 15:24 paul Note Added: 0002447 16-Dec-07 15:24 paul Status acknowledged => resolved 16-Dec-07 15:24 paul Resolution open => fixed 16-Dec-07 15:24 paul Fixed in Version => 2.3.0 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev