Input jdbc plugin network issue

(Jayadeep Reddy) #1

we are using the logstash JDBC scheduler to fetch data every 10 seconds. It is working fine, but with the network glitches it is not able to make a connection again after the network is up. Always it is returning

←[33mException when executing JDBC query {:exception=>#<Sequel::DatabaseError: J
ava::JavaSql::SQLException: [NetSuite][SuiteAnalytics Connect JDBC Driver]Intern
al network error, connection closed.>, :level=>:warn}←[0m
←[31mJava::JavaSql::SQLException: [NetSuite][SuiteAnalytics Connect JDBC Driver]
Internal network error, connection closed.:

When we stop and start the process it is working

Snippet of config file:

jdbc_pool_timeout => 100 
jdbc_validation_timeout => 60 
sequel_opts => {"login_timeout" => 60} 
schedule => "* * * * * *" 
jdbc_validate_connection => true; 

Any Solution?

(system) #2

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