Description
When attempting to execute a query against an Azure SQL Database after leaving Visual Studio Code unattended for a while, query results messages shows "Query was canceled by user". This behavior is new, as you used to be able to leave it unattended for indefinite periods, come back, and continue work.
Other things requiring a database connection also fail - for example, expanding the tables folder in the connections treelist.
The only way to fix the issue is to restart Visual Studio Code. Explicitly disconnecting from the database and reconnecting does not work. I have also tried completely uninstalling/reinstalling Visual Studio Code (including cleaning up all files left behind after uninstalling), and that did not help.
Steps to Reproduce
- Connect to database.
- Execute query successfully.
- Leave Visual Studio Code unattended for a while (two hours is enough, but it is likely less - I'll update this bug with shorter durations if found).
- Execute query and receive error.
Affected Area
If you selected "Other", please describe the affected area
No response
Environment Information
- VS Code Version: 1.119.0
- MSSQL Extension Verison: 1.42.2
- Operating System: macOS Tahoe 26.4.1
- Connection Type: Azure SQL
Confirmation
Description
When attempting to execute a query against an Azure SQL Database after leaving Visual Studio Code unattended for a while, query results messages shows "Query was canceled by user". This behavior is new, as you used to be able to leave it unattended for indefinite periods, come back, and continue work.
Other things requiring a database connection also fail - for example, expanding the tables folder in the connections treelist.
The only way to fix the issue is to restart Visual Studio Code. Explicitly disconnecting from the database and reconnecting does not work. I have also tried completely uninstalling/reinstalling Visual Studio Code (including cleaning up all files left behind after uninstalling), and that did not help.
Steps to Reproduce
Affected Area
If you selected "Other", please describe the affected area
No response
Environment Information
Confirmation