添加字段OTTER同步失败
pid:5 nid:1 exception:setl:com.alibaba.otter.node.etl.transform.exception.TransformException: wallet_user_id is not found in Table [name=tj_oto_order; 31 columns] and source : oto..*
2016-12-23 09:34:38.483 [pipelineId = 5,taskName = transformWorker] WARN c.a.o.s.a.i.setl.zookeeper.termin.WarningTerminProcess - nid :1[5:setl:com.alibaba.otter.node.etl.transform.exception.TransformException: wallet_user_id is not found in Table [name=tj_oto_order; 31 columns] and source : oto..* ] 2016-12-23 09:36:39.428 [pipelineId = 5,taskName = transformWorker] ERROR com.alibaba.otter.node.etl.transform.TransformTask - [5] tra nsformWork executor is error! data:EtlEventData[currNid=1,nextNid=1,desc=[MemoryPipeKey[identity=Identity[channelId=3,pipelineId=5,pro cessId=15],time=1482456999059,dataType=DB_BATCH]],processId=15,startTime=1482456998513,endTime=,firstTime=1482214467000,batchId= 16,number=10159,size=,exts=,pipelineId=5] com.alibaba.otter.node.etl.transform.exception.TransformException: wallet_user_id is not found in Table [name=tj_oto_order; 31 columns ] and source : oto..* 2016-12-23 09:36:39.494 [pipelineId = 5,taskName = transformWorker] WARN c.a.o.s.a.i.setl.zookeeper.termin.WarningTerminProcess - nid :1[5:setl:com.alibaba.otter.node.etl.transform.exception.TransformException: wallet_user_id is not found in Table [name=tj_oto_order; 31 columns] and source : oto..* ]
源头成功，目标不成功。双向配置，只在源开启DDL，源头跳过DDL也没用。OTTER 4.2.12 MYSQL 5.6.30
目标端添加字段解决
原提问者GitHub用户 aiaix
写回答
-
wallet_user_id is not found in Table [name=tj_oto_order; 31 columns]
是目标库缺少一个列
原回答者GitHub用户agapple
2023-06-21 17:42:34赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
