Frank,
apparently you have a message row with message_idnr=68941 but that same message_idnr doesn't have
corresponding messageblks.
The interesting part in your logfile is:
Oct 11 10:37:37 fg1 dbmail/imap4d[25302]: Fetching msgID 68941 (fetch num 68942)
Oct 11 10:37:37 fg1 dbmail/imap4d[25302]: dbmysql.c,db_query: executing query [SELECT pm.rfcsize FROM
physmessage pm, messages msg WHERE pm.id = msg.physmessage_id AND msg.message_idnr = '68941' AND msg.status<
'2' AND msg.unique_id != '' AND msg.mailbox_idnr = '10']
Oct 11 10:37:37 fg1 dbmail/imap4d[25302]: dbmysql.c,db_query: executing query [SELECT seen_flag,
answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag FROM messages WHERE message_idnr = '68941'
AND status<2 AND unique_id != '' AND mailbox_idnr = '10']
Oct 11 10:37:37 fg1 dbmail/imap4d[25302]: dbmysql.c,db_query: executing query [SELECT messageblk FROM
messageblks blk, messages msg WHERE blk.physmessage_id = msg.physmessage_id AND msg.message_idnr = '68941'
ORDER BY blk.messageblk_idnr ASC]
Oct 11 10:37:37 fg1 dbmail/imap4d[25302]: db.c,db_get_main_header: no message
blocks found for message
message_idnr 68941 is the first idnr retreived for this fetch command, but it trips up dbmail which makes the
whole command fail. Side-note: can we handle this more gracefully.
This is obviously an indication of a corrupted database. As to the cause I can
only speculate.
Message rows without messageblks are afaik however typically the kind of things dbmail-util should cleanup.
Should I say, doesn't in fact however.
dbmail-util will only check upstream (messageblk->message->physmessage->mailbox->user). It doesn't check
whether a message has any blocks, just like it doesn't check for mailboxes without physmessages etc. However,
the relations physmessage->message and message->messageblk are indeed compulsory, and dbmail-util should
therefore check for them.
Any good suggestions for queries that will solve this are most welcome, postgresql *and* mysql-compatibility
required of course. :-)
Aaron, what do you think.
Frank Eickemeyer wrote:
I have attached the log file for one transaction. For
some reason using your command actually gave some
results, but going from a client still doesn't work. I
captured the log of a failed transaction, let's hope
it sheds a little more light on the situation.
Thanks
--- Paul J Stevens <[EMAIL PROTECTED]> wrote:
Without a good debuglog there's nothing we can do.
You could try:
edit dbmail.conf and set TRACE_LEVEL=5 below [IMAP]
restart dbmail-imapd
&> telnet imapserver imap
1 login "username" "password"
2 select INBOX
3 fetch 1 (BODY[])
4 logout
this will try to fully retrieve the first message in
the inbox and generate plenty of debugging messages
in
your syslog.
grep and edit the results until you have a clean
anonimized backtrace and mail the results to the
list.
Frank Eickemeyer wrote:
Hi all,
I'm very puzzled... I have one imap folder (inbox
of
course) in one mailbox which I can not open any
messages. I have had this problem once before
which I
tracked down to a problem where there was no
messageblks with the same physmessage_id as was
referred to in messages. This time I am at a loss
as
to what is wrong. All other folders for that same
user
work fine, and all other users are unaffected.
dbmail-maintenance does not fix the problem. Does
anybody have an idea on how fix this problem?
I am running:
MySQL 4.0.18
Dbmail 2.0
on Gentoo 2004.1
Any help would be appreciated!
Thanks!
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens
mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP:
finger [EMAIL PROTECTED]
The
Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
------------------------------------------------------------------------
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
