Quota calculation with MySQL backend and replication.

Aki Tuomi aki.tuomi at open-xchange.com
Mon Apr 27 13:21:27 EEST 2020


> On 27/04/2020 12:35 Reio Remma <reio at mrstuudio.ee> wrote:
> 
>  
> On 27.04.2020 12:15, Reio Remma wrote:
> > Hello!
> >
> > Over the weekend I converted our Dovecot server from Maildir quota to 
> > MySQL backed quota and then provisioned a fresh replica server and 
> > seeded it via Dovecot replication.
> >
> > This morning most mailboxes were over quota, reporting twice the 
> > actual usage. I'm fairly certain it's the effect of having sql backed 
> > quota with both Dovecot servers using the same database.
> >
> > Can anyone tell me if this is a one-off problem stemming from 
> > replicating the 2nd server from scratch or should I be aware of other 
> > quirks concerning sql backed quota and replication?
> 
> I see that arrived messages are also counted twice.
> 
> Reio

Please try using count quota with quota_clone instead.

AKi


More information about the dovecot mailing list