K C wrote:
I tried move a message from one mailbox(non-dbmail) into dbmail box,
and that one result sql error. However, the sql statement was
truncated in /var/log/maillog that I can't investigate the cause(or
potential a bug).
Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
dbmail/imap4d[4177]: dbpgsql.c,db_query: executing query [SELECT
physmessage_id FROM dbmail_messages WHERE message_idnr = '11']
Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
dbmail/imap4d[4177]: dbpgsql.c,db_query: executing query [INSERT INTO
dbmail_messageblks (is_header, messageblk,blocksize, physmessage_id)
VALUES ('0','-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 -
---------------------------------------------------------------------
PostgreSQL New RPM Set 2005-11-08 Version: 8.1.0 Set labels:
8.1.0-2PGDG -
---------------------------------------------------------------------
-
---------------------------------------------------------------------
Release Info: PostgreSQL RPM Building Project has released RPMs for
8.1.0, and they are available in main FTP site and its mirrors. We
currently have RPMs for: - - Fedora Core 3 - - Fedora Core 4 - -
Fedora Core 4-x86_64 - - Red Hat Linux 9 - - Red Hat Enterprise Linux
Enterprise Server 3.0 - - Red Hat Enterprise Linux Enterprise Server
4 - - Red Hat Enterprise Linux Enterprise Server 4-x86_64 - - Red Hat
Enterprise Linux Advanced Server 4 - - Red Hat Enterprise Linux
Advanced Server 4-x86_64 More ma
Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
dbmail/imap4d[4177]: dbpgsql.c, db_query: Error executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize,
physmessage_id) VALUES ('0','-----BEGIN PGP SIGNED MESSAGE----- Hash:
SHA1 -
---------------------------------------------------------------------
PostgreSQL New RPM Set 2005-11-08 Version: 8.1.0 Set labels:
8.1.0-2PGDG -
---------------------------------------------------------------------
-
---------------------------------------------------------------------
Release Info: PostgreSQL RPM Building Project has released RPMs for
8.1.0, and they are available in main FTP site and its mirrors. We
currently have RPMs for: - - Fedora Core 3 - - Fedora Core 4 - -
Fedora Core 4-x86_64 - - Red Hat Linux 9 - - Red Hat Enterprise Linux
Enterprise Server 3.0 - - Red Hat Enterprise Linux Enterprise Server
4 - - Red Hat Enterprise Linux Enterprise Server 4-x86_64 - - Red Hat
Enterprise Linux Advanced Server 4 - - Red Hat Enterprise Linux
Advanced Server 4-x86_64
Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
dbmail/imap4d[4177]: db.c,db_insert_message_block: error inserting
messageblks for physmessage [6]
Nov 9 17:36:46 dhcp-6op7-6op8-6op9-east-130-35-57-132
dbmail/imap4d[4177]: pipe.c,store_message_in_blocks:
db_insert_message_block() failed
Anyway to let maillog retain the full text?
Thanks,
Kevin
------------------------------------------------------------------------
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
enable loggin on postgresql.conf
but it will slow your database
leonel
