# Elasticsearch

**URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1297

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1298

---

## [WatchStore Error - Version mismatch](https://discuss.elastic.co/t/watchstore-error-version-mismatch/181503)

<div class="topic-metadata">

**Author:** [@Manas](https://discuss.elastic.co/u/Manas)\
**Replies:** 0\
**Last updated:** [May 17, 2019, 3:45am UTC](https://discuss.elastic.co/t/watchstore-error-version-mismatch/181503 "2019-05-17T03:45:56Z")

</div>

Hello we are facing issue related to watch with following log .. Can some one guide ? | --- | --- | ||\[2019-05-17T03:31:37,891\]\[INFO \]\[o.e.n.Node \] initializing ...| ||\[2019-05-17T03:31:39,145\]\[INFO \]\[o.e.e.NodeEnvir…

---

## [Setting heap size in docker containers - can't get it to work](https://discuss.elastic.co/t/setting-heap-size-in-docker-containers-cant-get-it-to-work/181500)

<div class="topic-metadata">

**Author:** [@jamiejackson](https://discuss.elastic.co/u/jamiejackson)\
**Replies:** 3\
**Last updated:** [May 17, 2019, 3:01am UTC](https://discuss.elastic.co/t/setting-heap-size-in-docker-containers-cant-get-it-to-work/181500 "2019-05-17T03:01:42Z")

</div>

I'm at a loss as to how to configure the heap in docker containers. Nothing seems to work as I'd expect: Straightforward set to 2GB doesn't work: $ docker run -it -e "ES\_JAVA\_OPTS=-Xms2g -Xms2g" docker.elastic.co/elast…

---

## [Cannot install a \[platinum\] license unless TLS is configured or security is disabled](https://discuss.elastic.co/t/cannot-install-a-platinum-license-unless-tls-is-configured-or-security-is-disabled/181193)

<div class="topic-metadata">

**Author:** [@hari.v](https://discuss.elastic.co/u/hari.v)\
**Replies:** 5\
**Last updated:** [May 17, 2019, 2:21am UTC](https://discuss.elastic.co/t/cannot-install-a-platinum-license-unless-tls-is-configured-or-security-is-disabled/181193 "2019-05-17T02:21:13Z")

</div>

Hi i couldnt able to update platinum license on the kibana console. shows \* Error encountered uploading license: Cannot install a \[GOLD\] license unless TLS is configured or security is disabled so i tried to generate c…

---

## [Can\_match is not supported on pre 5.6.0 nodes](https://discuss.elastic.co/t/can-match-is-not-supported-on-pre-5-6-0-nodes/181260)

<div class="topic-metadata">

**Author:** [@Harshad](https://discuss.elastic.co/u/Harshad)\
**Replies:** 1\
**Last updated:** [May 16, 2019, 11:04pm UTC](https://discuss.elastic.co/t/can-match-is-not-supported-on-pre-5-6-0-nodes/181260 "2019-05-16T23:04:31Z")

</div>

I am running in to an issue while upgrading ES nodes from 5.4.1 to 5.6.4. When a user runs a search that is going to hit a large number of shards, we get the following exception: { "error": { "root\_cause": …

---

## [Unassigned shards during data nodes move](https://discuss.elastic.co/t/unassigned-shards-during-data-nodes-move/181486)

<div class="topic-metadata">

**Author:** [@mosiddi](https://discuss.elastic.co/u/mosiddi)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 10:19pm UTC](https://discuss.elastic.co/t/unassigned-shards-during-data-nodes-move/181486 "2019-05-16T22:19:34Z")

</div>

Recently we were migrating our data from one region to another region. The approach we selected for data move was - Update cluster to not allow data in new nodes Add new data nodes Update cluster to allow data only in …

---

## [Elasticsearch won't bind to localhost](https://discuss.elastic.co/t/elasticsearch-wont-bind-to-localhost/181484)

<div class="topic-metadata">

**Author:** [@sudoroot](https://discuss.elastic.co/u/sudoroot)\
**Replies:** 1\
**Last updated:** [May 16, 2019, 10:13pm UTC](https://discuss.elastic.co/t/elasticsearch-wont-bind-to-localhost/181484 "2019-05-16T22:13:51Z")

</div>

I am trying to set up Elasticsearch on a VM running CentOS 7. I've followed the configuration guide, but ES will not bind to 127.0.0.1:9200. The configuration is as follows: # NOTE: Elasticsearch comes with reasonable …

---

## [Unicode characters in documents are not properly loaded in integ tests](https://discuss.elastic.co/t/unicode-characters-in-documents-are-not-properly-loaded-in-integ-tests/181287)

<div class="topic-metadata">

**Author:** [@arsenmk](https://discuss.elastic.co/u/arsenmk)\
**Replies:** 1\
**Last updated:** [May 16, 2019, 9:13pm UTC](https://discuss.elastic.co/t/unicode-characters-in-documents-are-not-properly-loaded-in-integ-tests/181287 "2019-05-16T21:13:11Z")

</div>

Hi there, I have an integ test derived from ESIntegTestCase where I index a document with Chinese characters in some fields, e.g.: POST /account/account { "account\_number" : 6666, "balance" : 1515, "firstna…

---

## [Update Snapshot in the repo with same name?](https://discuss.elastic.co/t/update-snapshot-in-the-repo-with-same-name/181446)

<div class="topic-metadata">

**Author:** [@Mohit\_Ruke](https://discuss.elastic.co/u/Mohit_Ruke)\
**Replies:** 3\
**Last updated:** [May 16, 2019, 6:57pm UTC](https://discuss.elastic.co/t/update-snapshot-in-the-repo-with-same-name/181446 "2019-05-16T18:57:46Z")

</div>

Is there any way to update a snapshot in a repo after adding new records to an index?

---

## [How to recover from missing translog-N.ckp files \[ES-2.0.0\]](https://discuss.elastic.co/t/how-to-recover-from-missing-translog-n-ckp-files-es-2-0-0/181466)

<div class="topic-metadata">

**Author:** [@russinholi](https://discuss.elastic.co/u/russinholi)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 6:17pm UTC](https://discuss.elastic.co/t/how-to-recover-from-missing-translog-n-ckp-files-es-2-0-0/181466 "2019-05-16T18:17:39Z")

</div>

Hi all, after a reboot on my ES server we start to got a lot of following error: \<IndexShardRecoveryException\[failed to recovery from gateway\]; nested: EngineCreationFailureException\[failed to create engine\]; nested: No…

---

## [Nested filter with multiple term queries](https://discuss.elastic.co/t/nested-filter-with-multiple-term-queries/181465)

<div class="topic-metadata">

**Author:** [@tharindudg](https://discuss.elastic.co/u/tharindudg)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 6:14pm UTC](https://discuss.elastic.co/t/nested-filter-with-multiple-term-queries/181465 "2019-05-16T18:14:28Z")

</div>

I'm trying to use elasticsearch(6.7) sorting with multiple term queries. But it doesn't sort data when there are 3 term queries. It works when I specify only { "term": { "instance.instFields.sourceFieldI…

---

## [Nodes leave and then rejoin the cluster randomly](https://discuss.elastic.co/t/nodes-leave-and-then-rejoin-the-cluster-randomly/181464)

<div class="topic-metadata">

**Author:** [@elk11](https://discuss.elastic.co/u/elk11)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 6:11pm UTC](https://discuss.elastic.co/t/nodes-leave-and-then-rejoin-the-cluster-randomly/181464 "2019-05-16T18:11:56Z")

</div>

Hi, We have a 5 node elasticsearch cluster (7.0.0). In elasticsearch logs i see nodes randomly leave and then rejoin the cluster. They were not restarted by us. Here's a sample log: org.elasticsearch.action.FailedNode…

---

## [Reindexing stuck at some batch and fails with 'search context missing exception'](https://discuss.elastic.co/t/reindexing-stuck-at-some-batch-and-fails-with-search-context-missing-exception/181450)

<div class="topic-metadata">

**Author:** [@elk11](https://discuss.elastic.co/u/elk11)\
**Replies:** 2\
**Last updated:** [May 16, 2019, 5:32pm UTC](https://discuss.elastic.co/t/reindexing-stuck-at-some-batch-and-fails-with-search-context-missing-exception/181450 "2019-05-16T17:32:30Z")

</div>

I'm reindexing all my indexes from old cluster(5.x.x) to new cluster (7.0.0). I have some big indexes of size around 3GB. (For which i had to specify 'size' as low as 10 to reindex) (The number of documents in those ind…

---

## [Increment datetime using update by query](https://discuss.elastic.co/t/increment-datetime-using-update-by-query/181419)

<div class="topic-metadata">

**Author:** [@phager](https://discuss.elastic.co/u/phager)\
**Replies:** 3\
**Last updated:** [May 16, 2019, 5:13pm UTC](https://discuss.elastic.co/t/increment-datetime-using-update-by-query/181419 "2019-05-16T17:13:41Z")

</div>

I am tasked with updating the datetime field to keep log records within a week of the current date. The data set contains records from a 1 month period and I need to increment each record by a set number of days so simpl…

---

## [Index status going to RED After I create index with this setting "index.routing.allocation.require.box\_type": "hot"](https://discuss.elastic.co/t/index-status-going-to-red-after-i-create-index-with-this-setting-index-routing-allocation-require-box-type-hot/180583)

<div class="topic-metadata">

**Author:** [@chandukreddi](https://discuss.elastic.co/u/chandukreddi)\
**Replies:** 4\
**Last updated:** [May 16, 2019, 3:55pm UTC](https://discuss.elastic.co/t/index-status-going-to-red-after-i-create-index-with-this-setting-index-routing-allocation-require-box-type-hot/180583 "2019-05-16T15:55:15Z")

</div>

Hello Team, I have 2 node cluster and one node is HOT and another node WARM. Help me to understand why index status changing to RED when I use setting "index.routing.allocation.require.box\_type": "hot" Index creation …

---

## [Join related data from two indices](https://discuss.elastic.co/t/join-related-data-from-two-indices/181439)

<div class="topic-metadata">

**Author:** [@Jeremy\_A](https://discuss.elastic.co/u/Jeremy_A)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 3:25pm UTC](https://discuss.elastic.co/t/join-related-data-from-two-indices/181439 "2019-05-16T15:25:27Z")

</div>

Let's say I'm using Logstash to pull in data about sales in many franchise locations, and then I have the metadata about these locations (e.g. address, manager name, etc.) in a separate SQL Server database. The sales dat…

---

## [Error OptOutQueryCache with High cpu charge](https://discuss.elastic.co/t/error-optoutquerycache-with-high-cpu-charge/181429)

<div class="topic-metadata">

**Author:** [@tidom](https://discuss.elastic.co/u/tidom)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 2:30pm UTC](https://discuss.elastic.co/t/error-optoutquerycache-with-high-cpu-charge/181429 "2019-05-16T14:30:55Z")

</div>

Hello, I have a very big slowness on my elasticsearch environment. I wanted to know if it could be related to this error in the log file /var/log/elasticsearch/elasticsearch.log Do you have any idea of the source of th…

---

## [Elasticsearch failed: Caused by: java.lang.IllegalArgumentException: Plugin \[search-guard-5\] was built for Elasticsearch version 5.4.0 but version 7.0.1 is running](https://discuss.elastic.co/t/elasticsearch-failed-caused-by-java-lang-illegalargumentexception-plugin-search-guard-5-was-built-for-elasticsearch-version-5-4-0-but-version-7-0-1-is-running/181428)

<div class="topic-metadata">

**Author:** [@Bader](https://discuss.elastic.co/u/Bader)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 2:26pm UTC](https://discuss.elastic.co/t/elasticsearch-failed-caused-by-java-lang-illegalargumentexception-plugin-search-guard-5-was-built-for-elasticsearch-version-5-4-0-but-version-7-0-1-is-running/181428 "2019-05-16T14:26:23Z")

</div>

Hi, I am relatively new to ELK stack and am trying to set it up (version 7.0.1) on a CentOS virtual box. I have Kibana and Logstash up and running, and my only problem is with Elasticsearch. I can always get it running f…

---

## [ES-hive integration error- Cannot detect ES version - typically this happens if the network/Elasticsearch cluster is not accessible or when targeting a WAN/Cloud instance without the proper setting 'es.nodes.wan.only'](https://discuss.elastic.co/t/es-hive-integration-error-cannot-detect-es-version-typically-this-happens-if-the-network-elasticsearch-cluster-is-not-accessible-or-when-targeting-a-wan-cloud-instance-without-the-proper-setting-es-nodes-wan-only/181416)

<div class="topic-metadata">

**Author:** [@Bhanu\_Pratap\_Singh](https://discuss.elastic.co/u/Bhanu_Pratap_Singh)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 1:56pm UTC](https://discuss.elastic.co/t/es-hive-integration-error-cannot-detect-es-version-typically-this-happens-if-the-network-elasticsearch-cluster-is-not-accessible-or-when-targeting-a-wan-cloud-instance-without-the-proper-setting-es-nodes-wan-only/181416 "2019-05-16T13:56:12Z")

</div>

Hi, I am trying to push data from a Hive(1.2.1000.2.6.3.0-235) table over to ElasticSearch ("version": : "6.6.1") in the secured environment. I have tried numerous combinations of properties for the TBL\_PROPERTIES of …

---

## [Enabling xpack features](https://discuss.elastic.co/t/enabling-xpack-features/181309)

<div class="topic-metadata">

**Author:** [@Vikash\_Singh1](https://discuss.elastic.co/u/Vikash_Singh1)\
**Replies:** 6\
**Last updated:** [May 16, 2019, 12:49pm UTC](https://discuss.elastic.co/t/enabling-xpack-features/181309 "2019-05-16T12:49:31Z")

</div>

I have activated my 30 days trial. Now I have a new feature under management tab know as beats, in order to use it, I have to enable security feature in kibana and elasticsearch but in order to enable xpack we have to co…

---

## [What's wrong with my query?](https://discuss.elastic.co/t/whats-wrong-with-my-query/181224)

<div class="topic-metadata">

**Author:** [@davidbien](https://discuss.elastic.co/u/davidbien)\
**Replies:** 2\
**Last updated:** [May 16, 2019, 10:49am UTC](https://discuss.elastic.co/t/whats-wrong-with-my-query/181224 "2019-05-16T10:49:39Z")

</div>

I'm trying to search through documents using an equivalent of logical OR in elasticsearch. From the docs I understand I should use should, however when I run it I get all documents, none of them meeting my requirements …

---

## [Elastic Cluster Red - How to fix!](https://discuss.elastic.co/t/elastic-cluster-red-how-to-fix/181114)

<div class="topic-metadata">

**Author:** [@antonopo](https://discuss.elastic.co/u/antonopo)\
**Replies:** 5\
**Last updated:** [May 16, 2019, 8:23am UTC](https://discuss.elastic.co/t/elastic-cluster-red-how-to-fix/181114 "2019-05-16T08:23:21Z")

</div>

Hi all, I have a Elastic Cluster with 6 nodes in 6 different hosts. The elastic cluster status is red. I am using the latest elasticsearch version 7.0.1 to all the nodes. GET \_cluster/health { "cluster\_name" : "xh-e…

---

## [Is there workaround for join query](https://discuss.elastic.co/t/is-there-workaround-for-join-query/181329)

<div class="topic-metadata">

**Author:** [@tushar\_chevulkar](https://discuss.elastic.co/u/tushar_chevulkar)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 7:55am UTC](https://discuss.elastic.co/t/is-there-workaround-for-join-query/181329 "2019-05-16T07:55:06Z")

</div>

I am in a situation where I need to use join. My situation is as follows: I have a node where I have tweets for more than 50k twitter profile and increasing every day, on the other hand there are admins who are monitor…

---

## [Index Lifecycle Management (ILM) Roadmap](https://discuss.elastic.co/t/index-lifecycle-management-ilm-roadmap/180818)

<div class="topic-metadata">

**Author:** [@miga](https://discuss.elastic.co/u/miga)\
**Replies:** 4\
**Last updated:** [May 16, 2019, 7:07am UTC](https://discuss.elastic.co/t/index-lifecycle-management-ilm-roadmap/180818 "2019-05-16T07:07:33Z")

</div>

Hi, I already know and used Curator to manage indices and was now reading about the ILM. It seems to me that Curator does a lot more that ILM, currently. However, since ILM is quite new and Curator is some sort of an e…

---

## [How can I use percentile aggregation result as a range query boundary](https://discuss.elastic.co/t/how-can-i-use-percentile-aggregation-result-as-a-range-query-boundary/181136)

<div class="topic-metadata">

**Author:** [@Cherie](https://discuss.elastic.co/u/Cherie)\
**Replies:** 1\
**Last updated:** [May 16, 2019, 6:51am UTC](https://discuss.elastic.co/t/how-can-i-use-percentile-aggregation-result-as-a-range-query-boundary/181136 "2019-05-16T06:51:19Z")

</div>

Hi, I want to write a filter which can pick out 95 percent hits. These hits TotalTiming field range from 0 to P95 of All TotalTiming. So I wonder how can I use this 95 percentile aggregation result as a range query top …

---

## [Elasticsearch 7.0 Hierarchy Search](https://discuss.elastic.co/t/elasticsearch-7-0-hierarchy-search/181318)

<div class="topic-metadata">

**Author:** [@Choo\_Kar\_Chun](https://discuss.elastic.co/u/Choo_Kar_Chun)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 6:41am UTC](https://discuss.elastic.co/t/elasticsearch-7-0-hierarchy-search/181318 "2019-05-16T06:41:35Z")

</div>

Hello! Is there any way to get any parent/child data with their scores? If you take a look below: For example, if "Relational Database" is matched, it should display the result with the highest score,followed by its …

---

## [Keyword Search Scoring](https://discuss.elastic.co/t/keyword-search-scoring/181316)

<div class="topic-metadata">

**Author:** [@Choo\_Kar\_Chun](https://discuss.elastic.co/u/Choo_Kar_Chun)\
**Replies:** 1\
**Last updated:** [May 16, 2019, 6:35am UTC](https://discuss.elastic.co/t/keyword-search-scoring/181316 "2019-05-16T06:35:01Z")

</div>

Hello! Is there any way to get the relevancy score for keyword/partial searches? This is my mapping code: URL: /vacancy { "mappings": { "properties": { "vacancy\_join": { "type": "join", "relations": { "employer"…

---

## [After ES 5.5 to 6.5 upgrade nodes are not forming Cluster](https://discuss.elastic.co/t/after-es-5-5-to-6-5-upgrade-nodes-are-not-forming-cluster/181312)

<div class="topic-metadata">

**Author:** [@Suryadip\_Nag](https://discuss.elastic.co/u/Suryadip_Nag)\
**Replies:** 1\
**Last updated:** [May 16, 2019, 6:21am UTC](https://discuss.elastic.co/t/after-es-5-5-to-6-5-upgrade-nodes-are-not-forming-cluster/181312 "2019-05-16T06:21:36Z")

</div>

We recently upgraded ES 5.5 to 6.5. Little background: We are downloading the open source code of elasticsearch and bundle it with our own application and then we give it to the customer. So when the customer install ou…

---

## [How to specify authorization in python client?](https://discuss.elastic.co/t/how-to-specify-authorization-in-python-client/181123)

<div class="topic-metadata">

**Author:** [@MKU](https://discuss.elastic.co/u/MKU)\
**Replies:** 3\
**Last updated:** [May 16, 2019, 5:35am UTC](https://discuss.elastic.co/t/how-to-specify-authorization-in-python-client/181123 "2019-05-16T05:35:57Z")

</div>

Hi, I am looking for a way to specify the authorization token in python requests for elasticsearch. For example, es=Elasticsearch(\['http://localhost:8080'\],http\_auth=('user', 'pass')) in above example just like you sp…

---

## [GCoverhead](https://discuss.elastic.co/t/gcoverhead/181095)

<div class="topic-metadata">

**Author:** [@Vinay\_G](https://discuss.elastic.co/u/Vinay_G)\
**Replies:** 5\
**Last updated:** [May 16, 2019, 4:58am UTC](https://discuss.elastic.co/t/gcoverhead/181095 "2019-05-16T04:58:18Z")

</div>

Hi, I could see below warning message in my ES Logs. \[2017-04-07T13:34:15,260\]\[WARN \]\[o.e.m.j.JvmGcMonitorService\] \[FBp7aLX\] \[gc\]\[5157\] overhead, spent \[1s\] collecting in the last \[1.1s\] Also in our settings for ES, t…

---

## [Visualization in Kibana - Y axis configured dynamically](https://discuss.elastic.co/t/visualization-in-kibana-y-axis-configured-dynamically/181307)

<div class="topic-metadata">

**Author:** [@Sanjay\_Saatyaki](https://discuss.elastic.co/u/Sanjay_Saatyaki)\
**Replies:** 0\
**Last updated:** [May 16, 2019, 4:18am UTC](https://discuss.elastic.co/t/visualization-in-kibana-y-axis-configured-dynamically/181307 "2019-05-16T04:18:00Z")

</div>

Hi, I added 3 values similar to the json i have attached below. When i am creating a visualization with sub-buckets I am encountering issues in the y axis. The scale of the y axis is dynamically as the below snap shot S…

[Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1296)

[Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1298)
