Nextcloud connection issue

ℹ️ Support
,
1

Hello,

We are facing issue bellow:

FATAL:Remaining connection slots are reserved for non-replication superuser connections

[/details]

Nextcloud version (eg, 20.0.5): Nextcloud Hub 3 (25.0.0)
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04.5 LTS
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.41
PHP version (eg, 7.4): 7.4

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N):Y

Steps to replicate it:

The output of your postgres log in :

FATAL:Remaining connection slots are reserved for non-replication superuser connections

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'passwordsalt' => 'Redacted my Mod RK/JK',
  'secret' => 'Redacted my Mod RK/JK',
  'trusted_domains' => 
  array (
    0 => 'Redacted my Mod RK/JK',
    1 => 'Redacted my Mod RK/JK',
    2 => 'Redacted my Mod RK/JK',
  ),
  'datadirectory' => '/mnt/ncdata',
  'dbtype' => 'pgsql',
  'version' => '25.0.0.18',
  'overwrite.cli.url' => 'https://Redacted my Mod RK/JK/',
  'dbname' => 'nextcloud_db',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => '*************',
  'dbpassword' => '********************',
  'installed' => true,
  'instanceid' => '************',
  'log_type' => 'file',
  'logfile' => '/var/log/nextcloud/nextcloud.log',
  'loglevel' => 0,
  'log_rotate_size' => false,
  'log.condition' => 
  array (
    'apps' => 
    array (
      0 => 'admin_audit',
    ),
  ),
  'mail_smtpmode' => 'smtp',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'filelocking.enabled' => 'true',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/var/run/redis/redis-server.sock',
    'port' => 0,
    'timeout' => 0.5,
    'dbindex' => 0,
    'password' => '***********************',
  ),
  'logtimezone' => 'Africa/Tunis',
  'htaccess.RewriteBase' => '/',
  'maintenance' => false,
  'ldapIgnoreNamingRules' => false,
  'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
  'auth.bruteforce.protection.enabled' => 'false',
  'theme' => '',
  'app_install_overwrite' => 
  array (
    0 => 'flowupload',
    1 => 'rocketchat_nextcloud',
    2 => 'impersonate',
  ),
  'app.mail.verify-tls-peer' => false,
  'trusted_proxies' => 
  array (
    0 => '<zimbra server proxy ip here>',
  ),
  'forwarded_for_headers' => 
  array (
    0 => 'HTTP_X_FORWARDED_FOR',
  ),
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'nextcloud',
  'mail_domain' => 'test.tn',
  'mail_smtphost' => 'smtp1.test.com',
  'mail_smtpport' => '25',
);

The output of your Apache/nginx/system log in /var/log/____:

will be added when the issue will appear again

PASTE HERE


Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

will be added when the issue will appear again
4

I think this is more a general PostgreSQL query for which you find answers on the internet, like this one:

or this one:

1 Like
5

Hello,

@j-ed thank you for your reply.
The postgres and php-fpm are configured like nextcloud recommendation.
This why am searching for similar problems in nextcloud forum.

If the issue will happen again i will post all logs for more details may be it will be helpful.

1 Like