search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 898 forks source link

Fragile connection behavior using Serverless Azure SQL database #11153

Open sgellock opened 4 years ago

sgellock commented 4 years ago

Issue Type: Bug

  1. run an Azure SQL Serverless database
  2. connect to the database using Azure Data Studio
  3. once connected, create a new query, File -> New Query
  4. write any simple query against any table you wish. Do not save the query. Leave it in an unsaved query file (e.g. SQLQuery_1)
  5. run the query, see the successful results of the query
  6. now let enough time to pass that the serverless database gets put into a paused state. for me, that's about an hour or so.
  7. once the database is in a paused state, attempt to rerun the query from step 5

results, the query is not able to connect to the database and successfully run.
multiple attempts at running the query produce differing error behavior, and in some cases the query window crashes and is lost. This behavior appears to happen even when the paused database is started and in a running state.

If you create a new query (File -> New Query) and copy and paste the TSQL from the query in step 4 into this new query, it will run successfully

Azure Data Studio version: azuredatastudio 1.19.0 (4095037f2578c23033867e611e82c13de114ca5a, 2020-06-11T22:03:19.036Z) OS version: Darwin x64 19.5.0

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz (12 x 2600)| |GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
oop_rasterization: disabled_off
protected_video_decode: unavailable_off
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
viz_display_compositor: enabled_on
viz_hit_test_surface_layer: disabled_off_ok
webgl: enabled
webgl2: enabled| |Load (avg)|3, 2, 2| |Memory (System)|32.00GB (1.23GB free)| |Process Argv|-psn_0_2273835| |Screen Reader|no| |VM|0%|
Extensions: none
adsbot[bot] commented 4 years ago

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

sgellock commented 4 years ago

8557 is related, but not the same behavior I'm experiencing and tracked with this issue.