1 (edited by chronotech 2019-03-11 17:05:30)

Topic: Dovecor error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.7 PGSQL edition
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,

For a moment, we have a Postgresql error in dovecot.log :

Mar  5 15:22:24 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)

Can you tell us what to do ? Maybe increase Postgresql connections ? Or edit an Iredmail specific config file ?

COMPLETE LOG :

Mar  4 08:33:49 mx2 dovecot: master: Warning: Killed with signal 15 (by pid=24471 uid=0 code=kill)
Mar  4 08:33:49 mx2 dovecot: log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Mar  4 08:33:49 mx2 dovecot: master: Dovecot v2.2.22 (fe789d2) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Mar  4 08:34:01 mx2 dovecot: master: Warning: Killed with signal 15 (by pid=24830 uid=0 code=kill)
Mar  4 08:34:01 mx2 dovecot: master: Dovecot v2.2.22 (fe789d2) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Mar  4 08:52:08 mx2 dovecot: master: Warning: Killed with signal 15 (by pid=30432 uid=0 code=kill)
Mar  4 08:52:08 mx2 dovecot: master: Dovecot v2.2.22 (fe789d2) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Mar  4 08:52:27 mx2 dovecot: master: Warning: Killed with signal 15 (by pid=30751 uid=0 code=kill)
Mar  4 08:52:27 mx2 dovecot: log: Warning: Killed with signal 15 (by pid=1 uid=0 code=kill)
Mar  4 08:52:27 mx2 dovecot: master: Dovecot v2.2.22 (fe789d2) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Mar  5 15:22:24 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:24 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:24 mx2 dovecot: dict(28159): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:24 mx2 dovecot: dict(28159): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:25 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:25 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:25 mx2 dovecot: dict(28159): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:25 mx2 dovecot: dict(28159): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining  connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:30 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:30 mx2 dovecot: dict(28158): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:30 mx2 dovecot: dict(28159): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:22:30 mx2 dovecot: dict(28159): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32241): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32241): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32251): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32251): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:02 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32241): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32241): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32251): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32251): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:03 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32241): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32241): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32251): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32251): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:08 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:33 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:33 mx2 dovecot: dict(32252): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:35:33 mx2 dovecot: dict(32240): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  5 15:36:02 mx2 dovecot: dict(32252): Error: pgsql: Query timed out (no free connections for 60 secs): SELECT bytes FROM used_quota WHERE username = 'postmaster@immomundi.fr'
Mar  5 15:36:02 mx2 dovecot: dict(32252): Error: Not connected to database
Mar  8 09:14:20 mx2 dovecot: dict(2320): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:20 mx2 dovecot: dict(2320): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:20 mx2 dovecot: dict(2321): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:20 mx2 dovecot: dict(2321): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:21 mx2 dovecot: dict(2320): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:21 mx2 dovecot: dict(2320): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:21 mx2 dovecot: dict(2321): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:21 mx2 dovecot: dict(2321): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:25 mx2 dovecot: dict(2348): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:25 mx2 dovecot: dict(2348): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:25 mx2 dovecot: dict(2349): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:25 mx2 dovecot: dict(2349): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2348): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2348): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2349): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2349): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2320): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2320): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2321): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 09:14:26 mx2 dovecot: dict(2321): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:02 mx2 dovecot: dict(12264): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:02 mx2 dovecot: dict(12264): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:03 mx2 dovecot: dict(12264): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:03 mx2 dovecot: dict(12264): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:08 mx2 dovecot: dict(12264): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:08 mx2 dovecot: dict(12264): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:20 mx2 dovecot: dict(12355): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:20 mx2 dovecot: dict(12355): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:21 mx2 dovecot: dict(12372): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:21 mx2 dovecot: dict(12372): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:21 mx2 dovecot: dict(12355): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:21 mx2 dovecot: dict(12355): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12394): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12394): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12402): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12402): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12403): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12403): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12372): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12372): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12413): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:22 mx2 dovecot: dict(12413): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12394): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12394): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12402): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12402): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12403): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12403): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12413): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)
Mar  8 15:02:23 mx2 dovecot: dict(12413): Error: pgsql(127.0.0.1): Connect failed to database vmail: FATAL:  remaining connection slots are reserved for non-replication superuser connections (state: wait for input)

Best regards, Chronotech

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Dovecor error

Try to increase max connections in PostgreSQL.