JN wrote:
> Hi, I'm trying to cancel a long-running statement (takes about 400
> seconds) by calling PreparedStatement.cancel() from another thread,
> but it's not working. Specifically, the call to
> PreparedStatement.cancel() completes normally, but the executing
> statement seems to complete normally (i.e., it still takes the same
> amount of time to complete, and it does not throw any exception). The
> sql being executed is a delete ("delete from qos_data where
> report_time < ?"). Is PreparedStatement.cancel() not implemented?
It is implemented, but it just requests that the backend cancels any
query in progress - there are no guarantees that it will be effective.
Does the query get canceled if you manually send a SIGINT to the
relevant backend?
-O
