Re: [Dbmail] dbmail 2.0 to 2.1 upgrade gone bad - no message body ine-mails

Thu, 6 Apr 2006 03:51:09 +0200 (CEST) 

Are you running both dbmail 2.0.6 and dbmail SVN HEAD on the same database?
I have seen peculiar problems when jumping back and forth on dbmail versions. 
The issue occurs in dbmail_messageblks.messageblk and correlated fields.
The database can get messed up with the two versions running alternately and actually accepting and delivering mail. A dump and recover might be in order. I suggest you use two databases as I have done for running tests on the two versions (2.0 and =>2.1.X) 

did you run dbmail-util -by
best...
Mike
----- Original Message ----- From: "Colin Manning" <[EMAIL PROTECTED]> 
To: "DBMail mailinglist" <[email protected]>
Sent: Wednesday, April 05, 2006 5:52 PM
Subject: Re: [Dbmail] dbmail 2.0 to 2.1 upgrade gone bad - no message body ine-mails 


How about this entry:
Apr 6 05:40:19 mail dbmail/imap4d[14577]: COMMAND: [267 UID fetch 42269 (UID RFC822.SIZE BODY[])] 
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[0]: 'fetch'
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[1]: '42269'
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[2]: '('
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[3]: 'UID'
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[4]: 'RFC822.SIZE'
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[5]: 'BODY'
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[6]: '['
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[7]: ']'
Apr  6 05:40:19 mail dbmail/imap4d[14577]: arg[8]: ')'
Apr 6 05:40:19 mail dbmail/imap4d[14577]: imap4.c,IMAPClientHandler: Executing command uid... Apr 6 05:40:19 mail dbmail/imap4d[14577]: db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [2] Apr 6 05:40:19 mail dbmail/imap4d[14577]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], is that also [2]? Apr 6 05:40:19 mail dbmail/imap4d[14577]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], giving all rights Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [RFC822.SIZE] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = RFC822.SIZE (returning 4) Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [BODY] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token [)] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[7] = [)] Apr 6 05:40:19 mail dbmail/imap4d[14577]: imapcommands.c,_ic_fetch: fetch_start [42269] fetch_end [42269] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbpgsql.c,db_query: executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '42269' AND '42269' AND mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC] 
Apr  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [* 1217 FETCH (]
Apr  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [RFC822.SIZE 2523]
Apr  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [ ]
Apr  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [UID 42269]
Apr  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [ ]
Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,_imap_cache_update: cache message [42269] filter [1] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbpgsql.c,db_query: executing query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42269'] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbpgsql.c,db_query: executing query [SELECT messageblk FROM dbmail_messageblks WHERE physmessage_id = '29112' ORDER BY messageblk_idnr] Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-message.c,_set_content_from_stream: parse message Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbmail-imapsession.c,_imap_cache_update: cache size [2702] 
 ]r  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [BODY[] {2702}
Apr 6 05:40:19 mail dbmail/imap4d[14577]: dbpgsql.c,db_query: executing query [SELECT seen_flag FROM dbmail_messages WHERE message_idnr = '42269' AND status < '2' AND mailbox_idnr = '2'] 
 ]r  6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [)
]r 6 05:40:19 mail dbmail/imap4d[14577]: RESPONSE: [267 OK UID FETCH completedApr 6 05:40:19 mail dbmail/imap4d[14577]: imap4.c,IMAPClientHandler: Finished command uid [0] 


compared with
Apr 6 05:47:52 mail dbmail/imap4d[14659]: COMMAND: [14 UID fetch 42264 (BODYSTRUCTURE)] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[0]: 'fetch'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[1]: '42264'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[2]: '('
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[3]: 'BODYSTRUCTURE'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[4]: ')'
Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Executing command uid... Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [2] Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], is that also [2]? Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], giving all rights Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [BODYSTRUCTURE] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = BODYSTRUCTURE (returning 3) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [)] Apr 6 05:47:52 mail dbmail/imap4d[14659]: imapcommands.c,_ic_fetch: fetch_start [42264] fetch_end [42264] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '42264' AND '42264' AND mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [* 1212 FETCH (]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [UID 42264]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache message [42264] filter [1] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42264'] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT messageblk FROM dbmail_messageblks WHERE physmessage_id = '29113' ORDER BY messageblk_idnr] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-message.c,_set_content_from_stream: parse message Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache size [8320] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dm_imaputil.c,imap_get_structure: message type: [text/plain] Apr 6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [BODYSTRUCTURE ("text" "plain" NIL NIL NIL NIL 0 0 NIL NIL NIL NIL)] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [)
]r 6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [14 OK UID FETCH completed Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Finished command uid [0] Apr 6 05:47:52 mail dbmail/imap4d[14659]: COMMAND: [15 UID fetch 42264 (UID RFC822.SIZE BODY[]<0.12288>)] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[0]: 'fetch'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[1]: '42264'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[2]: '('
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[3]: 'UID'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[4]: 'RFC822.SIZE'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[5]: 'BODY'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[6]: '['
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[7]: ']'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[8]: '<0.12288>'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[9]: ')'
Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Executing command uid... Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [2] Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], is that also [2]? Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], giving all rights Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [RFC822.SIZE] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = RFC822.SIZE (returning 4) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [BODY] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token [<0.12288>] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[8] = [)] Apr 6 05:47:52 mail dbmail/imap4d[14659]: imapcommands.c,_ic_fetch: fetch_start [42264] fetch_end [42264] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '42264' AND '42264' AND mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [* 1212 FETCH (]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [RFC822.SIZE 34565]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [UID 42264]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache message [42264] filter [1] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache size [8320] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [BODY[]<0> {8320}
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag FROM dbmail_messages WHERE message_idnr = '42264' AND status < '2' AND mailbox_idnr = '2'] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [)
]r 6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [15 OK UID FETCH completed Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Finished command uid [0] Apr 6 05:47:52 mail dbmail/imap4d[14659]: COMMAND: [16 UID fetch 42264 (UID RFC822.SIZE BODY[]<12288.12288>)] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[0]: 'fetch'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[1]: '42264'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[2]: '('
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[3]: 'UID'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[4]: 'RFC822.SIZE'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[5]: 'BODY'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[6]: '['
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[7]: ']'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[8]: '<12288.12288>'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[9]: ')'
Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Executing command uid... Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [2] Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], is that also [2]? Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], giving all rights Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [RFC822.SIZE] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = RFC822.SIZE (returning 4) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [BODY] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token [<12288.12288>] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[8] = [)] Apr 6 05:47:52 mail dbmail/imap4d[14659]: imapcommands.c,_ic_fetch: fetch_start [42264] fetch_end [42264] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '42264' AND '42264' AND mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [* 1212 FETCH (]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [RFC822.SIZE 34565]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [UID 42264]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache message [42264] filter [1] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache size [8320] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [BODY[]<12288> {12288}
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag FROM dbmail_messages WHERE message_idnr = '42264' AND status < '2' AND mailbox_idnr = '2'] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [)
]r 6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [16 OK UID FETCH completed Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Finished command uid [0] Apr 6 05:47:52 mail dbmail/imap4d[14659]: COMMAND: [17 UID fetch 42264 (UID RFC822.SIZE BODY[]<24576.9989>)] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[0]: 'fetch'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[1]: '42264'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[2]: '('
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[3]: 'UID'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[4]: 'RFC822.SIZE'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[5]: 'BODY'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[6]: '['
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[7]: ']'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[8]: '<24576.9989>'
Apr  6 05:47:52 mail dbmail/imap4d[14659]: arg[9]: ')'
Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Executing command uid... Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [2] Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], is that also [2]? Apr 6 05:47:52 mail dbmail/imap4d[14659]: db.c, db_acl_has_right: mailbox [2] is owned by user [2], giving all rights Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [RFC822.SIZE] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = RFC822.SIZE (returning 4) Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [BODY] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token [<24576.9989>] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[8] = [)] Apr 6 05:47:52 mail dbmail/imap4d[14659]: imapcommands.c,_ic_fetch: fetch_start [42264] fetch_end [42264] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '42264' AND '42264' AND mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC] 
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [* 1212 FETCH (]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [RFC822.SIZE 34565]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [UID 42264]
Apr  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [ ]
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache message [42264] filter [1] Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbmail-imapsession.c,_imap_cache_update: cache size [8320] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [BODY[]<24576> {9989}
Apr 6 05:47:52 mail dbmail/imap4d[14659]: dbpgsql.c,db_query: executing query [SELECT seen_flag FROM dbmail_messages WHERE message_idnr = '42264' AND status < '2' AND mailbox_idnr = '2'] 
 ]r  6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [)
]r 6 05:47:52 mail dbmail/imap4d[14659]: RESPONSE: [17 OK UID FETCH completed Apr 6 05:47:52 mail dbmail/imap4d[14659]: imap4.c,IMAPClientHandler: Finished command uid [0] 


These are both run with the SVN version.
The first entry returns a blank message, the second one returns a garbled message (binary) - e.g. 

\ ^P  ¨.½0P  ~'g p;¼p;¼XË¿°ü[

Any further thoughts?


---------------------------------
On Yahoo!7
 Messenger: Make free PC-to-PC calls to your friends overseas.


--------------------------------------------------------------------------------



_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to