I'm getting some empty messages in Thunderbird .5 (MySQL 4), all the
headers are there, but the message body is empty. The trace doesn't look
suspicious to me:
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: IMAPClientHandler():
line read for PID 30427
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: COMMAND: [6 UID fetch
132124 (UID RFC822.SIZE BODY[])]
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[0]: 'fetch'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[1]: '132124'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[2]: '('
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[3]: 'UID'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[4]: 'RFC822.SIZE'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[5]: 'BODY'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[6]: '['
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[7]: ']'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: arg[8]: ')'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: IMAPClientHandler():
Executing command uid...
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: db.c,db_acl_has_right:
checking ACL for user [1] on mailbox [7]
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT mailbox_idnr FROM mailboxes WHERE mailbox_idnr =
'7' AND owner_idnr = '1']
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: next_fetch_item():
args[idx = 2] = UID (returning 3)
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: next_fetch_item():
args[idx = 3] = RFC822.SIZE (returning 4)
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: Fetching msgID 132124
(fetch num 132125)
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT pm.rfcsize FROM physmessage pm, messages msg
WHERE pm.id = msg.physmessage_id AND msg.message_idnr = '132124' AND
msg.status< '2' AND msg.unique_id != '' AND msg.mailbox_idnr = '7']
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT physmessage_id FROM messages WHERE message_idnr
= '132124']
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT messageblk FROM messageblks WHERE physmessage_id
= '125366' ORDER BY messageblk_idnr]
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: db_start_msg():
starting, stopbound: '<null>'
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: mime_readheader():
entering mime loop
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: mime_readheader(): found
double newline; header size: 41 lines
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: db_start_msg(): found
singlepart msg
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]:
dbmsgbuf.c,db_update_msgbuf: update msgbuf_buf updating 131072, 3789,
1701, 1701
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]:
dbmsgbuf.c,db_update_msgbuf: update msgbuf: entire fit
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]:
dbmsgbuf.c,db_update_msgbuf update msgbuf succes NOMORE
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: db_start_msg(): exit
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT physmessage_id FROM messages WHERE message_idnr
= '132124']
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]:
dbmsgbuf.c,db_dump_range: Dumping range: (0,2033) - (0,2033)
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT messageblk FROM messageblks WHERE physmessage_id
= '125366' ORDER BY messageblk_idnr]
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: dbmysql.c,db_query:
executing query [SELECT seen_flag FROM messages WHERE message_idnr =
'132124' AND status< '2' AND unique_id != '' AND mailbox_idnr = '7']
Mar 14 17:57:40 sls-cd7p8 dbmail/imap4d[30427]: IMAPClientHandler():
Finished command uid
If I:
SELECT messageblk FROM messageblks WHERE physmessage_id = '125366' ORDER
BY messageblk_idnr
in the sql shell, it gives me the whole thing, so it is in the
database. I'm swamped with work right now, hopefully in a day or two
I'll be able to steal a little time to debug this further. I did get
this behavior on Outlook 2003 occasionally as well, with rc2 and rc3.
95% of the mail with missing body is dbmail list posts, go figure?
I have also run up against the issue of no time zone support in the
received date. Would that be difficult to patch in?
Blake
