# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1234 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1235 --- ## [Getting java.io.IOException: Insufficient quota to complete the requested service](https://discuss.elastic.co/t/getting-java-io-ioexception-insufficient-quota-to-complete-the-requested-service/189516)
**Author:** [@bigster](https://discuss.elastic.co/u/bigster)\ **Replies:** 0\ **Last updated:** [July 9, 2019, 10:14am UTC](https://discuss.elastic.co/t/getting-java-io-ioexception-insufficient-quota-to-complete-the-requested-service/189516 "2019-07-09T10:14:29Z")
Hi all, In a period of time i get a Elastic crash with this kind of error: \[2019-07-02T11:56:54,440\]\[WARN \]\[o.e.i.e.Engine \] \[eai-elastic-node1\] \[index-2019.07.02\]\[0\] failed engine \[refresh failed source\[sch… --- ## [Kubernetes: best practice to let kibana access elasticsearch](https://discuss.elastic.co/t/kubernetes-best-practice-to-let-kibana-access-elasticsearch/186516)
**Author:** [@asp](https://discuss.elastic.co/u/asp)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 10:04am UTC](https://discuss.elastic.co/t/kubernetes-best-practice-to-let-kibana-access-elasticsearch/186516 "2019-07-09T10:04:32Z")
Hi, I am currently trying to setup an elastic stack in kubernetes. With some issues I managed to bring up an elasticsearch 3 node cluster as statefulset. What is best practice to let kibana loadbalance over the cluster… --- ## [About aggregates the results of buckets twice](https://discuss.elastic.co/t/about-aggregates-the-results-of-buckets-twice/189304)
**Author:** [@xuziqi](https://discuss.elastic.co/u/xuziqi)\ **Replies:** 4\ **Last updated:** [July 9, 2019, 9:42am UTC](https://discuss.elastic.co/t/about-aggregates-the-results-of-buckets-twice/189304 "2019-07-09T09:42:38Z")
hello， Elastic 6.3.0 Now，We hive a table of Consumption details.(A person has multiple consumption records ). First ,we want to Calculate a person's total consumption（need to agg）. Then we want to get all the people … --- ## [Single Node Is Not Allowing To Set Built In Users](https://discuss.elastic.co/t/single-node-is-not-allowing-to-set-built-in-users/189457)
**Author:** [@Jeniffer](https://discuss.elastic.co/u/Jeniffer)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 9:26am UTC](https://discuss.elastic.co/t/single-node-is-not-allowing-to-set-built-in-users/189457 "2019-07-09T09:26:30Z")
Hey, I am having problems with my single node, I built elasticsearch on a test machine i started configuring the security,enabled xpach and discovery type to single node. When i try to set the built-in users i get: E… --- ## [Date\_histogram offset results in wrong date \[6.2\]](https://discuss.elastic.co/t/date-histogram-offset-results-in-wrong-date-6-2/187347)
**Author:** [@alexfritz](https://discuss.elastic.co/u/alexfritz)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 9:23am UTC](https://discuss.elastic.co/t/date-histogram-offset-results-in-wrong-date-6-2/187347 "2019-07-09T09:23:51Z")
No one answered this topic, but I am experiencing the same problem. Is there an explanation or solution for this? { "size": 0, "query": { "range": { "@timestamp": { "gte": "now/d", "l… --- ## [Host name does not match the certificate](https://discuss.elastic.co/t/host-name-does-not-match-the-certificate/186618)
**Author:** [@yeziblo](https://discuss.elastic.co/u/yeziblo)\ **Replies:** 4\ **Last updated:** [July 9, 2019, 9:21am UTC](https://discuss.elastic.co/t/host-name-does-not-match-the-certificate/186618 "2019-07-09T09:21:06Z")
Hi everyone, I use command './bin/elasticsearch-certutil cert --ca-cert config/ca/ca.crt --ca-key config/ca/ca.key ' to create a p12 file. This file doesn't include any IP/Hostname information, so when I connect to ES … --- ## [Groovy Client for Elastic Search](https://discuss.elastic.co/t/groovy-client-for-elastic-search/189491)
**Author:** [@paul1243](https://discuss.elastic.co/u/paul1243)\ **Replies:** 3\ **Last updated:** [July 9, 2019, 9:19am UTC](https://discuss.elastic.co/t/groovy-client-for-elastic-search/189491 "2019-07-09T09:19:21Z")
Hi- I have ELK 6.8 Cluster, running in the Production, I would like to create the indices and publish the data to the Elastic Search using the Groovy Client. Could someone please help with some documentation. Thanks ! --- ## [Set tls using elasticsearch high level REST API](https://discuss.elastic.co/t/set-tls-using-elasticsearch-high-level-rest-api/189329)
**Author:** [@xodn0812](https://discuss.elastic.co/u/xodn0812)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 9:14am UTC](https://discuss.elastic.co/t/set-tls-using-elasticsearch-high-level-rest-api/189329 "2019-07-09T09:14:27Z")
i want to set tls by using elasticsearch high level REST API. how can do?? I refer to the site below, but I do not know how to create a keyStore. Do I have to create a .jks file? https://www.elastic.co/guide/en/elast… --- ## [addField(java.lang.String) deprecated in ES v5.6.2](https://discuss.elastic.co/t/addfield-java-lang-string-deprecated-in-es-v5-6-2/189473)
**Author:** [@utkarsh](https://discuss.elastic.co/u/utkarsh)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 9:06am UTC](https://discuss.elastic.co/t/addfield-java-lang-string-deprecated-in-es-v5-6-2/189473 "2019-07-09T09:06:52Z")
I am upgrading the java api's in favour of es v5.6.2. The code earlier used addField method on SearchRequestBuilder, by passing the field that were to be returned in the method argument. Now, this method been deprecated,… --- ## [How to make ES 6.8 ingest data faster](https://discuss.elastic.co/t/how-to-make-es-6-8-ingest-data-faster/189479)
**Author:** [@Sargu\_Xcode](https://discuss.elastic.co/u/Sargu_Xcode)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 9:00am UTC](https://discuss.elastic.co/t/how-to-make-es-6-8-ingest-data-faster/189479 "2019-07-09T09:00:21Z")
Hi Team , I would like to know how to make ES ingest faster, this is because i have a graylog server with ES 6.8 . The specs are 32 core, 64gb ram, Ubuntu 16.04.6 , 200gb disk. I have allocated 30gb ram for the ES heap.… --- ## [Elastic Search Json Save](https://discuss.elastic.co/t/elastic-search-json-save/189490)
**Author:** [@tarunbhandari1](https://discuss.elastic.co/u/tarunbhandari1)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 8:53am UTC](https://discuss.elastic.co/t/elastic-search-json-save/189490 "2019-07-09T08:53:59Z")
i want a to save a Big json format which is created using onix and we want to use the elastic search. and i dont have much knowkledge about how elastic search works so plz help. how to perform crud operation using sprin… --- ## [Calculate the average & standard deviation of the total events count](https://discuss.elastic.co/t/calculate-the-average-standard-deviation-of-the-total-events-count/189483)
**Author:** [@yagami23](https://discuss.elastic.co/u/yagami23)\ **Replies:** 0\ **Last updated:** [July 9, 2019, 8:29am UTC](https://discuss.elastic.co/t/calculate-the-average-standard-deviation-of-the-total-events-count/189483 "2019-07-09T08:29:56Z")
we currently migrating Splunk to ELK, in Splunk we can calculate the average & standard deviation of the total events count by using query in Splunk : earliest=-30d@d latest=@d | eval hour=strftime(\_time,"%H") | bin \_ti… --- ## [Stack monitoring is free?](https://discuss.elastic.co/t/stack-monitoring-is-free/189467)
**Author:** [@Hengheng1](https://discuss.elastic.co/u/Hengheng1)\ **Replies:** 2\ **Last updated:** [July 9, 2019, 8:09am UTC](https://discuss.elastic.co/t/stack-monitoring-is-free/189467 "2019-07-09T08:09:01Z")
Which version of this feature is free to start with? --- ## [Watcher webhook action in painless](https://discuss.elastic.co/t/watcher-webhook-action-in-painless/189468)
**Author:** [@NidOf3lp](https://discuss.elastic.co/u/NidOf3lp)\ **Replies:** 0\ **Last updated:** [July 9, 2019, 7:13am UTC](https://discuss.elastic.co/t/watcher-webhook-action-in-painless/189468 "2019-07-09T07:13:29Z")
Hi there, I want to use webhook type of action to send SMS to multiple recipients via our SMS gateway. "actions": { "create\_sms": { "webhook": { "scheme": "https", "host": "sms-gw.com", "port": 443, "method": "po… --- ## [I'm Getting Master Not Discovered Exception On Remote Server](https://discuss.elastic.co/t/im-getting-master-not-discovered-exception-on-remote-server/188508)
**Author:** [@emrealtan](https://discuss.elastic.co/u/emrealtan)\ **Replies:** 7\ **Last updated:** [July 9, 2019, 7:08am UTC](https://discuss.elastic.co/t/im-getting-master-not-discovered-exception-on-remote-server/188508 "2019-07-09T07:08:18Z")
I'm trying to configure Elastic Search on one of our remote servers. I've installed it with .msi setup file (v7.1.1) and configured the firewall for 9200 and 9300 ports. When I set network.publish\_host to server ip it g… --- ## [Elasticssearch cluster outage scenarios](https://discuss.elastic.co/t/elasticssearch-cluster-outage-scenarios/188996)
**Author:** [@JohnM](https://discuss.elastic.co/u/JohnM)\ **Replies:** 4\ **Last updated:** [July 9, 2019, 6:56am UTC](https://discuss.elastic.co/t/elasticssearch-cluster-outage-scenarios/188996 "2019-07-09T06:56:33Z")
I am newbie. Sorry if I am sking Here is my environment. ES 7.2 \[es-node-1/kibana1\] - cluster - \[es-node-2/kibana2\] \[logstash1\] for network devices log and \[logstash2\] for server logs. logstash servers (each logstas… --- ## [Fquery in python script](https://discuss.elastic.co/t/fquery-in-python-script/189461)
**Author:** [@JohnM](https://discuss.elastic.co/u/JohnM)\ **Replies:** 0\ **Last updated:** [July 9, 2019, 6:30am UTC](https://discuss.elastic.co/t/fquery-in-python-script/189461 "2019-07-09T06:30:46Z")
After upgrading Elasticsearch from 2.x to 7.x python script stopped working. Looks like fquery is no longer available after 6.x Could someone kindly tell me on how to convert fquery with a new syntax please? Thank you … --- ## [How Write throughput is calculated in Rally](https://discuss.elastic.co/t/how-write-throughput-is-calculated-in-rally/188997)
**Author:** [@suvarna](https://discuss.elastic.co/u/suvarna)\ **Replies:** 3\ **Last updated:** [July 9, 2019, 6:26am UTC](https://discuss.elastic.co/t/how-write-throughput-is-calculated-in-rally/188997 "2019-07-09T06:26:39Z")
Hi I have sending 1 Billion event data with below parameters.. Clients :60 Bulk indexing=10000 iteration = 1666 index.translog.durability= request i can see the indexing throughput as 368997.56 doc/sec. Can you pl… --- ## [Health check failed](https://discuss.elastic.co/t/health-check-failed/189446)
**Author:** [@wenchaodu](https://discuss.elastic.co/u/wenchaodu)\ **Replies:** 6\ **Last updated:** [July 9, 2019, 6:22am UTC](https://discuss.elastic.co/t/health-check-failed/189446 "2019-07-09T06:22:02Z")
Hi Team I install elasticsearch 7.2 and only one node, after installed, when I check with curl localhost:9200, it's seem working and return information such version, cluster\_name etc, but when i check the health with lo… --- ## [Can role be picked from yml and user from API](https://discuss.elastic.co/t/can-role-be-picked-from-yml-and-user-from-api/188968)
**Author:** [@amitavmohanty01](https://discuss.elastic.co/u/amitavmohanty01)\ **Replies:** 12\ **Last updated:** [July 9, 2019, 6:02am UTC](https://discuss.elastic.co/t/can-role-be-picked-from-yml-and-user-from-api/188968 "2019-07-09T06:02:05Z")
I am creating a user via curl and assigning a it a role which is defined in roles.yml. Is that a valid way of assigning roles? Do I have to create roles via curl also? --- ## [Merge daily index to one index](https://discuss.elastic.co/t/merge-daily-index-to-one-index/189448)
**Author:** [@rizkan\_abadi](https://discuss.elastic.co/u/rizkan_abadi)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 4:07am UTC](https://discuss.elastic.co/t/merge-daily-index-to-one-index/189448 "2019-07-09T04:07:19Z")
hello, how merge index daily to one index ? please give me the scripts --- ## [Elasticsearch service failed start java.lang.NoClassDefFoundError: java/sql/Date](https://discuss.elastic.co/t/elasticsearch-service-failed-start-java-lang-noclassdeffounderror-java-sql-date/189323)
**Author:** [@dcuti8](https://discuss.elastic.co/u/dcuti8)\ **Replies:** 1\ **Last updated:** [July 9, 2019, 3:36am UTC](https://discuss.elastic.co/t/elasticsearch-service-failed-start-java-lang-noclassdeffounderror-java-sql-date/189323 "2019-07-09T03:36:13Z")
Environment：Windows Server 2019 Standard (64-bit, 8GB) java version ："12.0.1" 2019-04-16 Java(TM) SE Runtime Environment (build 12.0.1+12) Java HotSpot(TM) 64-Bit Server VM (build 12.0.1+12, mixed mode, sharing) Elas… --- ## [How to Search Freeze Index using Java High Level REST Client](https://discuss.elastic.co/t/how-to-search-freeze-index-using-java-high-level-rest-client/189275)
**Author:** [@taku333](https://discuss.elastic.co/u/taku333)\ **Replies:** 5\ **Last updated:** [July 9, 2019, 1:47am UTC](https://discuss.elastic.co/t/how-to-search-freeze-index-using-java-high-level-rest-client/189275 "2019-07-09T01:47:01Z")
Hi Everyone, Currently, I am creating an application that acquires data from Elasticsearch using Java High Level REST Client. So I want to implement a search for the Freeze Index, but can't find something in the docume… --- ## [CORS required to connect to Elastic Cloud?](https://discuss.elastic.co/t/cors-required-to-connect-to-elastic-cloud/189444)
**Author:** [@caseydm](https://discuss.elastic.co/u/caseydm)\ **Replies:** 0\ **Last updated:** [July 9, 2019, 1:27am UTC](https://discuss.elastic.co/t/cors-required-to-connect-to-elastic-cloud/189444 "2019-07-09T01:27:03Z")
Hi All. I recently received a notice from the Elastic Cloud team saying they are changing the way they set up cross origin resource sharing on clusters: Elasticsearch Service clusters provisioned on Elastic Cloud prior… --- ## [Average bucket in histogram](https://discuss.elastic.co/t/average-bucket-in-histogram/189438)
**Author:** [@A\_google\_user](https://discuss.elastic.co/u/A_google_user)\ **Replies:** 0\ **Last updated:** [July 8, 2019, 10:48pm UTC](https://discuss.elastic.co/t/average-bucket-in-histogram/189438 "2019-07-08T22:48:41Z")
What if the zero value buckets are in the beginning or end? then it does not take them in account --- ## [ES 7.2.0 upgrade resulted in "Don't modify the classpath with ES\_CLASSPATH" error](https://discuss.elastic.co/t/es-7-2-0-upgrade-resulted-in-dont-modify-the-classpath-with-es-classpath-error/189431)
**Author:** [@KiloDunse](https://discuss.elastic.co/u/KiloDunse)\ **Replies:** 3\ **Last updated:** [July 8, 2019, 10:43pm UTC](https://discuss.elastic.co/t/es-7-2-0-upgrade-resulted-in-dont-modify-the-classpath-with-es-classpath-error/189431 "2019-07-08T22:43:16Z")
Hi, I upgraded Elasticsearch from 6.8.0 to 7.2.0. After install the service won't start. If I start it from .exe i get this error: The following deprecated environment variables are set and preventing elasticsearch f… --- ## [\[NOT POSSIBLE\] Yet another how to pre-register a "pretty printed" search template with conditional clauses?](https://discuss.elastic.co/t/not-possible-yet-another-how-to-pre-register-a-pretty-printed-search-template-with-conditional-clauses/189144)
**Author:** [@jetnet](https://discuss.elastic.co/u/jetnet)\ **Replies:** 7\ **Last updated:** [July 8, 2019, 10:16pm UTC](https://discuss.elastic.co/t/not-possible-yet-another-how-to-pre-register-a-pretty-printed-search-template-with-conditional-clauses/189144 "2019-07-08T22:16:37Z")
hello All, i have to maintain pretty big search templates. Now, I'd like to extend them by adding conditional clauses, as described here, it should be possible with pre-registered templates. But I ran into the same iss… --- ## [Document Not growing because of Template](https://discuss.elastic.co/t/document-not-growing-because-of-template/189432)
**Author:** [@meiyuan](https://discuss.elastic.co/u/meiyuan)\ **Replies:** 0\ **Last updated:** [July 8, 2019, 9:46pm UTC](https://discuss.elastic.co/t/document-not-growing-because-of-template/189432 "2019-07-08T21:46:06Z")
Hi team, We are using elasticsearch version 7.0 We have created this template for our indices, but it seems when the template is in place, the document for that index won't grow at all(index stat stopped updating). Onc… --- ## [Sql query input to output csv plugin](https://discuss.elastic.co/t/sql-query-input-to-output-csv-plugin/189386)
**Author:** [@prashanth1988](https://discuss.elastic.co/u/prashanth1988)\ **Replies:** 5\ **Last updated:** [July 8, 2019, 9:19pm UTC](https://discuss.elastic.co/t/sql-query-input-to-output-csv-plugin/189386 "2019-07-08T21:19:29Z")
Hi, I am generating csv files using logstash output csv plugin.I wanted to know if I can write SQL query as input to output csv plugin to generate csv files?I want to query the ES index and fetch the results and store i… --- ## [Intermittent logging](https://discuss.elastic.co/t/intermittent-logging/188068)
**Author:** [@VeeT](https://discuss.elastic.co/u/VeeT)\ **Replies:** 5\ **Last updated:** [July 8, 2019, 8:52pm UTC](https://discuss.elastic.co/t/intermittent-logging/188068 "2019-07-08T20:52:33Z")
Hi. We are using ELK 7.1 and we are seeing some intermittent logging for a particular appName. When checking Kibana, there were a couple of hours of missed logs yesterday and no log on the 26th. However, there were some … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1233) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1235)