flink使用时态表ddl创建mysql维表报错问题

Question

使用flinksql的ddl创建mysql维表，其中还用了lookup缓存，当程序运行一段时间后会报mysql链接失效问题，请问一下有知道怎么解决的吗，万分感谢，报错如下。
1、com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
2、The last packet successfully received from the server was 5,444,249 milliseconds ago. The last packet sent successfully to the server was 5,444,275 milliseconds ago.
3、Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

Answer 1

以下是建表语句
CREATE TABLE activity(
code string,
title string,
proctime as PROCTIME()
)WITH (
'connector.url' = 'jdbc:mysql://192.168.100.100:3306/ylfin?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&serverTimezone=GMT%2B8',
'connector.table' = 'activity',
'connector.type' = 'jdbc',
'connector.driver' = 'com.mysql.cj.jdbc.Driver',
'connector.lookup.cache.max-rows' = '10000',
'connector.lookup.cache.ttl' = '60s',
'connector.lookup.max-retries' = '3',
'connector.username' = 'root'," +
'connector.password' = 'hellomonitor')

Answer 2

检查MySQL服务，如果没问题的话就是你的维表使用方式，是否显示使用lookup join，单纯的join会导致状态过大如果没有状态ttl机制会出现taskmanager OOM之前踩过一次坑