SQL Server sync have started failing ingestion CDC incremental

Tools and Infos:

  • Is this your first time deploying Airbyte?: No

  • OS Version / Instance: Ubuntu on VM

  • Memory / Disk: you can use something like 4Gb / 1 Tb

  • Deployment: Using a instance on VM cloud

  • Airbyte Version: * 0.50.5

  • Source name/version: SQL Server(mssql)

  • Destination name/version: BigQuery

  • Description(Points):
    1 - I have a SQL Server conection Airbyte on cloud that run every day at 05:00 AM
    2 -The first sync(using JDBC) works 100%
    3 - The second sync(using change data capture) works 100%

4 - From now nothing has updated more, but i have a fake positive execution status.

I dont now if this problem is because my table has a biggest volume of data(283 GB) or because my Airbyte isnt supporting collect the CDC logs data:


Looking for the job log i see a message: Producer failure com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.

and other message: The main thread is exiting while children non-daemon threads from a connector are still active.

Just complementing, i have many others conections using CDC and working.

Does anyone know what must be the cause of this? I appreciate any help!