[CDCSDK] Data loss issue observed in explicit transaction case

[ShikharSahay]

Jira Link: DB-12950

Description

Data loss issue -
https://yugabyte.slack.com/archives/C03H4D4EVC6/p1726830498915699?thread_ts=1726552870.277439&cid=C03H4D4EVC6

Stress run - http://stress.dev.yugabyte.com/stress_test/0ee5eaf2-c733-4f6f-b690-963b12da72b7

Yb Version - 2024.1.3.0-b70

Source connector version

quay.io/yugabyte/debezium-connector:dz.1.9.5.yb.grpc.2024.1

Connector configuration

add connector connector_name='ybconnector_cdc_5a7e2c_table_1' stream_id='d8b8f517c7ccc786c44aefafc3b61b04' db_name='cdc_5a7e2c' connector_host='172.151.27.12' table_list=['table_1'] {'name': 'ybconnector_cdc_5a7e2c_table_1', 'config': {'database.master.addresses': '172.151.26.210:7100,172.151.21.192:7100,172.151.18.131:7100', 'database.hostname': '172.151.26.210:5433,172.151.21.192:5433,172.151.18.131:5433', 'database.port': 5433, 'database.masterhost': '172.151.21.192', 'database.masterport': '7100', 'database.user': 'yugabyte', 'database.password': 'yugabyte', 'database.dbname': 'cdc_5a7e2c', 'snapshot.mode': 'never', 'admin.operation.timeout.ms': 600000, 'socket.read.timeout.ms': 300000, 'max.connector.retries': '10', 'operation.timeout.ms': 600000, 'topic.creation.default.compression.type': 'lz4', 'topic.creation.default.cleanup.policy': 'delete', 'topic.creation.default.partitions': 2, 'topic.creation.default.replication.factor': '1', 'tasks.max': '1', 'connector.class': 'io.debezium.connector.yugabytedb.YugabyteDBgRPCConnector', 'database.server.name': 'db_cdc', 'database.streamid': 'd8b8f517c7ccc786c44aefafc3b61b04', 'table.include.list': 'public.table_1'}}

YugabyteDB version

2024.1.3.0-b70

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.