imapcommands.c (line 4676)
db_get_main_header returns a -3 if unable to parse the header, but this return
value is never caught.
try the patch attached.
Matthew T. O'Connor wrote:
Ok, thanks for the help. I found 5 messageblks where ltrim(messageblk)
= '' They were all in my INBOX and now that I have deleted them I can
open things working.
Now, why would / should this cause my INBOX not to open. I would think
this should be fixed. Any idea where I should look to find out what is
happening?
Thanks again,
Matthew
Paul J Stevens wrote:
Perhaps you need to delete all those empty messageblks:
delete from dbmail_messageblks where ltrim(messageblk) = '';
Matthew T. O'Connor wrote:
Here is the psql output:
tocr=# SELECT messageblk FROM dbmail_messageblks blk, dbmail_messages
msg WHERE blk.physmessage_id = msg.physmessage_id AND
msg.message_idnr = '54165' ORDER BY blk.messageblk_idnr ASC LIMIT 1;
messageblk
------------
(1 row)
Which seems strange, it is reporting that 1 row is being returned,
but that row seems to be just blank space. So it seems I may have a
few corrupted messages in the database. However this shouldn't stop
dbmail from allowing me to view any message, or even prevent me from
opening a folder.
FYI I manually looked up a few messages and they worked, for example:
tocr=# SELECT message_idnr, mailbox_idnr, physmessage_id from
dbmail_messages where mailbox_idnr = '11' order by random() limit 10;
message_idnr | mailbox_idnr | physmessage_id
--------------+--------------+----------------
816571 | 11 | 693926
801681 | 11 | 680875
791364 | 11 | 672365
752418 | 11 | 639407
814334 | 11 | 692100
690570 | 11 | 590216
345296 | 11 | 300238
754062 | 11 | 640846
732927 | 11 | 623837
798619 | 11 | 678337
(10 rows)
tocr=# SELECT messageblk FROM dbmail_messageblks blk, dbmail_messages
msg WHERE blk.physmessage_id = msg.physmessage_id AND
msg.message_idnr = '248347' ORDER BY blk.messageblk_idnr ASC LIMIT 1;
messageblk
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
From [EMAIL PROTECTED] Fri Oct 22 09:14:06 2004
Return-Path: <[EMAIL PROTECTED]>
X-Original-To: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
Received: by bait.tocr.com (Postfix, from userid 99)
id B9D696D41E7; Fri, 22 Oct 2004 09:14:06 -0400 (EDT)
Received: from bruiser.bcentralhost.com (bruiser.bcentralhost.com
[205.158.154.152])
by bait.tocr.com (Postfix) with ESMTP id 1032B6D41E2
for <[EMAIL PROTECTED]>; Fri, 22 Oct 2004 09:14:06 -0400 (EDT)
Received: from workstation1 (cpe-069-133-011-151.cinci.rr.com
[69.133.11.151])
by bruiser.bcentralhost.com
id KAA03071; Fri, 22 Oct 2004 10:14:15 -0400 (EDT)
[ConcentricHost SMTP Relay 1.14]
Errors-To: <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
From: "Classic Software, Inc." <[EMAIL PROTECTED]>
To: "Matthew T. O'Connor" <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject: Re: Data Conversion Question
Date: Fri, 22 Oct 2004 10:17:27 -0400
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Checker-Version: SpamAssassin 2.64 (2004-01-11) on bait.tocr.com
X-Spam-Level:
X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=no
version=2.64
(1 row)
This workd for all 10 in the random sample I grabbed. Now the
messages that are in the log appear to be very old based on a
message_idnr < 100000.
Any of this help yet?
Thanks for the help.
Matthew
Paul J Stevens wrote:
Matthew,
Picking a critical query:
SELECT messageblk FROM dbmail_messageblks blk, dbmail_messages msg
WHERE blk.physmessage_id = msg.physmessage_id AND msg.message_idnr =
'54165' ORDER BY blk.messageblk_idnr ASC LIMIT 1
Is this query a problem?? If not, does it retrieve the header
messageblk??
I don't have a filled pg database right now. It's loading, but it'll
take a little while...
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
Index: imapcommands.c
===================================================================
--- imapcommands.c (revision 1701)
+++ imapcommands.c (working copy)
@@ -2793,6 +2793,11 @@
return -1;
}
+ if (result == -3) {
+ curr = curr->nextnode;
+ continue;
+ }
+
} else {
/* parse message structure */
if (cached_msg.msg_parsed)