Thread: Postgres :- Could not open R2DBC Connection

Postgres :- Could not open R2DBC Connection

From

vimal va

Date:

10 July, 10:48:06

Dear team ,

This is Vimal from WIpro. We are using Postgres 14 , while connecting postgres from application we are getting "Could not open R2DBC Connection for transaction;" error in pod . We have increased the max number of connections in postgres from 100 to 1000 , still we are facing the same error.

I have pasted below the error for reference. Please help us on this issue

Thanks,

Vimal.

reactor.core.Exceptions$ErrorCallbackNotImplemented: org.springframework.transaction.CannotCreateTransactionException: Could not open R2DBC Connection for transaction; nested exception is io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException: Cannot connect to 10.0.202.121/<unresolved>:5432
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open R2DBC Connection for transaction; nested exception is io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException: Cannot connect to 10.0.202.121/<unresolved>:5432
        at org.springframework.r2dbc.connection.R2dbcTransactionManager.lambda$null$5(R2dbcTransactionManager.java:227)
        at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94)
        at co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126)
        at reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:172)
        at co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126)

Re: Postgres :- Could not open R2DBC Connection

From

Kashif Zeeshan

Date:

10 July, 10:52:03

Can you check the following.

1. The machine 10.0.202.121 is accessible.

2. Check the firewall settings.

3. Check the pg_hha.conf Settings.

Regards

Kashif Zeeshan

On Wed, Jul 10, 2024 at 12:48 PM vimal va <vimal.va@gmail.com> wrote:

Dear team ,

This is Vimal from WIpro. We are using Postgres 14 , while connecting postgres from application we are getting "Could not open R2DBC Connection for transaction;" error in pod . We have increased the max number of connections in postgres from 100 to 1000 , still we are facing the same error.
I have pasted below the error for reference. Please help us on this issue

Thanks,
Vimal.

reactor.core.Exceptions$ErrorCallbackNotImplemented: org.springframework.transaction.CannotCreateTransactionException: Could not open R2DBC Connection for transaction; nested exception is io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException: Cannot connect to 10.0.202.121/<unresolved>:5432
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open R2DBC Connection for transaction; nested exception is io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException: Cannot connect to 10.0.202.121/<unresolved>:5432
        at org.springframework.r2dbc.connection.R2dbcTransactionManager.lambda$null$5(R2dbcTransactionManager.java:227)
        at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94)
        at co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126)
        at reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:172)
        at co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126)

Re: Postgres :- Could not open R2DBC Connection

From

Matthias Apitz

Date:

10 July, 10:55:50

El día miércoles, julio 10, 2024 a las 01:18:06 +0530, vimal va escribió:

> Dear team ,
> 
> This is Vimal from WIpro. We are using Postgres 14 , while connecting
> postgres from application we are getting "*Could not open R2DBC Connection
> for transaction;"  error in pod . *We have increased the max number of
> connections in postgres from 100 to 1000 , still we are facing the same
> error.
> I have pasted below the error for reference. Please help us on this issue
> 
> Thanks,
> Vimal.

Please post the output of the following command from your server 10.0.202.121

netstat -an | grep 5432

    matthias

> *reactor.core.Exceptions$ErrorCallbackNotImplemented:
> org.springframework.transaction.CannotCreateTransactionException: Could not
> open R2DBC Connection for transaction; nested exception is
> io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException:
> Cannot connect to 10.0.202.121/
> <http://10.0.202.121/><unresolved>:5432Caused by:
> org.springframework.transaction.CannotCreateTransactionException: Could not
> open R2DBC Connection for transaction; nested exception is
> io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException:
> Cannot connect to 10.0.202.121/
> <http://10.0.202.121/><unresolved>:5432        at
> org.springframework.r2dbc.connection.R2dbcTransactionManager.lambda$null$5(R2dbcTransactionManager.java:227)
> at
> reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94)
> at
> co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126)
> at
> reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:172)
> at
> co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126)*

-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

I am not at war with Russia.  Я не воюю с Россией.
Ich bin nicht im Krieg mit Russland.