Cancel Does Not Work - Executing Stored Procedure and Queries

[rkdiekhoffwk]

Issue Type: Bug

When attempting to cancel a long-running stored procedure, when click on the 'Cancel' button on the query tab, nothing appears to happen. The stored procedure continues to run, indicated by the timer continuing to run and "Executing query...." message appearing in the status bar.

Azure Data Studio version: azuredatastudio 1.2.4 (1ebfd02, 2018-11-02T21:50:52.634Z)
OS version: Windows_NT x64 10.0.17134

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz (8 x 3592)
GPU Status	2d_canvas: enabled checker_imaging: disabled_off flash_3d: enabled flash_stage3d: enabled flash_stage3d_baseline: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on native_gpu_memory_buffers: disabled_software rasterization: enabled video_decode: enabled video_encode: enabled webgl: enabled webgl2: enabled
Memory (System)	15.89GB (8.31GB free)
Process Argv	C:\Program Files\Azure Data Studio\azuredatastudio.exe
Screen Reader	no
VM	0%

Extensions (2)

Extension	Author (truncated)	Version
agent	Mic	0.35.0
profiler	Mic	0.3.0

[romanovmv]

This syntax is also affected:
declare @i int
while (1=1)
set @i = 1

"Cancel" doesn't stop the query

[Artur2]

@kburtram Same thing when I was connected to database through VPN connection and my VPN connection expired and when I executing any query through Azure Data Studio against that database, cancel button not work.
I think need to control connection how to to close it in the middle when "Cancel" is clicked.

Now cancel is not working and we need to just end of ADS application through task manager.

Not ending application(freezed by unhandled connection issue without timeout) - http://take.ms/FTvLO

[akshayraut-gep]

Updating the latest occurrence of this issue at present, it's not fixed and is very frustrating

[robertgale]

I find this too - any plans to fix this?

[oleksiymumzhu]

2023, still doesnt works...

[smartguest]

@oleksiymumzhu What version of ADS are you using? And what is the query that is not cancelling and the type of server? I am not able to reproduce the issue with

declare @i int
while (1=1)
set @i = 1

on a local server and database.

[ClintThtSpn]

why is this still a problem, almost 5 years to fix? Seriously, there are several issues in ADS that prevent us from moving away from SSMS. Pick one microsoft...

[cheenamalhotra]

Noting down use-case that fails:

1. Reading a large value in resultset, e.g. 10 million character string.
   Not only does it take long time, but also cannot be cancelled.
   Mitigation: Disconnect and reconnect connection.

Let us know if you have more scenarios that we can take a look into.