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
