I get the following error from an email generated by the dmail mailing list.
The problem is dbmail was unable to save the data as the function call
store_message_temp{} failed. Why doesn't this failure generate an error to
Postfix?
Postfix thinks the mail was delivered so it didn't keep a copy. Basically,
the mail is lost. I didn't have tracing turned to max, but I have since set
it to 5. So if it happens again, I can email you more details.
Can someone figure out from the maillog below what exactly happened and
whether there's a fix for it? By the way, this is an intermittent problem.
I've received many emails from dbmail mailing list just fine. It only
happens on occassion with no noticeable pattern. I am running dbmail 2.0rc2
with Postgres and Postfix 1.1.12.
Thanks,
David
Feb 24 12:04:53 mybox dbmail/smtp[15811]: insert_messages(): resolving
address [EMAIL PROTECTED]
Feb 24 12:04:53 mybox dbmail/smtp[15811]: dbpgsql.c, db_query: Error
executing query [INSERT INTO mes
sageblks(messageblk,blocksize, physmessage_id) VALUES ('Received: from
localhost (localhost.localdoma
in [127.0.0.1]) ^Iby mybox.domain.tld (Postfix) with ESMTP id 3A2E1CFA9
^Ifor <[EMAIL PROTECTED]>; Tue
, 24 Feb 2004 12:04:53 -0800 (PST) Received: from mybox.domain.tld
([127.0.0.1]) by localhost (mybox
.domain.tld [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13849-02
for <[EMAIL PROTECTED]>; T
ue, 24 Feb 2004 12:04:49 -0800 (PST) Received: from twister.fastxs.net
(unknown [213.214.98.20]) ^Iby
mybox.domain.tld (Postfix) with ESMTP id E9C29CFA5 ^Ifor
<[EMAIL PROTECTED]>; Tue, 24 Feb 2004 12:04:
47 -0800 (PST) Received: from twister.fastxs.net (localhost [127.0.0.1])
^Iby twister.fastxs.net (Pos
tfix) with ESMTP ^Iid B233D7BB01; Tue, 24 Feb 2004 21:04:23 +0100 (CET)
Received: from mail.netmail.c
c (unknown [66.168.53.122]) ^Iby twister.fastxs.net (Postfix) with ESMTP id
112EE7BB01 ^Ifor <d
Feb 24 12:04:53 mybox dbmail/smtp[15811]:
db.c,db_insert_message_block_physmessage: dbquery failed
Feb 24 12:04:53 mybox dbmail/smtp[15811]: db.c,db_insert_message_block:
error inserting messageblks f
or physmessage [8489]
Feb 24 12:04:53 mybox dbmail/smtp[15811]: store_message_temp(): error
inserting msgblock [header]
Feb 24 12:04:53 mybox dbmail/smtp[15811]: insert_messages(): failed to store
temporary message.
Feb 24 12:04:53 mybox postfix/pipe[15810]: 3A2E1CFA9: to=<[EMAIL PROTECTED]>,
relay=dbmail, delay=0, s
tatus=sent (example.com)
