airbyte 2.1.0 stop to pull cdc data from mariadb, it is doing sync, but always with 0 records

There are a few known issues that could explain why your Airbyte 2.1.0 CDC sync from MariaDB returns 0 records. Here's what the knowledge sources indicate: Known Causes for 0 Records with MariaDB CDC 1. MariaDB CDC Compatibility Limitations The official docs note that MariaDB is a MySQL fork and the MySQL source connector has known limitations with CDC replication on MariaDB. If you encounter errors with CDC, the recommendation is to switch to a different replication method (e.g., cursor-based/Standard). [MySQL Troubleshooting] 2. Microsecond Precision Bug (Cursor-Based) If you're using cursor-based replication with a

DATETIME(6)

cursor field, there is a known bug where microseconds are truncated in the actual SQL query sent to the DB, causing 0 records to be returned even when matching records exist. This affects MariaDB 10.11 on RDS specifically. [GitHub Issue #76309] 3. Filtered-Out CDC Events A pattern seen with CDC connectors is that all received events get filtered out, so no offset is committed and 0 records are synced. This can happen if your tables don't match the configured filters or if heartbeat events are not enabled. [Forum Post] 4. Binlog / Offset Issues CDC returning 0 records can also occur when the binlog position has advanced past what Debezium expects, or when the saved offset is no longer valid. Recommended Actions 1. Switch replication method: Try switching from CDC to Standard (cursor-based) replication, as CDC has known compatibility issues with MariaDB. [MySQL Troubleshooting] 2. Check binlog retention: Ensure binlogs are not being purged between syncs. 3. Trigger a full resync: Reset the connection state to force a fresh snapshot. 4. Check JDBC parameters: Try adding

serverTimezone

to your JDBC URL if you see timezone-related errors in logs. [Forum Post] > Note: The knowledge sources do not contain a specific fix for CDC returning 0 records on MariaDB in Airbyte 2.1.0. If the above steps don't resolve the issue, consider opening a GitHub issue with your full logs for further investigation. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.