# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1279 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1280 --- ## [How to set "timeout" value of cursor in elasticsearch SQL syntax](https://discuss.elastic.co/t/how-to-set-timeout-value-of-cursor-in-elasticsearch-sql-syntax/182542)
**Author:** [@lunatic](https://discuss.elastic.co/u/lunatic)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 1:15pm UTC](https://discuss.elastic.co/t/how-to-set-timeout-value-of-cursor-in-elasticsearch-sql-syntax/182542 "2019-05-31T13:15:40Z")
I had a query return large results with SQL syntax, and I use the 'cursor' to fetch results. But I found there is no way to set 'timeout' value therefore my cursor would be expired after some default value. So how can I… --- ## ["in query" is not yet supported](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568)
**Author:** [@Paul\_Yeung](https://discuss.elastic.co/u/Paul_Yeung)\ **Replies:** 2\ **Last updated:** [May 31, 2019, 12:48pm UTC](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568 "2019-05-31T12:48:44Z")
When I try to use sql API to do the following: select name from school where name in ( select name from teachers ) ; ES complains that "in query" is not yet supported. This means I need to do this in query DSL. What is… --- ## [Unexpected "too many FDs" error on local ES cluster](https://discuss.elastic.co/t/unexpected-too-many-fds-error-on-local-es-cluster/181310)
**Author:** [@vangap](https://discuss.elastic.co/u/vangap)\ **Replies:** 12\ **Last updated:** [May 31, 2019, 12:35pm UTC](https://discuss.elastic.co/t/unexpected-too-many-fds-error-on-local-es-cluster/181310 "2019-05-31T12:35:15Z")
I have elasticsearch 6.4.2 running on Mac, inside a container (Docker Desktop). I have about 240 indices and 1100 shards with 0 replicas set. I probably have 100k docs at max (can't say exact count because the cluster is… --- ## [Backup/restore options for ES 7.0 installed from ES helm chart](https://discuss.elastic.co/t/backup-restore-options-for-es-7-0-installed-from-es-helm-chart/183549)
**Author:** [@Rimantas\_Mocevicius](https://discuss.elastic.co/u/Rimantas_Mocevicius)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 12:16pm UTC](https://discuss.elastic.co/t/backup-restore-options-for-es-7-0-installed-from-es-helm-chart/183549 "2019-05-31T12:16:15Z")
Is any backup/restore option e.g. to GCS bucket supported in https://github.com/elastic/helm-charts/tree/master/elasticsearch? --- ## [\[SOLVED\] Don't succeed to create cluster ES 7.1](https://discuss.elastic.co/t/solved-dont-succeed-to-create-cluster-es-7-1/183690)
**Author:** [@jmilot](https://discuss.elastic.co/u/jmilot)\ **Replies:** 10\ **Last updated:** [May 31, 2019, 11:40am UTC](https://discuss.elastic.co/t/solved-dont-succeed-to-create-cluster-es-7-1/183690 "2019-05-31T11:40:21Z")
Hi, I'm trying to setup a 3 nodes cluster. My configuration is : cluster.name: dxproelsme node.name: dxproelsme01 path.data: /var/lib/elasticsearch path.logs: /var/log/elasticsearch network.host: \_site\_ discovery.seed… --- ## [Elasticsearch crashes when heap size gradually reaches 100% for bigger queries](https://discuss.elastic.co/t/elasticsearch-crashes-when-heap-size-gradually-reaches-100-for-bigger-queries/183710)
**Author:** [@rjalla](https://discuss.elastic.co/u/rjalla)\ **Replies:** 0\ **Last updated:** [May 31, 2019, 11:07am UTC](https://discuss.elastic.co/t/elasticsearch-crashes-when-heap-size-gradually-reaches-100-for-bigger-queries/183710 "2019-05-31T11:07:48Z")
Elasticsearch crashes when heap size gradually reaches 100% for bigger queries. We are using Elastcsearch 6.2.3. and we have around 200 queries and executing the same sequentially. But after couple of minutes, heap size… --- ## [Elastic 2 node cluster: "Received fatal alert: certificate\_unknown", but .p12 file with same certs and keys work](https://discuss.elastic.co/t/elastic-2-node-cluster-received-fatal-alert-certificate-unknown-but-p12-file-with-same-certs-and-keys-work/182592)
**Author:** [@raulk89](https://discuss.elastic.co/u/raulk89)\ **Replies:** 6\ **Last updated:** [May 31, 2019, 9:59am UTC](https://discuss.elastic.co/t/elastic-2-node-cluster-received-fatal-alert-certificate-unknown-but-p12-file-with-same-certs-and-keys-work/182592 "2019-05-31T09:59:58Z")
Hi Elastic 6.8.0 Centos 7.6 (64-bit) I have 2 node elastic cluster in my sandbox. I created .p12 file myself with company certificates. openssl pkcs12 -export -in company\_domain.cer -inkey company\_domain.key -name … --- ## [ES 7.0 takes longer to respond the first search query](https://discuss.elastic.co/t/es-7-0-takes-longer-to-respond-the-first-search-query/182656)
**Author:** [@aaiaaba123](https://discuss.elastic.co/u/aaiaaba123)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 9:15am UTC](https://discuss.elastic.co/t/es-7-0-takes-longer-to-respond-the-first-search-query/182656 "2019-05-31T09:15:57Z")
Seeing a performance issue in ES. When we run 2 queries with a gap of 10-15 mins, the query runs very slow. Subsequent queries running back to back are very fast but when we give a gap of 10-15 mins, first query takes … --- ## [Elasticsearch reroute move command: remote\_transport\_exception Error](https://discuss.elastic.co/t/elasticsearch-reroute-move-command-remote-transport-exception-error/182610)
**Author:** [@stefano1](https://discuss.elastic.co/u/stefano1)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 9:07am UTC](https://discuss.elastic.co/t/elasticsearch-reroute-move-command-remote-transport-exception-error/182610 "2019-05-31T09:07:57Z")
Good Morning All, I have to balance the cluster occupation of the ES cluster, our cluster is composed by 11 servers and i am a beginner in Elasticsearch software. I would to move an index with primary shard to another … --- ## [Master CPU high when bulk indexing in ES 5.1](https://discuss.elastic.co/t/master-cpu-high-when-bulk-indexing-in-es-5-1/183613)
**Author:** [@willyaranda\_vonage](https://discuss.elastic.co/u/willyaranda_vonage)\ **Replies:** 3\ **Last updated:** [May 31, 2019, 9:04am UTC](https://discuss.elastic.co/t/master-cpu-high-when-bulk-indexing-in-es-5-1/183613 "2019-05-31T09:04:43Z")
Hi! I'm testing a kafka-connect plugin that writes to ES (the official one from confluent, that does not use the elastic package, but own implementation) and I'm seeing a huge spike in CPU usage in the master node when … --- ## [Problem with Elastic Node](https://discuss.elastic.co/t/problem-with-elastic-node/183552)
**Author:** [@antonopo](https://discuss.elastic.co/u/antonopo)\ **Replies:** 4\ **Last updated:** [May 31, 2019, 9:02am UTC](https://discuss.elastic.co/t/problem-with-elastic-node/183552 "2019-05-31T09:02:46Z")
Hi, I have a strange behavior with one of my elasitcsearch nodes on the Elastic Cluster. I have an elastic cluster using 7 nodes that are different hosts. In fact i have 6 linux machines and 1 with windows. When i am … --- ## [Elasticsearch 7, 3 nodes cluster setup, 1 failed to join](https://discuss.elastic.co/t/elasticsearch-7-3-nodes-cluster-setup-1-failed-to-join/179296)
**Author:** [@rozzaaq](https://discuss.elastic.co/u/rozzaaq)\ **Replies:** 13\ **Last updated:** [May 31, 2019, 8:43am UTC](https://discuss.elastic.co/t/elasticsearch-7-3-nodes-cluster-setup-1-failed-to-join/179296 "2019-05-31T08:43:08Z")
I tried to configure a cluster with 3 nodes on GCP. 2 nodes join the same cluster (same UUID), 1 nodes fail to join. Here's my nodes configuration: cluster.name: rdy-elastic node.name: rdy-elastic2 network… --- ## [Create scripted field using elasticsearch-py library](https://discuss.elastic.co/t/create-scripted-field-using-elasticsearch-py-library/183486)
**Author:** [@GitsBdr](https://discuss.elastic.co/u/GitsBdr)\ **Replies:** 2\ **Last updated:** [May 31, 2019, 8:26am UTC](https://discuss.elastic.co/t/create-scripted-field-using-elasticsearch-py-library/183486 "2019-05-31T08:26:07Z")
Hi all, And thanks in advance for helping me out I would like to create scripted fields using python scripts I found on the web that I maybe need to use the elasticsearch-dsl-py library to connect to my cluster and th… --- ## [Multiple JVM (instances) in same machine sharing same data and log directory](https://discuss.elastic.co/t/multiple-jvm-instances-in-same-machine-sharing-same-data-and-log-directory/183202)
**Author:** [@anon17386273](https://discuss.elastic.co/u/anon17386273)\ **Replies:** 4\ **Last updated:** [May 31, 2019, 7:32am UTC](https://discuss.elastic.co/t/multiple-jvm-instances-in-same-machine-sharing-same-data-and-log-directory/183202 "2019-05-31T07:32:56Z")
I have a few powerful machines which is a bit of wasted to run only one instance of es. I was thinking of running multiple instances. Each of these machines have 12 SSD with JBOD configuration. I have mounted them as /d… --- ## [Elastic search 2.4 performance issue on VM (openstack)](https://discuss.elastic.co/t/elastic-search-2-4-performance-issue-on-vm-openstack/183671)
**Author:** [@madhur2928](https://discuss.elastic.co/u/madhur2928)\ **Replies:** 0\ **Last updated:** [May 31, 2019, 7:20am UTC](https://discuss.elastic.co/t/elastic-search-2-4-performance-issue-on-vm-openstack/183671 "2019-05-31T07:20:35Z")
Hi, We have an elastic cluster(2.4) with around 18T data (with replica) running on 10 nodes. Recently we moved 2 of our servers to VM using openstack but started facing issues on both of the VM's intermittently. Issue… --- ## [Optimization of elastic search](https://discuss.elastic.co/t/optimization-of-elastic-search/183662)
**Author:** [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\ **Replies:** 2\ **Last updated:** [May 31, 2019, 7:17am UTC](https://discuss.elastic.co/t/optimization-of-elastic-search/183662 "2019-05-31T07:17:57Z")
hi all i am using Elastic Stack with 2 node. currently i have 1 index with 5 shards ,size of index is around 217 GB,now day by day query in index is getting slow . i have 2 question - 1 is there any ideal size of i… --- ## [Elastic nodes looks connected, but it is not](https://discuss.elastic.co/t/elastic-nodes-looks-connected-but-it-is-not/183609)
**Author:** [@Narottam\_Kumar](https://discuss.elastic.co/u/Narottam_Kumar)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 7:14am UTC](https://discuss.elastic.co/t/elastic-nodes-looks-connected-but-it-is-not/183609 "2019-05-31T07:14:56Z")
I have a weird problem here. I have 12 nodes and all are connected and joined in cluster but when i do run node statistics (192.168../\_nodes/stats) it gives me 11 nodes only. When I do /\_cat/shards , for one node which… --- ## [Moving SQL data to Elastic search NODE](https://discuss.elastic.co/t/moving-sql-data-to-elastic-search-node/183653)
**Author:** [@SudevPK](https://discuss.elastic.co/u/SudevPK)\ **Replies:** 2\ **Last updated:** [May 31, 2019, 6:52am UTC](https://discuss.elastic.co/t/moving-sql-data-to-elastic-search-node/183653 "2019-05-31T06:52:02Z")
I am having SQL data base and an Elastic search Node.What is the best way, To move data from sql to elastic search Enable sync between sql and elastic search ? --- ## [Failed to load plugin class \[org.elasticsearch.xpack.XPackPlugin](https://discuss.elastic.co/t/failed-to-load-plugin-class-org-elasticsearch-xpack-xpackplugin/183299)
**Author:** [@Krishna\_Kodumagulla](https://discuss.elastic.co/u/Krishna_Kodumagulla)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 6:01am UTC](https://discuss.elastic.co/t/failed-to-load-plugin-class-org-elasticsearch-xpack-xpackplugin/183299 "2019-05-31T06:01:49Z")
Below is the pom.xml -\> in eclipse facing with Xpack Plugin error. PLease guide. try { esClient = new PreBuiltXPackTransportClient(settings); //--XPACK plugin error for (String h : hosts) { esClient.addTransport… --- ## [Routing: Equal distribution on all shards](https://discuss.elastic.co/t/routing-equal-distribution-on-all-shards/183531)
**Author:** [@pokaleshrey](https://discuss.elastic.co/u/pokaleshrey)\ **Replies:** 4\ **Last updated:** [May 31, 2019, 5:19am UTC](https://discuss.elastic.co/t/routing-equal-distribution-on-all-shards/183531 "2019-05-31T05:19:21Z")
Hi, I have 5 unique routing keys "a","b","c","d","e" in my application. My ES setup consists of 5 shards. When i check in current state (ver 6.6.2). My shard allocation is like this: a 4 b 2 c 0 d 3 e 4 Note that… --- ## [Environment avariable in ELK docker](https://discuss.elastic.co/t/environment-avariable-in-elk-docker/183644)
**Author:** [@tatdat](https://discuss.elastic.co/u/tatdat)\ **Replies:** 3\ **Last updated:** [May 31, 2019, 5:28am UTC](https://discuss.elastic.co/t/environment-avariable-in-elk-docker/183644 "2019-05-31T05:28:24Z")
Im settingup ELK in dockcer with docker-compose. I have a question. Where do i can find evironment avariable setup for Elasticsearch, kibana image. I knew we have option overwrite configuration file with this option … --- ## [Javascript Client Linting Errors](https://discuss.elastic.co/t/javascript-client-linting-errors/183649)
**Author:** [@scottdfedorov](https://discuss.elastic.co/u/scottdfedorov)\ **Replies:** 0\ **Last updated:** [May 31, 2019, 3:51am UTC](https://discuss.elastic.co/t/javascript-client-linting-errors/183649 "2019-05-31T03:51:15Z")
Attempting to use the new Javascript client and am having some linting errors with ESLint. Using the prime example from the docs here: ESLint is giving me an error: ERROR: Parsing error: Unexpected token client spec… --- ## [Not able to create a cluster in Elasticsearch](https://discuss.elastic.co/t/not-able-to-create-a-cluster-in-elasticsearch/183374)
**Author:** [@Barun\_Kumar](https://discuss.elastic.co/u/Barun_Kumar)\ **Replies:** 1\ **Last updated:** [May 31, 2019, 3:43am UTC](https://discuss.elastic.co/t/not-able-to-create-a-cluster-in-elasticsearch/183374 "2019-05-31T03:43:18Z")
I have configured two nodes to create a cluster. Both these nodes are working fine separately. When We join them together to form a cluster, Only single node is appearing in cluster. The elasticsearch.yml of both node i… --- ## [Terms aggregation with order with Java High Level Rest Client fails](https://discuss.elastic.co/t/terms-aggregation-with-order-with-java-high-level-rest-client-fails/183452)
**Author:** [@Isarg](https://discuss.elastic.co/u/Isarg)\ **Replies:** 3\ **Last updated:** [May 31, 2019, 3:24am UTC](https://discuss.elastic.co/t/terms-aggregation-with-order-with-java-high-level-rest-client-fails/183452 "2019-05-31T03:24:01Z")
The elasticSearch version is 5.6.4 The following terms aggregation query works perfectly fine on my Kibana console GET zipkin:\*/\_search { "size": 0, "aggs": { "group\_by\_traceid": { "terms": { "fie… --- ## [How to set close auto create mapping when index data?](https://discuss.elastic.co/t/how-to-set-close-auto-create-mapping-when-index-data/183639)
**Author:** [@mh\_w](https://discuss.elastic.co/u/mh_w)\ **Replies:** 0\ **Last updated:** [May 31, 2019, 1:25am UTC](https://discuss.elastic.co/t/how-to-set-close-auto-create-mapping-when-index-data/183639 "2019-05-31T01:25:05Z")
Elasticsearch version ( bin/elasticsearch --version ): 7.1 Plugins installed : \[x-pack\] JVM version ( java -version ): 1.8.0\_212 OS version ( uname -a if on a Unix-like system): Linux VM-0-41-ubuntu 4.4.0-130-gene… --- ## [Error while starting elasticsearch 7](https://discuss.elastic.co/t/error-while-starting-elasticsearch-7/183504)
**Author:** [@Amr344](https://discuss.elastic.co/u/Amr344)\ **Replies:** 2\ **Last updated:** [May 30, 2019, 11:28pm UTC](https://discuss.elastic.co/t/error-while-starting-elasticsearch-7/183504 "2019-05-30T23:28:55Z")
i recieved below error while starting elasticsearch ,could you please advise? Linux 5.11 java version "1.8.0\_60" elasticsearch-7.1.1 \[dwh@DEVESBTRN01 bin\]$ cd ES\_HOME \[dwh@DEVESBTRN01 bin\] ./elasticsearch \[2019-05-3… --- ## [API to get all defaults/overriden settings in elasticsearch.yml](https://discuss.elastic.co/t/api-to-get-all-defaults-overriden-settings-in-elasticsearch-yml/183612)
**Author:** [@sg.esearch](https://discuss.elastic.co/u/sg.esearch)\ **Replies:** 3\ **Last updated:** [May 30, 2019, 10:42pm UTC](https://discuss.elastic.co/t/api-to-get-all-defaults-overriden-settings-in-elasticsearch-yml/183612 "2019-05-30T22:42:11Z")
Is there an API to get all the settings possible in elasticsearch.yml? We want to get both the default values as well as the overriden ones. Knowing these settings will help us fix cluster down issues better. Right no… --- ## [ES 2.4 Defending Against Bad Queries](https://discuss.elastic.co/t/es-2-4-defending-against-bad-queries/183577)
**Author:** [@sirsteve](https://discuss.elastic.co/u/sirsteve)\ **Replies:** 1\ **Last updated:** [May 30, 2019, 9:37pm UTC](https://discuss.elastic.co/t/es-2-4-defending-against-bad-queries/183577 "2019-05-30T21:37:13Z")
Hi, I've recently started supporting several ElasticSearch 2.4 clusters and am seeing issues occurring related to clients submitting bad queries. What happens typically is a bad query comes in and causes the majority o… --- ## [Elasticsearch Cleint Nodes OOM Killed by Gargantuan Query](https://discuss.elastic.co/t/elasticsearch-cleint-nodes-oom-killed-by-gargantuan-query/183581)
**Author:** [@IanGabes](https://discuss.elastic.co/u/IanGabes)\ **Replies:** 2\ **Last updated:** [May 30, 2019, 8:55pm UTC](https://discuss.elastic.co/t/elasticsearch-cleint-nodes-oom-killed-by-gargantuan-query/183581 "2019-05-30T20:55:56Z")
Hi all! I think we may have discovered a bit of an edge case or bug with elasticsearch and I'm just looking to confirm this known issue, or potentially document a new bug. One of my analysts has constructed a query cons… --- ## [Elasticsearch custom ingest plugin error when indexing with a field of type doble\[\]](https://discuss.elastic.co/t/elasticsearch-custom-ingest-plugin-error-when-indexing-with-a-field-of-type-doble/183488)
**Author:** [@Borwick\_5576](https://discuss.elastic.co/u/Borwick_5576)\ **Replies:** 1\ **Last updated:** [May 30, 2019, 6:58pm UTC](https://discuss.elastic.co/t/elasticsearch-custom-ingest-plugin-error-when-indexing-with-a-field-of-type-doble/183488 "2019-05-30T18:58:38Z")
I have been developing an ingest plugin that connects to a remote server and gets from it the projection of the document of the form: "vector": \[ 0.0021645021645200296, 0.0021645021645200296, 0.0021645021645200296, … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1278) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1280)