适用版本:所有版本皆适用
影响的范围:全量同步启动后会停止
症状:日志一直报错TESTNJY_CMSP_laassessaccessory-0:137327 ms has passed since batch creation,
No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries
Cannot perform operation after producer has been closed
问题:备端装载太慢了
原因:dump程序队列调整小点就好了
解决方案:
vi ./i2active/iadbdump-db2/config/dump.properties
queue.size = 15
queue.batch.size = 2000
这两个值调小点 我在处理东吴人寿的调整的是
queue.size = 3
queue.batch.size = 200
分析解决方法备注:调整后同步会变慢