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 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引起的超时，经排查发现是有个千万数据的表没有加索引，最后加上索引即可（顺便把一下不必要的数据清除）