The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=384 ====================================================================== Reported By: mavetju Assigned To: ====================================================================== Project: DBMail Issue ID: 384 Category: general delivery Reproducibility: random Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 26-Jul-06 03:52 CEST Last Modified: 26-Jul-06 03:52 CEST ====================================================================== Summary: database failure leads to message rejection Description: Sometimes, four, five times per day, we get a deadlock in postgresql:
Error executing query [UPDATE dbmail_users SET curmail_size = curmail_size + '2930503' WHERE user_idnr = '39361'] : [ERROR: deadlock detected DETAIL: Process 53401 waits for RowExclusiveLock on relation 19270441 of database 8435668; blocked by process 53654. Process 53654 waits for ExclusiveLock on relation 19588978 of database 8435668; blocked by process 53401. As a result, a lot of other things fail behind it (See additional information). But the worst is... dbmail-smtp returns EX_NOUSER, and the email is bounced. In my belief, this should be a temporary failure and be retried later. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 26-Jul-06 03:52 mavetju New Issue ======================================================================
