Hi all !
I have a question about Kibana, and the reporting option.
In the "Discover" section, as we would like to export the result in a csv file, so we set the query, and 2 filters.
The result is about 586.675 docuements as Kibana say. So its a "small" big dataset as we have 21B of documents inside this cluster.
In Kibana, the output is display very fast, as usual with Kibana.
But if we try to export then is csv, it never works...
We get every time the error:
Max attempts reached (3)
I already try to set the timeout to 6 hours, without success. Its only 500.000 rows, it shouldn't take as more than few min with my cluster size... I think !
To give you more informations, here the cluster configuration:
- 6 elasticsearch hardware datanodes (24 cores and 64G of ram with 31G for the heap of elasticsearch)
- 2 elasticsearch client nodes. VM with 4 vcpu and 6G of ram.
- 3 kibana nodes. Each Kibana is behind is own nginx proxy for SSL.
- 6.3.0 version on all services.
No load, no cpu when we try to export... it sleeping a lot !!
As we have have multiple Kibana, I set the
xpack.reporting.encryptionKey: settings with the same value on each.
Also, as Kibana is behind nginx, I set the different settings
Soes somebody haveing the same issue, and found how to solve it ? Hope yes !!
Thanks a lot for your help !