Closed jin82 closed 6 years ago
使用 mysql 配置后 又有下面的错误
2018-05-28 15:06:27.531 [destination = myexample , address = /172.16.9.11:3307 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta - parse faield : CREATE TABLE
user(
Hostchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
Userchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
Passwordchar(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
Select_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Insert_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Update_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Delete_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Drop_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Reload_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Shutdown_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Process_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
File_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Grant_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
References_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Index_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Alter_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Show_db_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Super_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_tmp_table_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Lock_tables_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Execute_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Repl_slave_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Repl_client_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_view_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Show_view_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_routine_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Alter_routine_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_user_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Event_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Trigger_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_tablespace_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
ssl_typeenum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
ssl_cipherblob NOT NULL,
x509_issuerblob NOT NULL,
x509_subjectblob NOT NULL,
max_questionsint(11) unsigned NOT NULL DEFAULT '0',
max_updatesint(11) unsigned NOT NULL DEFAULT '0',
max_connectionsint(11) unsigned NOT NULL DEFAULT '0',
max_user_connectionsint(11) unsigned NOT NULL DEFAULT '0',
pluginchar(64) COLLATE utf8_bin DEFAULT '',
authentication_stringtext COLLATE utf8_bin,
password_expiredenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N', PRIMARY KEY (
Host,
User) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'
换成26版本试试,这是25版本的bug。
我升级到26也是这个问题。不过,我感觉这像是个权限问题,我给mysql中的canal用户赋了全部权限,就没问题了。 GRANT ALL PRIVILEGES ON . TO 'canal'@'%' ; FLUSH PRIVILEGES;
LS正解
版本v1.0.25 开启 tsdb之后, 出现这种错误。删除之后就好了
1.0.25 版本,文档中默认配置 h2数据库
2018-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(
Hostchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
Dbchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
Userchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
Table_namechar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
Column_namechar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
Timestamptimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
Column_privset('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '', PRIMARY KEY (
Host,
Db,
User,
Table_name,
Column_name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges' com.alibaba.druid.sql.parser.ParserException: error pos 428, line 8, column 17, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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(
Hostchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
Dbchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
Userchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
Select_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Insert_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Update_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Delete_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Drop_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Grant_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
References_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Index_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Alter_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_tmp_table_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Lock_tables_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_view_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Show_view_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Create_routine_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Alter_routine_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Execute_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Event_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
Trigger_privenum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N', PRIMARY KEY (
Host,
Db,
User), KEY
User(
User) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges' com.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 at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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(
dbchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
namechar(64) NOT NULL DEFAULT '',
bodylongblob NOT NULL,
definerchar(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
execute_atdatetime DEFAULT NULL,
interval_valueint(11) DEFAULT NULL,
interval_fieldenum('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,
createdtimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
modifiedtimestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
last_executeddatetime DEFAULT NULL,
startsdatetime DEFAULT NULL,
endsdatetime DEFAULT NULL,
statusenum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
on_completionenum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
sql_modeset('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 '',
commentchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
originatorint(10) unsigned NOT NULL,
time_zonechar(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
character_set_clientchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
collation_connectionchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
db_collationchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
body_utf8longblob, PRIMARY KEY (
db,
name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events' com.alibaba.druid.sql.parser.ParserException: error pos 1035, line 16, column 14, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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(
namechar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
rettinyint(1) NOT NULL DEFAULT '0',
dlchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
typeenum('function','aggregate') CHARACTER SET utf8 NOT NULL, PRIMARY KEY (
name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions' com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'te') CHARACTER SET utf8 NOT NULL, ', expect RPAREN, actual IDENTIFIER pos 221, line 5, column 39, token IDENTIFIER CHARACTER at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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(
dbchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
namechar(64) NOT NULL DEFAULT '',
typeenum('FUNCTION','PROCEDURE') NOT NULL,
specific_namechar(64) NOT NULL DEFAULT '',
languageenum('SQL') NOT NULL DEFAULT 'SQL',
sql_data_accessenum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
is_deterministicenum('YES','NO') NOT NULL DEFAULT 'NO',
security_typeenum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
param_listblob NOT NULL,
returnslongblob NOT NULL,
bodylongblob NOT NULL,
definerchar(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
createdtimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
modifiedtimestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
sql_modeset('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 '',
commenttext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
character_set_clientchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
collation_connectionchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
db_collationchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
body_utf8longblob, PRIMARY KEY (
db,
name,
type) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures' com.alibaba.druid.sql.parser.ParserException: error pos 864, line 16, column 14, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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(
Hostchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
Dbchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
Userchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
Routine_namechar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
Routine_typeenum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
Grantorchar(77) COLLATE utf8_bin NOT NULL DEFAULT '',
Proc_privset('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
Timestamptimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (
Host,
Db,
User,
Routine_name,
Routine_type), KEY
Grantor(
Grantor) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges' com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'RE') COLLATE utf8_bin NOT NULL,
', expect RPAREN, actual IDENTIFIER pos 313, line 6, column 47, token IDENTIFIER COLLATE at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEtables_priv
(Host
char(60) COLLATE utf8_bin NOT NULL DEFAULT '',Db
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',User
char(16) COLLATE utf8_bin NOT NULL DEFAULT '',Table_name
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',Grantor
char(77) COLLATE utf8_bin NOT NULL DEFAULT '',Timestamp
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,Table_priv
set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',Column_priv
set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '', PRIMARY KEY (Host
,Db
,User
,Table_name
), KEYGrantor
(Grantor
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges' com.alibaba.druid.sql.parser.ParserException: error pos 422, line 8, column 16, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEuser
(Host
char(60) COLLATE utf8_bin NOT NULL DEFAULT '',User
char(16) COLLATE utf8_bin NOT NULL DEFAULT '',Password
char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',Select_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Insert_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Update_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Delete_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Drop_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Reload_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Shutdown_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Process_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',File_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Grant_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',References_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Index_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Alter_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Show_db_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Super_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_tmp_table_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Lock_tables_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Execute_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Repl_slave_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Repl_client_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_view_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Show_view_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_routine_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Alter_routine_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_user_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Event_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Trigger_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_tablespace_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',ssl_type
enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',ssl_cipher
blob NOT NULL,x509_issuer
blob NOT NULL,x509_subject
blob NOT NULL,max_questions
int(11) unsigned NOT NULL DEFAULT '0',max_updates
int(11) unsigned NOT NULL DEFAULT '0',max_connections
int(11) unsigned NOT NULL DEFAULT '0',max_user_connections
int(11) unsigned NOT NULL DEFAULT '0',plugin
char(64) COLLATE utf8_bin DEFAULT '',authentication_string
text COLLATE utf8_bin,password_expired
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N', PRIMARY KEY (Host
,User
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges' com.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 at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEhierquerysellist
(fieldtype_id
bigint(20) NOT NULL,whereclause
longtext NOT NULL,filtervariants
char(1) NOT NULL, UNIQUE KEYfieldtype_id
(fieldtype_id
) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . db : TableMeta [schema=bboss, table=hierquerysellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true] FieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] ] mem : TableMeta [schema=bboss, table=hierquerysellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] ] 2018-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 TABLEhierquerysellist_fields
(fieldtype_id
bigint(20) NOT NULL,sequencenr
smallint(6) NOT NULL,fieldname
varchar(50) NOT NULL, UNIQUE KEYfieldtype_id
(fieldtype_id
,sequencenr
) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . db : TableMeta [schema=bboss, table=hierquerysellist_fields, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true] FieldMeta [columnName=sequencenr, columnType=smallint(6), defaultValue=null, nullable=false, key=true] FieldMeta [columnName=fieldname, columnType=varchar(50), defaultValue=null, nullable=false, key=false] ] mem : TableMeta [schema=bboss, table=hierquerysellist_fields, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=sequencenr, columnType=smallint(6), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=fieldname, columnType=varchar(50), defaultValue=null, nullable=false, key=false] ] 2018-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 TABLElinkquerysellist
(fieldtype_id
bigint(20) NOT NULL,whereclause
longtext NOT NULL,filtervariants
char(1) NOT NULL, UNIQUE KEYfieldtype_id
(fieldtype_id
) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . db : TableMeta [schema=bboss, table=linkquerysellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true] FieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] ] mem : TableMeta [schema=bboss, table=linkquerysellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] ] 2018-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 TABLEparentlinkedsellist
(fieldtype_id
bigint(20) NOT NULL,whereclause
longtext NOT NULL,filtervariants
char(1) NOT NULL,linkfield
varchar(50) NOT NULL, UNIQUE KEYfieldtype_id
(fieldtype_id
) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . db : TableMeta [schema=bboss, table=parentlinkedsellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true] FieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=linkfield, columnType=varchar(50), defaultValue=null, nullable=false, key=false] ] mem : TableMeta [schema=bboss, table=parentlinkedsellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=whereclause, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=linkfield, columnType=varchar(50), defaultValue=null, nullable=false, key=false] ] 2018-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 TABLEquerysellist
(fieldtype_id
bigint(20) NOT NULL,query
longtext NOT NULL,filtervariants
char(1) NOT NULL,sort_order
varchar(1) NOT NULL, UNIQUE KEYfieldtype_id
(fieldtype_id
) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 , compare failed . db : TableMeta [schema=bboss, table=querysellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=true] FieldMeta [columnName=query, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=sort_order, columnType=varchar(1), defaultValue=null, nullable=false, key=false] ] mem : TableMeta [schema=bboss, table=querysellist, fileds= FieldMeta [columnName=fieldtype_id, columnType=bigint(20), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=query, columnType=longtext, defaultValue=null, nullable=false, key=false] FieldMeta [columnName=filtervariants, columnType=char(1), defaultValue=null, nullable=false, key=false] FieldMeta [columnName=sort_order, columnType=varchar(1), defaultValue=null, nullable=false, key=false] ] 2018-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 2018-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 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] 2018-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] ] 2018-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 2018-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 TABLEcolumns_priv
(Host
char(60) COLLATE utf8_bin NOT NULL DEFAULT '',Db
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',User
char(16) COLLATE utf8_bin NOT NULL DEFAULT '',Table_name
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',Column_name
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',Timestamp
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,Column_priv
set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '', PRIMARY KEY (Host
,Db
,User
,Table_name
,Column_name
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges' com.alibaba.druid.sql.parser.ParserException: error pos 428, line 8, column 17, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEdb
(Host
char(60) COLLATE utf8_bin NOT NULL DEFAULT '',Db
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',User
char(16) COLLATE utf8_bin NOT NULL DEFAULT '',Select_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Insert_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Update_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Delete_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Drop_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Grant_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',References_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Index_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Alter_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_tmp_table_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Lock_tables_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_view_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Show_view_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Create_routine_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Alter_routine_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Execute_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Event_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',Trigger_priv
enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N', PRIMARY KEY (Host
,Db
,User
), KEYUser
(User
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges' com.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 at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEevent
(db
char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',name
char(64) NOT NULL DEFAULT '',body
longblob NOT NULL,definer
char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',execute_at
datetime DEFAULT NULL,interval_value
int(11) DEFAULT NULL,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,created
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,modified
timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',last_executed
datetime DEFAULT NULL,starts
datetime DEFAULT NULL,ends
datetime DEFAULT NULL,status
enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',on_completion
enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',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 '',comment
char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',originator
int(10) unsigned NOT NULL,time_zone
char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',character_set_client
char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,collation_connection
char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,db_collation
char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,body_utf8
longblob, PRIMARY KEY (db
,name
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events' com.alibaba.druid.sql.parser.ParserException: error pos 1035, line 16, column 14, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEfunc
(name
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',ret
tinyint(1) NOT NULL DEFAULT '0',dl
char(128) COLLATE utf8_bin NOT NULL DEFAULT '',type
enum('function','aggregate') CHARACTER SET utf8 NOT NULL, PRIMARY KEY (name
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions' com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'te') CHARACTER SET utf8 NOT NULL, ', expect RPAREN, actual IDENTIFIER pos 221, line 5, column 39, token IDENTIFIER CHARACTER at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEproc
(db
char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',name
char(64) NOT NULL DEFAULT '',type
enum('FUNCTION','PROCEDURE') NOT NULL,specific_name
char(64) NOT NULL DEFAULT '',language
enum('SQL') NOT NULL DEFAULT 'SQL',sql_data_access
enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',is_deterministic
enum('YES','NO') NOT NULL DEFAULT 'NO',security_type
enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',param_list
blob NOT NULL,returns
longblob NOT NULL,body
longblob NOT NULL,definer
char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',created
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,modified
timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',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 '',comment
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,character_set_client
char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,collation_connection
char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,db_collation
char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,body_utf8
longblob, PRIMARY KEY (db
,name
,type
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures' com.alibaba.druid.sql.parser.ParserException: error pos 864, line 16, column 14, token SET at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1334) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2310) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2301) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:493) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:115) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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 TABLEprocs_priv
(Host
char(60) COLLATE utf8_bin NOT NULL DEFAULT '',Db
char(64) COLLATE utf8_bin NOT NULL DEFAULT '',User
char(16) COLLATE utf8_bin NOT NULL DEFAULT '',Routine_name
char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',Routine_type
enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,Grantor
char(77) COLLATE utf8_bin NOT NULL DEFAULT '',Proc_priv
set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',Timestamp
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (Host
,Db
,User
,Routine_name
,Routine_type
), KEYGrantor
(Grantor
) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges' com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'RE') COLLATE utf8_bin NOT NULL,', expect RPAREN, actual IDENTIFIER pos 313, line 6, column 47, token IDENTIFIER COLLATE at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:191) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:244) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:159) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.druid.sql.repository.SchemaRepository.console(SchemaRepository.java:295) ~[druid-1.1.6.jar:1.1.6] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.MemoryTableMeta.apply(MemoryTableMeta.java:69) ~[canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:177) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:127) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:72) [canal.parse-1.0.25.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:170) [canal.parse-1.0.25.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2018-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