we have an elk cluster from 5 ES nodes, xpack security enabled basic license.
whenever we try to create a TSVB (previously Visual Builder) visualization Kibana freezes and the java node process shows high CPU consumption over 100%. We tried to wait for more then 15 min but the freezing and the high cpu persist. No significant error in kibana logs were observed , knowing that the verbosity logging is enabled. The problem was first seen on version on version 7.2 ( visual Builder) , And upgrading the entire cluster (ES, kibana) to 7.3 did not solve the problem.
We stopped the logstash for 15 min to rule out the possibility of having huge data that was causing the TSVB to freeze, but same behavior was observed .
thank u for your help,
1-First this happen whenever we try to click on Create new Visualization , and then we choose TSVB it will do the explained behavior.
2-Before choosing the index the error occurs
3-Before choosing the type the error occurs
4- We tried to stop all the logs for 15 min since the default time of TSVB time range is 15 min, so we have like 0 docs on all our index during this 15 min , but still it hangs for 15 min.
5- we tried all other visualization one by one all working like charm except the TSVB.
Kindly find the attached image , when clicking on the below it crash for 15 min to 20 min
When loading the TSVB editor, a request is made to Elasticsearch which grabs the available fields from all indices. I suspect that this request is what's causing your cluster to have a CPU spike and generally become unresponsive.
Do you have a lot of indices, or indices with many many fields defined in their index mappings?
What happens if you issue the following request to Elasticsearch directly? How long does this request take to complete? Do you see the same performance drop?
GET /_field_caps?fields=*&ignore_unavailable=true&allow_no_indices=false
Thanks for running this test. It does seem like this particular call is at least part of the cause then. TSVB uses this call behind the scenes when loading the visual editor.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.