被拉取的库中存在该表,但otter日志报如下错误
pid:2 nid:1 exception:setl:com.google.common.collect.ComputationException: org.apache.commons.lang.exception.NestableRuntimeException: find table
[km.km_tbl_zookeeper_cluster] error at com.google.common.collect.ComputingConcurrentHashMap$ComputingSegment.compute(ComputingConcurrentHashMap.java:167) at com.google.common.collect.ComputingConcurrentHashMap$ComputingSegment.compute(ComputingConcurrentHashMap.java:116) at com.google.common.collect.ComputingConcurrentHashMap.apply(ComputingConcurrentHashMap.java:67) at com.google.common.collect.MapMaker$ComputingMapAdapter.get(MapMaker.java:623) at com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect.findTable(AbstractDbDialect.java:111) at com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect.findTable(AbstractDbDialect.java:115) at com.alibaba.otter.node.etl.transform.transformer.RowDataTransformer.transform(RowDataTransformer.java:102) at com.alibaba.otter.node.etl.transform.transformer.RowDataTransformer.transform(RowDataTransformer.java:49) at com.alibaba.otter.node.etl.transform.transformer.OtterTransformerFactory.transform(OtterTransformerFactory.java:77) at com.alibaba.otter.node.etl.transform.TransformTask$1.run(TransformTask.java:86) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.commons.lang.exception.NestableRuntimeException: find table [kmcommon.km_tbl_zookeeper_cluster] error at com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect$3.apply(AbstractDbDialect.java:191) at com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect$3.apply(AbstractDbDialect.java:175) at com.google.common.collect.ComputingConcurrentHashMap$ComputingSegment.compute(ComputingConcurrentHashMap.java:155) ... 14 more Caused by: org.apache.commons.lang.exception.NestableRuntimeException: no found table [kmcommon.km_tbl_zookeeper_cluster] , pls check at com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect$3.apply(AbstractDbDialect.java:185) ... 16 more
原提问者GitHub用户 huangdq1990
检查是否是大小写问题。
no found table [kmcommon.km_tbl_zookeeper_cluster] , pls check 目前遇到的只有这么几类场景:
1、表名大小写问题
2、表物理被删除
3、表权限问题,同步的DB账号没有对应表的权限
原回答者GitHub用户agapple
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。