Class JDBC not found

Elastic Stack Logstash
1

I'm trying to ingest data using logstash 1.5 to an ES 1.5 index. Every time I run logstash gives error

D:\ES\logstash-1.5.1\bin>logstash -f logstash_conf.conf
io/console not supported; tty will not be manipulated
The error reported is:
** Couldn't find any input plugin named 'jdbc'. Are you sure this is correct? Trying to load the jdbc input plugin resulted in this error: no such file to load -- logstash/inputs/jdbc**

I've set classpath env variable but no use.
I tried to install Jdbc plugin in logstash using command
plugin install logstash-input-jdbc

It gives me error:

io/console not supported; tty will not be manipulated
Validating logstash-input-jdbc
Unable to download data from https://rubygems.org/ - Received fatal alert: protocol_version (https://api.rubygems.org/latest_specs.4.8.gz)
ERROR: Installation aborted, verification failed for logstash-input-jdbc

Then I tried to install it manually. I download latest_specs.4.8.gz from https://api.rubygems.org/latest_specs.4.8.gz
and tried to install it using command
plugin install "path\latest_specs.4.8.gz"
or
plugin install file:\\D:\ES\latest_specs.4.8.gz

both give me same following error:

io/console not supported; tty will not be manipulated
Validating file:\\D:\ES\latest_specs.4.8.gz
Unable to download data from https://rubygems.org/ - Received fatal alert: protocol_version (https://api.rubygems.org/latest_specs.4.8.gz)
ERROR: Installation aborted, verification failed for file:\\D:\ES\latest_specs.4.8.gz

I'm messing with it like for 2 days rolling between rivers and logstash.
Any help would be appreciated.

2

Use a more recent version of Logstash. As long as you manage mappings yourself I think it is backwards compatible.

3

@Christian_Dahlqvist thnx for replying

Would logstash 5.x or higher be suitable to ingest data in ES 1.5 cluster?

4

I would take the latest version and see if it works. I have not used such old version in ages so can not tell for sure.

5

Ok I'll check latest logstash

6

If the latest does not work try version 6.7.

7

I tried logstash 6.7 it read input from sql server successfully but it couldn't ingest it into my cluster.
Here my logstash logs:

image
image.png1366×768 151 KB

Do they make you understand anything?

8

It sounds like your cluster is overloaded or that you are indexing into a large number of shards. Without knowing anything about your cluster or usecase it is hard to be more precise. Have a look at this blog post for more information on bulk rejections (429 responses as mentioned in the logs). How did you configure Logstash?