Re: Postgres :- Could not open R2DBC Connection

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Kashif Zeeshan <[email protected]>
To: vimal va <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Postgres :- Could not open R2DBC Connection
Date: Wed, 10 Jul 2024 12:52:03 +0500
Message-ID: <CAAPsdheGG9yO9BG+g0wuNv6r073TUg8uA4SE9-CCGGrVdxQKNw@mail.gmail.com> (raw)
In-Reply-To: <CAPPquYhdszBXEeY0drUeP5yXzXqeUXR3TTK-msVZDEnajGqf9A@mail.gmail.com>
References: <CAPPquYhdszBXEeY0drUeP5yXzXqeUXR3TTK-msVZDEnajGqf9A@mail.gmail.com>

Hi

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 <[email protected]> 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/
> <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)*
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Postgres :- Could not open R2DBC Connection
  In-Reply-To: <CAAPsdheGG9yO9BG+g0wuNv6r073TUg8uA4SE9-CCGGrVdxQKNw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox