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
