A NOTE has been added to this issue. ====================================================================== 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: 25-Jun-06 01:59 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. ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- related to 0000294 Server doesn't work properly with messa... ====================================================================== ---------------------------------------------------------------------- aaron - 20-Jun-06 21:00 ---------------------------------------------------------------------- I think that this is fixed in dbmail_2_0_branch. Would you mind testing that? ---------------------------------------------------------------------- cmayo - 24-Jun-06 12:37 ---------------------------------------------------------------------- I've tried with dbmail-2.1.6, using dbmail-smtp -m chris < rfcsize_problem.eml. It processes the message, calculates an rfcsize of 359, and then deletes it: Jun 24 11:28:13 dbmail/smtp[18851]: dbmail-message.c,dbmail_message_cache_subjectfield: no subject field value [2] Jun 24 11:28:13 dbmail/smtp[18851]: pipe.c, insert_messages: temporary msgidnr is [2] Jun 24 11:28:13 dbmail/smtp[18851]: dbpgsql.c,db_query: executing query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '2'] Jun 24 11:28:13 dbmail/smtp[18851]: dbpgsql.c,db_query: executing query [DELETE FROM dbmail_messages WHERE message_idnr = '2'] Jun 24 11:28:13 dbmail/smtp[18851]: dbpgsql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = '2'] Jun 24 11:28:13 dbmail/smtp[18851]: dbpgsql.c,db_query: executing query [DELETE FROM dbmail_physmessage WHERE id = '2'] Jun 24 11:28:13 dbmail/smtp[18851]: dbpgsql.c,db_query: executing query [DELETE FROM dbmail_messageblks WHERE physmessage_id = '2'] Jun 24 11:28:13 dbmail/smtp[18851]: pipe.c, insert_messages: temporary message deleted from database. Done. Jun 24 11:28:13 dbmail/smtp[18851]: dbpgsql.c,db_query: executing query [COMMIT] ---------------------------------------------------------------------- aaron - 24-Jun-06 17:32 ---------------------------------------------------------------------- Trunk is not affected by this issue. Please test dbmail_2_0_branch: svn checkout https://svn.ic-s.nl/svn/dbmail/branches/dbmail_2_0_branch/dbmail Thanks! ---------------------------------------------------------------------- cmayo - 24-Jun-06 19:50 ---------------------------------------------------------------------- Tried with dbmail_2_0_branch r2187 and still see the same problem: dbmail/smtp[22405]: dbpgsql.c, db_query: Error executing query [UPDATE dbmail_physmessage SET messagesize = '265', rfcsize = '13254237570661916931' WHERE id = '157319'] : [ERROR: value "13254237570661916931" is out of range for type bigint ] ---------------------------------------------------------------------- aaron - 25-Jun-06 01:59 ---------------------------------------------------------------------- I traced the calls back from the query, and I think I've found where the value was set (or not set, as might have been the issue). Let me know if this patch resolves the issue. 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 20-Jun-06 20:14 cmayo Issue Monitored: cmayo 20-Jun-06 20:59 aaron Relationship added related to 0000294 20-Jun-06 21:00 aaron Note Added: 0001253 24-Jun-06 12:37 cmayo Note Added: 0001279 24-Jun-06 17:32 aaron Note Added: 0001280 24-Jun-06 19:50 cmayo Note Added: 0001281 25-Jun-06 01:58 aaron File Added: empty_body_rfcsize.diff 25-Jun-06 01:59 aaron Note Added: 0001282 ======================================================================