Hi All, I am new to airbyte. I have configured airbyte mssql connector for cdc and scheduled for every hours to run however, it just hang for more than hour. is there any timeout if there is no new records ? Could you provide me best practice on scheduling cdc sync in mssql ? Thanks Siva

Mssql CDC connector hangs for long time

sivankumar86 June 10, 2022, 7:26am 7

@harshith Thank you for your reply. CPU/memory is usage is ~20% of total memory. I am expecting around ~100 MB data only on this run.

Topic		Replies	Views
MSSQL cdc query runs forever intermittently Connector Questions & Issues source-microsoft-sql-server-mssql , connectors	2	289	November 22, 2022
Source MSSQL connector hang forever intermittently (NPE) Connector Questions & Issues source-microsoft-sql-server-mssql , connectors	6	373	July 14, 2022
Sync usually works, but randomly hangs forever Connector Questions & Issues source-google-ads , source-microsoft-sql-server-mssql , connectors	5	782	August 29, 2022
Source MSSQL - CDC incremental load failed when there is a batch update at source Connector Questions & Issues source-microsoft-sql-server-mssql , data-loading , connectors	2	302	March 7, 2023
SQL Server sync have started failing ingestion CDC incremental Connector Questions & Issues data-loading , connectors	0	270	June 27, 2023