# Logstash-input-jdbc raise error\_message=\>"\\"\\\\x89\\" from ASCII-8BIT to UTF-8"

**URL:** <https://discuss.elastic.co/t/logstash-input-jdbc-raise-error-message-x89-from-ascii-8bit-to-utf-8/190540>\
**Category:** Logstash\
**Created:** [July 15, 2019, 1:14pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-raise-error-message-x89-from-ascii-8bit-to-utf-8/190540 "2019-07-15T13:14:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![muzijiang](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@muzijiang](https://discuss.elastic.co/u/muzijiang)\
**Post date:** [July 15, 2019, 1:14pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-raise-error-message-x89-from-ascii-8bit-to-utf-8/190540/1 "2019-07-15T13:14:48Z")

</div>

When I use logstash-input-jdbc plugin collect infor from Oracle database, it raised the following error messages.

input {  
jdbc {  
jdbc\_validate\_connection =\> true  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@xx.xx.xx.xx:1521/xxx"  
jdbc\_user =\> "system"  
jdbc\_password =\> "oracle"  
jdbc\_driver\_library =\> ""  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
statement =\> "select \* from v$active\_session\_history where sample\_time \> :sql\_last\_value"  
last\_run\_metadata\_path =\> "/tmp/.logstash.lastrun"  
record\_last\_run =\> true  
schedule =\> "\*/2 \* \* \* \*"  
}  
}

output {  
elasticsearch {  
hosts =\> ["[http://xx.x.xx.xx:9200](http://xx.x.xx.xx:9200)"]  
index =\> "logstash-[version]}-%{+YYYY.MM.dd}"  
#user =\> "elastic"  
#password =\> "changeme"  
}  
}

[2019-07-15T20:07:13,493][ERROR][logstash.outputs.elasticsearch] An unknown error occurred sending a bulk request to Elasticsearch. We will retry indefinitely {:error\_message=\>""\xE1" from ASCII-8BIT to UTF-8", :error\_class=\>"LogStash::Json::GeneratorError", :backtrace=\>["/usr/share/logstash/logstash-core/lib/logstash/json.rb:27:in `jruby_dump'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/http_client.rb:119:in`block in bulk'", "org/jruby/RubyArray.java:2577:in `map'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/http_client.rb:119:in`block in bulk'", "org/jruby/RubyArray.java:1792:in `each'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/http_client.rb:117:in`bulk'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/common.rb:296:in `safe_bulk'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/common.rb:201:in`submit'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/common.rb:169:in `retrying_submit'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-output-elasticsearch-10.1.0-java/lib/logstash/outputs/elasticsearch/common.rb:38:in`multi\_receive'", "org/logstash/config/ir/compiler/OutputStrategyExt.java:118:in `multi_receive'", "org/logstash/config/ir/compiler/AbstractOutputDelegatorExt.java:101:in`multi\_receive'", "/usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:239:in `block in start\_workers'"]}

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 12, 2019, 1:14pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-raise-error-message-x89-from-ascii-8bit-to-utf-8/190540/2 "2019-08-12T13:14:50Z")

</div>

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