The following issue has been CLOSED ====================================================================== http://www.dbmail.org/mantis/view.php?id=934 ====================================================================== Reported By: petteri Assigned To: ====================================================================== Project: DBMail Issue ID: 934 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: minor Priority: normal Status: closed target: Resolution: no change required Fixed in Version: ====================================================================== Date Submitted: 27-Oct-11 15:11 CEST Last Modified: 27-Oct-11 15:33 CEST ====================================================================== Summary: unconnected physmessages and mimeparts after DELETE Description: When dbmail-util has deleted messages with DELETE status or I have ran 'dbmail-users -e <username>' command, I get several unconnected physmessages and -mimeparts on next run of 'dbmail-util -ay'. It seems that DELETE query executed by dbmail-util or dbmail-users hits only to the dbmail_messages table but leaves other tables unaffected. On the next run of dbmail-util problem is fixed (message remainings from other tables are deleted) but gives ugly impression that there is something wrong.
dbmail-util also prints wrongly the time spent when repairing unconnected physmessages. ====================================================================== ---------------------------------------------------------------------- (0003307) froeske (reporter) - 27-Oct-11 15:16 http://www.dbmail.org/mantis/view.php?id=934#c3307 ---------------------------------------------------------------------- do you use MyISAM Tables for dbmail? ---------------------------------------------------------------------- (0003308) petteri (reporter) - 27-Oct-11 15:26 http://www.dbmail.org/mantis/view.php?id=934#c3308 ---------------------------------------------------------------------- ENGINE=InnoDB mysqld Ver 5.5.16-55-log for Linux on x86_64 (Percona Server (GPL), Release 22.0) ---------------------------------------------------------------------- (0003309) paul (administrator) - 27-Oct-11 15:33 http://www.dbmail.org/mantis/view.php?id=934#c3309 ---------------------------------------------------------------------- I'm closing this report, because it's not-a-bug. An impression that 'something' is wrong, does not constitute a bug. Deletion of messages *does* affect only dbmail_messages. physmessages and mimeparts are not connected to messages. They can be connected to multiple messages, and generally *are*. Unconnected physmessages/mimeparts (not used by any messages) are cleaned up as part of the integrity and cleanup checks. Issue History Date Modified Username Field Change ====================================================================== 27-Oct-11 15:11 petteri New Issue 27-Oct-11 15:12 petteri Issue Monitored: petteri 27-Oct-11 15:16 froeske Note Added: 0003307 27-Oct-11 15:26 petteri Note Added: 0003308 27-Oct-11 15:33 paul Note Added: 0003309 27-Oct-11 15:33 paul Status new => closed 27-Oct-11 15:33 paul Resolution open => no change required ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
