[source-mysql] MySQL CDC GTID validation can fail with "other is null"

[elegantcoder]

Connector Name

source-mysql

Connector Version

3.51.5

What step the error happened?

During the sync

Relevant information

We observed MySQL CDC failures with the following error:

• Incumbent CDC state is invalid
• java.lang.NullPointerException
• Cannot invoke "io.debezium.connector.mysql.gtid.MySqlGtidSet$UUIDSet.getUUID()" because "other" is null

This came up while validating CDC against a restored MySQL instance used for staging/testing.

Related discussion:

• CDC Replication Error: MySqlDbSet.getUUID() NullPointerException #74305

Upstream Debezium context:

• DBZ-9682 Added a nullity check when Subtracting UUIDSets debezium/debezium#6894
• debezium/debezium@8420613

Findings from investigation:

1. The Bulk Extract CDC toolkit still depended on Debezium 3.1.2.Final.
2. In local validation, moving that dependency line to Debezium 3.4.2.Final removed the GTID null-handling failure
   path.
3. While validating that change, we found that source-mysql was still pinned to Bulk CDK 0.1.77, and the current
   connector sources on master no longer compile cleanly against that stale published artifact.
4. source-mysql also still used the deprecated Jackson API ObjectNode.fields(), which fails under Kotlin -Werror.

This needs to be addressed in two follow-up PRs:

• one PR for the Bulk Extract CDC toolkit Debezium bump
• one PR for source-mysql Bulk CDK alignment and deprecated Jackson API cleanup

Relevant log output

2026-03-27 15:14:01 source ERROR main i.a.c.AirbyteConnectorRunnable(run):38 Failed class io.airbyte.cdk.read.ReadOperation operation execution. io.airbyte.cdk.ConfigErrorException: Incumbent CDC state is invalid, reason: java.lang.NullPointerException: Cannot invoke "io.debezium.connector.mysql.gtid.MySqlGtidSet$UUIDSet.getUUID()" because "other" is null
	at io.airbyte.cdk.read.cdc.CdcPartitionsCreator.run(CdcPartitionsCreator.kt:85) ~[bulk-cdk-toolkit-extract-cdc-0.1.77.jar:?]
	at io.airbyte.cdk.read.FeedReader.createPartitionsWithResources(FeedReader.kt:148) ~[bulk-cdk-core-extract-0.1.77.jar:?]
	at io.airbyte.cdk.read.FeedReader.access$createPartitionsWithResources(FeedReader.kt:35) ~[bulk-cdk-core-extract-0.1.77.jar:?]
	at io.airbyte.cdk.read.FeedReader$createPartitions$3.invokeSuspend(FeedReader.kt:121) ~[bulk-cdk-core-extract-0.1.77.jar:?]
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33) ~[kotlin-stdlib-2.1.10.jar:2.1.10-release-473]
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]
	at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]
	at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:584) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:811) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:715) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:702) ~[kotlinx-coroutines-core-jvm-1.8.1.jar:?]

Stack Trace: io.airbyte.cdk.ConfigErrorException: Incumbent CDC state is invalid, reason: java.lang.NullPointerException: Cannot invoke "io.debezium.connector.mysql.gtid.MySqlGtidSet$UUIDSet.getUUID()" because "other" is null
	at io.airbyte.cdk.read.cdc.CdcPartitionsCreator.run(CdcPartitionsCreator.kt:85)
	at io.airbyte.cdk.read.FeedReader.createPartitionsWithResources(FeedReader.kt:148)
	at io.airbyte.cdk.read.FeedReader.access$createPartitionsWithResources(FeedReader.kt:35)
	at io.airbyte.cdk.read.FeedReader$createPartitions$3.invokeSuspend(FeedReader.kt:121)
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
	at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
	at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
	at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:584)
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:811)
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:715)
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:702)

Contribute

• Yes, I want to contribute

---

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

[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/0e8af5d2362447139a9816224fab4eb7

✅ Devin AI session created successfully!

[devin-ai-integration]

Hi Constantine Kim 김현진 (@elegantcoder), thank you for reporting this issue and for the thorough investigation!

This is a confirmed bug in how Debezium's MySqlGtidSet.subtract() handles GTID sets with mismatched server UUIDs — the NullPointerException occurs when the MySQL server's available GTID set contains UUIDs not present in the saved CDC state (common after failover or replica topology changes on managed MySQL).

Your analysis aligns with the existing internal tracking for this issue, and your finding that upgrading to Debezium 3.4.2.Final resolves the problem is very helpful additional context.

Workaround: In the meantime, you can reset the connection state via the Airbyte UI (Connection → Settings → "Clear data and reset" for affected streams) to force a fresh CDC re-sync.

A draft fix PR is already in progress: airbytehq/airbyte#74306

This issue is being tracked internally: airbytehq/oncall#11532

---

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

[elegantcoder]

Opened follow-up PRs for this issue:

• fix(bulk-extract): bump Debezium to 3.4.2.Final #75559
• fix(source-mysql): align Bulk CDK version and replace deprecated Jackson usage #75560