Hello, dbmail 2.3.5, postgresql version is 8.3.7 Below is query, which returns invalid sum. As it is executed somewhere with EXPUNGE operation, reported error is "expunge failed" (see log). Any solutions for this?
without sum aggregate, one may encounter there's 0 rows to sum returned, while probably numeric value is expected (?) myserver:/var/log/dbmail# echo 'SELECT sum(pm.messagesize) FROM dbmail_messages msg, dbmail_physmessage pm WHERE msg.physmessage_id = pm.id AND msg.mailbox_idnr = 3 AND msg.status < 2 AND msg.deleted_flag = 1'|psql -U username dbname sum ----- myserver:/var/log/dbmail# echo 'SELECT pm.messagesize FROM dbmail_messages msg, dbmail_physmessage pm WHERE msg.physmessage_id = pm.id AND msg.mailbox_idnr = 3 AND msg.status < 2 AND msg.deleted_flag = 1'|psql -U username dbname messagesize ------------- (0 rows) log quote: May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x80b8d70] Debug:[MailboxState] db_acl_has_right(+524): mailbox [3] is owned by user [1543], giving all righ ts May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x80b8d70] Database:[db] db_con_get(+257): [0x807a528] connection from pool May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x80b8d70] Database:[db] db_query(+340): [0x807a528] [SELECT sum(pm.messagesize) FROM dbmail_messages msg, d bmail_physmessage pm WHERE msg.physmessage_id = pm.id AND msg.mailbox_idnr = 3 AND msg.status < 2 AND msg.deleted_flag = 1] May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x80b8d70] Database:[db] log_query_time(+290): last query took [0.001] seconds May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x80b8d70] Error:[db] db_get_mailbox_size(+1777): SQLException: May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x80b8d70] Database:[db] db_con_close(+275): [0x807a528] connection to pool May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x806d558] Info:[clientbase] ci_write(+172): [0x80cae18] S > [* BYE expunge failed ] May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x806d558] Debug:[imap] imap_handle_exit(+209): [0x80cb2e0] state [3] command_status [1] [EXPUNGE] returned with status [-1] May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x806d558] Debug:[imapsession] dbmail_imap_session_set_state(+1574): state [6] May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x806d558] Debug:[imapsession] dbmail_imap_session_set_state(+1599): [0x80cb2e0] state [3]->[6] May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x806d558] Debug:[imap] imap_session_bailout(+84): [0x80cb2e0] state [6] May 04 13:19:39 MYSERVER.domain.com dbmail-imapd[20859]: [0x806d558] Debug:[imapsession] dbmail_imap_session_delete(+139): [0x80cb2e0] -- View this message in context: http://www.nabble.com/dbmail-2.3.5-expunge-operation-select-sum%28%29-failed-tp23366697p23366697.html Sent from the dbmail dev mailing list archive at Nabble.com. _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman-new.icns.fastxs.net/cgi-bin/mailman/listinfo/dbmail-dev
