search

logstash-plugins / logstash-input-jdbc

Logstash Plugin for JDBC Inputs
Apache License 2.0
449 stars 187 forks source link

Communications link failure #285

Open hexiaohong-code opened 6 years ago

hexiaohong-code commented 6 years ago

Logstash run for a period of time will be submitted to the following exception, actually database is normal

[2018-05-19T11:16:22,453][ERROR][logstash.inputs.jdbc ] Unable to connect to database. Trying again {:error_message=>"Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 146,764 milliseconds ago. The last packet sent successfully to the server was 142,403 milliseconds ago."} [2018-05-19T11:16:45,153][ERROR][logstash.inputs.jdbc ] Unable to connect to database. Trying again {:error_message=>"Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 145,172 milliseconds ago. The last packet sent successfully to the server was 114,314 milliseconds ago."} [2018-05-19T11:12:16,708][ERROR][logstash.inputs.jdbc ] Unable to connect to database. Trying again {:error_message=>"Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 106,561 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago."}

Can you help to solve?

junym21 commented 5 years ago

+1

hexiaohong-code commented 5 years ago

+1

The problem has been solved, just upgrade logstash.the old version of logstash have memory leak