Paul, This bug may explain why I can't apply the:
CREATE UNIQUE INDEX dbmail_envelope_1 ON dbmail_envelope(physmessage_id); Of the file: 2_3_6-3_0_0.mysql What do you recommend to search & delete the duplicated info, without recreate the cache? I'm with 110GB right now, and if I can bypass the cache recreate would be good to not having the service down. > -----Original Message----- > From: dbmail-dev-boun...@dbmail.org [mailto:dbmail-dev- > boun...@dbmail.org] On Behalf Of Mantis Bug Tracker > Sent: segunda-feira, 13 de Fevereiro de 2012 21:21 > To: dbmail-dev@dbmail.org > Subject: [Dbmail-dev] [DBMail 0000897]: dbmail-util creates duplicate > entries in dbmail_envelope > > > The following issue has been RESOLVED. > ====================================================================== > http://www.dbmail.org/mantis/view.php?id=897 > ====================================================================== > Reported By: simkin > Assigned To: > ====================================================================== > Project: DBMail > Issue ID: 897 > Category: Command-Line programs (dbmail-users, > dbmail-util) > Reproducibility: always > Severity: major > Priority: normal > Status: resolved > target: > Resolution: fixed > Fixed in Version: 3.0.1 > ====================================================================== > Date Submitted: 19-Apr-11 19:14 CEST > Last Modified: 13-Feb-12 22:20 CET > ====================================================================== > Summary: dbmail-util creates duplicate entries in > dbmail_envelope > Description: > During the upgrade to 3.0.0, the header cache is deleted and must be > repopulated with dbmail-util. > > This task causes duplicate entries to be added to dbmail_envelope > because > the header cache function inserts an entry here regardless of whether > it > exists - and even if you empty dbmail_envelope prior to running dbmail > -by, > it firsts refills the envelope cache and then adds duplicate entries > while > populating the header cache. > ====================================================================== > > ---------------------------------------------------------------------- > (0003210) lemmster (reporter) - 06-Jul-11 10:14 > http://www.dbmail.org/mantis/view.php?id=897#c3210 > ---------------------------------------------------------------------- > Same happens here with MySQL and a fresh 3.0 database (not migration > from > 2.2 to 3.0). > > Issue History > Date Modified Username Field Change > ====================================================================== > 19-Apr-11 19:14 simkin New Issue > 19-Apr-11 20:08 simkin Issue Monitored: simkin > 06-Jul-11 10:14 lemmster Issue Monitored: lemmster > 06-Jul-11 10:14 lemmster Note Added: 0003210 > 13-Feb-12 22:20 paul Status new => > resolved > 13-Feb-12 22:20 paul Resolution open => fixed > 13-Feb-12 22:20 paul Fixed in Version => 3.0.1 > ====================================================================== > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
