This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Hi,
we have a problem where OPENROWSET based queries on Synapse Serverless SQL that are now running forever. No errors. One of the queries has now been running for 24+ hours. Any queries that only use sys-tables still work. The issue is the same across all the databases in the same Synapse environment and across multiple different data lakes / storage accounts. West Europe region.
I tried to kill the queries using this:
https://learn.microsoft.com/en-us/answers/questions/77884/how-to-cancel-a-synapse-on-demand-query.html (the one suggested by StefanAzaric-MSFT)
but now the killed queries seem to be in a permanent "KILLED/ROLLBACK" state and new queries still do not work.
Since there is no server to restart etc. with on-demand/serverless sql we are stuck. Can anyone help?
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hello @Edwin ,
Thanks for the question and using MS Q&A platform.
This issue looks strange. For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket.
Hello @Edwin ,
Did you get a chance to click on accept it as answer (
) button? This can be beneficial to other community members.
We ultimately deleted the Synapse Workspace and recreated it which fixed the issue. I wish there was someway to hard reset / restart the on-demand "Builtin" sql pool for these types of situations.
Hello @Edwin ,
Glad to know that your issue has resolved.
Unfortunately, there is no way to hard reset / restart the on-demand "Builtin" sql pool for these types of situations.
I would suggest you to provide feedback on the same:
https://feedback.azure.com/d365community/forum/9b9ba8e4-0825-ec11-b6e6-000d3a4f07b8
All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 49%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
I have faced the same issue with Azure Synapse Serverless when querying data lake based external tables (similar if not the same in nature to the OPENROWSET). The queries were hanging for days. Medium priority ticket was resolved by Microsoft engineers on the next day (pretty fast response).
The RCA below - it doesn't look like something that could be addressed without help from the engineering team.
"We identified a FE failover and fixed the issue from our end. Hence, there was a disconnect between the execution nodes which resulted in not generating a query plan and fetching the data remotely.
This is an intermittent issue and may not occur repeatedly.
Next Steps:
We are continuously taking steps to improve the Microsoft Azure Platform and our processes to help ensure such incidents do not occur in the future."
Many thanks,
Rob