A NOTE has been added to this issue. ====================================================================== http://dbmail.org/mantis/view.php?id=997 ====================================================================== Reported By: wbclay Assigned To: ====================================================================== Project: DBMail Issue ID: 997 Category: LMTP daemon Reproducibility: always Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 02-Jan-13 22:23 CET Last Modified: 13-Feb-13 14:43 CET ====================================================================== Summary: LMTPD fails attempting to store incoming mail Description: dbmail-lmtpd aborts at each LMTPD delivery attempt w/ the following error sequence:
dbmail-lmtpd[29151]: [0x18fef20] Debug:[message] insert_physmessage(+1250): new physmessage_id [4399201] dbmail-lmtpd[29151]: [0x18fef20] Error:[db] db_query(+351): SQLException: ERROR: insert or update on table "dbmail_messages" violates foreign key constraint "dbmail_messages_physmessage_id_fkey" DETAIL: Key (physmessage_id)=(4399201) is not present in table "dbmail_physmessage". dbmail-lmtpd[29151]: [0x18fef20] Error:[db] db_query(+352): failed query [INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id, unique_id,recent_flag, status) VALUES (2, 4399201, '694f8b4c2fd927187b38aa59d2b6f712', 1, 5) RETURNING message_idnr] dbmail-lmtpd: dm_db.c:483: db_insert_result: Assertion `r' failed. ====================================================================== ---------------------------------------------------------------------- (0003511) wbclay (reporter) - 02-Jan-13 22:57 http://dbmail.org/mantis/view.php?id=997#c3511 ---------------------------------------------------------------------- libzdb version = 2.11.1 ---------------------------------------------------------------------- (0003516) adamhull (reporter) - 13-Feb-13 14:43 http://dbmail.org/mantis/view.php?id=997#c3516 ---------------------------------------------------------------------- I have seen this error crash both dbmail-lmtpd and dbmail-imapd. Unfortunately, the following is all I see in my dbmail.err log file: dbmail-lmtpd: dm_db.c:483: db_insert_result: Assertion `r' failed. dbmail-lmtpd: dm_db.c:483: db_insert_result: Assertion `r' failed. dbmail-imapd: dm_db.c:483: db_insert_result: Assertion `r' failed. Issue History Date Modified Username Field Change ====================================================================== 02-Jan-13 22:23 wbclay New Issue 02-Jan-13 22:57 wbclay Note Added: 0003511 13-Feb-13 14:43 adamhull Note Added: 0003516 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev