BUG #18406: Connection issue after upgrading to postgres16

Started by PG Bug reporting formabout 2 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 18406
Logged by: RAJEEV RAPARTHI
Email address: rajeev.raparthi@gmail.com
PostgreSQL version: 16.0
Operating system: Linux
Description:

Hi Team ,

We recently upgraded our postgres version from 11 to 16 , and we are
encountering the connection issue after migration sporadically .
DriverManagerDataSource dataSource = new
DriverManagerDataSource(getUrl(), username, getDbPassword());
dataSource.setDriverClassName("org.postgresql.Driver");

We are observing the issue as "Caused by:
org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC
Connection [The connection attempt failed.] [n/a]"

We are using db3.t3.small machine which has 2GB of RAM .

#2Dave Cramer
pg@fastcrypt.com
In reply to: PG Bug reporting form (#1)
Re: BUG #18406: Connection issue after upgrading to postgres16

On Mon, 25 Mar 2024 at 07:58, PG Bug reporting form <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 18406
Logged by: RAJEEV RAPARTHI
Email address: rajeev.raparthi@gmail.com
PostgreSQL version: 16.0
Operating system: Linux
Description:

Hi Team ,

We recently upgraded our postgres version from 11 to 16 , and we are
encountering the connection issue after migration sporadically .
DriverManagerDataSource dataSource = new
DriverManagerDataSource(getUrl(), username, getDbPassword());
dataSource.setDriverClassName("org.postgresql.Driver");

We are observing the issue as "Caused by:
org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC
Connection [The connection attempt failed.] [n/a]"

We are using db3.t3.small machine which has 2GB of RAM .

Do you have any more information?

There isn't enough information here to tell what is going wrong.
Dave Cramer
www.postgres.rocks