Postgres :- Could not open R2DBC Connection

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 <vimal.va@gmail.com> wrote:

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/&gt;&lt;unresolved&gt;: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/&gt;&lt;unresolved&gt;: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.