![]() ![]() This is my connection string jdbc:postgresql://./dashboard?tcpKeepAlive=trueĮdited the RDS server side TCP_KeepAlive parameters as suggested in the selected answer. Perhaps forcing the connection pool to test and reconnect? I'm using Spring Boot with JDBC (tomcat connection pooling) and JDBCTemplate. When you receive this error most of the time it is due to not having PostgreSQL configured to allow TCP/IP connections or at least not connections from your particular workstation. I found this other question which suggests a work around that improved the situation (timeouts now take a lot longer) but didn't fix it. Common Cause: The postmaster or PostgreSQL's server daemon process is not running or configured incorrectly. The same issue happens in psql AND I don't have issues connecting to a local database, so I'm pretty sure the problem is on RDS. nested exception is : An I/O error occured while sending to the backend.] with root cause ![]() An I/O error occured while sending to the backend. To prevent dead connections, you must set a. Also, verify that you have the correct connection information and valid credentials. Before you continue, verify that your database is currently available. If you are getting this error, check that you have added the machine or resource you are connecting from to the database’s list of trusted sources. Use the following section to help you troubleshoot connections to data sources. I get the following exception in my application after leaving a database connection idle for some amount of time. If no timeout interval is set for the socket, the application keeps waiting for the database to return results. A Connection Timed Out error occurs when the database’s firewall won’t allow you to connect to the database from your local machine or resource. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |