Share via

Synapse Serverless query time out

Marc De Vreese 16 Reputation points
2022-03-24T15:59:41.58+00:00

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 ?

Azure Synapse Analytics
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.


1 answer

Sort by: Most helpful
  1. Marc De Vreese 16 Reputation points
    2022-03-25T15:02:30.447+00:00

    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.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.