Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,239 questions
Synapse Serverless - Deadlock
![](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(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ryan Abbey
1,181
Reputation points
I think this is something I need to raise a support request over but before I do, thought I would see if it's been experienced elsewhere and how it was resolved (more a setting change than a query change as I'm not looking for "row_number" style resolutions)
In our Synapse serverless environment, if we run a "select *" query, it executes fine, however, if we do a "select top 10 *" it fails with
Transaction (Process ID 153) was deadlocked on generic waitable object resources with another process and has been chosen as the deadlock victim. Rerun the transaction
It seems somehow the "top" is causing a lock that then causes the select to deadlock (or vice versa) but why? and is there something we can set to avoid?
{count} votes
-
![](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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,612 Reputation points Microsoft Employee2022-06-17T18:14:57.727+00:00 Hello @Ryan Abbey ,
Thanks for the question and using MS Q&A platform.
It seems like this might be occurring due to an issue on the product side but not 100% sure yet. We have escalated this issue to respective product to investigate and will keep you posted as soon as we hear back from them.
Thank you for your patience. -
KranthiPakala-MSFT 46,612 Reputation points Microsoft Employee
2022-06-23T00:54:14.867+00:00 Hello @Ryan Abbey ,
Just wanted to let you know that I'm still waiting for an update from internal team. Will keep you posted as soon as I have an update.
Thank you for your patience.
-
![](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(313.6, 32%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Anusha A 0 Reputation points2024-03-04T12:05:39.24+00:00 We are facing same issue. We are storing the data in adls as parquet and creating server-less views on it. Select Top is giving deadlock, but select * is working.
Sign in to comment
Sign in to answer