{"action":"created","issue":{"url":"https://api.github.com/repos/alibaba/otter/issues/79","labels_url":"https://api.github.com/repos/alibaba/otter/issues/79/labels{/name}","comments_url":"https://api.github.com/repos/alibaba/otter/issues/79/comments","events_url":"https://api.github.com/repos/alibaba/otter/issues/79/events","html_url":"https://github.com/alibaba/otter/issues/79","id":79318329,"number":79,"title":"添加字段报错","user":{"login":"laopangzhang","id":11938147,"avatar_url":"https://avatars.githubusercontent.com/u/11938147?v=3","gravatar_id":"","url":"https://api.github.com/users/laopangzhang","html_url":"https://github.com/laopangzhang","followers_url":"https://api.github.com/users/laopangzhang/followers","following_url":"https://api.github.com/users/laopangzhang/following{/other_user}","gists_url":"https://api.github.com/users/laopangzhang/gists{/gist_id}","starred_url":"https://api.github.com/users/laopangzhang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laopangzhang/subscriptions","organizations_url":"https://api.github.com/users/laopangzhang/orgs","repos_url":"https://api.github.com/users/laopangzhang/repos","events_url":"https://api.github.com/users/laopangzhang/events{/privacy}","received_events_url":"https://api.github.com/users/laopangzhang/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-05-22T06:38:55Z","updated_at":"2015-06-30T02:39:07Z","closed_at":"2015-06-30T02:39:07Z","body":"主库中添加一个字段'unionid’，发现日志有如下报错，添加一个字段'unionid’，发现日志有如下报错，\r\n\r\n首先是在表里面没有发现这个字段，而后，就说有重复的字段，我返回数据查询，发现从库已经添加这个字段了。但同步channel已经挂起了。不知道是什么原因。\r\n\r\n2015-05-21 11:40:49 pid:2 nid:2 exception:setl:com.alibaba.otter.node.etl.transform.exception.TransformException: unionid is not found in Table [name=users; 37 columns] and source : dji_store_production..*\r\n\r\n2015-05-21 11:41:48\r\npid:2 nid:2 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: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'unionid'\r\nCaused by: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'unionid'\r\nat java.util.concurrent.FutureTask.report(FutureTask.java:122)\r\nat java.util.concurrent.FutureTask.get(FutureTask.java:188)\r\nat com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader.load(DataBatchLoader.java:107)\r\nat com.alibaba.otter.node.etl.load.loader.OtterLoaderFactory.load(OtterLoaderFactory.java:50)\r\nat com.alibaba.otter.node.etl.load.LoadTask$1.run(LoadTask.java:85)\r\nat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)\r\nat java.util.concurrent.FutureTask.run(FutureTask.java:262)\r\nat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\nat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\nat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'unionid'\r\nCaused by: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'unionid'\r\nCaused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'unionid'\r\nat org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTransl"},"comment":{"url":"https://api.github.com/repos/alibaba/otter/issues/comments/116919891","html_url":"https://github.com/alibaba/otter/issues/79#issuecomment-116919891","issue_url":"https://api.github.com/repos/alibaba/otter/issues/79","id":116919891,"user":{"login":"agapple","id":834743,"avatar_url":"https://avatars.githubusercontent.com/u/834743?v=3","gravatar_id":"","url":"https://api.github.com/users/agapple","html_url":"https://github.com/agapple","followers_url":"https://api.github.com/users/agapple/followers","following_url":"https://api.github.com/users/agapple/following{/other_user}","gists_url":"https://api.github.com/users/agapple/gists{/gist_id}","starred_url":"https://api.github.com/users/agapple/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agapple/subscriptions","organizations_url":"https://api.github.com/users/agapple/orgs","repos_url":"https://api.github.com/users/agapple/repos","events_url":"https://api.github.com/users/agapple/events{/privacy}","received_events_url":"https://api.github.com/users/agapple/received_events","type":"User","site_admin":false},"created_at":"2015-06-30T02:39:07Z","updated_at":"2015-06-30T02:39:07Z","body":" Duplicate column name 'unionid'， 可能是otter的自动恢复机制导致出现重复同步，可忽略DDL同步异常跳过"}}