<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body>
<p>Hi,<br>
<br>
with the last dovecot version (2.3.13) I see many of this warnings
via "doveadm log errors":<br>
<br>
Feb 17 03:26:28 Warning: dict(31513): conn unix:dict
(pid=31330,uid=95): dict(mysql)<a class="moz-txt-link-rfc2396E" href="mailto:email1@company1.com"><email1@company1.com></a>:
sqlpool(mysql): Query failed, retrying: MySQL server has gone away
(idled for 679 secs)<br>
Feb 17 03:48:53 Warning: dict(31013): conn unix:dict
(pid=31805,uid=95): dict(mysql)<a class="moz-txt-link-rfc2396E" href="mailto:email2@company2.com"><email2@company2.com></a>:
sqlpool(mysql): Query failed, retrying: MySQL server has gone away
(idled for 685 secs)<br>
Feb 17 03:54:12 Warning: dict(32529): conn unix:dict
(pid=3147,uid=95): dict(mysql)<a class="moz-txt-link-rfc2396E" href="mailto:email3@company3.com"><email3@company3.com></a>:
sqlpool(mysql): Query failed, retrying: MySQL server has gone away
(idled for 670 secs)<br>
<br>
What do they mean?</p>
<p>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?<br>
<br>
My dovecot configuration about dict:<br>
<br>
dict {<br>
acl = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext<br>
expire = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext<br>
sieve = mysql:/etc/dovecot/dovecot-dict-sieve-sql.conf.ext<br>
sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext<br>
}<br>
plugin {<br>
[...]<br>
acl_shared_dict = proxy::acl<br>
expire_dict = proxy::expire<br>
quota2 = dict:Quota Usage::noenforcing:proxy::sqlquota<br>
sieve = <a class="moz-txt-link-freetext" href="file:~/sieve;active=~/.dovecot.sieve">file:~/sieve;active=~/.dovecot.sieve</a><br>
sieve_before = dict:proxy::sieve;name=activesql<br>
[...]<br>
}<br>
service dict {<br>
process_limit = 500<br>
unix_listener dict {<br>
group = vmail<br>
mode = 0660<br>
user = vmail<br>
}<br>
}<br>
<br>
Thanks<br>
</p>
<pre class="moz-signature" cols="72">--
Alessio Cecchi
Postmaster @ <a class="moz-txt-link-freetext" href="http://www.qboxmail.it">http://www.qboxmail.it</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/alessice">https://www.linkedin.com/in/alessice</a></pre>
</body>
</html>