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 ) id 1sMWha-002oMB-M0 for pgsql-general@arkaria.postgresql.org; Wed, 26 Jun 2024 17:45:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sMWhY-005ljG-Uq for pgsql-general@arkaria.postgresql.org; Wed, 26 Jun 2024 17:45:01 +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 ) id 1sMWhX-005lj8-NG for pgsql-general@lists.postgresql.org; Wed, 26 Jun 2024 17:45:00 +0000 Received: from dispatch1-us1.ppe-hosted.com ([67.231.154.184]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMWhU-003GEV-FG for pgsql-general@lists.postgresql.org; Wed, 26 Jun 2024 17:44:58 +0000 X-Virus-Scanned: Proofpoint Essentials engine Received: from COO-DC-MXS.domain.onalaskawi.gov (mail.onalaskawi.gov [24.159.224.165]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1-us1.ppe-hosted.com (PPE Hosted ESMTP Server) with ESMTPS id 3E2C7340067 for ; Wed, 26 Jun 2024 17:44:54 +0000 (UTC) Received: from COO-DC-MXS.domain.onalaskawi.gov (10.145.0.20) by COO-DC-MXS.domain.onalaskawi.gov (10.145.0.20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Wed, 26 Jun 2024 12:44:53 -0500 Received: from COO-DC-MXS.domain.onalaskawi.gov ([fe80::755:a89:5667:eeab]) by COO-DC-MXS.domain.onalaskawi.gov ([fe80::755:a89:5667:eeab%15]) with mapi id 15.02.1544.011; Wed, 26 Jun 2024 12:44:53 -0500 From: "Tarras, Tim" To: "pgsql-general@lists.postgresql.org" Subject: Dropping connections Thread-Topic: Dropping connections Thread-Index: AdrH8Bx+PWk8BPNwTHSMlgs3X3x7Bg== Date: Wed, 26 Jun 2024 17:44:53 +0000 Message-ID: <842a688946204561ad0787606a644ecf@onalaskawi.gov> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.145.15.125] Content-Type: multipart/alternative; boundary="_000_842a688946204561ad0787606a644ecfonalaskawigov_" MIME-Version: 1.0 X-MDID: 1719423895-aASFiFL4NEgl X-MDID-O: us1;at1;1719423895;aASFiFL4NEgl;;708f4cf6a8f07adf444be922aaf29da9 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_842a688946204561ad0787606a644ecfonalaskawigov_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am having problems with loosing connection to a postgresql database with = ESRI ArcGIS Pro. Below is what I put on the ESRI community forums but also = wanted to post here to see I can get a resolution to this problem. Thank y= ou for any help you can provide. Tim I'm not sure if this is the right place but, I am having an issue with ente= rprise Database connections dropping to my computer. If I work with ArcPro = on the server the connections do not drop. We also made a connection direct= ly from my computer using pgAdmin and will not lose connection even when I = loose it in Pro. My system is as follows: 1. ArcGIS Enterprise 11.2 Single machine deployment. Server has 32GB of = memory 2. ArcgisPro 3.3.0 3. Postgres 15.4 Downloaded from ESRI and on a separate server from ente= rprise. Server has 12 cores and 32GB of memory 4. Both servers are running Windows Server 2022 datacenter Version 21H2. When the connection drops I get the following message: Underlying DBMS error [no connection to the server::SQLSTATE=3D=E5] [xxxxxx= x.xxx.GDB_Items][STATE_ID =3D 0] X's replace actual names. Working with ESRI we found the following information in the logs : "An existing connection was forcibly closed by the remote host" where host = is the PostgreSQL Server and "FATAL: terminating connection due to administ= rator command". The following PostgreSQL documentation provides more inform= ation about the same (https://www.postgresql.org/message-id/5665.1202148155= %40sss.pgh.pa.us [postgresql.org]). At this time IT says it is not a fire wall issue as there are no rules setu= p for dropping connections. We are at a loss as to what the culprit is. I will also be posting this in PostgreSQL community to get their input. Thank you for your help with this. This email and any files transmitted with it are confidential and are inten= ded solely for the use of the individual or entity to which they are addres= sed. If you have received this email in error, please respond to the sender= and delete the material from any computer and/or server. The City of Onala= ska is subject to Wisconsin Statutes relating to public records. Emails sen= t or received by City employees are subject to these laws. Unless otherwise= exempted from the public records law, senders and receivers of City email = should presume that the emails are subject to release upon request, and to = state record retention requirements. --_000_842a688946204561ad0787606a644ecfonalaskawigov_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

I am having problems with loosing connection to a postgresql database wi= th ESRI ArcGIS Pro. Below is what I put on the ESRI community forums but al= so wanted to post here to see I can get a resolution to this problem. = Thank you for any help you can provide.

Tim

I'm not sure if this is the right place but, I am having an issue with e= nterprise Database connections dropping to my computer. If I work with ArcP= ro on the server the connections do not drop. We also made a connection dir= ectly from my computer using pgAdmin and will not lose connection even when I loose it in Pro.  =

My system is as follows:

  1. ArcGIS Enterprise 11.2 Single machine deployment. Server has 32GB of memory=
  2. ArcgisPro 3.3.0
  3. Postgres 15.4 Downloaded from ESRI and on a separate server from enterprise= . Server has 12 cores and 32GB of memory
  4. Both servers are running Windows Server 2022 datacenter Version 21H2.<= o:p>

When the connection drops I get the following message:

Underlying DBMS error [no connection to the server::SQLSTATE=3D=E5] [xxx= xxxx.xxx.GDB_Items][STATE_ID =3D 0]

X's replace actual names.

Working with ESRI we found the following information in the logs :<= /o:p>

"An existing connection was forcibly closed by the remote host" where host is the PostgreSQL Server and "FATAL: terminating connecti= on due to administrator command". The following PostgreS= QL documentation provides more information about the same (https://www.postgresql.org/me= ssage-id/5665.1202148155%40sss.pgh.pa.us [postgresql.org]).

At this time IT says it is not a fire wall issue as there are no rules s= etup for dropping connections. We are at a loss as to what the culprit is.<= o:p>

I will also be posting this in PostgreSQL community to get their input.<= o:p>

Thank you for your help with this.

 

 

This email and any files transmitted with it are confidential and are inten= ded solely for the use of the individual or entity to which they are addres= sed. If you have received this email in error, please respond to the sender= and delete the material from any computer and/or server. The City of Onalaska is subject to Wisconsin Statu= tes relating to public records. Emails sent or received by City employees a= re subject to these laws. Unless otherwise exempted from the public records= law, senders and receivers of City email should presume that the emails are subject to release upon request, = and to state record retention requirements. --_000_842a688946204561ad0787606a644ecfonalaskawigov_--