# Logstash Startup completed but no data loaded

**URL:** <https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243>\
**Category:** Logstash\
**Created:** [March 13, 2016, 2:12am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243 "2016-03-13T02:12:37Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [March 13, 2016, 2:12am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/1 "2016-03-13T02:12:37Z")

</div>

I am using logstash to feed my CSV file into my elasticsearch , my logstash startup completed but the files  
didn't load into the index.  
I try checking by using GET /\_cat/indices?v

health status index pri rep docs.count docs.deleted store.size pri.store.size  
green open .marvel-es-data 1 1 3 0 7.8kb 3.9kb  
green open .marvel-es-2016.03.11 1 1 801 32 584.8kb 278.1kb  
green open .kibana 1 1 2 0 29.9kb 14.9kb  
green open xxxxx 5 1 0 0 1.5kb 795b

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 13, 2016, 6:33am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/2 "2016-03-13T06:33:08Z")

</div>

Providing your config would be helpful.

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [March 13, 2016, 12:14pm UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/3 "2016-03-13T12:14:49Z")

</div>

input {  
file {  
path =\> ['CSV\xxx.csv']  
type =\> "data"  
start\_position =\> "beginning"

```
     }
```

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [March 13, 2016, 1:01pm UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/4 "2016-03-13T13:01:13Z")

</div>

Thanks Mark.  
It started when I copy and paste all the data after starting the logstash.  
But in Kibana i do not see any of the field names, as i am getting the error " \_csvparsefailure"

I created my index in elasticsearch,

PUT /approved  
{  
"mappings" : {  
"_default_" : {  
"properties" : {  
"Name and Appl #" : {"type": "string", "index" : "not\_analyzed" },  
"Suppl #" : {"type": "integer", "index" : "not\_analyzed" },  
"Ace Ingrs":{"type": "string", "index" : "not\_analyzed" },  
"Compy #" : {"type": "string", "index" : "not\_analyzed" },  
"Appral Type" : {"type": "string", "index" : "not\_analyzed" },  
"appral date" : {"type": "date", "format" : "yyyy-MM-dd" }  
}  
}  
}  
}  
;  
I provided my config file. Can you please help me in resolve this.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 13, 2016, 8:04pm UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/5 "2016-03-13T20:04:48Z")

</div>

If you are getting a `_csvparsefailure` then your CSV filter is wrong, what does the actual data look llke?

Also, please format your code with the `</>` button, it makes it easier to read.

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [March 13, 2016, 9:23pm UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/6 "2016-03-13T21:23:05Z")

</div>

Thanks Mark.  
My csv file looks like,

And can you please tell me where I have to put the \</\> button.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 14, 2016, 12:55am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/7 "2016-03-14T00:55:42Z")

</div>

Start by removing the elasticsearch output and swapping the file input for `stdin { codec => rubydebug}`.  
Then run LS and push through a line of your file and check the output, then make changes and go from there.

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [March 14, 2016, 1:27am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/8 "2016-03-14T01:27:48Z")

</div>

Thanks Mark,  
I removed the stdout from output and added #stdin { #codec =\> rubydebug #}  
I am getting the same error \_csvparsefailure

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 14, 2016, 3:58am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/9 "2016-03-14T03:58:54Z")

</div>

I just tested it and it works fine;

```auto
{
             "message" => "\"PROPRANOLOL HYDROCHLORIDE (NDA #016419)\",\"029\",\"PROPRANOLOL HYDROCHLORIDE\",\"BAXTER HLTHCARE CORP\",\"Labeling Revision\",\"04/01/2008\"",
            "@version" => "1",
          "@timestamp" => "2016-03-14T00:54:43.799Z",
                "host" => "bender.local",
    "Name and Appl. #" => "PROPRANOLOL HYDROCHLORIDE (NDA #016419)",
            "Suppl. #" => "029",
             "Act Ing" => "PROPRANOLOL HYDROCHLORIDE",
                 "Com" => "BAXTER HLTHCARE CORP",
           "Appr Type" => "Labeling Revision",
           "Appr Date" => "04/01/2008"
}

```

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [March 16, 2016, 1:34pm UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/10 "2016-03-16T13:34:01Z")

</div>

Thanks Mark.

---

<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:** [July 6, 2017, 5:06am UTC](https://discuss.elastic.co/t/logstash-startup-completed-but-no-data-loaded/44243/11 "2017-07-06T05:06:44Z")

</div>


