Ran into an issue where SQL Server CDC change tables showed some change records that did not make it to the topic in Confluent.
Does anyone have any troubleshooting/investigation tips to dig into why this might have happened? I reviewed the connect logs for the timeframe in which the change records showed up in SQL server, but found no errors or anything else that might indicate an issue.
I was thinking about trying to review the offset topic to see if there was a jump in log sequence numbers or something like that, but that seemed like a pretty daunting task to take that and try to map it back to the change records in SQL Server.
Any ideas?