Thread: BUG #18406: Connection issue after upgrading to postgres16

BUG #18406: Connection issue after upgrading to postgres16

From

PG Bug reporting form

Date:

25 March, 13:09:11

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 .

Re: BUG #18406: Connection issue after upgrading to postgres16

From

Dave Cramer

Date:

26 March, 22:34:58

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