开发者社区 问答 正文

canal-server对接了dts的实例时,报CanalParseException: fetc

cannal-server在监听接了阿里dts的实例时,会报这个错,然后connal-server就不在往client推数据变更了

提问198.png

2019-11-08 07:56:36.314 [destination = weps , address = rm-bpyo.mysql.rds.aliyuncs.com/xxx.xxx:3306 EventtParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:weps[com.alibaba.otter.canal.parse.exception.CanalParseException: com.alibaba.otter.canal.parse.exception.CanalParseException: com.alibaba.otter.canal.parse.exception.CanalParseException: fetch failed by table meta:dts.dts_trx4unit_mark_17 Caused by: com.alibaba.otter.canal.parse.exception.CanalParseException: com.alibaba.otter.canal.parse.exception.CanalParseException: fetch failed by table meta:dts.dts_trx4unit_mark_17 Caused by: com.alibaba.otter.canal.parse.exception.CanalParseException: fetch failed by table meta:dts.dts_trx4unit_mark_17 Caused by: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW command denied to user 'xxx' for table 'dts_trx4unit_mark_17', sqlState=42000, sqlStateMarker=#] with command: show create table dts.dts_trx4unit_mark_17 at com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.query(MysqlQueryExecutor.java:61) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.query(MysqlConnection.java:106) at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.TableMetaCache.getTableMeta(TableMetaCache.java:177) at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.getTableMeta(LogEventConvert.java:950) at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.parseRowsEventForTableMeta(LogEventConvert.java:479) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlMultiStageCoprocessor$SimpleParserStage.onEvent(MysqlMultiStageCoprocessor.java:280) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlMultiStageCoprocessor$SimpleParserStage.onEvent(MysqlMultiStageCoprocessor.java:246) at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168) at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) ]

原提问者GitHub用户NoNException

展开
收起
Java工程师 2023-05-03 15:52:01 110 分享 版权
1 条回答
写回答
取消 提交回答
  • SHOW command denied to user 'xxx' for table 'dts_trx4unit_mark_17', sqlState=42000, sqlStateMarker=#]

    没有权限

    原回答者GitHub用户agapple

    2023-05-04 16:45:51
    赞同 展开评论
问答分类:
问答标签:
问答地址: