org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections

Atlassian JIRA | Matt Ryall | 6 years ago
  1. 0

    [CONF-22033] Detect misconfigured database servers: too few available connections, etc. - Atlassian JIRA

    atlassian.com | 7 months ago
    org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections
  2. 0

    Here's a query you can run on PostgreSQL to check the number of connections available: {code:sql} SELECT name, current_setting(name) FROM pg_settings WHERE name = 'max_connections' {code} If this returns an insufficient number of connections, Confluence should abort start-up with a useful error message. Instead, you currently end up with exceptions occurring at runtime like this: {noformat} 2011-03-21 12:17:29,201 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [mchange.v2.resourcepool.BasicResourcePool] run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@decf7d5 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: -- referer: http://localhost:8080/confluence/setup/setupstandarddb.action | url: /confluence/setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:464) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) {noformat} For those who come across this actual issue with PostgreSQL, the fix is to increase the number of connections in postgresql.conf, and adjust the shared_buffer setting as necessary too. See the [PostgreSQL documentation|http://www.postgresql.org/docs/8.2/static/runtime-config-connection.html] for more information.

    Atlassian JIRA | 6 years ago | Matt Ryall
    org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections
  3. 0

    Here's a query you can run on PostgreSQL to check the number of connections available: {code:sql} SELECT name, current_setting(name) FROM pg_settings WHERE name = 'max_connections' {code} If this returns an insufficient number of connections, Confluence should abort start-up with a useful error message. Instead, you currently end up with exceptions occurring at runtime like this: {noformat} 2011-03-21 12:17:29,201 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [mchange.v2.resourcepool.BasicResourcePool] run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@decf7d5 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: -- referer: http://localhost:8080/confluence/setup/setupstandarddb.action | url: /confluence/setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:464) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) {noformat} For those who come across this actual issue with PostgreSQL, the fix is to increase the number of connections in postgresql.conf, and adjust the shared_buffer setting as necessary too. See the [PostgreSQL documentation|http://www.postgresql.org/docs/8.2/static/runtime-config-connection.html] for more information.

    Atlassian JIRA | 6 years ago | Matt Ryall
    org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Application.properties - Front-end - GUJ

    com.br | 11 months ago
    org.postgresql.util.PSQLException: FATAL: role "root " n?o existe
  6. 0

    none: 10/01/2010 - 11/01/2010

    blogspot.com | 1 year ago
    org.hibernate.exception.GenericJDBCException: Cannot open connection

  1. kjhdofjosvs 1 times, last 4 days ago
  2. serious2monkeys 1 times, last 1 week ago
  3. serious2monkeys 1 times, last 2 months ago
  4. max_samebug 2 times, last 2 months ago
12 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

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

    at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages()
  2. PostgreSQL JDBC Driver
    ConnectionFactory.openConnection
    1. org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:464)
    2. org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112)
    3. org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
    3 frames