public inbox for [email protected]help / color / mirror / Atom feed
Dropping connections 4+ messages / 3 participants [nested] [flat]
* Dropping connections @ 2024-06-26 17:44 Tarras, Tim <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Tarras, Tim @ 2024-06-26 17:44 UTC (permalink / raw) To: [email protected] <[email protected]> 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 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 enterprise Database connections dropping to my computer. If I work with ArcPro on the server the connections do not drop. We also made a connection directly 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. When the connection drops I get the following message: Underlying DBMS error [no connection to the server::SQLSTATE=å] [xxxxxxx.xxx.GDB_Items][STATE_ID = 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 administrator command". The following PostgreSQL documentation provides more information about the same (https://www.postgresql.org/message-id/5665.1202148155%40sss.pgh.pa.us [postgresql.org]<https://urldefense.com/v3/__https:/www.postgresql.org/message-id/5665.1202148155*40sss.pgh.pa.us__;J...;). At this time IT says it is not a fire wall issue as there are no rules setup 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 intended solely for the use of the individual or entity to which they are addressed. 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 Statutes relating to public records. Emails sent 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. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Dropping connections @ 2024-06-26 18:35 Adrian Klaver <[email protected]> parent: Tarras, Tim <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Adrian Klaver @ 2024-06-26 18:35 UTC (permalink / raw) To: Tarras, Tim <[email protected]>; [email protected] <[email protected]> On 6/26/24 10:44 AM, Tarras, Tim wrote: > Hello, > > Underlying DBMS error [no connection to the server::SQLSTATE=å] > [xxxxxxx.xxx.GDB_Items][STATE_ID = 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 > administrator command*". The following PostgreSQL documentation provides > more information about the same I see *FATAL: terminating connection due to administrator command*" and Windows my first thought is Windows Anti-Virus program hitting the Postgres server. Is there an AV program running on the Windows Server 2022 server? It would also be helpful to get the Postgres log entries immediately prior to lines you show above. -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [External] Dropping connections @ 2024-06-26 19:56 Tarras, Tim <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Tarras, Tim @ 2024-06-26 19:56 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; [email protected] <[email protected]> Windows Defender is turned off and a 3rd party AV is being used. We did ask about that and were told that would not be the issue. I would also think that I would be dropping the connection when I am on the Server itself which is not the case. I have attached the log files with the Errors highlighted in Yellow Go to last page in each one. In reading the whole error the password authentication failed for the postgres user, which is not the user we are logged in as to this database. -----Original Message----- From: Adrian Klaver <[email protected]> Sent: Wednesday, June 26, 2024 1:35 PM To: Tarras, Tim <[email protected]>; [email protected] Subject: Re: [External] Dropping connections On 6/26/24 10:44 AM, Tarras, Tim wrote: > Hello, > > Underlying DBMS error [no connection to the server::SQLSTATE=å] > [xxxxxxx.xxx.GDB_Items][STATE_ID = 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 administrator command*". The following PostgreSQL > documentation provides more information about the same I see *FATAL: terminating connection due to administrator command*" and Windows my first thought is Windows Anti-Virus program hitting the Postgres server. Is there an AV program running on the Windows Server 2022 server? It would also be helpful to get the Postgres log entries immediately prior to lines you show above. -- Adrian Klaver [email protected] This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. 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 Statutes relating to public records. Emails sent 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. Attachments: [application/vnd.openxmlformats-officedocument.wordprocessingml.document] postgresql-2024-06-17_000000_20240617182231.docx (15.4K, 2-postgresql-2024-06-17_000000_20240617182231.docx) download [application/vnd.openxmlformats-officedocument.wordprocessingml.document] postgresql-2024-06-17_112304_20240617182229.docx (14.7K, 3-postgresql-2024-06-17_112304_20240617182229.docx) download ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Dropping connections @ 2024-06-27 03:47 Kashif Zeeshan <[email protected]> parent: Tarras, Tim <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Kashif Zeeshan @ 2024-06-27 03:47 UTC (permalink / raw) To: Tarras, Tim <[email protected]>; +Cc: [email protected] <[email protected]> Hi Tarras Please refer to the following guide where connection was working fine with PG and EPAS. https://www.enterprisedb.com/docs/partner_docs/EsriArcGISProandEsriArcGISEnterprise/04-ConfiguringEs... Regards Kashif Zeeshan On Wed, Jun 26, 2024 at 10:45 PM Tarras, Tim <[email protected]> wrote: > 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 > 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 > enterprise Database connections dropping to my computer. If I work with > ArcPro on the server the connections do not drop. We also made a connection > directly 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. > > When the connection drops I get the following message: > > Underlying DBMS error [no connection to the server::SQLSTATE=å] > [xxxxxxx.xxx.GDB_Items][STATE_ID = 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 > administrator command*". The following PostgreSQL documentation provides > more information about the same (https://www.postgresql.org/message-id/5665.1202148155%40sss.pgh.pa.us > [postgresql.org] > <https://urldefense.com/v3/__https:/www.postgresql.org/message-id/5665.1202148155*40sss.pgh.pa.us__;J...; > ). > > At this time IT says it is not a fire wall issue as there are no rules > setup 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 > intended solely for the use of the individual or entity to which they are > addressed. 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 Statutes relating to public records. > Emails sent 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. > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-06-27 03:47 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-06-26 17:44 Dropping connections Tarras, Tim <[email protected]> 2024-06-26 18:35 ` Adrian Klaver <[email protected]> 2024-06-26 19:56 ` Tarras, Tim <[email protected]> 2024-06-27 03:47 ` Kashif Zeeshan <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox