I am kinda sure this is a bug! Because if I just use logstash-input-jdbc without using sqlite plugin I can import my sqlite data successfully!
Someone opened an issue at Logstash with sqllite3 problem · Issue #9788 · elastic/logstash · GitHub but it was closed.
Someone asked a similar question here Sqlite input plugin not working - #4 by Badger but no one answered.
I said a "similar" question b/c I am not sure it is exactly the same as mine. I check sqlite.rb:160
it is event = LogStash::Event.new("host" => @host, "db" => @db)
So why LogStash::Event.new failed ?
BTW, it uses sqlite-jdbc-3.20.1.jar
[2018-09-28T15:24:56,912][ERROR][logstash.pipeline ] A plugin had an unrecoverable error. Will restart this plugin.
Pipeline_id:main
Plugin: <LogStash::Inputs::Sqlite type=>"zh_text", path=>"./logstash.db", id=>"ec93cf323f8c401f8e8fd9d05f60fb0daeaf294a75127f75142b4024963b1a43", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_31da0d31-f2a4-416a-ac49-3f449e3ce3af", enable_metric=>true, charset=>"UTF-8">, batch=>5>
Error: Missing Converter handling for full class name=org.jruby.RubyObjectVar9, simple name=RubyObjectVar9
Exception: Java::OrgLogstash::MissingConverterException
Stack: org.logstash.Valuefier.fallbackConvert(Valuefier.java:97)
org.logstash.Valuefier.convert(Valuefier.java:75)
org.logstash.ConvertedMap$1.visit(ConvertedMap.java:35)
org.logstash.ConvertedMap$1.visit(ConvertedMap.java:29)
org.jruby.RubyHash.visitLimited(RubyHash.java:662)
org.jruby.RubyHash.visitAll(RubyHash.java:647)
org.logstash.ConvertedMap.newFromRubyHash(ConvertedMap.java:69)
org.logstash.ext.JrubyEventExtLibrary$RubyEvent.ruby_initialize(JrubyEventExtLibrary.java:72)
usr.local.Cellar.logstash.$6_dot_4_dot_1.libexec.vendor.bundle.jruby.$2_dot_3_dot_0.gems.logstash_minus_input_minus_sqlite_minus_3_dot_0_dot_4.lib.logstash.inputs.sqlite.RUBY$block$run$2(/usr/local/Cellar/logstash/6.4.1/libexec/vendor/bundle/jruby/2.3.0/gems/logstash-input-sqlite-3.0.4/lib/logstash/inputs/sqlite.rb:160)
Thanks,
Qiulang
