{"action":"closed","issue":{"url":"https://api.github.com/repos/alibaba/otter/issues/386","repository_url":"https://api.github.com/repos/alibaba/otter","labels_url":"https://api.github.com/repos/alibaba/otter/issues/386/labels{/name}","comments_url":"https://api.github.com/repos/alibaba/otter/issues/386/comments","events_url":"https://api.github.com/repos/alibaba/otter/issues/386/events","html_url":"https://github.com/alibaba/otter/issues/386","id":262998667,"number":386,"title":"在未开启DDL同步的DB上面做DDL操作被循环执行","user":{"login":"swift1911","id":9301003,"avatar_url":"https://avatars3.githubusercontent.com/u/9301003?v=4","gravatar_id":"","url":"https://api.github.com/users/swift1911","html_url":"https://github.com/swift1911","followers_url":"https://api.github.com/users/swift1911/followers","following_url":"https://api.github.com/users/swift1911/following{/other_user}","gists_url":"https://api.github.com/users/swift1911/gists{/gist_id}","starred_url":"https://api.github.com/users/swift1911/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/swift1911/subscriptions","organizations_url":"https://api.github.com/users/swift1911/orgs","repos_url":"https://api.github.com/users/swift1911/repos","events_url":"https://api.github.com/users/swift1911/events{/privacy}","received_events_url":"https://api.github.com/users/swift1911/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-10-05T04:06:42Z","updated_at":"2018-05-03T02:40:02Z","closed_at":"2018-05-03T02:40:02Z","author_association":"NONE","body":"A库开启了DDL同步，B库未开启DDL同步，在B库中新建一个表，在B库中删除这个表，重启otter发现以下的错误日志，似乎一直在往A库同步，错误日志如下：\r\n\r\ncaused by: com.alibaba.otter.canal.parse.exception.CanalParseException: fetch failed by table meta:`frc`.`host_service`\r\nCaused by: java.io.IOException: ErrorPacket [errorNumber=1146, fieldCount=-1, message=Table 'frc.host_service' doesn't exist, sqlState=42S02, sqlStateMarker=#]\r\n with command: desc `frc`.`host_service`\r\n\tat com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.query(MysqlQueryExecutor.java:60)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.query(MysqlConnection.java:73)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.TableMetaCache.getTableMeta0(TableMetaCache.java:105)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.TableMetaCache.access$000(TableMetaCache.java:26)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.TableMetaCache$1.apply(TableMetaCache.java:51)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.TableMetaCache$1.apply(TableMetaCache.java:42)\r\n\tat com.google.common.collect.ComputingConcurrentHashMap$ComputingSegment.compute(ComputingConcurrentHashMap.java:155)\r\n\tat com.google.common.collect.ComputingConcurrentHashMap$ComputingSegment.compute(ComputingConcurrentHashMap.java:116)\r\n\tat com.google.common.collect.ComputingConcurrentHashMap.apply(ComputingConcurrentHashMap.java:67)\r\n\tat com.google.common.collect.MapMaker$ComputingMapAdapter.get(MapMaker.java:623)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.TableMetaCache.getTableMeta(TableMetaCache.java:78)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.getTableMeta(LogEventConvert.java:677)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.parseRowsEvent(LogEventConvert.java:362)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.parse(LogEventConvert.java:108)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.parse(LogEventConvert.java:62)\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser.parseAndProfilingIfNecessary(AbstractEventParser.java:326)\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3$1.sink(AbstractEventParser.java:176)\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:129)\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:209)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\n]"}}
{"actor":{"display_login":"swift1911"}}