Synapse Serverless SQL request keeps running forever when using pyodbc connection

Question

Synapse Serverless SQL request keeps running forever when I try to connect its database through pyodbc connection and make the request 'Create Schema XXX' remotely.

There is no option available to stop or abort the process through the synapse workspace.

I have no choice but delete the entire synapse workspace and recreate. Is there any solution to solve this issue?

Please help

Answer 1

@Feng, QingTang - Thanks for the question and using MS Q&A platform.

Unfortunately, there is no way to stop/restart the on-demand "Builtin" sql pool for these types of situations.

If you have a long-running query or process that you want to cancel or abort in Synapse Serverless SQL pool, you can use the "Cancel Query" feature in the Synapse Studio. Here are the steps to do so:

1. Open the Synapse Studio and navigate to the "SQL scripts" tab.
2. Find the query or process that you want to cancel in the "Recent scripts" or "Recent queries" section.
3. Click on the query or process to open it.
4. Click on the "Cancel Query" button in the toolbar at the top of the screen.
5. Confirm that you want to cancel the query or process by clicking "Yes" in the confirmation dialog box.

Note that the "Cancel Query" feature is only available for queries or processes that are currently running. If the query or process has already completed, the "Cancel Query" button will be disabled.

For more details, refer to How to cancel a synapse on-demand query? which addressing similar issue.

And also, check to see if you have any running sql request which you are running on Serverless sql pool from monitoring page as shown.

For more details, refer to Monitoring Synapse serverless SQL pool query history

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.