Logstash Exception: Connection reset by peer

(Farhad Yousefi) #1

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

(Magnus B├Ąck) #2

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

(system) #3

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