The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=506 ====================================================================== Reported By: ddeineka Assigned To: ====================================================================== Project: DBMail Issue ID: 506 Category: Database layer Reproducibility: N/A Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 12-Feb-07 11:36 CET Last Modified: 12-Feb-07 11:36 CET ====================================================================== Summary: Errors in pgsql query while storing messages. Description: Trying to migrate from courier to dbmail. Fresh installation of dbmail (from ports - 2.2.1 or from SVN - 2.2.2 trunk), Postgresql 8..2.2 from ports.
While doing imapsync or contrib/mailbox2dbmail have number of warnings and errors in log. Some messages doesnot storing in dbmail with following: /var/log/messages: Feb 12 11:48:13 mail1 dbmail/imap4d[14693]: Error:[sql] dbpgsql.c,db_query(+289): query failed [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (24,816,'&http://www.dbmail.org/mantis/view.php?id=1084;&http://www.dbmail.org/mantis/view.php?id=1053;&http://www.dbmail.org/mantis/view.php?id=1041;&http://www.dbmail.org/mantis/view.php?id=1053;&http://www.dbmail.org/mantis/view.php?id=1071;&http://www.dbmail.org/mantis/view.php?id=1056;&http://www.dbmail.org/mantis/view.php?id=1061; &http://www.dbmail.org/mantis/view.php?id=1053;&http://www.dbmail.org/mantis/view.php?id=1056; &http://www.dbmail.org/mantis/view.php?id=1049;&http://www.dbmail.org/mantis/view.php?id=1053;&http://www.dbmail.org/mantis/view.php?id=1051;&http://www.dbmail.org/mantis/view.php?id=1054;&http://www.dbmail.org/mantis/view.php?id=1070;&http://www.dbmail.org/mantis/view.php?id=1052;&http://www.dbmail.org/mantis/view.php?id=1061;&http://www.dbmail.org/mantis/view.php?id=1061; &http://www.dbmail.org/mantis/view.php?id=1102;&http://www.dbmail.org/mantis/view.php?id=1071;&http://www.dbmail.org/mantis/view.php?id=1053;&http://www.dbmail.org/mantis/view.php?id=1056;&http://www.dbmail.org/mantis/view.php?id=1045;&http://www.dbmail.org/mantis/view.php?id=1050; ')] : [ERROR: invalid byte sequence for encoding "UTF8": 0xcdee HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". ] Feb 12 11:48:13 mail1 dbmail/imap4d[14693]: Error:[message] dbmail-message.c,_header_cache(+992): insert headervalue failed Feb 12 11:48:13 mail1 postgres[14694]: [134-1] ERROR: current transaction is aborted, commands ignored until end of transacti on block Feb 12 11:48:13 mail1 postgres[14694]: [134-2] STATEMENT: INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (816,'','[EMAIL PROTECTED]') Feb 12 11:48:13 mail1 postgres[14694]: [135-1] ERROR: current transaction is aborted, commands ignored until end of transacti on block Feb 12 11:48:13 mail1 dbmail/imap4d[14693]: Error:[sql] dbpgsql.c,db_query(+289): query failed [INSERT INTO dbmail_tofield (ph ysmessage_id, toname, toaddr) VALUES (816,'','[EMAIL PROTECTED]')] : [ERROR: current transaction is aborted, commands ign ored until end of transaction block ] Feb 12 11:48:13 mail1 postgres[14694]: [135-2] STATEMENT: INSERT INTO dbmail_fromfield (physmessage_id, fromname, fromaddr) V ALUES (816,'&http://www.dbmail.org/mantis/view.php?id=1087;M-^Z&http://www.dbmail.org/mantis/view.php?id=1087;&http://www.dbmail.org/mantis/view.php?id=9580;&http://www.dbmail.org/mantis/view.php?id=1087;&http://www.dbmail.org/mantis/view.php?id=9578;&http://www.dbmail.org/mantis/view.php?id=1087; ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 12-Feb-07 11:36 ddeineka New Issue 12-Feb-07 11:36 ddeineka File Added: problem-msg.txt ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
