Cancel query
What: I'm trying to cancel a query that's been running for many hours now but with no success.
Why: I'm trying to remove a table trigger but it doesn't complete. I suppose I can't remove a trigger when there's an active query related to it
How: I've tried a few things with no success so far:
1. In Neon's dashboard I click the menu option (Monitoring -> Active Queries -> Query options -> Cancel query) and nothing happens.
2. Tried running "select pg_terminate_backend(PID)" and, although it returns true meaning that the request was received, it doesn't terminate
3. Tried running "select pg_cancel_backend(PID)" and had the same result as #2
4. DROP TRIGGER also runs indefinitely
The problem is an insert in a table that contains a trigger. This trigger runs a function that calls an extension (rag_bge_small_en_v15.embedding_for_passage()). I tried calling the extension in a separate query and the query doesn't finish (it runs forever), so that shows me that the problem is there.
Why: I'm trying to remove a table trigger but it doesn't complete. I suppose I can't remove a trigger when there's an active query related to it
How: I've tried a few things with no success so far:
1. In Neon's dashboard I click the menu option (Monitoring -> Active Queries -> Query options -> Cancel query) and nothing happens.
2. Tried running "select pg_terminate_backend(PID)" and, although it returns true meaning that the request was received, it doesn't terminate
3. Tried running "select pg_cancel_backend(PID)" and had the same result as #2
4. DROP TRIGGER also runs indefinitely
The problem is an insert in a table that contains a trigger. This trigger runs a function that calls an extension (rag_bge_small_en_v15.embedding_for_passage()). I tried calling the extension in a separate query and the query doesn't finish (it runs forever), so that shows me that the problem is there.
