Spinning wheel never stops

[arnold-overby-SIM]

Type: Bug

When connecting to an Azure SQL Server, the spinning wheel never stops.
In the Output window: 2023-09-15 10:04:05.086 [error] editor input was null 2023-09-15 10:04:06.306 [error] TreeError [ServerTreeView] Data tree node not found: [object Object]: Error: TreeError [ServerTreeView] Data tree node not found: [object Object] at new I (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:68:75822) [] at e.AsyncServerTree.getDataNode (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:826:20315) [] at e.AsyncServerTree.getDataNode (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:1297:10714) [] at e.AsyncServerTree.rerender (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:826:17775) [] at vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:2625:34947 [] at l.invoke (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:180:145) [] at c.deliver (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:180:2468) [] at s.fire (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:180:2001) [] at e.ObjectExplorerService.sendUpdateNodeEvent (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:917:33301) [] at e.ObjectExplorerService.handleSessionCreated (vscode-file://vscode-app/c:/Users/{user-redacted}/AppData/Local/Programs/Azure%20Data%20Studio/resources/app/out/vs/workbench/workbench.desktop.main.js:917:32578) []

Azure Data Studio version: azuredatastudio 1.45.1 (88c21b1725a3e79440027bdb7b5a55fb036be0e2, 2023-08-03T00:42:37.945Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info

|Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-3630QM CPU @ 2.40GHz (8 x 2395)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: unavailable_off
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|7.89GB (0.72GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

Extensions: none

[cssuh]

Hi @arnold-overby-SIM, were you connecting to an azure server? Please follow the github steps to provide any additional logs that might be relevant in this case.

[arnold-overby-SIM]

Hi @arnold-overby-SIM, were you connecting to an azure server? Please follow the github steps to provide any additional logs that might be relevant in this case.

Yes, when I referred to "...connecting to an Azure SQL Server", that is an azure server. Steps to reproduce:

1. Open Azure Data Studio
2. Observe server connections listed under Servers

Some Azure SQL servers show the green dot when connecting, with a spinning circle that never stops, and the node cannot be expanded to see Tables, Views, etc., although queries can be executed successfully. Other Azure SQL servers with a green dot can be expanded to view Tables, Views, etc. Observe Output window and see results similar to what was shared previously, starting with: [error] TreeError [ServerTreeView] Data tree node not found: [object Object]: Error: TreeError [ServerTreeView] Data tree node not found: [object Object]

[github-actions[bot]]

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.

1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio.
2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace.
3. Run the repro scenarios.

4. Collect the following logs:

   Console Logs

   • Open Developer Tools (Help -> Toggle Developer Tools)
   • Click the Console tab
   • Click in the log area and select all text (CTRL+A)
   • Save this text into a file named console.log and attach it to this issue.
   • Developer Tools can be closed via Help -> Toggle Developer Tools

   Application Logs

   • Open command palette (Click View -> Command Palette)
   • Run the command: Developer: Open Logs Folder
   • This will open the log folder locally. Please zip up this folder and attach it to the issue.
5. Now you can revert the Log/Tracing levels changes made in step 1 and step 2.

[anthonylevine]

This issue has been plaguing me for over a year now. I've disabled all plugins, and yet the first 2-3 times I open Azure Data Studio and double-click on the connection icon it will spin, turn green, but refuse to stop spinning, This prevents you from expanding the tables. I've attached both of the requested logs. Hopefully it helps as it;s super frustrating to have to open and close Studio a handful of times each restart. Thanks.

console.log

Additional details: This happens for both local, container SQL Server contains AND Azure SQL databases.

I removed the attachment because I wasn't sure if it contained anything sensitive. Please reach out and I can provide it.