Skip to content

[Bug]: Query was canceled by user #22078

@obviousSailfish

Description

@obviousSailfish

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

  1. Connect to database.
  2. Execute query successfully.
  3. 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).
  4. Execute query and receive error.

Affected Area

  • Connection dialog (SQL Server | Azure browse/Fabric browse)
  • Query editor
  • Query results panel
  • Object Explorer
  • GitHub Copilot integration
  • Preview/Edit data
  • Table Designer
  • Schema Designer
  • Schema Compare
  • Local SQL Server Container provisioning
  • SQL database in Fabric provisioning
  • DACPAC/BACPAC export/import
  • SQL Database projects
  • Query Plan Visualizer
  • Other (please describe below)

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

  • I have searched existing issues and couldn't find a match
  • I want to work on this issue

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions