Been struggling with this issue for weeks now. Long story short, we try to create a Debezium connector and for various reasons it might fail. This creates an issue when trying to recreate the connector. Subsequent recreates fail with the following exception: The db history topic or its content is fully or partially missing. Please check database history topic configuration and re-execute the snapshot. and we have NOT found a way around this except to recreate the connector with a different name which is NOT what we want to do.
We are thinking the issue is during the first connector creation, an internal offset is stored somewhere and linked to that connector name but the issue is there is no way to clear or delete this. I have seen where if we wait 7 days maybe it eventually gets purged or cleared but we can’t work like this…we need a way to re-configure, delete and re-add, update…something to resolve this connector issue, even if it means deleting the history topic and starting over.