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	291	November 22, 2022
Source MSSQL connector hang forever intermittently (NPE) Connector Questions & Issues source-microsoft-sql-server-mssql , connectors	6	381	July 14, 2022
Sync usually works, but randomly hangs forever Connector Questions & Issues source-google-ads , source-microsoft-sql-server-mssql , connectors	5	797	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	311	March 7, 2023
Source MSSQL - initial load is very slow (CDC run) Connector Questions & Issues source-microsoft-sql-server-mssql , data-loading , connectors	3	1108	July 2, 2022