开发者社区> 问答> 正文

单表Pipeline管理->日志记录报错

数据单向同步日志记录中报错: tu16.png

求大神指点。

报错信息如下:

pid:1 nid:1 exception:setl:com.alibaba.otter.node.etl.select.exceptions.SelectException: com.alibaba.otter.node.etl.select.exceptions.SelectException: this rowdata has no pks , entry: header { version: 1 logfileName: "mysql-bin.000005" logfileOffset: 35321 serverId: 1 serverenCode: "UTF-8" executeTime: 1542176173000 sourceType: MYSQL schemaName: "test" tableName: "user" eventLength: 48 eventType: INSERT props { key: "rowsCount" value: "1" } } entryType: ROWDATA storeValue: "\bn\020\001P\000bF\022\034\b\000\020\004\032\002id \000(\0010\000B\003212R\aint(11)\022&\b\001\020\f\032\004name \000(\0010\000B\ahahahahR\vvarchar(50)" and rowData: afterColumns { index: 0 sqlType: 4 name: "id" isKey: false updated: true isNull: false value: "212" mysqlType: "int(11)" } afterColumns { index: 1 sqlType: 12 name: "name" isKey: false updated: true isNull: false value: "hahahah" mysqlType: "varchar(50)" }

at com.alibaba.otter.node.etl.select.selector.MessageParser.parse(MessageParser.java:212) at com.alibaba.otter.node.etl.select.selector.canal.CanalEmbedSelector.selector(CanalEmbedSelector.java:278) at com.alibaba.otter.node.etl.select.SelectTask.processSelect(SelectTask.java:236) at com.alibaba.otter.node.etl.select.SelectTask.access$300(SelectTask.java:94) at com.alibaba.otter.node.etl.select.SelectTask$1.run(SelectTask.java:208) 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) Caused by: com.alibaba.otter.node.etl.select.exceptions.SelectException: this rowdata has no pks , entry: header { version: 1 logfileName: "mysql-bin.000005" logfileOffset: 35321 serverId: 1 serverenCode: "UTF-8" executeTime: 1542176173000 sourceType: MYSQL schemaName: "test" tableName: "user" eventLength: 48 eventType: INSERT props { key: "rowsCount" value: "1" } } entryType: ROWDATA storeValue: "\bn\020\001P\000bF\022\034\b\000\020\004\032\002id \000(\0010\000B\003212R\aint(11)\022&\b\001\020\f\032\004name \000(\0010\000B\ahahahahR\vvarchar(50)" and rowData: afterColumns { index: 0 sqlType: 4 name: "id" isKey: false updated: true isNull: false value: "212" mysqlType: "int(11)" } afterColumns { index: 1 sqlType: 12 name: "name" isKey: false updated: true isNull: false value: "hahahah" mysqlType: "varchar(50)" }

at com.alibaba.otter.node.etl.select.selector.MessageParser.internParse(MessageParser.java:585) at com.alibaba.otter.node.etl.select.selector.MessageParser.internParse(MessageParser.java:391) at com.alibaba.otter.node.etl.select.selector.MessageParser.parse(MessageParser.java:142) ... 9 more

tu17.png tu18.png tu19.png

原提问者GitHub用户shubiao-yao

展开
收起
古拉古拉 2023-06-16 19:57:11 57 0
1 条回答
写回答
取消 提交回答
  • 问题已解决,我这导致这个问题的原因是两张表都没设置主键。我把主键加上就可以了

    原回答者GitHub用户shubiao-yao

    2023-06-16 20:18:54
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
Kubernetes下日志实时采集、存储与计算实践 立即下载
日志数据采集与分析对接 立即下载
智能化日志中心 立即下载