1 Topic by ca_maer (edited by ca_maer 2018-01-08 22:40:42)

  • ca_maer
  • Member
  • Offline
  • Registered: 2017-12-07
  • Posts: 16

Topic: FATAL: remaining connection slots are reserved for non-replication

======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- 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.
====


Hello,

I just came back from vacation with some weird errors sent to postmaster. It seems there is some issue in the lookup of sender_bcc_maps. I'm not sure what to do here.

Here's some logs of the error that happened multiple times.

The emails have been removed for privacy reasons but they are clients (not hosted on iredmail) email

Jan  8 08:22:41 prd-mail-1 postfix/proxymap[7115]: warning: connect to pgsql server 127.0.0.1: FATAL:  remaining connection slots are reserved for non-replication superuser connections?
Jan  8 08:22:41 prd-mail-1 postfix/cleanup[9463]: warning: proxy:pgsql:/etc/postfix/pgsql/sender_bcc_maps_user.cf lookup error for "random@email.com"
Jan  8 08:22:41 prd-mail-1 postfix/cleanup[9463]: warning: 6FD6814B2: sender_bcc_maps map lookup problem -- message not accepted, try again later
Jan  4 11:16:02 prd-mail-1 postfix/cleanup[9545]: warning: proxy:pgsql:/etc/postfix/pgsql/recipient_bcc_maps_domain.cf lookup error for "random@email.com"
Jan  4 11:16:02 prd-mail-1 postfix/cleanup[9545]: warning: 47F8635BC: recipient_bcc_maps map lookup problem -- message not accepted, try again later

Also the scripts return the same errors:

psycopg2.OperationalError: FATAL:  remaining connection slots are reserved for non-replication superuser connections

Thanks

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: FATAL: remaining connection slots are reserved for non-replication

Try to increase "max_connections" in /etc/postgresql/9.5/main/postgresql.conf. Restarting postgresql service is required.

3 Reply by ca_maer

  • ca_maer
  • Member
  • Offline
  • Registered: 2017-12-07
  • Posts: 16

Re: FATAL: remaining connection slots are reserved for non-replication

Hey Zhang,

I've increased the max connections to 200. Will see if this fix the issue.

Thanks for your help

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: FATAL: remaining connection slots are reserved for non-replication

If issue still happens, feel free to create a new topic.