The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=369 ====================================================================== Reported By: cmayo Assigned To: ====================================================================== Project: DBMail Issue ID: 369 Category: PIPE delivery (dbmail-smtp) Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 20-Jun-06 20:13 CEST Last Modified: 20-Jun-06 20:13 CEST ====================================================================== Summary: Blank emails cause huge rfcsize Description: A problem with my ISP's mail server generated blank emails that dbmail calculates huge rfcsize values for that don't fit in dbmail_physmessage, syslog messages:
Jun 18 19:45:34 dbmail/smtp[25366]: dbpgsql.c, db_query: Error executing query [UPDATE dbmail_physmessage SET messagesize = '265', rfcsize = '13254448676894499075' WHERE id = '156779'] : [ERROR: value "13254448676894499075" is out of range for type bigint ] Jun 18 19:45:34 dbmail/smtp[25366]: db.c,db_physmessage_set_sizes: error setting messagesize and rfcsize for physmessage [156779] Jun 18 19:45:34 dbmail/smtp[25366]: db.c,db_update_message: error updating physmessage [156779]. The database might be inconsistent. Run dbmail-util Example message attached, one of four may not be the exact one that generated this error (I have some of the characters in the email address - this is a spam free account! - let me know if this is a problem) I am running dbmail 2.0.10 on Postgresql 8.1.4. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 20-Jun-06 20:13 cmayo New Issue 20-Jun-06 20:13 cmayo File Added: rfcsize_problem.eml ======================================================================