org.postgresql.util.PSQLException: FATAL: too many connections for role "iyraxwqa"


Samebug tips

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


7 months ago
Expert tip

Solutions on the web

Solution icon of stackoverflow
FATAL: too many connections for role "iyraxwqa"

Solution icon of stackoverflow
FATAL: remaining connection slots are reserved for non-replication superuser connections

Solution icon of stackoverflow
FATAL: role "window" does not exist

Solution icon of googlegroups
via Google Groups by Mutowongi, 7 months ago
FATAL: role "dspace" is not permitted to log in

Solution icon of stackoverflow
via Stack Overflow by SSchneid
, 5 months ago
FATAL: remaining connection slots are reserved for non-replication superuser connections Ort: Datei: postinit.c, Routine: InitPostgres, Zeile: 779. Server SQLState: 53300

Solution icon of stackoverflow
ERROR: improper qualified name (too many dotted names) Position: 16

Solution icon of github
via GitHub by wernermarcel
, 10 months ago
ERROR: value too long for type character varying(4000)

Solution icon of github
ERROR: value too long for type character varying(255)

Solution icon of github
ERROR: value too long for type character varying(16)

Solution icon of opennms
via The OpenNMS Issue Tracker by David Hustace, 1 year ago
ERROR: value too long for type character varying(256)

Stack trace

org.postgresql.util.PSQLException: FATAL: too many connections for role "iyraxwqa"
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2586)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:113)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.Driver.makeConnection(Driver.java:404)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.postgresql.Driver.connect(Driver.java:272)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)[tomcat-jdbc-8.5.6.jar:na]
	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)[tomcat-jdbc-8.5.6.jar:na]
	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:718)[tomcat-jdbc-8.5.6.jar:na]

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 3 months ago
Samebug visitor profile picture
Unknown user
2 times, 4 months ago
74 times, 3 weeks ago
481 times, 3 months ago
2 times, 4 months ago
102 more bugmates