# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1288 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1289 --- ## [ElasticSearch failure: Environment is not locked](https://discuss.elastic.co/t/elasticsearch-failure-environment-is-not-locked/182559)
**Author:** [@HPVRNP](https://discuss.elastic.co/u/HPVRNP)\ **Replies:** 3\ **Last updated:** [May 24, 2019, 8:46am UTC](https://discuss.elastic.co/t/elasticsearch-failure-environment-is-not-locked/182559 "2019-05-24T08:46:57Z")
Hi, Environment: OS : Windows 64-bit ElasticSearch : 6.6.2 Java: 1.8.151 Cluster: Single Node cluster Index strategy: Indices are created daily and programmatically Shard: Single shard per index and no replicatio… --- ## [Return only the data inside hits \[ \]](https://discuss.elastic.co/t/return-only-the-data-inside-hits/182576)
**Author:** [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\ **Replies:** 4\ **Last updated:** [May 24, 2019, 8:41am UTC](https://discuss.elastic.co/t/return-only-the-data-inside-hits/182576 "2019-05-24T08:41:50Z")
Hi, I have a query that returns the hits field nested inside key andaggregations. I'm using curl to send the data to logstash for further processing and I would like to make my life a bit easier by only having to proce… --- ## [Elastic search snopshot azure repoistory](https://discuss.elastic.co/t/elastic-search-snopshot-azure-repoistory/182225)
**Author:** [@tamil6593](https://discuss.elastic.co/u/tamil6593)\ **Replies:** 21\ **Last updated:** [May 24, 2019, 8:16am UTC](https://discuss.elastic.co/t/elastic-search-snopshot-azure-repoistory/182225 "2019-05-24T08:16:30Z")
i need to save the elastic search snapshot in azure blobs container. how to config the elastic search and azure repository? i already installed azure repository plug in elastic Search.but not its show settings\_exceptio… --- ## [How to blow a query when elasticsearch first runs?](https://discuss.elastic.co/t/how-to-blow-a-query-when-elasticsearch-first-runs/182534)
**Author:** [@xodn0812](https://discuss.elastic.co/u/xodn0812)\ **Replies:** 3\ **Last updated:** [May 24, 2019, 7:35am UTC](https://discuss.elastic.co/t/how-to-blow-a-query-when-elasticsearch-first-runs/182534 "2019-05-24T07:35:34Z")
How to blow a query when elasticsearch first runs??? I need to automatically register policies, templates, security, etc. when elasticsearch is first run. I do not think there is a function that can do it automaticall… --- ## [Elasticsearch in RAM](https://discuss.elastic.co/t/elasticsearch-in-ram/182470)
**Author:** [@OksanaBarshchyk](https://discuss.elastic.co/u/OksanaBarshchyk)\ **Replies:** 3\ **Last updated:** [May 24, 2019, 7:19am UTC](https://discuss.elastic.co/t/elasticsearch-in-ram/182470 "2019-05-24T07:19:35Z")
Is there some way to run Elasticsearch completely in RAM? --- ## [Trigonometric functions in tiny math](https://discuss.elastic.co/t/trigonometric-functions-in-tiny-math/182574)
**Author:** [@6tUBp3gwd9Zp](https://discuss.elastic.co/u/6tUBp3gwd9Zp)\ **Replies:** 0\ **Last updated:** [May 24, 2019, 7:14am UTC](https://discuss.elastic.co/t/trigonometric-functions-in-tiny-math/182574 "2019-05-24T07:14:30Z")
Is it somehow possible to do sin(params.value) in the visual builder (tiny-)math aggregation? --- ## [Aggregate over top hits ElasticSearch](https://discuss.elastic.co/t/aggregate-over-top-hits-elasticsearch/182371)
**Author:** [@haych1702](https://discuss.elastic.co/u/haych1702)\ **Replies:** 6\ **Last updated:** [May 24, 2019, 7:12am UTC](https://discuss.elastic.co/t/aggregate-over-top-hits-elasticsearch/182371 "2019-05-24T07:12:33Z")
My documents are structured in the following way: { "chefInfo": { "id": int, "employed": String ... Some more recipe information ... } "recipe": { ... Some recipe information ... } } … --- ## [What would be the consequences of having abusive requests? Slowness or crash?](https://discuss.elastic.co/t/what-would-be-the-consequences-of-having-abusive-requests-slowness-or-crash/182278)
**Author:** [@nuwan](https://discuss.elastic.co/u/nuwan)\ **Replies:** 2\ **Last updated:** [May 24, 2019, 7:00am UTC](https://discuss.elastic.co/t/what-would-be-the-consequences-of-having-abusive-requests-slowness-or-crash/182278 "2019-05-24T07:00:47Z")
seems like Kibana search limit is by default 10000. I Increated it up to 20000. This 10000 limit is set for a reason. It protects the cluster from abusively large search requests PUT /ticker\_quote\_\*/\_settings { "inde… --- ## [Setting up HTTPS for Elasticsearch 7.1](https://discuss.elastic.co/t/setting-up-https-for-elasticsearch-7-1/181913)
**Author:** [@Krushna\_Bagde](https://discuss.elastic.co/u/Krushna_Bagde)\ **Replies:** 6\ **Last updated:** [May 24, 2019, 6:46am UTC](https://discuss.elastic.co/t/setting-up-https-for-elasticsearch-7-1/181913 "2019-05-24T06:46:19Z")
Hello, It looks like the basic elastic license allows encrypted communications as listed here - https://www.elastic.co/subscriptions but the documentation says security is only available as a part of x-pack (https://www… --- ## [Create user in elasticsearch](https://discuss.elastic.co/t/create-user-in-elasticsearch/182401)
**Author:** [@safderali5](https://discuss.elastic.co/u/safderali5)\ **Replies:** 3\ **Last updated:** [May 24, 2019, 6:33am UTC](https://discuss.elastic.co/t/create-user-in-elasticsearch/182401 "2019-05-24T06:33:00Z")
Can we automatically create new user and set passwords for default users(e.g kibana, logstash\_system, elasticsearch etc) during elasticsearch startup. i.e setting it up in elasticsearch configuration or providing that d… --- ## [Where to place unicast\_hosts.txt file for cluster setup in ES 6.5](https://discuss.elastic.co/t/where-to-place-unicast-hosts-txt-file-for-cluster-setup-in-es-6-5/181799)
**Author:** [@Suryadip\_Nag](https://discuss.elastic.co/u/Suryadip_Nag)\ **Replies:** 13\ **Last updated:** [May 24, 2019, 6:12am UTC](https://discuss.elastic.co/t/where-to-place-unicast-hosts-txt-file-for-cluster-setup-in-es-6-5/181799 "2019-05-24T06:12:27Z")
Where to place unicast\_hosts.txt file for cluster setup in ES 6.5? In elasticsearch website (6.5) it is mentioned to put the unicast\_hosts.txt file in below directory: $ES\_PATH\_CONF/discovery-file/unicast\_hosts.txt I … --- ## [Term matching without using keyword in the field name](https://discuss.elastic.co/t/term-matching-without-using-keyword-in-the-field-name/182562)
**Author:** [@Shashank\_reddy](https://discuss.elastic.co/u/Shashank_reddy)\ **Replies:** 0\ **Last updated:** [May 24, 2019, 5:39am UTC](https://discuss.elastic.co/t/term-matching-without-using-keyword-in-the-field-name/182562 "2019-05-24T05:39:05Z")
I am trying to use Elastic Search for both free text search and structured search. In order filter documents during structured search, exact matches are desired and I understand that term matches can achieve this. Howeve… --- ## [Has anyone been successful configuring "free" TLS in 7.1?](https://discuss.elastic.co/t/has-anyone-been-successful-configuring-free-tls-in-7-1/182343)
**Author:** [@mwarren](https://discuss.elastic.co/u/mwarren)\ **Replies:** 8\ **Last updated:** [May 24, 2019, 5:31am UTC](https://discuss.elastic.co/t/has-anyone-been-successful-configuring-free-tls-in-7-1/182343 "2019-05-24T05:31:58Z")
I had xpack security working on a six node cluster using a trial of v6. But now I find the documentation is unclear on how to configure the non xpack security. I used this blog as a guide but it got me no where. Is ther… --- ## [ES - statefulset keeps restarting the pod](https://discuss.elastic.co/t/es-statefulset-keeps-restarting-the-pod/182557)
**Author:** [@Maurya\_M](https://discuss.elastic.co/u/Maurya_M)\ **Replies:** 0\ **Last updated:** [May 24, 2019, 5:09am UTC](https://discuss.elastic.co/t/es-statefulset-keeps-restarting-the-pod/182557 "2019-05-24T05:09:11Z")
Hi, Have tried to match up all my Elastic stack image to version 7.0.1 using the docker image mentioned here : https://www.docker.elastic.co But my Elastic search - statefulset pods keep restarting again (several times… --- ## [Force adding of Dangling Indices via a command](https://discuss.elastic.co/t/force-adding-of-dangling-indices-via-a-command/182554)
**Author:** [@Jeremy\_Chan](https://discuss.elastic.co/u/Jeremy_Chan)\ **Replies:** 0\ **Last updated:** [May 24, 2019, 4:43am UTC](https://discuss.elastic.co/t/force-adding-of-dangling-indices-via-a-command/182554 "2019-05-24T04:43:47Z")
Hi, I am currently using Elasticsearch 6.0 and I want to build a plugin to force the adding of the dangling indices through a rest api instead of adding a new node or waiting for the cluster's state to change. As there… --- ## [Is there any way to get watcher last run time?](https://discuss.elastic.co/t/is-there-any-way-to-get-watcher-last-run-time/182537)
**Author:** [@rugenl](https://discuss.elastic.co/u/rugenl)\ **Replies:** 1\ **Last updated:** [May 24, 2019, 3:53am UTC](https://discuss.elastic.co/t/is-there-any-way-to-get-watcher-last-run-time/182537 "2019-05-24T03:53:56Z")
Is there any to reference a watch last run timestamp? Since the watcher has an interval, I thought I could use something like range gte: "last run", lte now. Thanks --- ## [Es 7.0.0 use ssl can't connect with sql](https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540)
**Author:** [@zqc0512](https://discuss.elastic.co/u/zqc0512)\ **Replies:** 1\ **Last updated:** [May 24, 2019, 3:02am UTC](https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540 "2019-05-24T03:02:45Z")
the error is \[es@xxxx elasticsearch-7\]$ ./bin/elasticsearch-sql-cli https://elastic:Axxxx@xxxxx:19200 WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance. ERROR: Cannot communic… --- ## [More\_like\_this The size of the problem](https://discuss.elastic.co/t/more-like-this-the-size-of-the-problem/182539)
**Author:** [@Zyuxing](https://discuss.elastic.co/u/Zyuxing)\ **Replies:** 0\ **Last updated:** [May 24, 2019, 2:16am UTC](https://discuss.elastic.co/t/more-like-this-the-size-of-the-problem/182539 "2019-05-24T02:16:11Z")
I tried to use more\_like\_thisAPI, and found that there was a big time gap between size=0 and size=10. There was 30 million data, using a mechanical hard disk. I wonder if the step was slow. The matching fields are index… --- ## [ES 7.1 Cross cluster search and TLS](https://discuss.elastic.co/t/es-7-1-cross-cluster-search-and-tls/182484)
**Author:** [@o1o1o11o1](https://discuss.elastic.co/u/o1o1o11o1)\ **Replies:** 1\ **Last updated:** [May 24, 2019, 2:13am UTC](https://discuss.elastic.co/t/es-7-1-cross-cluster-search-and-tls/182484 "2019-05-24T02:13:41Z")
I have two ES 7.1 clusters with TLS enabled and they are working fine as separate clusters. I am trying to configure cross-cluster search between both clusters. The documentation states: Enable a trust relationship bet… --- ## [Only show results that match exactly with the words of the query and order alphabetic them](https://discuss.elastic.co/t/only-show-results-that-match-exactly-with-the-words-of-the-query-and-order-alphabetic-them/182531)
**Author:** [@Itzel](https://discuss.elastic.co/u/Itzel)\ **Replies:** 0\ **Last updated:** [May 23, 2019, 11:32pm UTC](https://discuss.elastic.co/t/only-show-results-that-match-exactly-with-the-words-of-the-query-and-order-alphabetic-them/182531 "2019-05-23T23:32:23Z")
Actually I have been using "Multi-index" to search like this: {"index" : "moviesklic","Type":"vod"} {"query" : {"query\_string":{"fields":\["MediaName^1","Nombre original"\],"query":"el gran p\*"}}, "from" : 0, "size" : 15… --- ## [How to Replace node](https://discuss.elastic.co/t/how-to-replace-node/182074)
**Author:** [@chandukreddi](https://discuss.elastic.co/u/chandukreddi)\ **Replies:** 2\ **Last updated:** [May 23, 2019, 10:30pm UTC](https://discuss.elastic.co/t/how-to-replace-node/182074 "2019-05-23T22:30:05Z")
Hello, How do I replace a node with the same IP? Here is my situation: I was having 2 node cluster node-1 with HOT data(was acting as master before it went down), node-2 with WARM data nodes and because of hardware i… --- ## [How to get documents in Elasticsearch based on aggregation output values?](https://discuss.elastic.co/t/how-to-get-documents-in-elasticsearch-based-on-aggregation-output-values/182109)
**Author:** [@Thomas\_Lee](https://discuss.elastic.co/u/Thomas_Lee)\ **Replies:** 1\ **Last updated:** [May 23, 2019, 10:29pm UTC](https://discuss.elastic.co/t/how-to-get-documents-in-elasticsearch-based-on-aggregation-output-values/182109 "2019-05-23T22:29:08Z")
I'd like to use aggregation outputs as an input to filtering for documents in one query. For example, I'd like to get sales documents in the last 24 hours where sale amount is greater than the average of sale amounts in… --- ## [How to debug Java Thread Park issues between client process and the Elastic Search server?](https://discuss.elastic.co/t/how-to-debug-java-thread-park-issues-between-client-process-and-the-elastic-search-server/182527)
**Author:** [@jm\_1999](https://discuss.elastic.co/u/jm_1999)\ **Replies:** 0\ **Last updated:** [May 23, 2019, 10:24pm UTC](https://discuss.elastic.co/t/how-to-debug-java-thread-park-issues-between-client-process-and-the-elastic-search-server/182527 "2019-05-23T22:24:20Z")
Question: How do I find out - What is causing the thread park on the client side Which Elastic search thread picked up this request and if it is parked there too? Use case: The client is calling the Elastic server fo… --- ## [Securing Port 9200](https://discuss.elastic.co/t/securing-port-9200/182422)
**Author:** [@dawiro](https://discuss.elastic.co/u/dawiro)\ **Replies:** 1\ **Last updated:** [May 23, 2019, 10:24pm UTC](https://discuss.elastic.co/t/securing-port-9200/182422 "2019-05-23T22:24:03Z")
Hi, When upgrading to 6.8.0 is it possible to configure port 9200 to accept both http and https traffic? Or is that the default when enabling ssl? A hard cutover will cause problems with client teams who don't get the … --- ## [Elastic search broke in Bitbucket](https://discuss.elastic.co/t/elastic-search-broke-in-bitbucket/182301)
**Author:** [@vnagana](https://discuss.elastic.co/u/vnagana)\ **Replies:** 1\ **Last updated:** [May 23, 2019, 10:21pm UTC](https://discuss.elastic.co/t/elastic-search-broke-in-bitbucket/182301 "2019-05-23T22:21:38Z")
Hi Team, Elastic search is completely broke in Bitbucket. Getting error that " Search is currently unavailable . Refresh the page and try again" . In Logs: Caused by: org.elasticsearch.ElasticsearchException: Unable … --- ## [\_id length](https://discuss.elastic.co/t/id-length/182245)
**Author:** [@jbalaguero](https://discuss.elastic.co/u/jbalaguero)\ **Replies:** 6\ **Last updated:** [May 23, 2019, 10:13pm UTC](https://discuss.elastic.co/t/id-length/182245 "2019-05-23T22:13:40Z")
We are using ES6.4 to index a cache whose values are xml documents. The key of this cache is generated capturing values from the xml document, so it's easy to get ids longer than 512 bytes. Then when we perform an index… --- ## [Connect to the OSIsoft® PI System® using ELK stack](https://discuss.elastic.co/t/connect-to-the-osisoft-pi-system-using-elk-stack/182385)
**Author:** [@Ikbel\_Benabdessamad](https://discuss.elastic.co/u/Ikbel_Benabdessamad)\ **Replies:** 1\ **Last updated:** [May 23, 2019, 10:02pm UTC](https://discuss.elastic.co/t/connect-to-the-osisoft-pi-system-using-elk-stack/182385 "2019-05-23T22:02:47Z")
While studying the market of Industrial data analytics tools, I got impressed by the services provided by ELK stack and its features (X-pack), but my biggest concern is the establishment of a real-time data streaming con… --- ## [Elasticsearch migrating data](https://discuss.elastic.co/t/elasticsearch-migrating-data/182430)
**Author:** [@saiteja\_c](https://discuss.elastic.co/u/saiteja_c)\ **Replies:** 1\ **Last updated:** [May 23, 2019, 9:54pm UTC](https://discuss.elastic.co/t/elasticsearch-migrating-data/182430 "2019-05-23T21:54:56Z")
I have an existing elasticsearch installation which i'm running off an executable (not as a service). Now, I have decided to run elasticsearch as a service for easier access. After installing elasticsearch as a service… --- ## [Export and import index](https://discuss.elastic.co/t/export-and-import-index/182491)
**Author:** [@aniaks](https://discuss.elastic.co/u/aniaks)\ **Replies:** 9\ **Last updated:** [May 23, 2019, 9:51pm UTC](https://discuss.elastic.co/t/export-and-import-index/182491 "2019-05-23T21:51:23Z")
Is there a way to export index from one cluster and import into another cluster ? --- ## [Enabling security features in an existing cluster with Elasticsearch 6.8](https://discuss.elastic.co/t/enabling-security-features-in-an-existing-cluster-with-elasticsearch-6-8/182075)
**Author:** [@Henrik\_Ossipoff\_Hans](https://discuss.elastic.co/u/Henrik_Ossipoff_Hans)\ **Replies:** 4\ **Last updated:** [May 23, 2019, 9:44pm UTC](https://discuss.elastic.co/t/enabling-security-features-in-an-existing-cluster-with-elasticsearch-6-8/182075 "2019-05-23T21:44:29Z")
With the release of Elasticsearch 6.8 / 7.1 we have some questions on the right approach to enabling the base security features on an existing cluster, which we seem unable to find anywhere. Help appreciated, or someone … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1287) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1289)