You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Jerry Malcolm <te...@malcolms.com> on 2017/10/08 13:17:23 UTC
james_mail_userflag not being managed
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-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: james_mail_userflag not being managed
Posted by Benoit Tellier <bt...@linagora.com>.
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-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org