Dashboard Table doesn't Refresh


#1

I am very new to Elasticsearch and Kibana. I have setup an index with a number of documents that I want to monitor as a table on the dashboard.

The JSON documents stored in elastic search simply have four fields.

I created/saved a search on the Discover tab with all four fields and then added that search to my Dashboard.

I then set the auto refresh to every 5 seconds.

  • If I update an existing document the table does not change.
  • If I add/remove new documents to elasticsearch they do appear/disappear in the table on the next refresh.
  • Table flickers every 5s so it is clearly re-rendering.
  • Examining the network traffic shows that the response to the query contains the new data.
  • Pressing the arrow drop-down next to the row in the table shows the correct data
  • Refreshing the entire page shows the new data

Am I missing something?


(Lee Drengenberg) #2

So it's only on the automatic refresh that changes to data don't appear?

I'll try to reproduce this problem.

Thanks,
Lee


(Lee Drengenberg) #3

I did a test and changes to documents did appear in my auto-refreshing data table in both the Visualize tab and in the Dashboard. I'm on the Kibana 4.5.0 release that's going to be released soon.

Can you describe more details of the version of Kibana you're using and the steps of your issue?

I loaded this data;

curl -XPOST 'http://localhost:9200/test8' -d '{
    "settings" : {
        "number_of_shards" : 1
    },
    "mappings" : {
        "test" : {
            "properties" : {
                "date" : { "type" : "date"},
                "action" : { 
                  "type" : "string", 
                  "analyzer" : "standard",
                  "fields": {
                    "raw" : { "type" : "string", "index" : "not_analyzed" }
                  }
                },
                "myid" : { "type" : "integer"}
            }
        }
    }
}'

curl -XPUT 'http://localhost:9200/test8/test/1' -d '{
    "date" : "2015-08-23T00:01:00",
    "action" : "start",
    "myid" : 1
}'

curl -XPUT 'http://localhost:9200/test8/test/2' -d '{
    "date" : "2015-08-23T14:02:30",
    "action" : "stop",
    "myid" : 1
}'

curl -XPUT 'http://localhost:9200/test8/test/3' -d '{
    "date" : "2015-08-23T00:01:45",
    "action" : "start",
    "myid" : 2
}'

curl -XPUT 'http://localhost:9200/test8/test/4' -d '{
    "date" : "2015-08-23T00:01:55",
    "action" : "start",
    "myid" : 3
}'

curl -XPUT 'http://localhost:9200/test8/test/5' -d '{
    "date" : "2015-08-23T14:04:00",
    "action" : "stop",
    "myid" : 2
}'

curl -XPUT 'http://localhost:9200/test8/test/6' -d '{
    "date" : "2015-08-23T14:02:55",
    "action" : "stop",
    "myid" : 3
}'

Then on the Settings tab I created an index pattern for this "test8" data.

Then I created a Data Table visualization splitting as shown below and saved as DataTable2;

Next I loaded this data to change an existing document. The DataTable2 updated and did show the new data.

# change 1 - works in auto-refreshing Visualization
curl -XPUT 'http://localhost:9200/test8/test/6' -d '{
    "date" : "2015-08-23T14:02:55",
    "action" : "stopping",
    "myid" : 3
}'

Then I created a new dashboard and added that DataTable2 visualization to it. The dashboard was auto-refreshing at 5 second interval.
Then I changed the data again and the dashboard shows the new data;

# change 2 - works in auto-refreshing Dashboard
curl -XPUT 'http://localhost:9200/test8/test/6' -d '{
    "date" : "2015-08-23T14:02:55",
    "action" : "stopping again",
    "myid" : 3
}'


#4

Thanks for the quick and very detailed response. I followed your method to create the table and it works perfectly.

What I did that was different was to create a search and then add that search directly to my Dashboard. I did not create a Table visualization.


#5

So, I guess the question is, do searches not update on the dashboard the same way visualizations do?


(system) #6