I think I may have found a bug that needs to be fixed. Someone has been
trying to send me an email that was constantly getting bounced by our
mail server. What's going on here (I think) is just a garden variety
encoding conflict. The issue, is that since we converted the
message_body data type to bytea to avoid encoding issues, shouldn't we
also convert all the header cache columns to bytea?
DBMail version Info:
svn info
Path: .
URL: https://svn.ic-s.nl/svn/dbmail/trunk/dbmail
Repository Root: https://svn.ic-s.nl/svn/dbmail
Repository UUID: 7b491191-dbf0-0310-aff6-d879d4d69008
Revision: 2259
Node Kind: directory
Schedule: normal
Last Changed Author: aaron
Last Changed Rev: 2259
Last Changed Date: 2006-09-08 15:48:57 -0400 (Fri, 08 Sep 2006)
PostgreSQL 8.1 on CentOS 4.4
From /var/log/maillog:
Oct 26 16:54:05 stayman postfix/pipe[30325]: C7731116D9C0:
to=<[EMAIL PROTECTED]>, relay=dbmail-smtp, delay=4, status=bounced (user
unknown. Command output: Error dbpgsql.c, db_query: Error executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (8,1429221,'FW: Terrie O''Connor Real Estate Picture
Path account is now active to link virtual tours to REALTOR.com_')] :
[ERROR: invalid byte sequence for encoding "UTF8": 0xae ]
Error dbmail-message.c,_header_cache: insert headervalue failed Error
dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_tofield
(physmessage_id, toname, toaddr) VALUES (1429221,'','matthew@zeut.net')]
: [ERROR: current transaction is aborted, commands ignored until end of
transaction block ] Error dbmail-message.c,insert_address_cache: insert
tofield failed [INSERT INTO dbmail_tofield (physmessage_id, toname,
toaddr) VALUES (1429221,'','matthew@zeut.net')] Error dbpgsql.c,
db_query: Error executing query [INSERT INTO dbmail_ccfield (
The Details of the Bounced message:
<[EMAIL PROTECTED]>: user unknown. Command output: Error dbpgsql.c,
db_query:Error executing query [INSERT INTO dbmail_headervalue
(headername_id, physmessage_id, headervalue) VALUES (8,1429212,'RE:
Terrie O''Connor Real Estate Picture Path account is now active to link
virtual tours to REALTOR.com_')] : [ERROR: invalid byte sequence for
encoding "UTF8": 0xae]
