Cannot execute a query

[romanovmv]

Issue Type: Bug

Query window ocasionally stops responding to Execute query command, meanwhile the following queries can be traced via SQL Profiler:
exec sp_executesql N'select c.definition,convert(bit,OBJECTPROPERTY(c.object_id,N''ExecIsQuotedIdentOn'')) from [OmniMeta].sys.sql_modules c where c.object_id = @_msparam_0',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'303808640'

Those queries are initiated by sqlops-languageService application. Looks like it's a part ob built in intellisense running synchronously under the same SPID?

Azure Data Studio version: Azure Data Studio 1.3.9 (cacf077, 2019-01-14T23:17:16.459Z)
OS version: Darwin x64 18.2.0

System Info

Item	Value
CPUs	Intel(R) Core(TM) i5-8259U CPU @ 2.30GHz (8 x 2300)
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.99GB free)
Process Argv	/private/var/folders/x7/rfbbhss14_lft0f2zyn5tk9w0000gn/T/AppTranslocation/159C6862-A3C3-47BC-9371-41EEA6716B0E/d/Azure Data Studio.app/Contents/MacOS/Electron
Screen Reader	no
VM	0%

Extensions (2)

Extension	Author (truncated)	Version
agent	Mic	0.35.2
profiler	Mic	0.5.1

[kburtram]

@romanovmv does the UI freeze or clicking the "Execute" button just doesn't do anything? Do you know if there are any additional repro steps, such as canceling a previously executing query or something like that?

[romanovmv]

@kburtram it does nothing, I've attached a sample video. But normally it's stuck for ~10-30 seconds. I've also noticed that it happens mostly when working on our US servers (ping from Australia is about 200ms).
https://drive.google.com/open?id=1Bds2uHxkguJvibim0w1K0H2VR5q7Xpm9

[anthonydresser]

Could be related to #2694

[anthonydresser]

related to #3627

[cheenamalhotra]

This issue has been addressed in the latest insiders build, closing as resolved.