# Logstasch pipe line error **URL:** \ **Category:** Logstash\ **Created:** [October 2, 2018, 7:45am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656 "2018-10-02T07:45:29Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Mohamed.Yousry](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@Mohamed.Yousry](https://discuss.elastic.co/u/Mohamed.Yousry)\ **Post date:** [October 2, 2018, 7:45am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/1 "2018-10-02T07:45:29Z")
Hi There I am facing a problem each time I start logstash , below are the errors, Can you support Sending Logstash logs to C:/ELK\_STACK/logstash-6.4.0/logs which is now configured via log4j2.properties [2018-10-02T09:12:34,755][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified [2018-10-02T09:12:35,505][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.4.0"} [2018-10-02T09:12:38,003][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50} [2018-10-02T09:12:38,395][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>[], :added=\>[[http://127.0.0.1:9200/](http://127.0.0.1:9200/)]}} [2018-10-02T09:12:38,411][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[http://127.0.0.1:9200/](http://127.0.0.1:9200/), :path=\>"/"} [2018-10-02T09:12:38,603][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://127.0.0.1:9200/](http://127.0.0.1:9200/)"} [2018-10-02T09:12:38,658][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6} [2018-10-02T09:12:38,664][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6} [2018-10-02T09:12:38,700][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//127.0.0.1:9200](https://127.0.0.1:9200)"]} [2018-10-02T09:12:38,720][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil} [2018-10-02T09:12:38,769][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"match"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_float"}}}}}}}} [2018-10-02T09:12:39,253][ERROR][logstash.pipeline] Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"\"postgres", schedule=\>"\*/1 \* \* \* \*", add\_field=\>{"origin"=\>"sms\_1"}, jdbc\_validate\_connection=\>true, jdbc\_password=\>, statement=\>"select \* from a2p where date like '2018-08-01 01%'; ", jdbc\_driver\_library=\>"C:\\ELK\_STACK\\postgresql-42.2.5.jre6.jar", jdbc\_connection\_string=\>"jdbc:postgresql://localhost:5433/smsc", id=\>"da27f63e923d60e18a6dd65f6cdbe33e38c64bb2563e82bd37391c5bf140cdbc", jdbc\_driver\_class=\>"org.postgresql.Driver", enable\_metric=\>true, codec=\>\"plain\_89389bf1-15d8-4efb-9694-64881409eea3", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, last\_run\_metadata\_path=\>"C:\\Users\\IOT & M2M/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\>", :error=\>"(): 'reader' unacceptable code point '\u0000' (0x0) special characters are not allowed\nin "'reader'", position 0 at line 0 column 0", :thread=\>"#\"} [2018-10-02T09:12:39,704][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\, :backtrace=\>["org/jruby/ext/psych/PsychParser.java:231:in `parse'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/psych.rb:377:in`parse\_stream'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/psych.rb:325:in `parse'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/psych.rb:252:in`load'", "C:/ELK\_STACK/logstash-6.4.0/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin\_mixins/value\_tracking.rb:106:in `read'", "C:/ELK_STACK/logstash-6.4.0/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin_mixins/value_tracking.rb:80:in`get\_initial'", "C:/ELK\_STACK/logstash-6.4.0/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin\_mixins/value\_tracking.rb:36:in `initialize'", "C:/ELK_STACK/logstash-6.4.0/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/plugin_mixins/value_tracking.rb:29:in`build\_last\_value\_tracker'", "C:/ELK\_STACK/logstash-6.4.0/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.11/lib/logstash/inputs/jdbc.rb:216:in `register'", "C:/ELK_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:241:in`register\_plugin'", "C:/ELK\_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:252:in `block in register_plugins'", "org/jruby/RubyArray.java:1734:in`each'", "C:/ELK\_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:252:in `register_plugins'", "C:/ELK_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:395:in`start\_inputs'", "C:/ELK\_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:293:in `start_workers'", "C:/ELK_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:199:in`run'", "C:/ELK\_STACK/logstash-6.4.0/logstash-core/lib/logstash/pipeline.rb:159:in `block in start'"], :thread=\>"#\"} [2018-10-02T09:12:39,731][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil} [2018-10-02T09:12:40,075][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600} ---
**Author:** ![pjanzen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pjanzen/32/13756_2.png) [@pjanzen](https://discuss.elastic.co/u/pjanzen)\ **Post date:** [October 2, 2018, 7:55am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/2 "2018-10-02T07:55:01Z")
> [@Mohamed.Yousry](#): > > [2018-10-02T09:12:39,704][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\ **Author:** ![Mohamed.Yousry](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@Mohamed.Yousry](https://discuss.elastic.co/u/Mohamed.Yousry)\ **Post date:** [October 2, 2018, 8:24am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/3 "2018-10-02T08:24:26Z") Query is working fine, I just applied on DB and working fine Do you have any other suggestion ? ---
**Author:** ![pjanzen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pjanzen/32/13756_2.png) [@pjanzen](https://discuss.elastic.co/u/pjanzen)\ **Post date:** [October 2, 2018, 11:03am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/4 "2018-10-02T11:03:49Z")
Not really, I have never used jdbc. This [link might help](https://discuss.elastic.co/t/logstash-5-1-2-starting-with-errors/72188/7), it mentions the same error. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [October 2, 2018, 11:07am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/5 "2018-10-02T11:07:49Z")
It probably makes it easier for someone to help if you show your configuration. ---
**Author:** ![Mohamed.Yousry](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@Mohamed.Yousry](https://discuss.elastic.co/u/Mohamed.Yousry)\ **Post date:** [October 2, 2018, 11:25am UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/6 "2018-10-02T11:25:20Z")
![CONF](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a3dd90c97f42e04a2cd82ae45f52a61742ea5243.jpeg) Hi Christian Attached is the configuration file ---
**Author:** ![Mohamed.Yousry](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@Mohamed.Yousry](https://discuss.elastic.co/u/Mohamed.Yousry)\ **Post date:** [October 4, 2018, 12:35pm UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/7 "2018-10-04T12:35:28Z")
Any one can support? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 1, 2018, 12:35pm UTC](https://discuss.elastic.co/t/logstasch-pipe-line-error/150656/8 "2018-11-01T12:35:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.