The following issue has been RESOLVED. ====================================================================== 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: resolved target: Resolution: no change required Fixed in Version: ====================================================================== Date Submitted: 02-Jan-13 22:23 CET Last Modified: 14-Feb-13 14:39 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. ---------------------------------------------------------------------- (0003517) paul (administrator) - 14-Feb-13 14:39 http://dbmail.org/mantis/view.php?id=997#c3517 ---------------------------------------------------------------------- Either you have activated the 'default_with_oids' option or you have explicitly created the dbmail tables 'WITH OIDS'. Neither of them is standard, and they should not be used for dbmail. 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 14-Feb-13 14:39 paul Note Added: 0003517 14-Feb-13 14:39 paul Status new => resolved 14-Feb-13 14:39 paul Resolution open => no change required ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
