Keeps running while in transaction

[acquavivaclaudio]

Type: Bug

begin tran
delete command
exec sp
select
while committing (or even on previous commands), the editor keep "executing query"

Extension version: 1.30.0
VS Code version: Code 1.99.2 (4949701c880d4bdb949e3c0e6b400288da7f474b, 2025-04-10T01:21:25.295Z)
OS version: Windows_NT x64 10.0.26100
Modes:

System Info

Item	Value
CPUs	12th Gen Intel(R) Core(TM) i7-1255U (12 x 2611)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	15.68GB (2.06GB free)
Process Argv	--crash-reporter-id be4b83fa-1a15-441d-a95b-0802ecbe4b43
Screen Reader	no
VM	0%

A/B Experiments

vsliv368:30146709
vspor879:30202332
vspor708:30202333
vspor363:30204092
vscod805cf:30301675
binariesv615:30325510
c4g48928:30535728
azure-dev_surveyone:30548225
a9j8j154:30646983
962ge761:30959799
2e7ec940:31000449
pythontbext0:30879054
cppperfnew:31000557
dwnewjupyter:31046869
pythonrstrctxt:31112756
nativeloc1:31192215
5fd0e150:31155592
dwcopilot:31170013
6074i472:31201624
dwoutputs:31242946
customenabled:31248079
hdaa2157:31222309
copilot_t_ci:31222730
e5gg6876:31282496
pythoneinst12cf:31262606
bgtreat:31268568
4gafe986:31271826
31787653:31262186
3e8i5726:31271747
49da9784:31282606
useunpkgapi:31280918
747dc170:31275177
aj496949:31278748
aj953862:31281341

[kburtram]

Here's a bit more detail on a repro for this bug.

Repro A (blocking while you COMMIT)

You need two connections (two query tabs in VS Code pointing to the same server/db).

Tab 1 – hold a transaction open

USE WideWorldImporters;
GO

-- Make a harmless, reversible lock to demo blocking
BEGIN TRAN;

-- Take an exclusive lock that other sessions will want
UPDATE Warehouse.StockItems
SET CustomFields = CustomFields  -- no-op update to acquire X locks
WHERE StockItemID BETWEEN 1 AND 100;  -- small range is enough

-- DO NOT COMMIT YET

Tab 2 – run something that needs those rows

USE WideWorldImporters;
GO

-- This will block waiting on Tab 1's X locks
SELECT *
FROM Warehouse.StockItems WITH (READCOMMITTEDLOCK)
WHERE StockItemID BETWEEN 1 AND 100;

In Tab 2 you’ll see “Executing query…” with no rows for as long as Tab 1 holds the tran.

Currently the query execution completes in tab1 and releases the transaction.