search

astronomer / astro-sdk

Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow.
https://astro-sdk-python.rtfd.io/
Apache License 2.0
329 stars 40 forks source link

Look into example_transform_mssql intermittent failure #2095

Open vatsrahul1001 opened 6 months ago

vatsrahul1001 commented 6 months ago

We have noticed example_transform_mssql DAG sometimes fails with timeout error, This issue is to address failure

pymssql._pymssql.OperationalError: (40613, b"Database 'astromssqldb' on server 'astromssqlserver.database.windows.net' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '{77552186-180C-4873-B9FF-BED89116AEA9}'.DB-Lib error message 20018, severity 20:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (astromssqlserver.database.windows.net)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (astromssqlserver.database.windows.net)\n")