Select to view content in your preferred language

Automatically removing dead processes from AWS Aurora PostreSQL Geodatabase

214
1
11-05-2024 09:32 AM
ChrisUnderwood
Esri Regular Contributor

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.

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.

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 ?

0 Kudos
1 Reply
ChrisUnderwood
Esri Regular Contributor

For ref, this was logged as BUG-000172096, "Connections and locks from referenced services are never removed from Amazon Web Services (AWS) Aurora PostgreSQL geodatabase." and is Fixed in "3.5, 11.5, 3.1.8, 3.4.3"

0 Kudos