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.56k stars 899 forks source link

Trying to Reconnect a Disconnected Query Crashes ADS #23301

Closed XMLDiva closed 1 year ago

XMLDiva commented 1 year ago

Type: Bug

If I open ADS with a query that I had open, if I try to click on "Connect" and then choose from my list of saved server connection strings, ADS will crash right after clicking the connect button. This happens for both Azure instances as well as hosted local sql servers.

Additionally this works the same with notebooks. I cannot try to connect it to a server without it crashing. Making them and any saved query unusable.

I must copy the query, right click on the saved server, do New Query, and then paste the code in it.

Azure Data Studio version: azuredatastudio 1.44.0 (31bee67f005648cdc9186f28ef39b4f1d6585e0f, 2023-05-19T16:50:03.880Z) OS version: Darwin arm64 22.3.0 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|Apple M1 Max (10 x 24)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
skia_renderer: enabled_on
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: disabled_off| |Load (avg)|5, 4, 3| |Memory (System)|64.00GB (3.31GB free)| |Process Argv|| |Screen Reader|yes| |VM|0%|
Extensions (23) Extension|Author (truncated)|Version ---|---|--- demo-mode|dre|1.1.1 copilot|Git|1.82.15 newdatabase|kev|1.0.0 ssmskeymap|kev|1.1.0 mssql-db-insights|mat|0.2.2 admin-pack|Mic|0.0.2 agent|Mic|0.49.0 cms|Mic|0.9.3 dacpac|Mic|1.13.0 import|Mic|1.5.5 powershell|ms-|2022.7.2 profiler|Mic|0.12.2 query-history|Mic|0.5.3 schema-compare|Mic|1.19.0 server-report|Mic|0.2.4 sql-assessment|Mic|0.6.4 sql-database-projects|Mic|1.1.1 whoisactive|Mic|0.1.5 azdata-sanddance|msr|4.0.1 sqlops-spexecutesql-to-sql|pej|1.0.2 schema-visualization|R0t|0.8.2 simple-data-scripter|sea|0.1.6 vscodeintellicode|Vis|1.2.1
github-actions[bot] commented 1 year ago

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart ADS and repro your issue. Next there are two types of logs to collect:

Console Logs

cheenamalhotra commented 1 year ago

Hi @XMLDiva

I couldn't reproduce the issue by using steps above, please upload logs for investigation.

XMLDiva commented 1 year ago

Hi @cheenamalhotra ,

LogFile.zip

Attached log files after setting tracing to all attached.

cheenamalhotra commented 1 year ago

These are normal logs. I don't see any error here. Can you check a different folder in the logs directory that contains any error?

cheenamalhotra commented 1 year ago

@XMLDiva

Can you please confirm if this issue still occurs for you using the latest insiders build?

cssuh commented 1 year ago

Closing as no relevant logs were provided