The STALLED state indicates that, at the time of the snapshot, the statement had an open cursor and was waiting for the client to resume fetching rows.

Display active queries, excluding those running in your connection

Monitoring tables are read-only. However, the server has a built-in mechanism for deleting (and only deleting) records in the MON$STATEMENTS table, which makes it possible to cancel a running query.

Notes

• After a query is cancelled, calling execute/fetch API functions will return an error with the isc_cancelled code

ExampleCancelling all active queries for the specified connection: