Matthew,
Could you please include the actual imap COMMAND in the trace? That way we can
see better what's actually going on here. Looks to me like your database may be
corrupted (messages without messageblks or something similar).
The differences between 2.0.1 and 2.0.4 are very small, but mostly related to
postgres' slowness wrt MAX() and SUM(). I'm not sure however, that is relevant
here. Not without seeing the COMMAND that is....
Matthew T. O'Connor wrote:
I posted something about this when I tried to upgrade to dbmail 2.0.3,
but no one responded. When dbmail 2.0.4 came out I thought I would give
it a shot to see if it fixed the problem, but alas it did not. So here
is a little more detail:
I have a working dbmail w/ postgresql install cirrca 2.0.1. When I
tried to update to dbmail 2.0.3 (and now 2.0.4) I could no longer
retrive messages via IMAP. From the older working dbmail I get a log
like this:
Mar 21 23:32:41 bait dbmail/imap4d[21158]: Fetching msgID 819563 (fetch
num 819564)
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbpgsql.c,db_query: executing
query [SELECT pm.rfcsize FROM dbmail_physmessage pm, dbmail_messages msg
WHERE pm.id
= msg.physmessage_id AND msg.message_idnr = '819563' AND msg.status< '2'
AND msg.unique_id != '' AND msg.mailbox_idnr = '11']
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbpgsql.c,db_query: executing
query [SELECT block.messageblk FROM dbmail_messageblks block,
dbmail_messages msg WHE
RE block.physmessage_id = msg.physmessage_id AND msg.message_idnr =
'819563' ORDER BY block.messageblk_idnr]
Mar 21 23:32:41 bait dbmail/imap4d[21158]: db_start_msg(): starting,
stopbound: '<null>'
Mar 21 23:32:41 bait dbmail/imap4d[21158]: mime_readheader(): entering
mime loop
Mar 21 23:32:41 bait dbmail/imap4d[21158]: mime_readheader(): found
double newline; header size: 23 lines
Mar 21 23:32:41 bait dbmail/imap4d[21158]: db_start_msg(): found
singlepart msg
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbmsgbuf.c,db_update_msgbuf:
update msgbuf_buf updating 131072, 1625, 487, 487
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbmsgbuf.c,db_update_msgbuf:
update msgbuf: entire fit
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbmsgbuf.c,db_update_msgbuf
update msgbuf succes NOMORE
Mar 21 23:32:41 bait dbmail/imap4d[21158]: db_start_msg(): exit
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbmsgbuf.c,db_dump_range:
Dumping range: (1,0) - (1,486)
Mar 21 23:32:41 bait dbmail/imap4d[21158]: dbpgsql.c,db_query: executing
query [SELECT block.messageblk FROM dbmail_messageblks block,
dbmail_messages msg WHE
RE block.physmessage_id = msg.physmessage_id AND msg.message_idnr =
'819563' ORDER BY block.messageblk_idnr]
From the new dbmail 2.0.4 I get a log like this:
Mar 21 23:20:26 bait dbmail/imap4d[20768]: Fetching msgID 54320 (fetch
num 54321)
Mar 21 23:20:26 bait dbmail/imap4d[20768]: dbpgsql.c,db_query: executing
query [SELECT messageblk FROM dbmail_messageblks blk, dbmail_messages
msg WHERE blk.p
hysmessage_id = msg.physmessage_id AND msg.message_idnr = '54320' ORDER
BY blk.messageblk_idnr ASC LIMIT 1]
Mar 21 23:20:26 bait dbmail/imap4d[20768]: mime_readheader(): entering
mime loop
Mar 21 23:20:26 bait dbmail/imap4d[20768]: mime_readheader(): mimeloop
finished
Mar 21 23:20:26 bait dbmail/imap4d[20768]: mime_readheader(): no valid
mime headers found
Mar 21 23:20:26 bait dbmail/imap4d[20768]: db.c,db_get_main_header:
error parsing header of message [54320]
Obviously, the problem appears to be that the new dbmail is not finding
valid headers, where as the old dbmail was.
Any ideas?
Thanks,
Matthew O'Connor
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl