I am using ES 5.1.1 LS 5.1.1 and logstash-input-jdbc (4.1.3) With the following input config: input { jdbc { # Oracle jdbc connection string to Oracle database jdbc_connection_string => "jdbc:oracle:thin:@//host:port/sid" # The user we wish to execute our statement as jdbc_user => "user" jdb…

Problem solved. The problem is not the input plugin, but the jdbc output plugin. Defaul maximumPoolSize actually is 24. Not 5 as the doc says. I have 1 JDBC input and 4 JDBC outputs, so 1 + 24*4=97. In my case, I do not need pooling since there is only 1 user. Set: maximumPoolSize =>1

Jdbc input plugin with scheduler opens 96 extra connections to Oracle

Elastic Stack Logstash

system (system) Closed February 7, 2017, 8:59pm 3

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

Topic		Replies	Views
Logasth jdbc connection Logstash	1	265	May 28, 2020
Logstash JDBC Inputs SQL Connections are never closed Logstash	3	226	September 6, 2024
Logstash JDBC Input Plugin Connection Pooling Logstash jdbc	5	1345	August 28, 2023
Input plugin issue in maintaining JDBC connections Logstash	7	3610	July 6, 2017
Logstash JDBC input plugin skips few scheduled runs Logstash jdbc	6	147	July 17, 2024

Jdbc input plugin with scheduler opens 96 extra connections to Oracle

Related topics