Hello, I have one "[1] un-cached physmessages" that "dbmail-util -ya" is not fixing. How can I find out which message that is and then how do I delete it manually?
Below is the shell output. -- Demi # dbmail-util -a Opening connection to database... Opening connection to authentication... Ok. Connected. Checking DBMAIL messageblocks integrity... Ok. Found [0] unconnected messageblks. Checking DBMAIL message integrity... Ok. Found [0] unconnected messages. Checking DBMAIL mailbox integrity... Ok. Found [0] unconnected mailboxes. Checking DBMAIL for NULL messages... Ok. Found [0] NULL messages. Checking DBMAIL for NULL physmessages... Ok. Found [0] physmessages without messageblocks. Counting messages with DELETE status... Ok. [0] messages have DELETE status. Checking DBMAIL for incorrect is_header flags... Ok. Found [0] incorrect is_header flags. Checking DBMAIL for rfcsize field... Ok. Found [0] missing rfcsize values. Checking DBMAIL for cached header values... Ok. Found [1] un-cached physmessages. Counting deleted messages that need the DELETE status set... Vacuum and optimize not performed. Maintenance done. Errors were found but not fixed. Try running dbmail-util with the '-y' option to repair the errors. =========================================== With y option =========================================== # dbmail-util -ya Opening connection to database... Opening connection to authentication... Ok. Connected. ... Repairing DBMAIL for cached header values... Ok. Found [1] un-cached physmessages. . Setting DELETE status for deleted messages... Ok. [2483] messages set for deletion. Re-calculating used quota for all users... Ok. Used quota updated for all users. Vacuuming and optimizing database... Ok. Database cleaned up. Maintenance done. Errors were found and fixed. Try running dbmail-util again to confirm that the errors were repaired. =========================================== Testing if it was OK =========================================== # dbmail-util -a Opening connection to database... Opening connection to authentication... Ok. Connected. ... Checking DBMAIL for cached header values... Ok. Found [1] un-cached physmessages. Counting deleted messages that need the DELETE status set... Vacuum and optimize not performed. Maintenance done. Errors were found but not fixed. Try running dbmail-util with the '-y' option to repair the errors.
