oracle cdc：The connector is now using the maximum batch size 100000 when querying the LogMiner view. This could be indicative of large SCN gaps

[MonsterChenzhuo]

taskmanage不断答疑以下内容，并且新的数据不在摄入，整个任务呈现卡死状态：
The connector is now using the maximum batch size 100000 when querying the LogMiner view. This could be indicative of large SCN gaps
求教该如何解决

[spoon-lz]

我也遇到了相同的问题，请问你是如何解决的呢

[li57598]

遇到同样的问题，你们都怎么解决的

[LiaoMinYu]

遇到同样的问题，你们都怎么解决的

[li57598]

无解呀，oracle cdc太难用了

[LiaoMinYu]

大佬有代替方案吗

[thachnv92]

This document may help us!
https://debezium.io/documentation/reference/stable/connectors/oracle.html#scn-jumps
Read it and re-config connector.

[thachnv92]

Can you try with new config:

    "log.mining.batch.size.default": "100000",
    "log.mining.batch.size.min":"10000",
    "log.mining.batch.size.max":"1000000",
    "log.mining.sleep.time.default":"200",
    "log.mining.sleep.time.min":"0",
    "log.mining.sleep.time.max":"1000",
    "log.mining.sleep.time.increment":"100"

[LiaoMinYu]

I tried what you said last night, but I found the same error today

[LiaoMinYu]

[thachnv92]

Maybe, your DB is so much update, so gap of SCN is large.
Try to increase log.mining.batch.size.max and find reason value.
EX: 2000000

[LiaoMinYu]

It's impossible！Because I'm the only one using the database，I didn't change the data

[ZwzYJ999]

我也遇到了相同的问题, 请问有解决吗

[zhangfqcxl]

log.mining.batch.size.min=200000
log.mining.batch.size.max=50000000
尽量设置大点