Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sRSBE-00FTF9-B8
	for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 07:56:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sRSBC-0031sp-W0
	for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 07:55:59 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <guru@unixarea.de>)
	id 1sRSBC-0031sh-LM
	for pgsql-general@lists.postgresql.org; Wed, 10 Jul 2024 07:55:58 +0000
Received: from ms-10.1blu.de ([178.254.4.101])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <guru@unixarea.de>)
	id 1sRSB8-001Kxe-W8
	for pgsql-general@lists.postgresql.org; Wed, 10 Jul 2024 07:55:57 +0000
Received: from [212.222.85.114] (helo=pureos)
	by ms-10.1blu.de with esmtpsa  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.95)
	(envelope-from <guru@unixarea.de>)
	id 1sRSB5-0060jq-UI;
	Wed, 10 Jul 2024 09:55:52 +0200
Date: Wed, 10 Jul 2024 09:55:50 +0200
From: Matthias Apitz <guru@unixarea.de>
To: vimal va <vimal.va@gmail.com>
Cc: pgsql-general@lists.postgresql.org, vimal.arumugam@wipro.com
Subject: Re: Postgres :- Could not open R2DBC Connection
Message-ID: <Zo4+hgIWW6EKWDng@pureos>
Reply-To: Matthias Apitz <guru@unixarea.de>
References: <CAPPquYhdszBXEeY0drUeP5yXzXqeUXR3TTK-msVZDEnajGqf9A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAPPquYhdszBXEeY0drUeP5yXzXqeUXR3TTK-msVZDEnajGqf9A@mail.gmail.com>
X-Operating-System: FreeBSD 14.0-CURRENT 1400094 (amd64)
X-message-flag: Mails in HTML will not be read!  Send only plain text.
X-Con-Id: 51246
X-Con-U: 0-guru
X-Originating-IP: 212.222.85.114
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/Zo4%2BhgIWW6EKWDng%40pureos>
Precedence: bulk

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.