Are you sure the command ran correctly? The pipe character after the K option is piping your kcat command into some -p 6 command, which wouldn't be valid.

You'll need to quote your key separator, or use a different one that's not interpreted by the shell

Are you sure the command ran correctly? The pipe character after the K option is piping your kcat command into some -p 6 command, which wouldn't be valid.

You'll need to quote your key separator, or use a different one that's not interpreted by the shell

Thank you for your reply.Sorry for the typo here.But in fact,I have this symbol （\）when I execute this command
echo '["mysqltest0216",{"server":"mysqltest021601"}]|{"ts_sec":1644913815,"file":"mysql-bin.002655","pos":1062699299,"row":1,"server_id":10011,"event":3}' | /usr/bin/kcat -P -b 10.7.102.13:9092 -t connect-offsets-01 -K | -p 6

When I copy this history command to here，the symbol （\） is automatically lost

You can use triple backticks to write code in github markdown

echo '["mysqltest0216",{"server":"mysqltest021601"}]|{"ts_sec":1644913815,"file":"mysql-bin.002655","pos":1062699299,"row":1,"server_id":10011,"event":3}' | /usr/bin/kcat -P -b 10.7.102.13:9092 -t connect-offsets-01 -K \| -p 6

But you could still change the delimiter to not use something interpreted by the shell

Overall, I don't think this is a kcat issue if you're able to produce and consume records to the topic... You could be using any other client to write the exact same message, and you'll have the same issues with the connector.

Perhaps open a ticket against the JDBC connector / Debezium repository for the connector you're using?

More specifically, how do you know that the combination of "ts_sec" "file" "pos" are correct?

I can't confirm if that is correct，I referenced the information on this site：https://debezium.io/documentation/faq/#how_to_change_the_offsets_of_the_source_database

Still, assuming kcat actually produced the correct event, the issue of whether the connector reset, or not, is a Debezium issue, and they have their own issue board which will provide better support for that

Thank you so much ，I will submit this question on their site.