A NOTE has been added to this issue. ====================================================================== 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: 26-Feb-07 09:48 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; ====================================================================== ---------------------------------------------------------------------- paul - 12-Feb-07 12:31 ---------------------------------------------------------------------- The message you've attached is not complete. There are no headers there at all. There have been some fixes since 2.2.2 that would possibly address this issue. Please test dbmail_2_2_branch and include a full trace of a message insertion that breaks if you can. ---------------------------------------------------------------------- ddeineka - 12-Feb-07 12:44 ---------------------------------------------------------------------- Oops, sorry, my mistake. See attachment. Full logs from imapd that stores this message follows (filtered by pid) also attached (see log.txt) ---------------------------------------------------------------------- ddeineka - 12-Feb-07 13:28 ---------------------------------------------------------------------- Also, now installed dbmail_2_2_branch from friday. Problem still exist. ---------------------------------------------------------------------- paul - 26-Feb-07 09:48 ---------------------------------------------------------------------- Please try setting the encoding in dbmail.conf [DBMAIL] ... encoding = utf8 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 12-Feb-07 12:31 paul Note Added: 0001826 12-Feb-07 12:43 ddeineka Note Added: 0001827 12-Feb-07 12:43 ddeineka File Added: problem-msg-fixed.txt 12-Feb-07 12:44 ddeineka File Added: log.txt 12-Feb-07 12:44 ddeineka Note Edited: 0001827 12-Feb-07 13:28 ddeineka Note Added: 0001828 26-Feb-07 09:48 paul Note Added: 0001840 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
