UNSOLVED oracle 同步到mysql,增量阶段不可用
-
版本:1.2.1.4
就是全量 + 增量 的模式,全量是OK,增量的时候一开始任务报了异常,过了一会,就好了。

报错内容都是 data task(36) not in data job(31) task list.
查看任务日志,目前显示的都是
2022-02-17 11:04:20.097 [oracle-log-extractor-4-thd-66] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4700] mlog is empty, sleep 1000 2022-02-17 11:04:20.097 [oracle-log-extractor-4-thd-49] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_6300] mlog is empty, sleep 1000 2022-02-17 11:04:20.097 [oracle-log-extractor-4-thd-64] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4705] mlog is empty, sleep 1000 2022-02-17 11:04:20.097 [oracle-log-extractor-4-thd-62] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_3220] mlog is empty, sleep 1000 2022-02-17 11:04:20.124 [oracle-log-extractor-4-thd-67] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4701] mlog is empty, sleep 1000 2022-02-17 11:04:20.125 [oracle-log-extractor-4-thd-65] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_2122] mlog is empty, sleep 1000 2022-02-17 11:04:20.167 [oracle-log-extractor-4-thd-10] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_1120] mlog is empty, sleep 1000 2022-02-17 11:04:20.219 [oracle-log-extractor-4-thd-79] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_1500] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-72] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_2120] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-73] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_3330] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-76] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4610] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-69] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_2121] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-70] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4780] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-75] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_1220] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-68] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_5230] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-74] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4660] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-78] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4730] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-77] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_4611] mlog is empty, sleep 1000 2022-02-17 11:04:20.220 [oracle-log-extractor-4-thd-71] INFO c.c.c.o.w.reader.incre.MaterializedIncRecordExtractor - table[SSBUDGET.OB_DISP_BUDGET_6200] mlog is empty, sleep 1000
但是修改oracle数据,发现未同步到oracle中
-
@lvwenyuan 有加社区群么?这个得具体看看。
Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2