Warning sqlpool(mysql): Query failed

[Alessio Cecchi]

Hi,

with the last dovecot version (2.3.13) I see many of this warnings via 
"doveadm log errors":

Feb 17 03:26:28 Warning: dict(31513): conn unix:dict (pid=31330,uid=95): 
dict(mysql)<email1 at company1.com>: sqlpool(mysql): Query failed, 
retrying: MySQL server has gone away (idled for 679 secs)
Feb 17 03:48:53 Warning: dict(31013): conn unix:dict (pid=31805,uid=95): 
dict(mysql)<email2 at company2.com>: sqlpool(mysql): Query failed, 
retrying: MySQL server has gone away (idled for 685 secs)
Feb 17 03:54:12 Warning: dict(32529): conn unix:dict (pid=3147,uid=95): 
dict(mysql)<email3 at company3.com>: sqlpool(mysql): Query failed, 
retrying: MySQL server has gone away (idled for 670 secs)

What do they mean?

I thinks are related to inactivity timeout on mysql server (where I have 
a wait_timeout=600), but these warnings could be problems or can be 
fixed with some setting in dovecot?

My dovecot configuration about dict:

dict {
   acl = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
   expire = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
   sieve = mysql:/etc/dovecot/dovecot-dict-sieve-sql.conf.ext
   sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
plugin {
   [...]
   acl_shared_dict = proxy::acl
   expire_dict = proxy::expire
   quota2 = dict:Quota Usage::noenforcing:proxy::sqlquota
   sieve = file:~/sieve;active=~/.dovecot.sieve
   sieve_before = dict:proxy::sieve;name=activesql
   [...]
}
service dict {
   process_limit = 500
   unix_listener dict {
     group = vmail
     mode = 0660
     user = vmail
   }
}

Thanks

-- 
Alessio Cecchi
Postmaster @ http://www.qboxmail.it
https://www.linkedin.com/in/alessice

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20210217/6b381d5a/attachment.html>