Statement.cancel() fails to kill running query during result streaming

Statement.cancel() checks for lock absence before killing a query, assuming no query is running.
However, when streaming results, the lock is released while fetching rows, causing cancel() to skip the KILL command even though a query is actively streaming data.