A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1008 ====================================================================== Reported By: rmoesbergen Assigned To: ====================================================================== Project: DBMail Issue ID: 1008 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 31-May-13 10:17 CEST Last Modified: 28-Aug-13 16:13 CEST ====================================================================== Summary: dbmail-util -ay does not clean headervalue table Description: It seems dbmail-util does not clean the headervalue table. My database is empty (it contains no messages for any user), but the headervalue table still contains http://www.dbmail.org/mantis/view.php?id=33#c70.000 rows. Running dbmail-util -ay does not clean this table. ======================================================================
---------------------------------------------------------------------- (0003523) rmoesbergen (reporter) - 04-Jun-13 10:53 http://www.dbmail.org/mantis/view.php?id=1008#c3523 ---------------------------------------------------------------------- This query cleans things up manually: delete from dbmail_headervalue where not exists (select headervalue_id from dbmail_header where headervalue_id = dbmail_headervalue.id); ---------------------------------------------------------------------- (0003567) santa (reporter) - 28-Aug-13 16:13 http://www.dbmail.org/mantis/view.php?id=1008#c3567 ---------------------------------------------------------------------- I can confirm that. Both dbmail_headervalue and dbmail_headername keep orphaned records. Issue History Date Modified Username Field Change ====================================================================== 31-May-13 10:17 rmoesbergen New Issue 04-Jun-13 10:53 rmoesbergen Note Added: 0003523 28-Aug-13 16:13 santa Note Added: 0003567 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
