[Dovecot] Dovecot 2.0.1 Quota dict timeout

[David Jonas]

On 9/9/10 , Sep 9, 12:23 PM, David Jonas wrote:
> On 9/8/10 , Sep 8, 8:05 AM, Timo Sirainen wrote:
>> On Tue, 2010-09-07 at 18:07 -0700, David Jonas wrote:
>>>> Well, see if this helps:
>>>> http://hg.dovecot.org/dovecot-2.0/rev/902f008f17cf
>>> The patch didn't seem to make a difference. I'm still seeing the error.
>>>
>>> If you have any ideas on debugging I'm open to trying them. Dovecot
>>> 2.0.1 running on CentOS release 4.8 (Final) i386. MySQL AB's
>>> devel/client/shared rpms, 4.1.22. I can insert some logging probes (or
>>> whatever you like) if you give me pointers on how and where.
>>
>> Try the attached patch what it logs with it?
> 
> Hm, nothing extra gets logged. I'm not sure this will help, but I
> inserted a few more probes wherever sql_not_connected_result comes up.
> One fired, src/lib-sql/driver-mysql.c around line 294:
> 
> Sep  9 12:17:23 dovecot: dict: Warning: In driver_mysql_query_s,
> driver_mysql_do_query returned 0, query=BEGIN
> Sep  9 12:17:23 dovecot: dict: Error: sql dict: commit failed: Not
> connected to database
> Sep  9 12:17:23 dovecot: lda(u at example.com): Error: dict quota: Quota
> update failed, it's now desynced

A little more info:

Sep  9 19:31:30 dovecot: dict: Warning: mysql_query failed, error=Lost
connection to MySQL server during query, query=BEGIN

Generated from this probe in src/lib-sql/driver-mysql.c near line 219,
in driver_mysql_do_query():

if (mysql_query(db->mysql, query) == 0)
        return 1;

/* failed */
i_warning("mysql_query failed, error=%s, query=%s",
mysql_error(db->mysql), query);