A NOTE has been added to this issue. ====================================================================== http://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: 30-Aug-13 09:21 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://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://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://dbmail.org/mantis/view.php?id=1008#c3567 ---------------------------------------------------------------------- I can confirm that. Both dbmail_headervalue and dbmail_headername keep orphaned records. ---------------------------------------------------------------------- (0003568) Bloody (reporter) - 30-Aug-13 09:21 http://dbmail.org/mantis/view.php?id=1008#c3568 ---------------------------------------------------------------------- confirm, dbmail=# select count(*) from dbmail_headervalue left outer join dbmail_header on dbmail_header.headervalue_id=dbmail_headervalue.id where dbmail_header.headervalue_id is null; count --------- 5673957 (1 row) dbmail=# select count(*) from dbmail_headervalue; count --------- 5794361 (1 row) 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 30-Aug-13 09:21 Bloody Note Added: 0003568 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
