Error when importing DATETIME field using sqlite plugin

Elastic Stack Logstash
1

I'm unable to import an SQLite db containing a DATETIME field (eg. 2017-03-22 16:04:22) into Logstash using the SQLite plugin (it worked after I modified the db and changed this field to a string). My Configuration file looks like this:

input {
sqlite {
path => "March Server 25.db"
}
}

output {
elasticsearch {
hosts => ["localhost:9200"]
index => "datetest"
}
stdout{ codec => rubydebug}
}

Any pointers on how to import a DATETIME field in SQLite would be greatly appreciated!

2

In what way is it not working?

3

Magnus, I get the following error. If I remove the DATETIME field or change it to string, then the data is successfully imported

Plugin: <LogStash::Inputs::Sqlite path=>"dates2.db", id=>"eac6b3b245781778a59006bd6cd50864208ef05e-1", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_c3d7a65b-4bf9-4e6e-b8f9-d4d6b804883a", enable_metric=>true, charset=>"UTF-8">, batch=>5>
Error: Missing Valuefier handling for full class name=org.jruby.RubyObject, simple name=RubyObject
[2017-06-26T09:46:20,397][ERROR][logstash.pipeline ] A plugin had an unrecoverable error. Will restart this plugin.

4

Did you try "sqlite-jdbc" recipe?

5

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