问题描述
我wget 了项目代码 编译成功 ,并且 更改了 conf/example/instance.properties 内容 ,运行/bin/startup.sh后报错
2018-10-11 20:12:49.383 [Thread-5] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - stop CannalInstance for null-example
2018-10-11 20:12:49.391 [Thread-5] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - stop successful....
2018-10-11 20:12:57.090 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [canal.properties]
2018-10-11 20:12:57.095 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [example/instance.properties]
2018-10-11 20:12:57.289 [main] WARN o.s.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'connectionCharset' being accessed! Ambiguous write methods found next to actually used [public void com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.setConnectionCharset(java.nio.charset.Charset)]: [public void com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.setConnectionCharset(java.lang.String)]
2018-10-11 20:12:57.343 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [canal.properties]
2018-10-11 20:12:57.343 [main] INFO c.a.o.c.i.spring.support.PropertyPlaceholderConfigurer - Loading properties file from class path resource [example/instance.properties]
2018-10-11 20:12:57.553 [main] ERROR com.alibaba.druid.pool.DruidDataSource - testWhileIdle is true, validationQuery not set
2018-10-11 20:12:57.865 [main] INFO c.a.otter.canal.instance.spring.CanalInstanceWithSpring - start CannalInstance for 1-example
2018-10-11 20:12:57.881 [main] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - start successful....
2018-10-11 20:12:57.918 [destination = example , address = xxxxxxxx:3333 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - prepare to find start position just show master status
2018-10-11 20:12:59.013 [destination = example , address = xxxxxxxx:3333 , EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address xxxxxxxx:3333 has an error, retrying. caused by
com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'xxxxxx' for table 'slow_log', sqlState=42000, sqlStateMarker=#]
with command: show create table mysql
.event
;show create table mysql
.func
;show create table mysql
.general_log
;show create table mysql
.help_category
;show create table mysql
.help_keyword
;show create table mysql
.help_relation
;show create table mysql
.help_topic
;show create table mysql
.proc
;show create table mysql
.slow_log
;show create table mysql
.time_zone
;show create table mysql
.time_zone_leap_second
;show create table mysql
.time_zone_name
;show create table mysql
.time_zone_transition
;show create table mysql
.time_zone_transition_type
;
Caused by: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'xxxxxxx' for table 'slow_log', sqlState=42000, sqlStateMarker=#]
with command: show create table mysql
.event
;show create table mysql
.func
;show create table mysql
.general_log
;show create table mysql
.help_category
;show create table mysql
.help_keyword
;show create table mysql
.help_relation
;show create table mysql
.help_topic
;show create table mysql
.proc
;show create table mysql
.slow_log
;show create table mysql
.time_zone
;show create table mysql
.time_zone_leap_second
;show create table mysql
.time_zone_name
;show create table mysql
.time_zone_transition
;show create table mysql
.time_zone_transition_type
;
at com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.queryMulti(MysqlQueryExecutor.java:109) ~[canal.parse.driver-1.1.0.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.queryMulti(MysqlConnection.java:107) ~[canal.parse-1.1.0.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.dumpTableMeta(DatabaseTableMeta.java:175) ~[canal.parse-1.1.0.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta.rollback(DatabaseTableMeta.java:129) ~[canal.parse-1.1.0.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.AbstractMysqlEventParser.processTableMeta(AbstractMysqlEventParser.java:91) ~[canal.parse-1.1.0.jar:na]
at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:188) ~[canal.parse-1.1.0.jar:na]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_171
原提问者GitHub用户aslijiasheng
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。