canal-python
canal-python copied to clipboard
不能区分BEGIN ,COMMIT
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秒执行