MySQL CDC sync fails due to zero date in the source

[SteZe85]

Connector Name

source-mysql

Connector Version

3.53.0

What step the error happened?

During the sync

Relevant information

Our MySQL CDC connector (source-mysql, Percona Server 5.7.41-44-log) repeatedly crashes during binlog streaming when it encounters a MySQL zero-date value (0000-00-00 00:00:00)

I found this related PR: #78084

Relevant log output

"internalMessage" : "org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.",
"externalMessage" : "MySQL Connector Error: The sync encountered an unexpected error in the change event producer and has stopped. Please check the logs for details and troubleshoot accordingly.\nhttps://docs.oracle.com/javase/9/docs/api/java/lang/RuntimeException.html",

Caused by: org.apache.kafka.connect.errors.ConnectException: Error while processing event at offset {ts_sec=1783634723, file=mysql-bin.000678, pos=820639837, row=1, server_id=10, event=2}
Caused by: org.apache.kafka.connect.errors.DataException: Invalid value: null used for required field: "date_added", schema type: STRING
	at org.apache.kafka.connect.data.ConnectSchema.validateValue(ConnectSchema.java:224)
	at org.apache.kafka.connect.data.Struct.validate(Struct.java:233)
	at org.apache.kafka.connect.data.Struct.put(Struct.java:216)
	at io.debezium.data.Envelope.update(Envelope.java:308)
	at io.debezium.relational.RelationalChangeRecordEmitter.emitUpdateRecord(RelationalChangeRecordEmitter.java:123)
	at io.debezium.pipeline.EventDispatcher.dispatchDataChangeEvent(EventDispatcher.java:281)

Contribute

• Yes, I want to contribute

---

Internal Tracking: https://github.com/airbytehq/oncall/issues/12600

[octavia-bot]

AI Triage Starting...

Thank you for opening this issue! I'm an AI assistant that will do an initial review and may:

• Ask clarifying questions if needed
• Suggest relevant documentation or workarounds
• Flag this for internal visibility

Note: Community issues are reviewed on a best-effort basis and do not have a guaranteed response time. For additional help:

• Join the Airbyte Community Slack to connect with other users and community members
• If you're an Airbyte Cloud customer, you can open a support ticket or contact your account representative, referencing this issue URL

View playbook

• 🔗 Session URL: https://app.devin.ai/sessions/610277603b384e6aa69a2df3f1e6cbf5

✅ Devin AI session created successfully!

[airbyte-support-bot]

Hi SteZe85, thank you for reporting this and for including the connector version, stack trace, and related PR. We’re reviewing how source-mysql 3.53.0 handles MySQL zero-date values during CDC and will follow up here with findings or internal tracking.

---

Need more help? Join Airbyte Community Slack for peer support, or if you’re a Cloud customer, open a support ticket referencing this URL.

[airbyte-support-bot]

Hi SteZe85, we’ve linked this report to the existing internal investigation: https://github.com/airbytehq/oncall/issues/12600. A related implementation change is under review at #80858; while that review continues, replacing zero-date values in affected required DATE/DATETIME columns with a valid date or timestamp, if feasible, should avoid this failure path.

---

Need more help? Join Airbyte Community Slack for peer support, or if you’re a Cloud customer, open a support ticket referencing this URL.