Here's a small snip to an endless loop i saw with the latest cvs checkout...
Oct 26 02:38:01 ded3 dbmail/imap4d[15425]: imap4.c,IMAPClientHandler:
COMMAND [authenticate]
Oct 26 02:38:01 ded3 dbmail/imap4d[15425]: arg[0]: 'login'
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45196 (fetch
num 1)
Oct 26 02:38:01 ded3 dbmail/imap4d[15425]: IMAPClientHandler():
Executing command authenticate...
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45196' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45197 (fetch
num 2)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45197' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45198 (fetch
num 3)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45198' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45199 (fetch
num 4)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45199' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45200 (fetch
num 5)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45200' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45201 (fetch
num 6)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45201' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45202 (fetch
num 7)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45202' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45203 (fetch
num 8)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45203' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45204 (fetch
num 9)
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag FROM dbmail_messages WHERE message_idnr =
'45204' AND status < '2' AND mailbox_idnr = '2']
Oct 26 02:38:01 ded3 dbmail/imap4d[15421]: Fetching msgID 45205 (fetch
num 10)
Dan wrote:
Hey Paul,
One thing I noticed when I grabbed the latest CVS build (well, about
11 hours ago), was that my mailboxes would display zero messages and
it seemed dbmail-imapd would enter into a loop. I don't know if it is
just the fact I am using Thunderbird as my client, or if different
clients have different results. I'll grab a TRACE=5 on IMAP and post
it here in a few after I recompile and test.
-Dan
Paul J Stevens wrote:
Aaron,
all patches were applied to head of course.
That said: I've setup several patches for 2_0 that have been holding
up just fine:
- dynamic preforking.
- dbmysql.c (db_get_result)
- db.c (db_getmailbox)
I can live without the preforking patch in 2_0. It'll be in de debian
packages anyway.
The other two are small and very local but remain to be fully tested.
For mysql they perform great, but I don't know how the db_getmailbox
patch affects postgres performance (if at all).
Aaron Stone wrote:
Paul J Stevens <[EMAIL PROTECTED]> said:
Hi all,
I've applied several of the patches discussed to cvs-head:
strip_unique_id: remove unique_id<>'' from queries
Doesn't this also require db_imap_append to be sanitized?
dbmysql: Mikhail's db_get_result speedup
This looks good for 2.0.1, yes?
db_getmailbox: my own speedup of opening mailboxes.
Is this ripe for 2.0.1?
ic_fetch cleanup: I've split _ic_fetch and a lot of code out of
imapcommands.c to imaputil.c and dbmail-imapsession.c
This is clearly HEAD work.
Aaron
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
