12-04-2014 15:38, Paul J Stevens написав(ла):
missing rfcsize means
physmessage.rfcsize == 0
missing envelope values means some physmessage rows don't have a
corresponding row in the envelope table.
un-cached physmessages means the same for the header table.
So, from the output of dbmail-util, build a list of all physmessage.id
values involved, and delete them from the database.
Of course, the Error output is bogus. If the messageblks table doesn't
exists, that should *not* be a problem. I can, and will fix that for 3.1
and master, but *not* for 3.0.
Thanks Paul, that solved the issue.
I was only concerned if this side effect could prevent the upgrade to
3.1.13. It didn't, and I was much pleased to see that my headervalue
table shrank from many GB to few MB.
One more cleanup-related question -- what does it mean when physmessage
table contain much more messages than are actually in the mailboxes? And
why some of these messages have 'internal date' way back to year 2005
and 2002 ?
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
