A NOTE has been added to this issue. ====================================================================== http://www.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: 16-Feb-09 16:12 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://www.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. ---------------------------------------------------------------------- (0002786) maximP (reporter) - 16-Feb-09 16:12 http://www.dbmail.org/mantis/view.php?id=751#c2786 ---------------------------------------------------------------------- The problem has gone with libzdb 2.4, thank you, Paul, you can close this bug. 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 16-Feb-09 16:12 maximP Note Added: 0002786 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
