microsoft / vscode-mssql

Visual Studio Code SQL Server extension.
Other
1.53k stars 455 forks source link

When attempting to run a query "Executing Query" is show in the statusbar but the actual query does not run #17433

Open mkey opened 2 years ago

mkey commented 2 years ago

Steps to Reproduce:

  1. I connect to various databases all day long, mostly in Azure
  2. I execute the query and can see this in the status bar on the below right-hand side:

ExecutingQuery

But the query does not appear to have been sent to the SQL server, the query stop button is not there on the top right-hand side:

QueryNotRunning

This can get stuck for minutes at a time (=quite annoying especially when one is very busy). Typically, after a few minutes, it will just run the query and you get back the result. Sometimes it will get unstuck if I disconnect and reconnect the VPN, but usually, I just restart VSC and hope it will let me proceed.

Notes:

image

My working theory is that there might be some lag in the connection that is making VSC/MSSQL extension go bonkers from time to time, while other applications (DBeaver, a node script I wrote using node mssql library) are not affected by the same.

My installed extensions:

Extensions

More details on VSC:

VSC_version

Thanks for your time, Marko

mkey commented 2 years ago

A quick addendum: this has been going on and off for a while now. I have been using VSC/MSSQL for maybe a year and this has been with me. I'd mostly like to understand if this is related to my environment and how to confirm if so.

mkey commented 1 year ago

After more testing, I can confirm that by restarting VSC the issue will go away, at least temporarily.