nortrom-lh commented on issue #276: URL: https://github.com/apache/flink-cdc/issues/276#issuecomment-2316603304
> 在等待社区大佬处理时，在[https://debezium.io/上发现类似的报错，有调整MySQL参数验证过没？](https://debezium.io/%E4%B8%8A%E5%8F%91%E7%8E%B0%E7%B1%BB%E4%BC%BC%E7%9A%84%E6%8A%A5%E9%94%99%EF%BC%8C%E6%9C%89%E8%B0%83%E6%95%B4MySQL%E5%8F%82%E6%95%B0%E9%AA%8C%E8%AF%81%E8%BF%87%E6%B2%A1%EF%BC%9F) What is causing intermittent EventDataDeserializationExceptions with the MySQL connector? When you run into intermittent deserialization exceptions around 1 minute after starting connector, with a root cause of type EOFException or java.net.SocketException: Connection reset: > > Caused by: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4{timestamp=1542193955000, eventType=GTID, serverId=91111, headerLength=19, dataLength=46, nextPosition=1058898202, flags=0} Caused by: java.lang.RuntimeException: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4{timestamp=1542193955000, eventType=GTID, serverId=91111, headerLength=19, dataLength=46, nextPosition=1058898202, flags=0} Caused by: java.io.EOFException > > or > > Caused by: java.net.SocketException: Connection reset Then updating these MySQL server global properties like this will fix it: > > set global slave_net_timeout = 120; (default was 30sec) set global thread_pool_idle_timeout = 120; 已测试，问题还会再次发生。 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
