admin管理员组

文章数量:1618727

文章目录

  • 背景
  • 一、步骤
    • 1.修改/etc/myf配置文件

背景

报错信息：
“success”: false,
“msg”: “同步失败:\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 244,056 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.\n### The error may exist in class path resource [mybatis/mappers/dataCollection/DataCollectionMapper.xml]\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: select * from ( select t.*,t.table_name_cn as tableNameCn,i2.status as collectionStatus,pt.cron_express,sy.name as systemName from t_data_collection_table t LEFT JOIN (select i.collection_id,MAX(i.id) id from t_log_info i GROUP BY i.collection_id) b ON t.id=b.collection_id LEFT JOIN t_log_info i2 ON b.id=i2.id LEFT JOIN t_prehandle_task pt on pt.id =t.cron_plan_id left join t_datasource td on td.id=t.source_id left join t_source_system sy on sy.id=td.system_id ) as a where 1=1 and a.source_id = ? order by collectionStatus desc ,a.status desc, a.last_collection_time desc,a.id asc\n### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 244,056 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.\n; Communications link failure\n\nThe last packet successfully received from the server was 244,056 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 244,056 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.”,
“obj”: null,
“errorCode”: -1

说明：简单的方法，修改wait_timeout值。

一、步骤

1.修改/etc/myf配置文件

在/etc/myf里面修改wait_timeout值。

*注：linux值为1至31536000，可根据实际情况调整。

本文标签： failurePacketCommunicationsLINKsuccessfully

版权声明：本文标题：Communications link failure，The last packet successfully received from the server was 244056 millis 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.elefans.com/xitong/1728782788a1172938.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。