开发者社区 > 数据库 > 正文

聚石塔内的RDS部署无效

问题描述
我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

展开
收起
Java工程师 2023-05-08 19:05:09 129 0
1 条回答
写回答
取消 提交回答
  • 去掉mysql库的订阅

    原回答者GitHub用户agapple

    2023-05-09 19:05:06
    赞同 展开评论 打赏

数据库领域前沿技术分享与交流

相关产品

  • 云数据库 RDS MySQL 版
  • 相关电子书

    更多
    TcpRT:阿里云RDS智能诊断系统云上大规模部署自动化服务的客户实践经验 立即下载
    TcpRT:面向大规模海量云数据库的服务质量实时采集与诊断系 立即下载
    袋鼠云基于阿里云RDS的数据库架构实践 立即下载

    相关镜像