Clarity GCP - PG error - FATAL: terminating connection due to administrator command
search cancel

Clarity GCP - PG error - FATAL: terminating connection due to administrator command

book

Article ID: 250615

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We see the error in logs on a process/job or another Clarity action:

  • Error message: FATAL: terminating connection due to administrator command
  • SQL error code: 0
  • Error message: An I/O error occurred while sending to the backend.

Environment

Release : Any

Resolution

  • This error is thrown when a SQL query has been killed at the backend
  • Usually no action is required for OOTB queries and actions.
  • Typically occurs with very long running queries or idle queries
  • If this is happening on a custom job or report, consider tuning / optimizing your code 
  • You may review an explain plan to understand which part has to be optimized
  • Contact Broadcom Support if assistance is needed