Notebooks: get "Spark kernels require a connection to a SQL Server big data cluster" when 1 connection is still connecting

[adsbot[bot]]

Issue Type: Bug

Really fun one:

• Define a connection to a server that doesn't exist
• Try to connect (it'll spin for a minute)
• While that's connecting, open another SQL Server big data cluster in object explorer, right-click and do New Notebook
• Change kernel from SQL -> PySpark3

Expected:

• Kernel change works Actual:
• Kernel change fails with error Spark kernels require a connection to a SQL Server big data cluster

Something is going wrong here, and I would have to guess the Jupyter kernel is getting the wrong connection . This needs investigating as there are other scenarios this could go wrong.

Azure Data Studio version: azuredatastudio 1.5.0 (9ca6200018fc206d67a47229f991901a8a453781, 2017-12-15T12:00:00.000Z) OS version: Darwin x64 18.2.0

System Info

|Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-4770HQ CPU ! 2.20GHz (8 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, 3, 3| |Memory (System)|16.00GB (0.18GB free)| |Process Argv|. --remote-debugging-port=9222 --no-first-run --no-default-browser-check --inspect=5875 --no-cached-data| |Screen Reader|no| |VM|0%|

Extensions (3)

Extension|Author (truncated)|Version ---|---|--- newdatabase|kev|0.0.3 server-report|Mic|0.1.5 queryplan-show|phi|0.0.2

[adstestbot[bot]]

Thanks for submitting this issue. Please also check if it is already covered by an existing one, like:

• Revise error msg: Connection is not valid for the kernel: PySpark3. A SQL Server Big Data Cluster connection is required for Spark kernels. (#3940)