# Logstash since\_db =\> "NUL" not forcing reload

**URL:** https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566
**Category:** Logstash
**Created:** [July 9, 2020, 4:30pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566 "2020-07-09T16:30:07Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![noamc](https://avatars.discourse-cdn.com/v4/letter/n/ce7236/32.png) [@noamc](https://discuss.elastic.co/u/noamc)
#### Post date: [July 9, 2020, 4:30pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/1 "2020-07-09T16:30:07Z")

</div>

Hello all,

I've built a ELK stack that loads a CSV on an hourly basis. The CSV is of all our tasks from jira, and so every change in an issue gets updated in the CSV, and needs to be reloaded to Kibana.

The stack works fine on loading, every new row gets sent, but logstash doesn't reload the entire file unless i manually restart it. I've defined the start point and sincedb\_path correctly to my knowledge.

Server - windows  
Version - 6.1.1

My input:

```auto
input {
  
  file {
  path => "C:/CFS/ELK/jira_raw.csv"
   start_position => "beginning"
   sincedb_path => "NUL"
   codec => plain {
                    charset => "UTF-8"
            }
  }
}

```

I've also tried with "/dev/null" for the heck of it even though it's a windows server

If anybody knows what might be the reason it dosen't work, or how i can time a reset of logstash, it would be highly appreciated.

All the best,

Noam

---

<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: [July 9, 2020, 4:35pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/2 "2020-07-09T16:35:18Z")

</div>

> Logstash since\_db =\> “NUL” not forcing reload

That is correct. Setting 'sincedb\_path =\> “NUL”' prevents the in-memory sincedb being persisted across restarts, but the file input still maintains the sincedb and there is no way to stop that.

Can you include the date/time in the filename when you extract tasks from jira?

---

<div class="post-metadata">

### Author: ![noamc](https://avatars.discourse-cdn.com/v4/letter/n/ce7236/32.png) [@noamc](https://discuss.elastic.co/u/noamc)
#### Post date: [July 9, 2020, 4:49pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/3 "2020-07-09T16:49:50Z")

</div>

Do you mean to the CSV I export?  
Yes, i can, would that solve it? That would require me to change the path to be  
`path => "C:/CFS/ELK/*.csv"`  
correct?

Thank you,

Noam

---

<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: [July 9, 2020, 4:55pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/4 "2020-07-09T16:55:08Z")

</div>

> [@noamc](#):
>
> That would require me to change the path to be  
> `path => "C:/CFS/ELK/*.csv"`  
> correct?

Correct.

---

<div class="post-metadata">

### Author: ![noamc](https://avatars.discourse-cdn.com/v4/letter/n/ce7236/32.png) [@noamc](https://discuss.elastic.co/u/noamc)
#### Post date: [July 9, 2020, 8:12pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/5 "2020-07-09T20:12:04Z")

</div>

Solved. Thank you!  
For some Reason it isn't loading the final row, but probably a matter of config that isn't relevant to the issue.

Thanks

---

<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: [July 9, 2020, 8:22pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/6 "2020-07-09T20:22:26Z")

</div>

> [@noamc](#):
>
> For some Reason it isn't loading the final row

Does the last line end with a newline?

---

<div class="post-metadata">

### Author: ![noamc](https://avatars.discourse-cdn.com/v4/letter/n/ce7236/32.png) [@noamc](https://discuss.elastic.co/u/noamc)
#### Post date: [July 9, 2020, 9:33pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/7 "2020-07-09T21:33:20Z")

</div>

Yes, I can remove it but it didn't seem to be a problem

---

<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: [July 9, 2020, 10:11pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/8 "2020-07-09T22:11:30Z")

</div>

I was thinking the other way around. If the last line did not have a newline at the end then the file input would continue tailing the file, waiting for the newline to appear so that it could ingest the last line.

---

<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: [August 6, 2020, 10:11pm UTC](https://discuss.elastic.co/t/logstash-since-db-nul-not-forcing-reload/240566/9 "2020-08-06T22:11:33Z")

</div>

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