发现了事件怎么都 skip event 都跳过去了 ,没有同步 ,另外之前也没有成功初始化dm_tidb_test库的同步
[2020/02/18 10:54:15.240 +08:00] [INFO] [relay.go:113] [“current earliest active relay log”] [task=127190_to_gs_heming] [unit=“binlo
g replication”] [“active relay log”=1bfe5e41-adfe-11e9-988b-b8ca3a621608.000001/mysql-bin.001533]
[2020/02/18 10:54:15.449 +08:00] [INFO] [syncer.go:1599] [task=127190_to_gs_heming] [unit=“binlog replication”] [event=query] [state
ment=“CREATE TABLE user_hem
(\
id
int(11) NOT NULL DEFAULT ‘0’,\
card
varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT
‘编号’,\
name
varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘姓名’,\
equipment_id
int(11) DEFAULT NULL COMMENT '设备id
',\
area_id
int(10) DEFAULT NULL COMMENT ‘区域ID’,\
start_time
datetime DEFAULT NULL COMMENT ‘开始时间’,\
end_time
datet
ime DEFAULT NULL COMMENT ‘结束时间’,\
ifdel
int(11) DEFAULT ‘0’ COMMENT ‘0:使用,1:已移除’\
) ENGINE=InnoDB DEFAULT CHARSET=utf
8 COLLATE=utf8_bin”] [schema=dm_tidb_test] [“last position”="(mysql-bin|000001.001533, 50384)"] [position="(mysql-bin|000001.001533,
51093)"] [“gtid set”=NULL]
[2020/02/18 10:54:15.455 +08:00] [INFO] [syncer.go:1615] [“resolve sql”] [task=127190_to_gs_heming] [unit=“binlog replication”] [eve
nt=query] [“raw statement”=“CREATE TABLE user_hem
(\
id
int(11) NOT NULL DEFAULT ‘0’,\
card
varchar(32) CHARACTER SET utf8
DEFAULT NULL COMMENT ‘编号’,\
name
varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘姓名’,\
equipment_id
int(11) DEFAUL
T NULL COMMENT ‘设备id’,\
area_id
int(10) DEFAULT NULL COMMENT ‘区域ID’,\
start_time
datetime DEFAULT NULL COMMENT '开始时间
',\
end_time
datetime DEFAULT NULL COMMENT ‘结束时间’,\
ifdel
int(11) DEFAULT ‘0’ COMMENT ‘0:使用,1:已移除’\
) ENGINE=Inno
DB DEFAULT CHARSET=utf8 COLLATE=utf8_bin”] [statements="[“CREATE TABLE IF NOT EXISTS dm_tidb_test
.user_hem
(id
INT(11) NOT NU
LL DEFAULT ‘0’,card
VARCHAR(32) CHARACTER SET UTF8 DEFAULT NULL COMMENT ‘编号’,name
VARCHAR(32) CHARACTER SET UTF8 DEFAULT NULL
COMMENT ‘姓名’,equipment_id
INT(11) DEFAULT NULL COMMENT ‘设备id’,area_id
INT(10) DEFAULT NULL COMMENT ‘区域ID’,start_time
DAT
ETIME DEFAULT NULL COMMENT ‘开始时间’,end_time
DATETIME DEFAULT NULL COMMENT ‘结束时间’,ifdel
INT(11) DEFAULT ‘0’ COMMENT ‘0:使
,1:已移除’) ENGINE = InnoDB DEFAULT CHARACTER SET = UTF8 DEFAULT COLLATE = UTF8_BIN”]"] [schema=dm_tidb_test] [“last position”="(
mysql-bin|000001.001533, 51093)"] [position="(mysql-bin|000001.001533, 51093)"] [“gtid set”=NULL]
[2020/02/18 10:54:15.457 +08:00] [WARN] [syncer.go:1647] [“skip event”] [task=127190_to_gs_heming] [unit=“binlog replication”] [even
t=query] [statement=“CREATE TABLE IF NOT EXISTS dm_tidb_test
.user_hem
(id
INT(11) NOT NULL DEFAULT ‘0’,card
VARCHAR(32) CHAR
ACTER SET UTF8 DEFAULT NULL COMMENT ‘编号’,name
VARCHAR(32) CHARACTER SET UTF8 DEFAULT NULL COMMENT ‘姓名’,equipment_id
INT(11)
DEFAULT NULL COMMENT ‘设备id’,area_id
INT(10) DEFAULT NULL COMMENT ‘区域ID’,start_time
DATETIME DEFAULT NULL COMMENT ‘开始时间’,
end_time
DATETIME DEFAULT NULL COMMENT ‘结束时间’,ifdel
INT(11) DEFAULT ‘0’ COMMENT ‘0:使用,1:已移除’) ENGINE = InnoDB DEFAULT
CHARACTER SET = UTF8 DEFAULT COLLATE = UTF8_BIN”] [schema=dm_tidb_test]
[2020/02/18 10:54:15.457 +08:00] [INFO] [syncer.go:1700] [“prepare to handle ddls”] [task=127190_to_gs_heming] [unit=“binlog replica
tion”] [event=query] [ddls="[]"] [“raw statement”=“CREATE TABLE user_hem
(\
id
int(11) NOT NULL DEFAULT ‘0’,\
card
varchar
(32) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘编号’,\
name
varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘姓名’,\
equip ment_id
int(11) DEFAULT NULL COMMENT ‘设备id’,\
area_id
int(10) DEFAULT NULL COMMENT ‘区域ID’,\
start_time
datetime DEFAULT
NULL COMMENT ‘开始时间’,\
end_time
datetime DEFAULT NULL COMMENT ‘结束时间’,\
ifdel
int(11) DEFAULT ‘0’ COMMENT ‘0:使用,1
已移除’\
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin”] [position="(mysql-bin|000001.001533, 51093)"]
[2020/02/18 10:54:15.457 +08:00] [INFO] [syncer.go:1702] [“skip event, need handled ddls is empty”] [task=127190_to_gs_heming] [unit
=“binlog replication”] [event=query] [“raw statement”=“CREATE TABLE user_hem
(\
id
int(11) NOT NULL DEFAULT ‘0’,\
card
var
char(32) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘编号’,\
name
varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘姓名’,\
e quipment_id
int(11) DEFAULT NULL COMMENT ‘设备id’,\
area_id
int(10) DEFAULT NULL COMMENT ‘区域ID’,\
start_time
datetime DEF
AULT NULL COMMENT ‘开始时间’,\
end_time
datetime DEFAULT NULL COMMENT ‘结束时间’,\
ifdel
int(11) DEFAULT ‘0’ COMMENT ‘0:使用
,1:已移除’\
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin”] [position="(mysql-bin|000001.001533, 51093)"]
[2020/02/18 10:54:15.471 +08:00] [INFO] [syncer.go:1599] [task=127190_to_gs_heming] [unit=“binlog replication”] [event=query] [state
ment="/*!40000 ALTER TABLE user_hem
DISABLE KEYS /"] [schema=dm_tidb_test] [“last position”="(mysql-bin|000001.001533, 51093)"] [
position="(mysql-bin|000001.001533, 51295)"] [“gtid set”=NULL]
[2020/02/18 10:54:15.472 +08:00] [INFO] [syncer.go:1615] [“resolve sql”] [task=127190_to_gs_heming] [unit=“binlog replication”] [eve
nt=query] [“raw statement”="/!40000 ALTER TABLE user_hem
DISABLE KEYS /"] [statements="[“ALTER TABLE dm_tidb_test
.user_hem
DISABLE KEYS”]"] [schema=dm_tidb_test] [“last position”="(mysql-bin|000001.001533, 51295)"] [position="(mysql-bin|000001.001533, 51
295)"] [“gtid set”=NULL]
[2020/02/18 10:54:15.472 +08:00] [WARN] [syncer.go:1647] [“skip event"] [task=127190_to_gs_heming] [unit=“binlog replication”] [even
t=query] [statement=“ALTER TABLE dm_tidb_test
.user_hem
DISABLE KEYS”] [schema=dm_tidb_test]
[2020/02/18 10:54:15.472 +08:00] [INFO] [syncer.go:1700] [“prepare to handle ddls”] [task=127190_to_gs_heming] [unit=“binlog replica
tion”] [event=query] [ddls=”[]"] [“raw statement”="/!40000 ALTER TABLE user_hem
DISABLE KEYS /"] [position="(mysql-bin|000001.00
1533, 51295)"]
[2020/02/18 10:54:15.472 +08:00] [INFO] [syncer.go:1702] [“skip event, need handled ddls is empty”] [task=127190_to_gs_heming] [unit
=“binlog replication”] [event=query] [“raw statement”="/!40000 ALTER TABLE user_hem
DISABLE KEYS /"] [position="(mysql-bin|00000
1.001533, 51295)"]
[2020/02/18 10:54:15.649 +08:00] [INFO] [syncer.go:1599] [task=127190_to_gs_heming] [unit=“binlog replication”] [event=query] [state
ment="/!40000 ALTER TABLE user_hem
ENABLE KEYS /"] [schema=dm_tidb_test] [“last position”="(mysql-bin|000001.001533, 55162)"] [p
osition="(mysql-bin|000001.001533, 55363)"] [“gtid set”=NULL]
[2020/02/18 10:54:15.649 +08:00] [INFO] [syncer.go:1615] [“resolve sql”] [task=127190_to_gs_heming] [unit=“binlog replication”] [eve
nt=query] [“raw statement”="/!40000 ALTER TABLE user_hem
ENABLE KEYS /"] [statements="[“ALTER TABLE dm_tidb_test
.user_hem
E
NABLE KEYS”]"] [schema=dm_tidb_test] [“last position”="(mysql-bin|000001.001533, 55363)"] [position="(mysql-bin|000001.001533, 5536
3)"] [“gtid set”=NULL]
[2020/02/18 10:54:15.649 +08:00] [WARN] [syncer.go:1647] [“skip event”] [task=127190_to_gs_heming] [unit=“binlog replication”] [even
t=query] [statement=“ALTER TABLE dm_tidb_test
.user_hem
ENABLE KEYS”] [schema=dm_tidb_test]
[2020/02/18 10:54:15.649 +08:00] [INFO] [syncer.go:1700] [“prepare to handle ddls”] [task=127190_to_gs_heming] [unit=“binlog replica
tion”] [event=query] [ddls="[]"] [“raw statement”="/!40000 ALTER TABLE user_hem
ENABLE KEYS /"] [position="(mysql-bin|000001.001
533, 55363)"]
[2020/02/18 10:54:15.649 +08:00] [INFO] [syncer.go:1702] [“skip event, need handled ddls is empty”] [task=127190_to_gs_heming] [unit
=“binlog replication”] [event=query] [“raw statement”="/!40000 ALTER TABLE user_hem
ENABLE KEYS */"] [position="(mysql-bin|000001
.001533, 55363)"]
[2020/02/18 10:54:20.080 +08:00] [INFO] [syncer.go:2023] [“binlog replication progress”] [task=127190_to_gs_heming] [unit=“binlog re
plication”] [“total binlog size”=5829] [“last binlog size”=162] [“cost time”=30] [bytes/Second=188] [“unsynced binlog size”=0] [“est
imate time to catch up”=0]
[2020/02/18 10:54:20.081 +08:00] [INFO] [syncer.go:2048] [“binlog replication status”] [task=127190_to_gs_heming] [unit=“binlog repl
ication”] [total_events=0] [total_tps=0] [tps=0] [master_position="(mysql-bin.001533, 55363)"] [master_gtid=] [checkpoint="(mysql-bi
n|000001.001533, 55162)(flushed (mysql-bin.001533, 50172))"]
[2020/02/18 10:54:21.330 +08:00] [INFO] [relay.go:564] [“flush meta finished”] [component=“relay log”] [meta=“master-uuid = 1bfe5e41
-adfe-11e9-988b-b8ca3a621608.000001, relay-binlog = (mysql-bin.001533, 55363), relay-binlog-gtid = “]
[2020/02/18 10:54:45.575 +08:00] [INFO] [relay.go:425] [“ignore event by transformer”] [component=“relay log”] [header=”{“Timestamp
“:0,“EventType”:27,“ServerID”:13308,“EventSize”:39,“LogPos”:55363,“Flags”:0}”] [reason=“heartbeat event”]
[2020/02/18 10:54:50.081 +08:00] [INFO] [syncer.go:2048] [“binlog replication status”] [task=127190_to_gs_heming] [unit=“binlog repl
ication”] [total_events=0] [total_tps=0] [tps=0] [master_position=”(mysql-bin.001533, 55363)”] [master_gtid=] [checkpoint="(mysql-bi
n|000001.001533, 55162)(flushed (mysql-bin.001533, 50172))"]
[2020/02/18 10:55:15.575 +08:00] [INFO] [relay.go:425] [“ignore event by transformer”] [component=“relay log”] [header="{“Timestamp
“:0,“EventType”:27,“ServerID”:13308,“EventSize”:39,“LogPos”:55363,“Flags”:0}”] [reason=“heartbeat event”]
[2020/02/18 10:55:15.650 +08:00] [INFO] [syncer.go:1231] [“deadline exceeded when fetching binlog event”] [task=127190_to_gs_heming]
[unit=“binlog replication”]
[2020/02/18 10:55:15.650 +08:00] [INFO] [syncer.go:2117] [“flush all jobs”] [task=127190_to_gs_heming] [unit=“binlog replication”] [
“global checkpoint”=”(mysql-bin|000001.001533, 55162)(flushed (mysql-bin.001533, 50172))"]
[2020/02/18 10:55:15.959 +08:00] [INFO] [syncer.go:870] [“flushed checkpoint”] [task=127190_to_gs_heming] [unit=“binlog replication”
] [checkpoint="(mysql-bin|000001.001533, 55162)(flushed (mysql-bin|000001.001533, 55162))"]
[2020/02/18 10:55:15.960 +08:00] [INFO] [relay.go:113] [“current earliest active relay log”] [task=127190_to_gs_heming] [unit=“binlo
g replication”] [“active relay log”=1bfe5e41-adfe-11e9-988b-b8ca3a621608.000001/mysql-bin.001533]
[2020/02/18 10:55:20.081 +08:00] [INFO] [syncer.go:2048] [“binlog replication status”] [task=127190_to_gs_heming] [unit=“binlog repl
ication”] [total_events=0] [total_tps=0] [tps=0] [master_position="(mysql-bin.001533, 55363)"] [master_gtid=] [checkpoint="(mysql-bi
n|000001.001533, 55162)(flushed (mysql-bin|000001.001533, 55162))"]