Logstash Exception: Connection reset by peer

I want to monitor our exception table via logstash. but I have got this error.

[2018-02-07T15:43:11,344][ERROR][org.logstash.beats.BeatsHandler] Exception: Connection reset by peer
[2018-02-07T15:44:00,478][INFO ][logstash.inputs.jdbc     ] (0.161000s) SELECT * FROM EXCEPTION

here is my logstash configure:

 jdbc {
    jdbc_driver_library => "etc/logstash/lib/db2jcc4.jar"
    jdbc_driver_class => "com.ibm.db2.jcc.DB2Driver"
    jdbc_connection_string => "jdbc:db2://ip:port/db"
    jdbc_user => "usr"
    jdbc_password => "pass"
    schedule => "* * * * *"
    statement => "SELECT * FROM EXCEPTION" 
    type => "EXCEPTION"      

I really appreciate it if anyone can help me. thank you

The error is related to your beats input. It looks like the client disconnected.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.