使用mysql导入kafka connect 输出也是mysql 报错record value schema is missing，求解答

最新推荐文章于 2024-08-15 11:27:04 发布

电大之家

最新推荐文章于 2024-08-15 11:27:04 发布

阅读量1.1k

点赞数

文章标签： kafka connect kafka

本文链接：https://blog.csdn.net/wylwsb/article/details/102837563

版权

在尝试使用Kafka Connect从Kafka导入数据到MySQL时，遇到了错误'PK mode for table 'dim_channel_copy' is RECORD_VALUE, but record value schema is missing'。该错误表明在记录主键模式为RECORD_VALUE的情况下，记录值的模式缺失。这可能是配置问题或数据格式不正确导致的。" 127353835,8269990,PAT乙级1064题解析：朋友数的统计方法,"['算法', '数据结构', 'C语言', 'PAT考试', '编程实践']

摘要由CSDN通过智能技术生成

[2019-10-31 14:37:32,956] ERROR WorkerSinkTask{id=mysql-sink-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted. (org.apache.kafka.connect.runtime.WorkerSinkTask:544)
org.apache.kafka.connect.errors.ConnectException: PK mode for table 'dim_channel_copy' is RECORD_VALUE, but record value schema is missing
   at io.confluent.connect.jdbc.sink.metadata.FieldsMetadata.extractRecordValuePk(FieldsMetadata.java:238)
   at io.confluent.connect.jdbc.sink.metadata.FieldsMetadata.extract(FieldsMetadata.java:102)
   at io.confluent.connect.jdbc.sink.metadata.FieldsMetadata.extract(FieldsMetadata.java:64)
   at io.confluent.connect.jdbc.sink.BufferedRecords.add(BufferedRecords.java:71)
   at io.confluent.connect.jdbc.sink.JdbcDbWriter.write(JdbcDbWriter.java:66)
   at io.confluent.connect.jdbc.sink.JdbcSinkTask.put(JdbcSinkTask.java:69)
   at