# Logstash starts but does not pass csv data to index

**URL:** <https://discuss.elastic.co/t/logstash-starts-but-does-not-pass-csv-data-to-index/152268>\
**Category:** Logstash\
**Created:** [October 12, 2018, 3:38pm UTC](https://discuss.elastic.co/t/logstash-starts-but-does-not-pass-csv-data-to-index/152268 "2018-10-12T15:38:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vkryvor](https://avatars.discourse-cdn.com/v4/letter/v/b9e5f3/32.png) [@Vkryvor](https://discuss.elastic.co/u/Vkryvor)\
**Post date:** [October 12, 2018, 3:38pm UTC](https://discuss.elastic.co/t/logstash-starts-but-does-not-pass-csv-data-to-index/152268/1 "2018-10-12T15:38:04Z")

</div>

Hey all,  
I am trying new to Logstash and the ELK stack altogether and am trying to accomplish a simple task- reading data from a CSV file into elastic search via Logstash. I followed the tutorial and it seems as if Logstash is starting a pipeline with no errors, but it doesn't read the CSV file. Below is my config file:

input{  
file{  
path =\> ["C:\toolkit\ELKstack\SamplData\SalesJan2009.csv"]  
start\_position =\> "beginning"  
sincedb\_path =\> "NUL"  
ignore\_older =\> 0  
}  
}  
filter{  
csv{  
separator =\> ","  
columns =\>["TransactionID","Product","Payment\_Type","Name","City","State","Country"]  
}  
mutate{convert =\> ["TransactionID","integer"]  
}  
}  
output{  
elasticsearch{  
hosts =\> "127.0.0.1:9200"  
index =\> "customer"  
document\_type =\> "customer"  
document\_id =\> "%{id}"  
workers =\> 1  
}  
stdout{}  
}

This is what Logstash outputs:

C:\toolkit\ELKstack\logstash-6.4.2\bin\>logstash -f C:\toolkit\ELKstack\logstash-6.4.2\config\samplCof.config

Sending Logstash logs to C:/toolkit/ELKstack/logstash-6.4.2/logs which is now configured via log4j2.properties  
[2018-10-12T11:35:20,929][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2018-10-12T11:35:21,471][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.4.2"}  
[2018-10-12T11:35:23,890][WARN][logstash.outputs.elasticsearch] You are using a deprecated config setting "document\_type" set in elasticsearch. Deprecated settings will continue to work, but are scheduled for removal from logstash in the future. Document types are being deprecated in Elasticsearch 6.0, and removed entirely in 7.0. You should avoid this feature If you have any questions about this, please visit the #logstash channel on freenode irc. {:name=\>"document\_type", :plugin=\>\<LogStash::Outputs::ElasticSearch index=\>"customer", id=\>"e8eafe54e92f8ada95b3e0c687a4b32406bcd43e331f6660727e42e74e05d2ca", document\_id=\>"%{id}", workers=\>1, hosts=\>[[//127.0.0.1:9200](https://127.0.0.1:9200)], document\_type=\>"customer", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_560b3d5f-2b6b-4e1f-92aa-511f29f3db58", enable\_metric=\>true, charset=\>"UTF-8"\>, manage\_template=\>true, template\_name=\>"logstash", template\_overwrite=\>false, doc\_as\_upsert=\>false, script\_type=\>"inline", script\_lang=\>"painless", script\_var\_name=\>"event", scripted\_upsert=\>false, retry\_initial\_interval=\>2, retry\_max\_interval=\>64, retry\_on\_conflict=\>1, action=\>"index", ssl\_certificate\_verification=\>true, sniffing=\>false, sniffing\_delay=\>5, timeout=\>60, pool\_max=\>1000, pool\_max\_per\_route=\>100, resurrect\_delay=\>5, validate\_after\_inactivity=\>10000, http\_compression=\>false\>}  
[2018-10-12T11:35:25,422][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>8, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50}  
[2018-10-12T11:35:25,820][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>[], :added=\>[[http://127.0.0.1:9200/](http://127.0.0.1:9200/)]}}  
[2018-10-12T11:35:25,830][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[http://127.0.0.1:9200/](http://127.0.0.1:9200/), :path=\>"/"}  
[2018-10-12T11:35:25,979][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://127.0.0.1:9200/](http://127.0.0.1:9200/)"}  
[2018-10-12T11:35:26,027][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6}  
[2018-10-12T11:35:26,030][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6}  
[2018-10-12T11:35:26,058][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//127.0.0.1:9200](https://127.0.0.1:9200)"]}  
[2018-10-12T11:35:26,079][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil}  
[2018-10-12T11:35:26,102][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"match"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_float"}}}}}}}}  
[2018-10-12T11:35:26,618][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x774bb6f5 run\>"}  
[2018-10-12T11:35:26,671][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>[]}  
[2018-10-12T11:35:26,684][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections  
[2018-10-12T11:35:26,987][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

Should it not display the data it reads after it starts? Please advise  
Oh and I am using Windows 10 64 bit.

Thanks,  
Vlad

---

<div class="post-metadata">

**Author:** ![Vkryvor](https://avatars.discourse-cdn.com/v4/letter/v/b9e5f3/32.png) [@Vkryvor](https://discuss.elastic.co/u/Vkryvor)\
**Post date:** [October 16, 2018, 7:45pm UTC](https://discuss.elastic.co/t/logstash-starts-but-does-not-pass-csv-data-to-index/152268/2 "2018-10-16T19:45:00Z")

</div>

UPDATE:

I ran in debug and it seems I am stuck a loop after logstash starts:

[2018-10-16T15:42:08,879][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=\>"ParNew"}  
[2018-10-16T15:42:08,879][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=\>"ConcurrentMarkSweep"}  
[2018-10-16T15:42:10,752][DEBUG][logstash.pipeline] Pushing flush onto pipeline {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x2d1b5d15 sleep\>"}  
[2018-10-16T15:42:13,756][DEBUG][logstash.instrument.periodicpoller.cgroup] One or more required cgroup files or directories not found: /proc/self/cgroup, /sys/fs/cgroup/cpuacct, /sys/fs/cgroup/cpu

Has anyone ran into this before? Help would be greatly appreciated

Thanks in advance

---

<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:** [November 13, 2018, 7:45pm UTC](https://discuss.elastic.co/t/logstash-starts-but-does-not-pass-csv-data-to-index/152268/3 "2018-11-13T19:45:01Z")

</div>

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