Hi. I’ve setup a MySQL<>Snowflake connection...
# ask-community-for-troubleshooting
a
Hi. I’ve setup a MySQL<>Snowflake connection using CDC from MySQL. It works great for exactly 24 hours then stops processing changes from the source. It states the sync has succeeded yet no records are emitted or committed. Lost on why. Can anyone provide an assist?
u
Hi, Andrew! Could you please give ma bit more info: 1. Airbyte version 2. Connector versions 3. Any sync logs Thanks!
a
Hi @Nataly Merezhuk (Airbyte). Thanks for looking into this, requested details are below; 1. Airbyte version 0.40.17 2. MySQL currently 1.0.9 but initial loads were on 1.0.7. Snowflake 0.4.38 3. Logs attached 138 is the last sync that worked, 140 is the first sync with 0 records
HI. Is there any update on this please?
u
Hi, Andrew! Apologies for the wait. I've been looking into this and can't put my finger on what is wrong - it seems that the source does not emit any records in that 140 sync log. I'm looking further into this, but I know there have been some issues with CDC sync. I hope to have some more debugging ideas for you in the next few days!
a
@Nataly Merezhuk (Airbyte) Thanks for the update! Appreciate any insight you can assist with. It’s interesting also that the timing is exactly 24 hours after start of the connector. I’ve tried recreating and it does exactly the same thing.
Any update on this?
u
Hi, Andrew! It seems this issue has popped up for multiple users, I am tracking down the correct GitHub issue and will update soon.
a
HEllo any update on this?
n
Hi! I've found an issue regarding this that's already open on GitHub: https://github.com/airbytehq/airbyte/issues/17512 Could you please comment on that thread and include your logs? As one of the connectors (Snowflake) is a GA connector, I will ping the team to prioritize this!