I am creating index from csv data. I got error as below. What is the problem ??
07:31:56.196 [[main]-pipeline-manager] INFO logstash.pipeline - Pipeline main started
07:31:56.335 [LogStash::Runner] FATAL logstash.runner - An unexpected error occurred! {:error=>#<IOError: Unable to establish loopback connection>, :backtrace=>["org/jruby/RubyIO.java:4627:in
pipe'", "org/jruby/RubyIO.java:4604:inpipe'", "C:/ElasticProducts/logstash-5.2.0/vendor/bundle/jruby/1.9/gems/puma-2.16.0-java/lib/puma/util.rb:18:in pipe'", "C:/ElasticProducts/logstash-5 .2.0/vendor/bundle/jruby/1.9/gems/puma-2.16.0-java/lib/puma/server.rb:54:ininitialize'", "C:/ElasticProducts/logstash-5.2.0/logstash-core/lib/logstash/webserver.rb:87:in start_webserver'", "C:/ElasticProducts/logstash-5.2.0/logstash-core/lib/logstash/webserver.rb:44:inrun'", "org/jruby/RubyRange.java:479:in each'", "org/jruby/RubyEnumerable.java:974:ineach_with_index'", "C:
/ElasticProducts/logstash-5.2.0/logstash-core/lib/logstash/webserver.rb:39:in run'", "C:/ElasticProducts/logstash-5.2.0/logstash-core/lib/logstash/agent.rb:198:instart_webserver'"]}
attaching the conf file and template below.
input {
file {
path => ["C:/ElasticProducts/IncidentTestData.csv"]
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
csv {
columns => ["ITIL_Incident_ID","Incident_Number","Incident_Create_Date","Incident_Created_By_Name","P1_Incident_Flag"]
separator => ","
}
date {
match => ["Incident_Create_Date" , "MM/dd/YY HH:mm"]
}
mutate {
convert => { "ITIL_Incident_ID" => "integer"
"P1_Incident_Flag" => "boolean"
"Incident_Number" => "string"
"Incident_Created_By_Name" => "string"
}
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
user => "elastic"
password => "changeme"
# protocol => "http"
index => "csv"
template => "C:/ElasticProducts/csv1.json"
document_id => "%{ITIL_Incident_ID}"
document_type => "csv"
}
stdout {
codec => rubydebug
}
}
Template as below
{
"template" : "csv",
"settings": { "index.refresh_interval": "5s" },
"mappings" : {
"csv" : {
"properties": {
"Incident_Number": { "type": "string" },
"Incident_Create_Date": { "type": "date", "format" : "MM/dd/YY HH:mm" },
"Incident_Created_By_Name": { "type": "string" },
"P1_Incident_Flag": { "type": "boolean" }
}
}
}
}