MIME-Version: 1.0
From: vimal va <vimal.va@gmail.com>
Date: Wed, 10 Jul 2024 13:18:06 +0530
Message-ID: <CAPPquYhdszBXEeY0drUeP5yXzXqeUXR3TTK-msVZDEnajGqf9A@mail.gmail.com>
Subject: Postgres :- Could not open R2DBC Connection
To: pgsql-general@lists.postgresql.org
Cc: vimal.arumugam@wipro.com
Content-Type: multipart/alternative; boundary="000000000000a03855061cdfdeec"
Archived-At: <https://www.postgresql.org/message-id/CAPPquYhdszBXEeY0drUeP5yXzXqeUXR3TTK-msVZDEnajGqf9A%40mail.gmail.com>
Precedence: bulk

--000000000000a03855061cdfdeec
Content-Type: text/plain; charset="UTF-8"

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)*

--000000000000a03855061cdfdeec
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div dir=3D"ltr">Dear team ,<div><br></div><div>This is V=
imal from WIpro. We are using Postgres 14 , while connecting postgres from =
application we are getting &quot;<span style=3D"font-size:inherit"><b>Could=
 not open R2DBC Connection for transaction;&quot;=C2=A0 error in pod . </b>=
We have increased the max number of connections in postgres from 100 to 100=
0 , still we are facing the same error.</span></div><div><span style=3D"fon=
t-size:inherit">I have pasted below the error for reference. Please help us=
 on this issue</span></div><div><span style=3D"font-size:inherit"><br></spa=
n></div><div><span style=3D"font-size:inherit">Thanks,</span></div><div><sp=
an style=3D"font-size:inherit">Vimal.</span></div><div><br></div><div><span=
 dir=3D"ltr"><p style=3D"margin-bottom:16px"></p><p style=3D"margin-bottom:=
16px"><b><span style=3D"font-size:inherit">reactor.core.Exceptions$ErrorCal=
lbackNotImplemented: org.springframework.transaction.CannotCreateTransactio=
nException: Could not open R2DBC Connection for transaction; nested excepti=
on is io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionExc=
eption: Cannot connect to <a href=3D"http://10.0.202.121/" target=3D"_blank=
" rel=3D"noreferrer">10.0.202.121/</a>&lt;unresolved&gt;:5432</span><br><sp=
an style=3D"font-size:inherit">Caused by: org.springframework.transaction.C=
annotCreateTransactionException: Could not open R2DBC Connection for transa=
ction; nested exception is io.r2dbc.postgresql.PostgresqlConnectionFactory$=
PostgresConnectionException: Cannot connect to <a href=3D"http://10.0.202.1=
21/" target=3D"_blank" rel=3D"noreferrer">10.0.202.121/</a>&lt;unresolved&g=
t;:5432</span><br><span style=3D"font-size:inherit">=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 at org.springframework.r2dbc.connection.R2dbcTransact=
ionManager.lambda$null$5(R2dbcTransactionManager.java:227)</span><br><span =
style=3D"font-size:inherit">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at r=
eactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErro=
rResume.java:94)</span><br><span style=3D"font-size:inherit">=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at co.elastic.apm.agent.reactor.TracedSubscr=
iber.onError(TracedSubscriber.java:126)</span><br><span style=3D"font-size:=
inherit">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at reactor.core.publish=
er.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:172)</span><br><span st=
yle=3D"font-size:inherit">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at co.=
elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:12=
6)</span></b><br><span style=3D"font-size:inherit">=C2=A0</span></p></span>=
</div></div></div>

--000000000000a03855061cdfdeec--