canal-python icon indicating copy to clipboard operation
canal-python copied to clipboard

不能区分BEGIN ,COMMIT

Open Fanduzi opened this issue 4 years ago • 0 comments

In [48]: EntryProtocol_pb2.EventType.items()                                                                                                                                                                                                                    
Out[48]: 
[('EVENTTYPECOMPATIBLEPROTO2', 0),
 ('INSERT', 1),
 ('UPDATE', 2),
 ('DELETE', 3),
 ('CREATE', 4),
 ('ALTER', 5),
 ('ERASE', 6),
 ('QUERY', 7),
 ('TRUNCATE', 8),
 ('RENAME', 9),
 ('CINDEX', 10),
 ('DINDEX', 11),
 ('GTID', 12),
 ('XACOMMIT', 13),
 ('XAROLLBACK', 14),
 ('MHEARTBEAT', 15)]

BEGIN和COMMIT的header.eventType都是0, 也就是EntryProtocol_pb2.EventType.Name(0)='EVENTTYPECOMPATIBLEPROTO2' 无法区分begin和commit.

还有一个问题是发现经常获取不到COMMIT, 除非COMMIT比事务中最后一个语句晚6秒执行

Fanduzi avatar Aug 30 '20 05:08 Fanduzi