SQL Error with Database connections

0
I have the following error after updating my application from 7.23.4 to 8.11.1: WARNING ConnectionBus: Database connections: 0 active, 35 idle. ERROR    ConnectionBus: Opening JDBC connection to Some(<DOMAIN>) failed with SQLState: 53300 Error code: 0 Message: FATAL: remaining connection slots are reserved for non-replication superuser connections Retrying...(1/4) The application is very slow and waiting for long times. Can anybody help me?
asked
1 answers
0

If this is a cloud environment the number of connections is limited by default. Creating pages with lots of selectors and grids might cause the connectionpool to run out of connections. This can be seen in the monitoring by looking at the connections graph and you’ll then see a graph with a flat top of the peak. Either find the page or function that is creating all these connections and redesign the page/function or ask via support to increase the number of possible connections. Keep in mind though that more connections will increase the load on de database, so more computing power (CPU and RAM) might be needed as well.

Locally you can change this in the configuration of your database (postgres.conf)

answered