Topic: Error: sql dict: commit failed
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Greetings, I am reviewing the logs of the dovecot and I find the following.
# tail -f /var/log/dovecot/dovecot.log
Jul 7 13:17:05 mail1 dovecot: dict(16692): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 15 secs)
Jul 7 13:17:13 mail1 dovecot: dict(19307): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 17 secs)
Jul 7 13:17:20 mail1 dovecot: dict(18438): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 29 secs)
Jul 7 13:17:21 mail1 dovecot: dict(13665): Warning: mysql: Query failed, retrying: MySQL server has gone away (idled for 33 secs)
Jul 8 21:22:23 mail1 dovecot: dict(27067): Error: sql dict: commit failed: Lost connection to MySQL server during query (idled for 0 secs)
Jul 8 21:22:24 mail1 dovecot: dict(27797): Error: sql dict: commit failed: Lost connection to MySQL server during query (idled for 0 secs)
Jul 8 21:22:24 mail1 dovecot: dict(28875): Error: sql dict: commit failed: Lost connection to MySQL server during query (idled for 32 secs)
Jul 8 21:22:25 mail1 dovecot: dict(28257): Warning: mysql: Query failed, retrying: Lost connection to MySQL server during query (idled for 2 secs)
Jul 8 21:42:53 mail1 dovecot: dict(30773): Error: sql dict: commit failed: Lost connection to MySQL server during query (idled for 0 secs)
Jul 8 22:33:49 mail1 dovecot: dict(30131): Error: sql dict: commit failed: Lost connection to MySQL server during query (idled for 0 secs)
What may be happening...????
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.