Topic: Dovecot sql dict commit failed
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1
- Linux/BSD distribution name and version: Ubuntu 16.04.1 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro?: No
- Related log if you're reporting an issue:
====
Every few seconds I am getting this in the dovecot log.
Jan 13 10:30:40 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:40 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:40 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:40 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:41 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:41 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:41 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:41 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:41 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:41 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:42 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:42 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:42 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:42 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:42 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:42 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:43 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:43 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:43 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:43 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:43 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:43 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:44 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:44 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:44 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:44 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:44 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:44 dict(10273): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:45 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:45 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
Jan 13 10:30:45 dict(10127): Error: sql dict: commit failed: The user specified as a definer ('root'@'localhost') does not exist
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.