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(153.6, 51%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Hi,
Since this afternoon I'm having issues with all queries on external tables on Azure Synapse SQL on-demand for a synapse workspace. All queries go in time-out.
Started executing query at Line 1
Statement ID: {E941E7FE-FF68-454C-8F18-7B9FFE286B40} | Query hash: 0x261C61940D4BA169 | Distributed request ID: {E9104BBF-2865-40BA-ADC1-51D4D80E378A}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes.
Msg 15884, Level 16, State 1, Line 1
Query timeout expired.
Total execution time: 00:30:00.442
Wait_type for the PID was EDC_EXEC.
Strange thing is that I have an onther Synapse workspace sql on-demand going to the same source (ADL) that has no issues. What could be the problem here and how can I fix this ?
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
![](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(153.6, 11%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Same here. Since 2022-03-24 16:00 CET my queries fail after 30 minutes. Even the select top 100 * from small datasets.
I've raised a support ticket. Will see and update here if relevant.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Marc
is there any way to suppress log message? every time I extract a CSV file from Synapse Serverless through a sqlcmd query in every CSV file at the top has next message "Statement ID: {D689D1D4-18DB-428E-A911-ACC6906B6A5C} | Query hash: 0x3B8F7D06822F509E | Distributed request ID: {9F91D255-8713-4130-B68D-92524781D04D}. Total size of data scanned is 1759 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes."
Thank you in advance
In the meanwhile my problem was fixed by Microsoft support
I apologize for the inconvenience however we've identified a regression in a recent deployment which has resulted in the reported behavior. Our engineering team are currently rolling back the deployment in order to recover the service.
Top! Roll back apparently not yet performed at our environment. Thanks for the info.