Is this your first time deploying Airbyte: No OS Version / Instance: AWS EC2 Memory / Disk: 8Gb/30 GB Deployment: Docker Airbyte Version: 0.35.62-alpha Source: MySQL (0.5.6) Destination: Clickhouse (0.1.4) Source name/version: MySQL 8.0.28 Destination name/version: Clickhouse 22.1.3.7 Description: I created a new MySQL source and then a fresh connection from scratch to ClickHouse. When I use the sync mode of

Icremental | Deduped + History

I faced an error that its logs attached. The tables are created but they are empty in the Clickhouse. The exact same steps for MySQL 5.7.33 work fine in the first place. You said you support MySQL 8.0 in the documentation. Right?

loading...

Hi @Arash Layeghi, thank you for taking the time of recording these videos. You say that both database are the same, but how is it possible if they are hosted on different MySQL versions? After switching your source to CDC do you mind resetting your connection?

loading...

@Augustin Lafanechere (Airbyte) I meant that we have two database instances: development and production. development database recently upgraded to MySQL v8.0.28, but the production database is still on v5.7.33. The schema of both instances is the same.

“Hi there! Thank you for your time posting in the [Troubleshooting or whatever] Slack Channel. This week we’re moving our support discussions over to discuss.airbyte.io; if you would be so kind as to post your questions there, you’ll be able ask for help from fellow users as well as the Airbyte team. It is our intention that as of Friday afternoon (Pacific Time) we will lock this channel to everything except administrator posts. We’ll leave everything in place for the rest of April if you need to get information or troubleshooting from existing threads, with the intention of archiving the channel in early May. We really appreciate everyone helping us to build our community, and we’re looking forward to the next phase. Sincerely, the Airbyte team.

Hey @Marcos Marx (Airbyte) I created this issue there: https://discuss.airbyte.io/t/mysql-v8-0-to-clickhouse-incremental-deduped-history-sync-error/445