Re: [I] 请问出现这个错误(io.debezium.DebeziumException: Failed to deserialize data of EventHeaderV4{timestamp=1627541881000,)是什么原因? [flink-cdc]

["yoheimuta (via GitHub)" <gi...@apache.org>]

yoheimuta commented on issue #276:
URL: https://github.com/apache/flink-cdc/issues/276#issuecomment-2623391981

   If your issue occurs only with a large table, it’s worth sharing.
   
   We encountered the same issue before and resolved it by increasing `net_write_timeout` to 3600 seconds. This issue occurs when Flink experiences backpressure, causing the **mysql-cdc** client to stop receiving TCP packets for an extended period, which eventually leads to the MySQL server disconnecting it.
   
   > The number of seconds to wait for a block to be written to a connection before aborting the write.
   https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_net_write_timeout
   
   We can observe this behavior using `tcpdump`, where the client periodically sends a **TCP Zero Window** to the server, and the server eventually responds by sending a **FIN** packet.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org