# Logstash logging problem

**URL:** https://discuss.elastic.co/t/logstash-logging-problem/178169
**Category:** Logstash
**Created:** [April 24, 2019, 7:33am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169 "2019-04-24T07:33:04Z")
**Posts on this page:** 17
**Page:** 1

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 7:33am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/1 "2019-04-24T07:33:04Z")

</div>

Hello everyone,  
I'm having trouble with logstash when I want to log a CSV file into elasticsearch and my config file is below.

elastic search version:6.5.4  
Logstash version:6.6.0

There is that kind of warning  
[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}

and last 3 row is like that;  
[2019-04-24T09:47:35,815][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>}  
[2019-04-24T09:47:35,841][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections  
[2019-04-24T09:47:37,760][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

input{  
file{  
path=\>"C:\Users\akumas\Desktop\Cars\cars.csv"  
start\_position=\>"beginning"  
sincedb\_path=\>"NULL"  
}

}  
filter{  
csv{  
separator =\>","

```
	columns => ["maker","model","mileage","manufacture_year","engine_displacement","engine_power","body_type","color_slug","stk_year","transmission","door_count","seat_count","fuel_type","date_created","date_last_seen","price_eur"]

}
mutate{convert => ["mileage", "integer"] }
mutate{convert => ["price_eur", "float"] }
mutate{convert => ["engine_power", "integer"] }
mutate{convert => ["door_power", "integer"] }
mutate{convert => ["seat_count", "integer"] }

```

}  
output{  
elasticsearch {  
hosts =\> "localhost"  
index =\> "cars"  
document\_type=\>"solid\_cars"  
}  
stdout{}  
}

---

<div class="post-metadata">

### Author: ![Gomathi\_Meena](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gomathi_meena/32/43086_2.png) [@Gomathi\_Meena](https://discuss.elastic.co/u/Gomathi_Meena)
#### Post date: [April 24, 2019, 7:50am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/2 "2019-04-24T07:50:29Z")

</div>

Does your process stopped or index into elasticsearch with failure tag ?

---

<div class="post-metadata">

### Author: ![Gomathi\_Meena](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gomathi_meena/32/43086_2.png) [@Gomathi\_Meena](https://discuss.elastic.co/u/Gomathi_Meena)
#### Post date: [April 24, 2019, 7:52am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/3 "2019-04-24T07:52:27Z")

</div>

> [@ahmetkumas1](#):
>
> [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}

This is a common warning .That wont affect the process i hope..

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 7:56am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/4 "2019-04-24T07:56:37Z")

</div>

these are last rows i think there is no problem but i does not complace process no respond just waits

[2019-04-24T09:47:35,727][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x7f8d1314 run\>"}  
[2019-04-24T09:47:35,815][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>}  
[2019-04-24T09:47:35,841][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections  
[2019-04-24T09:47:37,760][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

---

<div class="post-metadata">

### Author: ![Gomathi\_Meena](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gomathi_meena/32/43086_2.png) [@Gomathi\_Meena](https://discuss.elastic.co/u/Gomathi_Meena)
#### Post date: [April 24, 2019, 8:05am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/5 "2019-04-24T08:05:48Z")

</div>

> [@ahmetkumas1](#):
>
> mutate{convert =\> ["mileage", "integer"] } mutate{convert =\> ["price\_eur", "float"] } mutate{convert =\> ["engine\_power", "integer"] } mutate{convert =\> ["door\_power", "integer"] } mutate{convert =\> ["seat\_count", "integer"] }

can you change your mutate filter code to like this format ,

mutate{convert =\> {"milege" =\> "integer"} }

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 10:15am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/6 "2019-04-24T10:15:08Z")

</div>

Noo it doesn't workk

---

<div class="post-metadata">

### Author: ![nandha\_88](https://avatars.discourse-cdn.com/v4/letter/n/3e96dc/32.png) [@nandha\_88](https://discuss.elastic.co/u/nandha_88)
#### Post date: [April 24, 2019, 11:58am UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/7 "2019-04-24T11:58:31Z")

</div>

Hi Ahmet,

Please run the logstash config and share the error after starting .  
Paste the full error if possible

Regards  
Nandha

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 12:51pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/8 "2019-04-24T12:51:11Z")

</div>

Hello, this is full output, but I can not see any errors.

C:\Users\akumas\Desktop\logstash-6.6.0\bin\>logstash -f C:\Users\akumas\Desktop\Cars\logstash\_cars.config  
Sending Logstash logs to C:/Users/akumas/Desktop/logstash-6.6.0/logs which is now configured via log4j2.properties  
[2019-04-24T13:23:27,578][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2019-04-24T13:23:27,654][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.6.0"}  
[2019-04-24T13:23:48,921][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=\>"cars", id=\>"2306a9f312e723e483c65baa0f0891e8e4faadc85e2b0ed07ac630386450dc41", hosts=\>[[//localhost](https://localhost)], document\_type=\>"sold\_cars", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_50a9c1fe-8203-47e3-a514-8e4316ac8330", enable\_metric=\>true, charset=\>"UTF-8"\>, workers=\>1, 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, ilm\_enabled=\>false, ilm\_rollover\_alias=\>"logstash", ilm\_pattern=\>"{now/d}-000001", ilm\_policy=\>"logstash-policy", 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\>}  
[2019-04-24T13:23:51,453][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50}  
[2019-04-24T13:23:52,042][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://localhost:9200/](http://localhost:9200/)]}}  
[2019-04-24T13:24:02,522][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"}  
[2019-04-24T13:24:06,468][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6}  
[2019-04-24T13:24:06,475][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}  
[2019-04-24T13:24:06,533][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost](https://localhost)"]}  
[2019-04-24T13:24:06,546][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil}  
[2019-04-24T13:24:06,633][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"}}}}}}}}  
[2019-04-24T13:24:07,945][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x4b274809 sleep\>"}  
[2019-04-24T13:24:08,018][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>}  
[2019-04-24T13:24:08,029][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections  
[2019-04-24T13:24:09,529][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

---

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 24, 2019, 12:58pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/9 "2019-04-24T12:58:26Z")

</div>

> [@ahmetkumas1](#):
>
> path=\>"C:\Users\akumas\Desktop\Cars\cars.csv"  
> start\_position=\>"beginning"  
> sincedb\_path=\>"NULL"

Use forward slash instead of backslash in the path option on a file input.

The sincedb\_path value should be NUL, not NULL.

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 1:09pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/10 "2019-04-24T13:09:08Z")

</div>

it's windows slash are okay i changed AS NUL but still same output

---

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 24, 2019, 1:19pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/11 "2019-04-24T13:19:34Z")

</div>

> [@ahmetkumas1](#):
>
> it's windows slash are okay

Backslashes are not OK in a file input.

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 1:34pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/12 "2019-04-24T13:34:10Z")

</div>

You are right, ı got that now;  
Sending Logstash logs to C:/Users/akumas/Desktop/logstash-6.6.0/logs which is now configured via log4j2.properties  
[2019-04-24T16:26:00,217][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2019-04-24T16:26:00,458][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.6.0"}  
[2019-04-24T16:26:02,973][ERROR][logstash.agent] Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of #, {, } at line 5, column 22 (byte 114) after input{\n\tfile{\n\t\tpath=\>"C:/Users/akumas/Desktop/Cars/cars.csv"\n\t\tstart\_position=\>"beginning"\n\t\tsincedb\_path=\>"NUL"", :backtrace=\>["C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/compiler.rb:41:in `compile_imperative'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/compiler.rb:49:in`compile\_graph'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/compiler.rb:11:in `block in compile_sources'", "org/jruby/RubyArray.java:2486:in`map'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/compiler.rb:10:in `compile_sources'", "org/logstash/execution/AbstractPipelineExt.java:149:in`initialize'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/pipeline.rb:22:in `initialize'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/pipeline.rb:90:in`initialize'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/pipeline\_action/create.rb:42:in `block in execute'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/agent.rb:92:in`block in exclusive'", "org/jruby/ext/thread/Mutex.java:148:in `synchronize'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/agent.rb:92:in`exclusive'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/pipeline\_action/create.rb:38:in `execute'", "C:/Users/akumas/Desktop/logstash-6.6.0/logstash-core/lib/logstash/agent.rb:317:in`block in converge\_state'"]}  
[2019-04-24T16:26:05,414][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}

---

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 24, 2019, 1:44pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/13 "2019-04-24T13:44:43Z")

</div>

What does your configuration look like. When you copy and paste your configuration select the text of the configuration and click on \</\> in the toolbar above the editing pane so that it is block-quoted.

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 1:55pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/14 "2019-04-24T13:55:53Z")

</div>

input{  
file{  
path=\>"C:/Users/akumas/Desktop/Cars/cars1.csv"  
start\_position=\>"beginning"  
sincedb\_path=\>"NUL"log  
}  
}  
filter{  
csv {  
separator =\>","

```
	columns => ["maker", "model", "mileage", "manufacture_year", "engine_displacement", "engine_power", "body_type", "color_slug", "stk_year", "transmission", "door_count", "seat_count", "fuel_type", "date_created", "date_last_seen", "price_eur"]

   } 
mutate {convert => ["mileage", "integer"] }
mutate {convert => ["price_eur", "float"] }
mutate {convert => ["engine_power", "integer"] }
mutate {convert => ["door_power", "integer"] }
mutate {convert => ["seat_count", "integer"] }

```

}  
output{  
elasticsearch {  
hosts =\> "localhost"  
index =\> "cars"  
document\_type=\>"sold\_cars"  
}  
stdout{}  
}

I don't really understand why can't put my code into what you told me for nice view

---

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 24, 2019, 2:06pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/15 "2019-04-24T14:06:08Z")

</div>

> [@ahmetkumas1](#):
>
> sincedb\_path=\>"NUL"log

Remove the trailing "log"

---

<div class="post-metadata">

### Author: ![ahmetkumas1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmetkumas1/32/44691_2.png) [@ahmetkumas1](https://discuss.elastic.co/u/ahmetkumas1)
#### Post date: [April 24, 2019, 3:22pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/16 "2019-04-24T15:22:47Z")

</div>

Thank you so much Badger problem soved!!

---

<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: [May 22, 2019, 3:22pm UTC](https://discuss.elastic.co/t/logstash-logging-problem/178169/17 "2019-05-22T15:22:53Z")

</div>

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