topic Automatically removing dead processes from AWS Aurora PostreSQL Geodatabase in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/automatically-removing-dead-processes-from-aws/m-p/1555508#M9386 <P>Hello Geodatabase, when using an AWS Aurora PostgreSQL Geodatabase I am seeing dead processes permanently left in the sde_process_information table, and their associated locks in the sde_table_locks table.</P> <P>While a dead process can sometimes occur, on a non-AWS Geodatabase this is removed after a while, but on an AWS Aurora PostgreSQL Geodatabase Geodatabase it remains permanently.</P> <P>I believe the Geodatabase function SDE_PURGE_PROCESSES should be tidying these up, but on AWS Aurora PostreSQL this seems to be failing. Does anyone have any suggestions or recommendations around this ?</P> Tue, 05 Nov 2024 17:32:38 GMT ChrisUnderwood 2024-11-05T17:32:38Z Automatically removing dead processes from AWS Aurora PostreSQL Geodatabase https://community.esri.com/t5/geodatabase-questions/automatically-removing-dead-processes-from-aws/m-p/1555508#M9386 <P>Hello Geodatabase, when using an AWS Aurora PostgreSQL Geodatabase I am seeing dead processes permanently left in the sde_process_information table, and their associated locks in the sde_table_locks table.</P> <P>While a dead process can sometimes occur, on a non-AWS Geodatabase this is removed after a while, but on an AWS Aurora PostgreSQL Geodatabase Geodatabase it remains permanently.</P> <P>I believe the Geodatabase function SDE_PURGE_PROCESSES should be tidying these up, but on AWS Aurora PostreSQL this seems to be failing. Does anyone have any suggestions or recommendations around this ?</P> Tue, 05 Nov 2024 17:32:38 GMT https://community.esri.com/t5/geodatabase-questions/automatically-removing-dead-processes-from-aws/m-p/1555508#M9386 ChrisUnderwood 2024-11-05T17:32:38Z Re: Automatically removing dead processes from AWS Aurora PostreSQL Geodatabase https://community.esri.com/t5/geodatabase-questions/automatically-removing-dead-processes-from-aws/m-p/1606541#M9567 <P>For ref, this was logged as&nbsp;BUG-000172096, "<EM>Connections and locks from referenced services are never removed from Amazon Web Services (AWS) Aurora PostgreSQL geodatabase</EM>." and is Fixed in "<EM>3.5, 11.5, 3.1.8, 3.4.3</EM>"</P> Wed, 16 Apr 2025 16:20:39 GMT https://community.esri.com/t5/geodatabase-questions/automatically-removing-dead-processes-from-aws/m-p/1606541#M9567 ChrisUnderwood 2025-04-16T16:20:39Z