pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres :- Could not open R2DBC Connection
3+ messages / 3 participants
[nested] [flat]
* Postgres :- Could not open R2DBC Connection
@ 2024-07-10 07:48 vimal va <vimal.va@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: vimal va @ 2024-07-10 07:48 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org; +Cc: vimal.arumugam@wipro.com
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)*
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres :- Could not open R2DBC Connection
@ 2024-07-10 07:52 Kashif Zeeshan <kashi.zeeshan@gmail.com>
parent: vimal va <vimal.va@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Kashif Zeeshan @ 2024-07-10 07:52 UTC (permalink / raw)
To: vimal va <vimal.va@gmail.com>; +Cc: pgsql-general@lists.postgresql.org; vimal.arumugam@wipro.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 <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/
> <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)*
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres :- Could not open R2DBC Connection
@ 2024-07-10 07:55 Matthias Apitz <guru@unixarea.de>
parent: vimal va <vimal.va@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Matthias Apitz @ 2024-07-10 07:55 UTC (permalink / raw)
To: vimal va <vimal.va@gmail.com>; +Cc: pgsql-general@lists.postgresql.org; vimal.arumugam@wipro.com
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-07-10 07:55 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-10 07:48 Postgres :- Could not open R2DBC Connection vimal va <vimal.va@gmail.com>
2024-07-10 07:52 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-07-10 07:55 ` Matthias Apitz <guru@unixarea.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox