Connections terminated from the backend results in orphaned connections in ArcMap, ArcCatalog, ArcGIS Pro and the sde_process_information table in PostgreSQL.

Additional Information

Workaround

The pg_terminate_backend command should kill the connections automatically. However, to manually remove the connections and the locks from sde, use the following:

1. Query the sde_process_information table: select * from sde_process_information.
2. Note the orphaned connection “sde_id” value.
3. Run the following queries:

• Remove the connection from SDE: delete from sde_process_information where sde_id = ‘<sde_id>’
• Remove any orphaned state locks: delete from SDE_state_locks where sde_id = ‘<sde_id>';
• Remove any orphaned table locks: delete from SDE_table_locks where sde_id = '<sde_id>';
• Remove any orphaned object locks: delete from SDE_object_locks where sde_id = '<sde_id>';
• Remove any orphaned layer locks: delete from SDE_layer_locks where sde_id = ‘<sde_id>’;

Steps to Reproduce