Intermittent but frequent Azure Synapse Serverless pool warming up error !!

ManiK 21 Reputation points
2021-11-25T18:13:45.553+00:00

Hello,

I have been getting below error randomly / intermittently, but frequent i.e. every after 3-4 days. I have just one pipeline that runs once a day only. In that pipeline I have one Stored Procedure activity that runs in the last and auto creates external tables based out of data-lake .parquet files structure.

"Execution fail against sql server. Sql error number: 42109. Error Message: The SQL pool is warming up. Please try again."

How to avoid this or fix this issue permanently ? Is there a way to add an intermediate activity (like via an API endpoint call similar to how we resume/pause SQL dedicated pools ?) to ping/initialize Serverless pool and wait until it's up & running and then run the SP activity ??

Of course, I can setup retry + retry interval settings in the SP activity. However, would like to understand why it's happening randomly and frequently and if there's a better way to handle it ? Had also checked Azure service availability (Synapse serverless pools) around same time of the error, but couldn't find any issues in any region.

Thanks!

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.
2,625 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ManiK 21 Reputation points
    2021-12-01T11:29:43.12+00:00

    Below is the link shared by MS support team: - that it's a transitive error and that it would get succeed in next retry attempt; which is what have been doing already.

    https://learn.microsoft.com/sr-cyrl-rs/sql/relational-databases/errors-events/mssqlserver-42109-database-engine-error?view=sql-server-ver15