This repository was archived by the owner on Apr 2, 2024. It is now read-only.
This repository was archived by the owner on Apr 2, 2024. It is now read-only.
Unable to kill/terminate long running queries #562
Description
Description:
I have some select queries that have been long running from promscale. They are starting to cause some blocking issues with the maintenance jobs. I have tried to terminate these sessions in multiple different ways but cannot get these to go away.
These sessions cannot be terminated or cancelled through postgres functions or from the shell.
The user has tried below SQL functions but had no luck.
pg_cancel_backend
pg_terminate_backend
Example PromQL query:
sum(container_memory_usage_bytes{node=~"$Node",prometheus_source="$prometheus_source",pod_name=~".+",container=~".+",namespace=~"$namespace"}) by (pod)
Reference:
https://timescaledb.slack.com/archives/C011FC0PPC5/p1667931255049309