Quota calculation with MySQL backend and replication.

[Reio Remma]

On 27.04.2020 13:21, Aki Tuomi wrote:
>> 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

Thank you! I'll look into it.

Reio