> orphaned messageblks is exactly the sort of stuff dbmail-util is supposed to
> look for.
>
> if dbmail-util -r doesn't clean out those blks, we have a bug.

I pointed this out on dbmail-dev a little while ago as I had the same
problem.  dbmail-util doesn't yet fix these.

select count(*) from dbmail_physmessage WHERE id NOT IN (SELECT
physmessage_id FROM dbmail_messages);

Replace select with delete to actually delete the stragglers.  This is
only for postgres (no idea if mysql supports this).

> > Weren't there going to be a cleanup tool to get rid of old messages no
> > longer linked from any mailbox?
> >
> > I did some housekeeping, and still have 300.000+ messageblks, tho only
> > 350 messages.

-----
"It's a damn poor mind that can only think of one way
to spell a word." -- Andrew Jackson
[EMAIL PROTECTED]

Reply via email to