[Dovecot] Quota transaction bug?

Timo Sirainen tss at iki.fi
Wed Jul 25 06:08:55 EEST 2007


On 25.7.2007, at 1.03, David Jonas wrote:

>>> INSERT INTO quota (current, path, username) VALUES (0, 'quota/ 
>>> storage',
>>> 'user at example.com') ON DUPLICATE KEY UPDATE current = current + 0;
>>>
>>> So it's only added to or inserted, never changed then replaced.
>>
>> OK, so absolutely nothing about the INSERT (including whether or  
>> not it is
>> performed) depends on anything about the result from the SELECT?
>
> I won't pretend to know for sure, but as far as I can tell, no.

Right.

> I never poked around to find out why the SELECT is done.

v1.0 code does it at the beginning of each mailbox transaction. I've  
already fixed in v1.1 code so that it's done only when quota checking  
is actually needed.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20070725/9044d1a9/attachment.bin 


More information about the dovecot mailing list