Logstash does not reconnect when Oracle "SQLRecoverableException" is raised
edmocosta opened this issue · 0 comments
edmocosta commented
This problem is caused when a connection gets closed by Oracle (idle sessions, workload rules, network issues, etc.)
Logstash should gracefully recover from those errors, discarding the stale connection and reconnecting the client. Instead, the plugin hangs trying to reuse the closed/invalid connections.
It's the same sequel DB2 issue #143, but this time for oracle databases.
Fortunately, the latest sequel version is already fixed, so bumping the library should solve the problem.