You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-zh@flink.apache.org by "amenhub@163.com" <am...@163.com> on 2020/09/01 02:12:10 UTC

Re: 回复： flink1.11连接mysql问题

如果是mysql5.x以上的版本，url中autoReconnect参数会无效吧，

可以尝试下修改配置文件wait_timeout/interactive_out参数

best,
amenhub
 
发件人： 酷酷的浑蛋
发送时间： 2020-08-31 20:48
收件人： user-zh@flink.apache.org
主题： 回复： flink1.11连接mysql问题
 
 
下面是我连接mysql的配置，用的flink-1.11.1，还是报那个错误
CREATE TABLE xx(
  `xx` varchar,
  `xx` varchar
) WITH (
    'connector' = 'jdbc',
    'url' = 'jdbc:mysql://xx/xx?autoReconnect=true&failOverReadOnly=false',
    'table-name' = ‘xx',
    'driver' = 'com.mysql.jdbc.Driver',
    'username' = ‘xx',
    'password' = ‘xx',
    'scan.partition.column' = 'id',
    'scan.partition.num' = '50',
    'scan.partition.lower-bound' = '500',
    'scan.partition.upper-bound' = '1000',
    'scan.fetch-size' = '100',
    'lookup.cache.max-rows' = '5000',
    'lookup.cache.ttl' = '10s'
);
在2020年08月31日 17:33，Leonard Xu<xb...@gmail.com> 写道：
 
 
在 2020年8月28日，15:02，酷酷的浑蛋 <ap...@163.com> 写道：
 
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 52,445,041 milliseconds ago. The last packet sent successfully to the server was 52,445,045 milliseconds ago. is longer than the server configured value of'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, orusing the Connector/J connection property 'autoReconnect=true' to avoid this problem.
 
 
 
 
flink连接mysql，在过了一定时间后，就断开连接了，设置'autoReconnect=true’也不管用
 
 
 
Hi
 
超时断开问题在1.11应该已经修复[1]，你是怎么使用的？可以提供更多的信息吗
 
Best
Leonard
[1]https://issues.apache.org/jira/browse/FLINK-16681 <https://issues.apache.org/jira/browse/FLINK-16681>

回复： flink1.11连接mysql问题

Posted by 酷酷的浑蛋 <ap...@163.com>.
你是说让我修改mysql配置？ 怎么可能允许我修改啊




在2020年09月1日 10:12，amenhub@163.com<am...@163.com> 写道：
如果是mysql5.x以上的版本，url中autoReconnect参数会无效吧，

可以尝试下修改配置文件wait_timeout/interactive_out参数

best,
amenhub

发件人： 酷酷的浑蛋
发送时间： 2020-08-31 20:48
收件人： user-zh@flink.apache.org
主题： 回复： flink1.11连接mysql问题


下面是我连接mysql的配置，用的flink-1.11.1，还是报那个错误
CREATE TABLE xx(
`xx` varchar,
`xx` varchar
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:mysql://xx/xx?autoReconnect=true&failOverReadOnly=false',
'table-name' = ‘xx',
'driver' = 'com.mysql.jdbc.Driver',
'username' = ‘xx',
'password' = ‘xx',
'scan.partition.column' = 'id',
'scan.partition.num' = '50',
'scan.partition.lower-bound' = '500',
'scan.partition.upper-bound' = '1000',
'scan.fetch-size' = '100',
'lookup.cache.max-rows' = '5000',
'lookup.cache.ttl' = '10s'
);
在2020年08月31日 17:33，Leonard Xu<xb...@gmail.com> 写道：


在 2020年8月28日，15:02，酷酷的浑蛋 <ap...@163.com> 写道：

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 52,445,041 milliseconds ago. The last packet sent successfully to the server was 52,445,045 milliseconds ago. is longer than the server configured value of'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, orusing the Connector/J connection property 'autoReconnect=true' to avoid this problem.




flink连接mysql，在过了一定时间后，就断开连接了，设置'autoReconnect=true’也不管用



Hi

超时断开问题在1.11应该已经修复[1]，你是怎么使用的？可以提供更多的信息吗

Best
Leonard
[1]https://issues.apache.org/jira/browse/FLINK-16681 <https://issues.apache.org/jira/browse/FLINK-16681>