ucarGroup/DataLink

RDBMS MYSQL-> MYSQL 目标数据库没有同步数据

jkl0898 opened this issue · 1 comments

jkl0898 commented

#版本 V1.0.1-beta

  1. RDBMS MYSQL -> MYSQL

介质管理-> 数据源建立完毕

增量任务 ->Task 管理->MysqlTask 建立Task 完毕

映射管理 -> 新增映射 完毕

MySql task 启动完毕

  1. 向源数据库表插入数据完毕

  2. 查看目标表数据没有同步数据。

Manager Log:

2020-01-16 18:05:24.131 [qtp1792384402-147] INFO c.u.d.m.core.web.controller.shadow.TaskShadowController - 收到的参数为:{search={"regex":false,"value":""}, columns=[{"search":{"regex":false,"value":""},"data":"id","orderable":true,"name":"","searchable":true},{"search":{"regex":false,"value":""},"data":"taskName","orderable":true,"name":"","searchable":true},{"search":{"regex":false,"value":""},"data":"state","orderable":true,"name":"","searchable":true},{"search":{"regex":false,"value":""},"data":"mappingIds","orderable":true,"name":"","searchable":true},{"search":{"regex":false,"value":""},"data":"resetTime","orderable":true,"name":"","searchable":true},{"search":{"regex":false,"value":""},"data":"createTime","orderable":true,"name":"","searchable":true},{"search":{"regex":false,"value":""},"data":"modifyTime","orderable":true,"name":"","searchable":true}], start=0, length=10, draw=1, state=, taskId=4, order=[{"column":0,"dir":"asc"}]}

Worker Log:

java.lang.NullPointerException: null
at com.ucar.datalink.worker.core.probe.WorkerSystemStateProbeImpl.getWorkerSystemState(WorkerSystemStateProbeImpl.java:95) ~[dl-worker-core-1.0.0-beta.jar:na]
at com.ucar.datalink.worker.core.probe.WorkerSystemStateProbeImpl.access$000(WorkerSystemStateProbeImpl.java:31) ~[dl-worker-core-1.0.0-beta.jar:na]
at com.ucar.datalink.worker.core.probe.WorkerSystemStateProbeImpl$1.run(WorkerSystemStateProbeImpl.java:65) ~[dl-worker-core-1.0.0-beta.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_121]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
2020-01-16 18:13:59.130 [Probe-Type-WorkerSystemStateProbe-pool-1] ERROR c.u.d.worker.core.probe.WorkerSystemStateProbeImpl - Worker system state probe failed.
java.lang.NullPointerException: null
at com.ucar.datalink.worker.core.probe.WorkerSystemStateProbeImpl.getWorkerSystemState(WorkerSystemStateProbeImpl.java:95) ~[dl-worker-core-1.0.0-beta.jar:na]
at com.ucar.datalink.worker.core.probe.WorkerSystemStateProbeImpl.access$000(WorkerSystemStateProbeImpl.java:31) ~[dl-worker-core-1.0.0-beta.jar:na]
at com.ucar.datalink.worker.core.probe.WorkerSystemStateProbeImpl$1.run(WorkerSystemStateProbeImpl.java:65) ~[dl-worker-core-1.0.0-beta.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_121]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]

Task Log:

2020-01-16 17:58:07.404 [Task-5-Reader-reader-mysql] INFO com.ucar.datalink.worker.core.runtime.WorkerTaskReader - TaskReader-reader-mysql finished initialization and start.
2020-01-16 17:58:07.442 [destination = 5-main , address = /172.16.159.139:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - ---> begin to find start position, it will be long time for reset or first position
2020-01-16 17:58:07.443 [destination = 5-main , address = /172.16.159.139:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - prepare to find start position just show master status
2020-01-16 17:58:07.444 [destination = 5-main , address = /172.16.159.139:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.000013,position=945,serverId=,gtid=,timestamp=] cost : 1ms , the next step is binlog dump

jkl0898 commented

已找到原因，任务配置不正确。