I set logstash.conf as the below on input section after I ran "bin/plugin install logstash-input-sqlite".
But Logstash terminate immediately after execution.
----- @ logstash logs -----
io/console not supported; tty will not be manipulated
{:timestamp=>"2015-10-20T00:34:39.688000+0900", :message=>"A plugin had an unrecoverable error. Will restart this plugin.\n Plugin: <LogStash::Inputs::Sqlite path=>"C:\\\\Program Files\\\\sample\\\\test", type=>"ACCESSLOG", debug=>false, codec=><LogStash::Codecs::Plain charset=>"UTF-8">, batch=>5>\n Error: Java::JavaSql::SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: id)", :level=>:error}
{:timestamp=>"2015-10-20T00:34:41.779000+0900", :message=>"A plugin had an unrecoverable error. Will restart this plugin.\n Plugin: <LogStash::Inputs::Sqlite path=>"C:\\\\Program Files\\\\sample\\\\test", type=>"ACCESSLOG", debug=>false, codec=><LogStash::Codecs::Plain charset=>"UTF-8">, batch=>5>\n Error: Java::JavaSql::SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: id)", :level=>:error}
{:timestamp=>"2015-10-20T00:34:42.793000+0900", :message=>"A plugin had an unrecoverable error. Will restart this plugin.\n Plugin: <LogStash::Inputs::Sqlite path=>"C:\\\\Program Files\\\\sample\\\\test", type=>"ACCESSLOG", debug=>false, codec=><LogStash::Codecs::Plain charset=>"UTF-8">, batch=>5>\n Error: Java::JavaSql::SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: id)", :level=>:error}
----- @ logstash logs -----
I understand that the issue is caused by no id column from the LS log.
There is "id" although I confirmed table.
Could you tell me what cause the issue ?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.