# Kibana not showing recent Elasticsearch data

**URL:** https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184
**Category:** Kibana
**Created:** [March 11, 2016, 5:24pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184 "2016-03-11T17:24:03Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![HelpComputer](https://avatars.discourse-cdn.com/v4/letter/h/ac8455/32.png) [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)
#### Post date: [March 11, 2016, 5:24pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/1 "2016-03-11T17:24:03Z")

</div>

Hello,

I just upgraded my ELK stack but now I am unable to see all data in Kibana. I see data from a couple hours ago but not from the last 15min or 30min. It's like it just stopped. After the upgrade, I ran into some Elasticsearch parsing exceptions but I think I have those fixed because the errors went away and a new Elasticsearch index file was created. Using the Elastic HQ plugin I can see the Elasticsearch index is increasing it size and the number of docs, so I am pretty sure the data is getting to Elasticsearch. It's just not displaying correctly in Kibana. I tried removing the index pattern in Kibana and adding it back but that didn't seem to work. I even did a refresh. The index fields repopulated after the refresh/add. I am not sure what else to do. Any ideas or suggestions? Thanks in advance for the help!

Environment  
syslog--\>logstash--\>redis--\>logstash--\>elasticsearch

- elasticsearch-2.2.0-1
- logstash-2.2.2-1
- redis-2.8.19-2.el7.x86\_64

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [March 11, 2016, 10:10pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/2 "2016-03-11T22:10:04Z")

</div>

What version of Kibana and ES?

Does the total Count on the discover tab (top right corner) match the count you get when hitting Elasticsearch directly? If not, try opening developer tools in your browser and look at the requests Kibana is sending to elasticsearch. On the Discover tab you should see a couple of msearch requests. Are they querying the indexes you'd expect?

---

<div class="post-metadata">

### Author: ![HelpComputer](https://avatars.discourse-cdn.com/v4/letter/h/ac8455/32.png) [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)
#### Post date: [March 11, 2016, 10:48pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/3 "2016-03-11T22:48:00Z")

</div>

Thanks for the reply Bargs.

Sorry about that. Meant to include the Kibana version.

Kibana 4.4.1  
ES 2.2.0-1

If I am following your question, the count in Kibana and elasticsearch count are different. Kibana shows 0

Here's what I get when I query the ES index (only copied the first part.)

{  
"took" : 15,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 5,  
"successful" : 5,  
"failed" : 0  
},  
"hits" : {  
"total" : 2619460,  
"max\_score" : 1.0,  
"hits" : [ {  
"\_index" : "logstash-2016.03.11",  
"\_type" : "cisco-asa",  
"\_id" : "AVNmb2fDzJwVbTGfD3xE",  
"\_score" : 1.0,  
"\_source" : {

Not real familiar with using the dev tools but I think this is what you're asking about

{"index":[".kibana-devnull"],"ignore\_unavailable":true}  
{"size":500,"sort":[{"@timestamp":{"order":"desc","unmapped\_type":"boolean"}}],"query":{"filtered":{"query":{"query\_string":{"analyze\_wildcard":true,"query":"_"}},"filter":{"bool":{"must":[{"range":{"@timestamp":{"gte":1457721534039,"lte":1457735934040,"format":"epoch\_millis"}}}],"must\_not":[]}}}},"highlight":{"pre\_tags":["@kibana-highlighted-field@"],"post\_tags":["@/kibana-highlighted-field@"],"fields":{"_":{}},"require\_field\_match":false,"fragment\_size":2147483647},"aggs":{"2":{"date\_histogram":{"field":"@timestamp","interval":"5m","time\_zone":"America/Chicago","min\_doc\_count":0,"extended\_bounds":{"min":1457721534039,"max":1457735934039}}}},"fields":["\*","\_source"],"script\_fields":{},"fielddata\_fields":["@timestamp"]}

Two posts above the \_msearch is this  
{"docs":[{"\_index":".kibana","\_type":"index-pattern","\_id":"logstash-\*"}]}

Any suggestions based on 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 11, 2016, 11:14pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/4 "2016-03-11T23:14:03Z")

</div>

What versions did you upgrade from?

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [March 11, 2016, 11:23pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/5 "2016-03-11T23:23:59Z")

</div>

> [@HelpComputer](#):
>
> "index":[".kibana-devnull"]

That shouldn't be the case. What index pattern is Kibana showing as selected in the top left hand corner of the side bar?

---

<div class="post-metadata">

### Author: ![HelpComputer](https://avatars.discourse-cdn.com/v4/letter/h/ac8455/32.png) [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)
#### Post date: [March 12, 2016, 5:29pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/6 "2016-03-12T17:29:00Z")

</div>

@warkolm I think I was on the following versions

- kibana-4.0.3
- elasticsearch 1.7
- logstash 1.5

@Bargs Kibana is showing "logstash-\*"

Something strange to add to this. I checked this morning and I see data in  
Kibana from 18:17-19:09 last night but it stops after that.

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [March 14, 2016, 3:35pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/7 "2016-03-14T15:35:03Z")

</div>

I noticed your timezone is set to America/Chicago. What timezone are you sending to Elasticsearch for your @timestamp date data? Elasticsearch will assume UTC if you don't provide a timezone, so this could be a source of trouble.

When you load the discover tab you should also see a request in your devtools for a url with `_field_stats` in the name. This sends a request to elasticsearch with the min and max datetime you've set in the time picker, which elasticsearch responds to with a list of indices that contain data for that time frame. You might want to check that request and response and make sure it's including the indices you expect.

If the correct indices are included in the \_field\_stats response, the next step I would take is to look at the \_msearch request for the specific index you think the missing data should be in. It'll be the one where the request payload starts with `{"index":["your-index-name"],"ignore_unavailable":true}`. You'll see a date range filter in this request as well (in the form of millis since the epoch). Check and make sure the data you expect to see would pass this filter, try manually querying elasticsearch with the same date range filter and see what the results are.

---

<div class="post-metadata">

### Author: ![HelpComputer](https://avatars.discourse-cdn.com/v4/letter/h/ac8455/32.png) [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)
#### Post date: [March 14, 2016, 9:57pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/8 "2016-03-14T21:57:46Z")

</div>

@Bargs I am pretty sure I am sending America/Chicago timezone to Elasticsearch. How would I confirm that? Would that be in the output section on the Logstash config?

The min and max datetime in the \_field\_stats are correct (or at least match the filter I am setting in Kibana). I don't know how to confirm that the indices are there. How would I go about that? I see this in the Response tab (in the devtools):

\_shards: Object  
total:85  
successful:85  
failed: 0  
indices: Object (this has an arrow, that you can expand but nothing is listed under this object)

Not real sure how to query Elasticsearch with the same date range. I was able to to query it with this and it pulled up some results.  
localhost:9200/logstash-2016.03.11/\_search?q=@timestamp:\*&pretty=true

One thing I noticed was the "z" at the end of the timestamp. Is that normal. Here's what Elasticsearch is showing  
"@timestamp" : "2016-03-11T15:57:27.000Z"

Thanks again for the help.

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [March 15, 2016, 12:26am UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/9 "2016-03-15T00:26:39Z")

</div>

The empty indices object in your `_field_stats` response definitely indicates that no data matches the date/time range you've selected in Kibana. That means this is almost definitely a date/time issue.

The Z at the end of your @timestamp value indicates that the time is in UTC, which is the timezone elasticsearch automatically stores all dates in.

I'd take a look at your raw data and compare it to what's in elasticsearch. My guess is that you're sending dates to Elasticsearch that are in Chicago time, but don't actually contain timezone information so Elasticsearch assumes they're in UTC already. That would make it look like your events are lagging behind, just like you're seeing.

If you need some help with that comparison, feel free to post an example of a raw log line you've ingested, and it's matching document in Elasticsearch, and we should be able to track the problem down.

---

<div class="post-metadata">

### Author: ![HelpComputer](https://avatars.discourse-cdn.com/v4/letter/h/ac8455/32.png) [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)
#### Post date: [March 17, 2016, 3:49pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/10 "2016-03-17T15:49:45Z")

</div>

Sorry for the delay in my response, been doing a lot of research lately. It appears the logs are being graphed but it's a day behind. After your last comment, I really started looking at the timestamps in the Logstash logs and noticed it was a day behind. I can also confirm this by selecting yesterday in the time range option in Kibana and watch the logs grow as I refresh the page. The good news is that it's still processing the logs but it's just a day behind.

Now I just need to figure out what's causing the slowness. Is it Redis or Logstash? I have two Redis servers and two Logstash servers. The Redis servers are not load balanced but I have one Cisco ASA dumping to one Redis server and another ASA dumping to the other. Both Logstash servers have both Redis servers as their input in the config. I increased the pipeline workers thread ([https://www.elastic.co/guide/en/logstash/current/pipeline.html](https://www.elastic.co/guide/en/logstash/current/pipeline.html)) on the two Logstash servers, hoping that would help but it hasn't caught up yet.

I am debating on starting up a Kafka server as a comparison to Redis but that will take some time. If you have any suggestions or comments feel free to share, I'd love to hear them otherwise I'll probably have to end this thread and start a different one in the Logstash topic, since Kibana seems to be working fine.

Thanks again for all the help, appreciate it.

---

<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 17, 2016, 10:01pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/11 "2016-03-17T22:01:16Z")

</div>

Is data backed up in redis?

---

<div class="post-metadata">

### Author: ![HelpComputer](https://avatars.discourse-cdn.com/v4/letter/h/ac8455/32.png) [@HelpComputer](https://discuss.elastic.co/u/HelpComputer)
#### Post date: [March 18, 2016, 3:17pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/12 "2016-03-18T15:17:50Z")

</div>

I am not 100% sure. It kind of looks that way but I don't know how to tell if it's backed up in Redis or if Logstash is not processing the Redis input fast enough. Both Redis servers have a large (2-7GB) dump.rdb file in the /var/lib/redis folder. I am assuming that's the data that's backed up. Any suggestions?

---

<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 18, 2016, 10:06pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/13 "2016-03-18T22:06:20Z")

</div>

I think the redis command is `llist` to see how much is in a list. I'd start there - or the redis docs to find out what your lists are like.

---

<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, 1:58pm UTC](https://discuss.elastic.co/t/kibana-not-showing-recent-elasticsearch-data/44184/14 "2017-07-06T13:58:34Z")

</div>


