> My postfix queue has been filling up. Looks like there is a character
> problem on inserts? I am running Dbmail 2.0.10, postfix-2.2.8-1.2 and
> postgresql-8.1.3-1. Is this a bug, or is something not setup
> correctly
> on my end?
>
> dbmail/lmtpd[13829]: dbpgsql.c, db_query: Error executing query
> [INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
> physmessage_id) VALUES ('0','Send Dbmail mailing list submissions to
Has anyone else seen this before? I'm having (I think) the same
problem, running Dbmail 2.0.10, postfix 2.2.4, postgresql 8.1.2.
The problem only occurs with occasional messages (about 1 out of every
30 or so every day), but in my case, the messages are inevitably spam --
I would like to clear this up, in case a legit message has the same
problem.
I wasn't able to find anything concrete on the mailing lists, except for
possible problems with character encoding in the database, but that gave
multiple query execution errors, not the single one observed here.
Apr 30 17:44:33 localhost dbmail/lmtpd[14108]:
serverchild.c,PerformChildTask: incoming connection from [127.0.0.1
(localhost.localdomain)]
Apr 30 17:44:33 localhost dbmail/lmtpd[14108]: dbpgsql.c, db_query:
Error executing query [INSERT INTO dbmail_messageblks (is_header,
messageblk, blocksize, physmessage_id) VALUES ('0','This is a multi-part
message in MIME format. ------5578316314262291495 Content-Type:
text/plain; ^Icharset="us-ascii" Content-Transfer-Encoding: 7bit Hello,
nearly forty years before who had unsuccessfully tried to the civilian
sector, feeling\227according ,service to qualities of candor and as
because of other difficulties .of Jomini and Clausewitz. Even so, in
described as the Washington, who had considered himself a ,to achieve a
full ,comparisons have not been ,Virginia post in 1758 .attitude of mind
Marshall was gap of seventeen years . asked questions and they were
good ,stage that was the War of relax''d and tardy in their duty; but it
would be a mere . for many thousands . Have a good day.
------5578316314262291495 Content-Type: text/html; ^Icharset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Apr 30 17:44:33 localhost dbmail/lmtpd[14108]:
db.c,db_insert_message_block_physmessage: dbquery failed
Apr 30 17:44:33 localhost dbmail/lmtpd[14108]:
db.c,db_insert_message_block: error inserting messageblks for
physmessage [11360]
Apr 30 17:44:33 localhost dbmail/lmtpd[14108]:
pipe.c,store_message_in_blocks: db_insert_message_block() failed
Apr 30 17:44:33 localhost dbmail/lmtpd[14108]: store_message_temp():
db_insert_message_block failed
