Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

一个表先目标加字段,再源加字段,之后同步报找不到字段 #218

Closed
wlcwfwyt opened this issue Nov 3, 2016 · 7 comments
Closed
Milestone

Comments

@wlcwfwyt
Copy link

wlcwfwyt commented Nov 3, 2016

pid:20 nid:6 exception:setl:com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: column name extended_content is not found in Table[Table [name=deal_price_check; 18 columns]]

2016-11-03 18:51:02.329 [DbLoadAction] WARN com.alibaba.otter.node.etl.load.loader.db.DbLoadAction - ##load phase one failed!
201 java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception
.LoadException: column name extended_content is not found in Table[Table [name=deal_price_check; 18 columns]]

停止channel后,再启动channel才能正常继续同步

@agapple
Copy link
Member

agapple commented Nov 10, 2016

估计是内存的表结构没有被刷新,目前ddl只能刷新源库,没法刷新目标库,是一个bug

@agapple
Copy link
Member

agapple commented Nov 10, 2016

可以开启自动恢复的功能,这样再出现异常后自动重启channel同步

@agapple agapple added this to the v4.2.1.4 milestone Dec 30, 2016
@aiaix
Copy link

aiaix commented Jan 23, 2017

这个自动恢复功能在那里开启@agapple

@wlcwfwyt
Copy link
Author

在监控管理里 “触发自动恢复阀值” 这个选项设置里

@aiaix
Copy link

aiaix commented Jan 23, 2017

触发自动恢复阀值 默认是2 表示什么含义?

@wlcwfwyt
Copy link
Author

异常报警两次后就会自动停止再启channel

@aiaix
Copy link

aiaix commented Jan 23, 2017

多谢@wlcwfwyt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants