当前位置:   article > 正文

The last packet successfully received from the server was 10,011 milliseconds ago. The last packet s

the last packet successfully received from the server was 10,011 millisecond

生产报错
The last packet successfully received from the server was 10,011 milliseconds ago. The last packet sent successfully to the server was 10,011 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

SELECT * FROM t_gps_pos_trace WHERE last_update_time >= ‘2023-12-25T18:30:25’ AND last_update_time <= ‘2024-01-02T09:15’ LIMIT 0,1000;

last_update_time没有加索引

是由于慢sql引起的超时,经排查发现是有个千万数据的表没有加索引,最后加上索引即可(顺便把一下不必要的数据清除)

声明:本文内容由网友自发贡献,转载请注明出处:【wpsshop博客】
推荐阅读
相关标签
  

闽ICP备14008679号