SQLException: ORA-02396: exceeded maximum idle time

Elastic Stack Logstash
1

Hi Team,
I tried to push bulk data using logstash configuration file.I have given all database connection related parameters and query but after sometime connection closed and getting below exception:

Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaSql::SQLException: ORA-02396: exceeded maximum idle time, please connect again

}

How to resolve it.

2

It looks like the server is closing the idle connection. Isn't Logstash reconnecting as it should, or what's the real problem here?

3

Try version 4.3.1 of the JDBC input plugin. It was recently (22 days ago) patched to open and close a connection for each query.