# RuntimeException occurs when importing data from mysql

**URL:** <https://discuss.elastic.co/t/runtimeexception-occurs-when-importing-data-from-mysql/70050>\
**Category:** Logstash\
**Created:** [December 27, 2016, 8:58am UTC](https://discuss.elastic.co/t/runtimeexception-occurs-when-importing-data-from-mysql/70050 "2016-12-27T08:58:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![catinred2](https://avatars.discourse-cdn.com/v4/letter/c/df705f/32.png) [@catinred2](https://discuss.elastic.co/u/catinred2)\
**Post date:** [December 27, 2016, 8:58am UTC](https://discuss.elastic.co/t/runtimeexception-occurs-when-importing-data-from-mysql/70050/1 "2016-12-27T08:58:34Z")

</div>

I am trying to import data from mysql to elastic by logstash-input-jdbc plugin.  
I've successfully imported simple data into elastic, the plugin works fine.  
But when it comes to complicated data table, e.g. some field contains Chinese character, it will raise exception like I paste below.  
Any suggestions? Thanks.

Env:  
Centos 7.3/x64/java version "1.8.0\_111"/logstash-5.1.1/elasticsearch-5.1.1

Exception:

[2016-12-27T16:32:41,048][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
Exception in thread "[main]\>worker3" org.logstash.ackedqueue.QueueRuntimeException: deserialize invocation error  
at org.logstash.ackedqueue.Queue.deserialize(Queue.java:532)  
at org.logstash.ackedqueue.Page.lambda$readBatch$0(Page.java:57)  
at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)  
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374)  
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)  
at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)  
at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)  
at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)  
at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)  
at org.logstash.ackedqueue.Page.readBatch(Page.java:57)  
at org.logstash.ackedqueue.Queue.\_readPageBatch(Queue.java:406)  
at org.logstash.ackedqueue.Queue.readBatch(Queue.java:397)  
at org.logstash.ackedqueue.ext.JrubyAckedQueueExtLibrary$RubyAckedQueue.ruby\_read\_batch(JrubyAckedQueueExtLibrary.java:125)  
at org.logstash.ackedqueue.ext.JrubyAckedQueueExtLibrary$RubyAckedQueue$INVOKER$i$2$0$ruby\_read\_batch.call(JrubyAckedQueueExtLibrary$RubyAckedQueue$INVOKER$i$2$0$ruby\_read\_batch.gen)  
at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:346)  
at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:204)  
at org.jruby.ast.CallTwoArgNode.interpret(CallTwoArgNode.java:59)  
at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)  
at org.jruby.ast.BlockNode.interpret(BlockNode.java:71)  
at org.jruby.evaluator.ASTInterpreter.INTERPRET\_METHOD(ASTInterpreter.java:74)  
at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:225)  
at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:219)  
at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:346)  
at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:204)

---

<div class="post-metadata">

**Author:** ![jsvd](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsvd/32/6203_2.png) [@jsvd](https://discuss.elastic.co/u/jsvd)\
**Post date:** [December 27, 2016, 10:03am UTC](https://discuss.elastic.co/t/runtimeexception-occurs-when-importing-data-from-mysql/70050/2 "2016-12-27T10:03:55Z")

</div>

@catinred2 this seems to be a bug, can you open an issue in [https://github.com/logstash-plugins/logstash-input-jdbc/issues](https://github.com/logstash-plugins/logstash-input-jdbc/issues) with this content? thank you!

---

<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:** [January 24, 2017, 10:05am UTC](https://discuss.elastic.co/t/runtimeexception-occurs-when-importing-data-from-mysql/70050/3 "2017-01-24T10:05:03Z")

</div>

Closed on January 24, 2017, 10:05am UTC

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