1

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.

2

Re: Error: sql dict: commit failed

Is the SQL service actually running?