Thread

1. Postgres :- Could not open R2DBC Connection

   vimal va <vimal.va@gmail.com> — 2024-07-10T07:48:06Z

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

2. Re: Postgres :- Could not open R2DBC Connection

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-10T07:52:03Z

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

3. Re: Postgres :- Could not open R2DBC Connection

   Matthias Apitz <guru@unixarea.de> — 2024-07-10T07:55:50Z

   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.