Azuredatastudio: Query Window "Hang"

Created on 14 Dec 2018 · 6Comments · Source: microsoft/azuredatastudio

Issue Type: Bug

Sometimes the query windows will just "hang" there. Clicking on "Run" does nothing, and there is no error or warning. It just wouldn't execute the query.

Azure Data Studio version: Azure Data Studio 1.2.4 (1ebfd0235690ad044ed2874a02e65188f5fea01c, 2018-11-02T21:36:55.143Z)
OS version: Darwin x64 18.2.0

System Info

|Item|Value|
|---|---|
|CPUs|Intel(R) Core(TM) i7-8750H CPU @ 2.20GHz (12 x 2200)|
|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: enabled
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled|
|Load (avg)|2, 2, 2|
|Memory (System)|16.00GB (0.17GB free)|
|Process Argv|/Applications/Azure Data Studio.app/Contents/MacOS/Electron|
|Screen Reader|no|
|VM|0%|

Extensions (5)

Extension|Author (truncated)|Version
---|---|---
agent|Mic|0.35.0
profiler|Mic|0.3.0
server-report|Mic|0.1.3
whoisactive|Mic|0.1.1
sql-search|Red|0.2.1

Area - Performance Area - Query Editor Bug

Source

zengshengliu

👍3

Most helpful comment

@kburtram Sorry I might have stated it wrong. The UI itself is fine, but no query will execute when its in that state.
What happen is while typing the query, when get to certain part (like the table name), interllisense tries to get the table definition like column names and got blocked, but the user (me) continue the query. After we finish typing and try to execute, nothing will happen. The query doesn't execute, nor does it contains any error message.
There are multiple developers within the company that encounters this issue.

Another issue (maybe) is that the query intellisense uses (one shown on the screenshot), it doesn't get kill when we exit Asure Data Studio. I usually notice a few blocked queries from the activity monitor even after I close (quit) the tool. Exploring the running process does shows that its still running in background.

zengshengliu on 14 Jan 2019

👍3

All 6 comments

After this happen, if I closed the query window and open a new one, a "progress bar" will show on top of the "Search server names" box in Server window. So it looks like there is something running in the background that cause the query window to become unresponsive.

zengshengliu on 14 Dec 2018

I look into it more, it seems like its the intellisense service that is running behind the scene, when it is being blocked on the database side, it render the Azure Data Studio inoperational.

zengshengliu on 3 Jan 2019

@zengshengliu it would be unexpected that the intellisense SQL queries would cause UI delays since they run async in a child process and the UI doesn't block rendering waiting for these tasks (it waits on callback notifications). I'll try to repro the issue.