The following issue has been ACKNOWLEDGED. ====================================================================== http://dbmail.org/mantis/view.php?id=751 ====================================================================== Reported By: maximP Assigned To: paul ====================================================================== Project: DBMail Issue ID: 751 Category: Database layer Reproducibility: always Severity: crash Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 12-Jan-09 09:30 CET Last Modified: 03-Feb-09 09:24 CET ====================================================================== Summary: SQLException during POP3 session Description: After deleting messages during the POP3 session dbmail tries to calculate mailbox size by executing "select sum(...)". It gets one record with NULL value and tries to convert it to int in db_result_get_u64() function. The result is the following log message:
Error:[db] dm_quota_rebuild_user(+908): SQLException: (Tested with PostgreSQL 8.3) I suggest to replace sum(...) with coalesce(sum(...), 0) The patch is attached. ====================================================================== ---------------------------------------------------------------------- (0002754) paul (administrator) - 03-Feb-09 09:24 http://dbmail.org/mantis/view.php?id=751#c2754 ---------------------------------------------------------------------- This smells like a libzdb bug to me. I've seen it myself a couple of times. Will investigate. Issue History Date Modified Username Field Change ====================================================================== 12-Jan-09 09:30 maximP New Issue 12-Jan-09 09:30 maximP File Added: dm_db.c.diff 03-Feb-09 09:24 paul Note Added: 0002754 03-Feb-09 09:24 paul Assigned To => paul 03-Feb-09 09:24 paul Status new => acknowledged ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev