{"action":"opened","issue":{"url":"https://api.github.com/repos/alibaba/canal/issues/659","repository_url":"https://api.github.com/repos/alibaba/canal","labels_url":"https://api.github.com/repos/alibaba/canal/issues/659/labels{/name}","comments_url":"https://api.github.com/repos/alibaba/canal/issues/659/comments","events_url":"https://api.github.com/repos/alibaba/canal/issues/659/events","html_url":"https://github.com/alibaba/canal/issues/659","id":326914408,"number":659,"title":"同步的时候初始化sql报错","user":{"login":"jin82","id":15924732,"avatar_url":"https://avatars3.githubusercontent.com/u/15924732?v=4","gravatar_id":"","url":"https://api.github.com/users/jin82","html_url":"https://github.com/jin82","followers_url":"https://api.github.com/users/jin82/followers","following_url":"https://api.github.com/users/jin82/following{/other_user}","gists_url":"https://api.github.com/users/jin82/gists{/gist_id}","starred_url":"https://api.github.com/users/jin82/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jin82/subscriptions","organizations_url":"https://api.github.com/users/jin82/orgs","repos_url":"https://api.github.com/users/jin82/repos","events_url":"https://api.github.com/users/jin82/events{/privacy}","received_events_url":"https://api.github.com/users/jin82/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-28T06:45:06Z","updated_at":"2018-05-28T06:45:06Z","closed_at":null,"author_association":"NONE","body":"1.0.25 版本，文档中默认配置 h2数据库\r\n`\r\n2018-05-28 14:36:38.957 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `columns_priv` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 428, line 8, column 17, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.960 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `db` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  PRIMARY KEY (`Host`,`Db`,`User`),\r\n  KEY `User` (`User`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :''Y') CHARACTER SET utf8 NOT NULL DE', expect RPAREN, actual IDENTIFIER pos 225, line 5, column 31, token IDENTIFIER CHARACTER\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.961 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `event` (\r\n  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `name` char(64) NOT NULL DEFAULT '',\r\n  `body` longblob NOT NULL,\r\n  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `execute_at` datetime DEFAULT NULL,\r\n  `interval_value` int(11) DEFAULT NULL,\r\n  `interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,\r\n  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\r\n  `last_executed` datetime DEFAULT NULL,\r\n  `starts` datetime DEFAULT NULL,\r\n  `ends` datetime DEFAULT NULL,\r\n  `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',\r\n  `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',\r\n  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',\r\n  `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `originator` int(10) unsigned NOT NULL,\r\n  `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',\r\n  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `body_utf8` longblob,\r\n  PRIMARY KEY (`db`,`name`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 1035, line 16, column 14, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.964 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `func` (\r\n  `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `ret` tinyint(1) NOT NULL DEFAULT '0',\r\n  `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,\r\n  PRIMARY KEY (`name`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :'te') CHARACTER SET utf8 NOT NULL,\r\n ', expect RPAREN, actual IDENTIFIER pos 221, line 5, column 39, token IDENTIFIER CHARACTER\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.967 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `proc` (\r\n  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `name` char(64) NOT NULL DEFAULT '',\r\n  `type` enum('FUNCTION','PROCEDURE') NOT NULL,\r\n  `specific_name` char(64) NOT NULL DEFAULT '',\r\n  `language` enum('SQL') NOT NULL DEFAULT 'SQL',\r\n  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',\r\n  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',\r\n  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',\r\n  `param_list` blob NOT NULL,\r\n  `returns` longblob NOT NULL,\r\n  `body` longblob NOT NULL,\r\n  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\r\n  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',\r\n  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\r\n  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `body_utf8` longblob,\r\n  PRIMARY KEY (`db`,`name`,`type`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 864, line 16, column 14, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.968 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `procs_priv` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,\r\n  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),\r\n  KEY `Grantor` (`Grantor`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :'RE') COLLATE utf8_bin NOT NULL,\r\n  `', expect RPAREN, actual IDENTIFIER pos 313, line 6, column 47, token IDENTIFIER COLLATE\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.972 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `tables_priv` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),\r\n  KEY `Grantor` (`Grantor`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 422, line 8, column 16, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:36:38.974 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `user` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',\r\n  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  `ssl_cipher` blob NOT NULL,\r\n  `x509_issuer` blob NOT NULL,\r\n  `x509_subject` blob NOT NULL,\r\n  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',\r\n  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',\r\n  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',\r\n  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',\r\n  `plugin` char(64) COLLATE utf8_bin DEFAULT '',\r\n  `authentication_string` text COLLATE utf8_bin,\r\n  `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  PRIMARY KEY (`Host`,`User`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :''Y') CHARACTER SET utf8 NOT NULL DE', expect RPAREN, actual IDENTIFIER pos 256, line 5, column 31, token IDENTIFIER CHARACTER\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:38:19.380 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - pls submit github issue, show create table ddl:CREATE TABLE `hierquerysellist` (\r\n  `fieldtype_id` bigint(20) NOT NULL,\r\n  `whereclause` longtext NOT NULL,\r\n  `filtervariants` char(1) NOT NULL,\r\n  UNIQUE KEY `fieldtype_id` (`fieldtype_id`) USING BTREE\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . \r\n db : TableMeta [schema=bboss, table=hierquerysellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true]\r\n\tFieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n] \r\n mem : TableMeta [schema=bboss, table=hierquerysellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n]\r\n2018-05-28 14:38:19.590 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - pls submit github issue, show create table ddl:CREATE TABLE `hierquerysellist_fields` (\r\n  `fieldtype_id` bigint(20) NOT NULL,\r\n  `sequencenr` smallint(6) NOT NULL,\r\n  `fieldname` varchar(50) NOT NULL,\r\n  UNIQUE KEY `fieldtype_id` (`fieldtype_id`,`sequencenr`) USING BTREE\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . \r\n db : TableMeta [schema=bboss, table=hierquerysellist_fields, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true]\r\n\tFieldMeta [columnName=sequencenr, columnType=smallint(6), defaultValue=null, nullable=false, key=true]\r\n\tFieldMeta [columnName=fieldname, columnType=varchar(50), defaultValue=null, nullable=false, key=false]\r\n] \r\n mem : TableMeta [schema=bboss, table=hierquerysellist_fields, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=sequencenr, columnType=smallint(6), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=fieldname, columnType=varchar(50), defaultValue=null, nullable=false, key=false]\r\n]\r\n2018-05-28 14:38:20.005 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - pls submit github issue, show create table ddl:CREATE TABLE `linkquerysellist` (\r\n  `fieldtype_id` bigint(20) NOT NULL,\r\n  `whereclause` longtext NOT NULL,\r\n  `filtervariants` char(1) NOT NULL,\r\n  UNIQUE KEY `fieldtype_id` (`fieldtype_id`) USING BTREE\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . \r\n db : TableMeta [schema=bboss, table=linkquerysellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true]\r\n\tFieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n] \r\n mem : TableMeta [schema=bboss, table=linkquerysellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n]\r\n2018-05-28 14:38:20.837 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - pls submit github issue, show create table ddl:CREATE TABLE `parentlinkedsellist` (\r\n  `fieldtype_id` bigint(20) NOT NULL,\r\n  `whereclause` longtext NOT NULL,\r\n  `filtervariants` char(1) NOT NULL,\r\n  `linkfield` varchar(50) NOT NULL,\r\n  UNIQUE KEY `fieldtype_id` (`fieldtype_id`) USING BTREE\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . \r\n db : TableMeta [schema=bboss, table=parentlinkedsellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true]\r\n\tFieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=linkfield, columnType=varchar(50), defaultValue=null, nullable=false, key=false]\r\n] \r\n mem : TableMeta [schema=bboss, table=parentlinkedsellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=linkfield, columnType=varchar(50), defaultValue=null, nullable=false, key=false]\r\n]\r\n2018-05-28 14:38:21.359 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - pls submit github issue, show create table ddl:CREATE TABLE `querysellist` (\r\n  `fieldtype_id` bigint(20) NOT NULL,\r\n  `query` longtext NOT NULL,\r\n  `filtervariants` char(1) NOT NULL,\r\n  `sort_order` varchar(1) NOT NULL,\r\n  UNIQUE KEY `fieldtype_id` (`fieldtype_id`) USING BTREE\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . \r\n db : TableMeta [schema=bboss, table=querysellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true]\r\n\tFieldMeta [columnName=query, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=sort_order, columnType=varchar(1), defaultValue=null, nullable=false, key=false]\r\n] \r\n mem : TableMeta [schema=bboss, table=querysellist, fileds=\r\n\tFieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=query, columnType=longtext, defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false]\r\n\tFieldMeta [columnName=sort_order, columnType=varchar(1), defaultValue=null, nullable=false, key=false]\r\n]\r\n2018-05-28 14:38:28.334 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - compare failed , check log\r\n2018-05-28 14:38:28.356 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address /172.16.9.11:3307 has an error, retrying. caused by \r\ncom.alibaba.otter.canal.parse.exception.CanalParseException: can't find init table meta for myexample with position : EntryPosition[included=false,journalName=mysql-bin.000001,position=1314,serverId=1,timestamp=1527489302000]\r\n2018-05-28 14:38:28.359 [destination = myexample , address = /172.16.9.11:3307 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:myexample[com.alibaba.otter.canal.parse.exception.CanalParseException: can't find init table meta for myexample with position : EntryPosition[included=false,journalName=mysql-bin.000001,position=1314,serverId=1,timestamp=1527489302000]\r\n]\r\n2018-05-28 14:38:40.151 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - prepare to find start position just show master status\r\n2018-05-28 14:40:01.773 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `columns_priv` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 428, line 8, column 17, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:40:01.775 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `db` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',\r\n  PRIMARY KEY (`Host`,`Db`,`User`),\r\n  KEY `User` (`User`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :''Y') CHARACTER SET utf8 NOT NULL DE', expect RPAREN, actual IDENTIFIER pos 225, line 5, column 31, token IDENTIFIER CHARACTER\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:40:01.776 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `event` (\r\n  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `name` char(64) NOT NULL DEFAULT '',\r\n  `body` longblob NOT NULL,\r\n  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `execute_at` datetime DEFAULT NULL,\r\n  `interval_value` int(11) DEFAULT NULL,\r\n  `interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,\r\n  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\r\n  `last_executed` datetime DEFAULT NULL,\r\n  `starts` datetime DEFAULT NULL,\r\n  `ends` datetime DEFAULT NULL,\r\n  `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',\r\n  `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',\r\n  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',\r\n  `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `originator` int(10) unsigned NOT NULL,\r\n  `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',\r\n  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `body_utf8` longblob,\r\n  PRIMARY KEY (`db`,`name`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 1035, line 16, column 14, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:40:01.778 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `func` (\r\n  `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `ret` tinyint(1) NOT NULL DEFAULT '0',\r\n  `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,\r\n  PRIMARY KEY (`name`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :'te') CHARACTER SET utf8 NOT NULL,\r\n ', expect RPAREN, actual IDENTIFIER pos 221, line 5, column 39, token IDENTIFIER CHARACTER\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:40:01.780 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `proc` (\r\n  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `name` char(64) NOT NULL DEFAULT '',\r\n  `type` enum('FUNCTION','PROCEDURE') NOT NULL,\r\n  `specific_name` char(64) NOT NULL DEFAULT '',\r\n  `language` enum('SQL') NOT NULL DEFAULT 'SQL',\r\n  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',\r\n  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',\r\n  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',\r\n  `param_list` blob NOT NULL,\r\n  `returns` longblob NOT NULL,\r\n  `body` longblob NOT NULL,\r\n  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\r\n  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',\r\n  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,\r\n  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,\r\n  `body_utf8` longblob,\r\n  PRIMARY KEY (`db`,`name`,`type`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'\r\ncom.alibaba.druid.sql.parser.ParserException: error pos 864, line 16, column 14, token SET\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:40:01.783 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE `procs_priv` (\r\n  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,\r\n  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),\r\n  KEY `Grantor` (`Grantor`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges'\r\ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :'RE') COLLATE utf8_bin NOT NULL,\r\n  `', expect RPAREN, actual IDENTIFIER pos 313, line 6, column 47, token IDENTIFIER COLLATE\r\n\tat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na]\r\n\tat com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na]\r\n\tat java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]\r\n2018-05-28 14:40:01.789 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN  c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTab`"}}
{"actor":{"display_login":"jin82"}}