Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    UNSOLVED oracle 同步到mysql,增量阶段不可用

    问答区
    oracle 增量 同步到 mysql 失败
    2
    2
    219
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      lvwenyuan last edited by

      版本:1.2.1.4

      就是全量 + 增量 的模式,全量是OK,增量的时候一开始任务报了异常,过了一会,就好了。
      ![替代文字](0647bf18-b5ea-44eb-9f3b-a5515be74fa3-image.png 图片地址)

      报错内容都是 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中

      junyu-cloudcanal 1 Reply Last reply Reply Quote 0
      • junyu-cloudcanal
        junyu-cloudcanal @lvwenyuan last edited by

        @lvwenyuan 有加社区群么?这个得具体看看。

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post
        Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2