logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Unable to insert error: msg#00192

mail.imap.dbmail

Subject: Unable to insert error

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 [user@xxxxxxxxxxx]
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 <user@xxxxxxxxxxx>; 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 <user@xxxxxxxxxxx>; 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
<user@xxxxxxxxxxx>; 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=<user@xxxxxxxxxxx>,
relay=dbmail, delay=0, s
tatus=sent (example.com)


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
krysalis.sandbo...    web.zope.zwiki/...    gnome.apps.gnum...    xfree86.newbie/...    editors.vim/200...    mozilla.enigmai...    boot-loaders.gr...    network.vnc.ult...    redhat.release....    java.geronimo.u...    os.netbsd.devel...    horde.wicked/20...    linux.lsb.discu...    ietf.ips/2005-0...    alsa.devel/2002...    user-groups.lin...    package-managem...    debian.devel.da...    security.cyrus....    video.gstreamer...   
Home | blog view | USPTO Patent Archive | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation