Question

cloud, database connection

2

Hi, When using the test environment, we sometimes get the following error: 2014-01-07 10:11:58.929 INFO - ConnectionBusRetrieve: Trying to clean up and reset connection pooling mechanism... 2014-01-07 10:11:58.929 ERROR - ConnectionBus: Error on closing JDBC connection. Already closed. 2014-01-07 10:11:58.943 WARNING - ConnectionBus: Database connections: -27 active, 0 idle. 2014-01-07 10:11:58.943 ERROR - ConnectionBus: Opening JDBC connection to 10.181.67.76:0 failed with SQLState: 57P03 Error code: 0 Message: FATAL: the database system is in recovery mode Retrying...(1/4) 2014-01-07 10:11:59.000 ERROR - ConnectionBusRetrieve: JDBCDataStore::execRetrieveQuery failed with SQLState: 08006, error code: 0, message: An I/O error occured while sending to the backend. It seems that the user can not access the database but I have no idea why this happens. Did anyone encounter similar problems?

asked 2014-01-07

Friso Nijboer

3 answers

Achiel · Answer 1 · 2014-01-07

I checked out your app, there was a network connection error between your appnode and dbnode, which is why it couldn't connect. As far as I can tell this has resolved itself and your app should be up and running.

Note that the runtime tries to reconnect automatically when it can't reach the dbnode, so if this ever happens again you should be able to just wait and have it resolve itself.

Aleksandar Alempic · Answer 2 · 2018-09-14

Hello guys,

I experienced the same issue on the cloud environment that is used only by me.

Every time it happened when the same action is repeated and also I received the alert from Mendix that says that Database service went out of memory. The good thing is that the app continues its work as usual but it's not clear why I'm getting into the issue because the same actions were performed in the past and there were no problems.

Any idea what went wrong? :)

Thanks in advance,

org.hibernate.exception.GenericJDBCException: Cannot open connection

Sep 13 21:10:27.973 - ERROR - getVPRelation: (72/494) Caused by: java.sql.SQLException: Cannot get new connection for user null from database driver: java.sql.SQLException: Listener refused the connection with the following error:

Sep 13 21:11:25.187 - ERROR - ConnectionBus_Retrieve: JDBCDataStore::execRetrieveQuery failed with SQLState: 08006, error code: 0, message: An I/O error occurred while sending to the backend.
Sep 13 21:11:25.190 - ERROR - ConnectionBus_Retrieve: (1/125) org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
Sep 13 21:11:25.190 - ERROR - ConnectionBus_Retrieve: (2/125) #011at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:318)
Sep 13 21:11:25.190 - ERROR - ConnectionBus_Retrieve: (3/125) #011at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)

Kind regards.

Aleksandar Alempic

Lester Allen · Answer 3 · 2019-04-01

What database do you use and is there any additional services? Because I run my SQL database from this database management company at work and I haven’t experienced any problems with connections so far.