The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=348 ====================================================================== Reported By: eZeus Assigned To: paul ====================================================================== Project: DBMail Issue ID: 348 Category: Database layer Reproducibility: always Severity: minor Priority: none Status: resolved target: Resolution: fixed Fixed in Version: 2.1.8 ====================================================================== Date Submitted: 11-May-06 16:19 CEST Last Modified: 03-Oct-06 13:28 CEST ====================================================================== Summary: When delete subfolder, MS Outlook don't delete messages inside it. Description: I use MS Outlook 2003 When I create a subfolder and put some messages inside (even one), after that I want to delete this subfolder. dbmail_mailboxes table delete subfolder fine and there is no messages in dbmail_message table, but other tables still have all other information about "deleted" messages. I switch the sequence of deleting of mailbox in db.c:db_delete_mailbox function: 1. Delete all messages 2. Delete the mailbox ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- related to 0000305 integrity checks in maintenance.c are i... ======================================================================
---------------------------------------------------------------------- paul - 11-May-06 17:49 ---------------------------------------------------------------------- What 'other tables still have all other information about "deleted" message' ? If you're talking about physmessages/messageblks: it's a feature not a bug. Running dbmail-util -ty should get rid of any physmessages that don't have any corresponding messages. ---------------------------------------------------------------------- eZeus - 11-May-06 18:06 ---------------------------------------------------------------------- Unfortunately it is not. I am talking about dbmail_ccfield, dbmail_datefield, dbmail_fromfield, dbmail_headervalue, dbmail_replytofield, dbmail_subjectfield, dbmail_tofield and those table that you have mentioned. dbmail-util -ty return output: Opening connection to database... Opening connection to authentication... Ok. Connected. Repairing 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. Maintenance done. No errors found. But I can see that there is some messages in dbmail_physmessage after executing. ---------------------------------------------------------------------- paul - 12-May-06 09:32 ---------------------------------------------------------------------- All the header cache tables have foreign key constraints on the physmessage table. My guess is that dbmail-util -ty doesn't detect unconnected physmessages which would make this bug report a dupe of http://www.dbmail.org/mantis/view.php?id=305 ---------------------------------------------------------------------- eZeus - 12-May-06 09:50 ---------------------------------------------------------------------- This is a point, that dbmail_physmessage still contains messages! I this that this problem persist only in MS Outlook poduct, though Outlook deletes folder without previous deletion of mesasges inside it, and imap recieves command to delete (empty?) mailbox. What ever after changes in src code, it works well. ---------------------------------------------------------------------- paul - 03-Oct-06 13:28 ---------------------------------------------------------------------- I've rearranged db_delete_mailbox so we now first delete all messages before removing the mailbox. Issue History Date Modified Username Field Change ====================================================================== 11-May-06 16:19 eZeus New Issue 11-May-06 17:49 paul Note Added: 0001164 11-May-06 17:49 paul Priority normal => none 11-May-06 17:49 paul Status new => feedback 11-May-06 17:49 paul Resolution open => no change required 11-May-06 18:05 eZeus Note Added: 0001165 11-May-06 18:06 eZeus Note Edited: 0001165 12-May-06 09:32 paul Note Added: 0001166 12-May-06 09:32 paul Relationship added related to 0000305 12-May-06 09:33 paul Status feedback => acknowledged 12-May-06 09:33 paul Resolution no change required => duplicate 12-May-06 09:50 eZeus Note Added: 0001169 03-Oct-06 13:28 paul Note Added: 0001439 03-Oct-06 13:28 paul Assigned To => paul 03-Oct-06 13:28 paul Status acknowledged => resolved 03-Oct-06 13:28 paul Resolution duplicate => fixed 03-Oct-06 13:28 paul Fixed in Version => 2.1.8 ======================================================================
