java.lang.IllegalStateException: Logstash stopped processing because of an error: (SystemExit) exit

Elastic Stack Logstash
1

Hi There,

Got Stuck from last three days.

I m getting this error while starting the logstash. Could anyone help me on this.Stack trace is defined below :-
Sending Logstash logs to D:/Elasticsearch/logstash-7.9.1/logs which is now configured via log4j2.properties [2020-09-25T12:34:27,176][INFO ][logstash.runner ] Starting Logstash {"logstash.version"=>"7.9.1", "jruby.version"=>"jruby 9.2.13.0 (2.5.7) 2020-08-03 9a89c94bcc Java HotSpot(TM) 64-Bit Server VM 25.201-b09 on 1.8.0_201-b09 +indy +jit [mswin32-x86_64]"} [2020-09-25T12:34:27,629][WARN ][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified [2020-09-25T12:34:29,599][ERROR][logstash.agent ] Failed to execute action {:action=>LogStash::PipelineAction::Create/pipeline_id:main, :exception=>"LogStash::ConfigurationError", :message=>"Expected one of [A-Za-z0-9_-], [ \\t\\r\\n], \"#\", \"=>\" at line 11, column 20 (byte 527) after input {\n jdbc {\n jdbc_driver_library => \"D:\\\\Elastic - search\\\\mysql-connector-java-8.0.21\\\\mysql-connector-java-8.0.21.jar\"\n jdbc_driver_class => \"com.mysql.jdbc.Driver\"\n jdbc_connection_string => \"\"\n jdbc_user => \n jdbc_password => \n tracking_column", :backtrace=>["D:/Elasticsearch/logstash-7.9.1/logstash-core/lib/logstash/compiler.rb:32:in compile_imperative'", "org/logstash/execution/AbstractPipelineExt.java:183:in initialize'", "org/logstash/execution/JavaBasePipelineExt.java:69:in initialize'", "D:/Elasticsearch/logstash-7.9.1/logstash-core/lib/logstash/java_pipeline.rb:44:in initialize'", "D:/Elasticsearch/logstash-7.9.1/logstash-core/lib/logstash/pipeline_action/create.rb:52:in execute'", "D:/Elasticsearch/logstash-7.9.1/logstash-core/lib/logstash/agent.rb:357:in block in converge_state'"]} [2020-09-25T12:34:30,211][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600} [2020-09-25T12:34:34,950][INFO ][logstash.runner ] Logstash shut down. [2020-09-25T12:34:35,006][ERROR][org.logstash.Logstash ] java.lang.IllegalStateException: Logstash stopped processing because of an error: (SystemExit) exit.

Operating System: Window
Startup command : logstash.bat -f logstash-sample.conf

Configuration file sample is below:

# Sample Logstash configuration for creating a simple

Beats -> Logstash -> Elasticsearch pipeline.

input {
jdbc {
jdbc_driver_library => "D:\Elastic - search\mysql-connector-java-8.0.21\mysql-connector-java-8.0.21.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string =>
jdbc_user =>
jdbc_password =>
tracking_column¹ =>
use_column_value²=>true
statement => "";
schedule³ => " * * * * * *"
}
}

output {
elasticsearch {
document_id⁴=> "%{id}"
document_type => "doc"
index => "test"
hosts => ["http://localhost:9200"]
}
stdout{
codec => rubydebug
}
}

Thanks for the help in advance:!

2

Can you please respect syntax formatting using ```

Your configuration is unreadable and keeping us from debugging what's going wrong.

Please read guidelines for posting.

3

You need to fill in the values for these.

4

@grumo35 thanks for replying and i will check this mistake and i will correct it.

5

@Badger thanks for replying. i just use the local DB for testing. It is connecting.

6

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