Hi. This is a known issue: https://issues.apache.org/jira/browse/MAILBOX-229
Either upgrade or apply the patch :-) Thanks for report. Cheers, -- Tellier Benoit Software engineer dedicated to OpenPaaS at Linagora PMC of the Apache JAMES project VIE in Vietnam https://twitter.com/AwesomePaaS https://medium.com/linagora-engineering (I'm proud to tell you this e-mail is JAMES and OpenPaaS powered) Le 08/10/2017 à 20:17, Jerry Malcolm a écrit : > I'm running r3b5. I have a reasonably large repository with ~1M mail > records. I just noticed that the james_mail_userflag table has 1.2 > BILLION records... approximately 1000 records for each email record. I > do use user flags a lot. But I would expect a max of one user flag > record for each email. It appears that when email records are deleted, > (e.g. spam cleanup), then associated userflag records are not being > deleted. > > Fortunately, I have an imap utility that can rebuild the flags. So I > emptied out the user flag table. (it cut the database size in half....) > and let the utility rebuild the flags. But obviously, this is not the > correct process. > > Is this a known issue? > > Thanks. > > Jerry > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org > For additional commands, e-mail: server-user-h...@james.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org For additional commands, e-mail: server-user-h...@james.apache.org
