# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=123 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 124 --- ## [Elasticsearch does not release lock on node.lock file](https://discuss.elastic.co/t/elasticsearch-does-not-release-lock-on-node-lock-file/357579)
**Author:** [@Prashant\_Rana](https://discuss.elastic.co/u/Prashant_Rana)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 8:16am UTC](https://discuss.elastic.co/t/elasticsearch-does-not-release-lock-on-node-lock-file/357579 "2024-04-17T08:16:02Z")
Sometimes when the machine shutsdown, the Elasticsearch is not releasing the lock on the node.lock file. Even after machine restart, ES is not able to lock the env stating failed to obtain node lock. Similar issue occur… --- ## [Need help with query to aggregate and get data across objects](https://discuss.elastic.co/t/need-help-with-query-to-aggregate-and-get-data-across-objects/357569)
**Author:** [@nser-melwin](https://discuss.elastic.co/u/nser-melwin)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 6:39am UTC](https://discuss.elastic.co/t/need-help-with-query-to-aggregate-and-get-data-across-objects/357569 "2024-04-17T06:39:27Z")
I have data in an index in this format: doc1 doc1 { ports: { "80": 2, "443": 10, "23": 12 } } doc2 { ports: { "80": 32, "44": 6, "22": 1 } } I am trying to query and get an aggregate of data which ca… --- ## [Elastic Watcher](https://discuss.elastic.co/t/elastic-watcher/357520)
**Author:** [@ashish25](https://discuss.elastic.co/u/ashish25)\ **Replies:** 1\ **Last updated:** [April 17, 2024, 5:53am UTC](https://discuss.elastic.co/t/elastic-watcher/357520 "2024-04-17T05:53:20Z")
Hi Team, I created below watcher - PUT \_watcher/watch/transaction\_status\_watch { "trigger": { "schedule": { "interval": "10s" } }, "input": { "search": { "request": { "indices": \["test-transaction"\], "body":… --- ## [Encrypt HTTP client communications for Elasticsearch](https://discuss.elastic.co/t/encrypt-http-client-communications-for-elasticsearch/357561)
**Author:** [@abhinavtyagi](https://discuss.elastic.co/u/abhinavtyagi)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 5:49am UTC](https://discuss.elastic.co/t/encrypt-http-client-communications-for-elasticsearch/357561 "2024-04-17T05:49:55Z")
Look at the image sharing the docs for version 8.13. Now, I am using docker for my application. And the step-1 says to stop Elasticsearch and Kibana if they are running. I used to execute the commands, using docker … --- ## [Query to return only when one of the values greater than x but not when another value is also greater than x](https://discuss.elastic.co/t/query-to-return-only-when-one-of-the-values-greater-than-x-but-not-when-another-value-is-also-greater-than-x/357470)
**Author:** [@axiom](https://discuss.elastic.co/u/axiom)\ **Replies:** 2\ **Last updated:** [April 17, 2024, 2:29am UTC](https://discuss.elastic.co/t/query-to-return-only-when-one-of-the-values-greater-than-x-but-not-when-another-value-is-also-greater-than-x/357470 "2024-04-17T02:29:37Z")
Hi, I'm new to Elastic Search and need some help if this query is possible to be done Value in Table Format: value1 value2 6000 2000 3000 3000 5000 8000 3002 3001 80 3500 only one of the values can … --- ## [Timeout during index refresh](https://discuss.elastic.co/t/timeout-during-index-refresh/357146)
**Author:** [@wnmills3](https://discuss.elastic.co/u/wnmills3)\ **Replies:** 2\ **Last updated:** [April 16, 2024, 11:26pm UTC](https://discuss.elastic.co/t/timeout-during-index-refresh/357146 "2024-04-16T23:26:43Z")
I'm getting a timeout when refreshing an index after a large bulk ingest. I'm using the synchronous client with 8.1.3 Java APIs. It seems the refresh occurs, just waiting for completion times out. It is safe to ignore th… --- ## [Routing allocation shard doesn't work](https://discuss.elastic.co/t/routing-allocation-shard-doesnt-work/357540)
**Author:** [@INS](https://discuss.elastic.co/u/INS)\ **Replies:** 5\ **Last updated:** [April 16, 2024, 9:43pm UTC](https://discuss.elastic.co/t/routing-allocation-shard-doesnt-work/357540 "2024-04-16T21:43:46Z")
Hi I'm struggling the case why even it was enabled the routing rebalance on that index. shards are still placed on one node, how to force automatically rerouting shards on the other nodes? some of the index(with shard… --- ## [Can not query when inserting data](https://discuss.elastic.co/t/can-not-query-when-inserting-data/357532)
**Author:** [@D\_Tu](https://discuss.elastic.co/u/D_Tu)\ **Replies:** 4\ **Last updated:** [April 16, 2024, 6:14pm UTC](https://discuss.elastic.co/t/can-not-query-when-inserting-data/357532 "2024-04-16T18:14:49Z")
I am a newbie to elastic and use spring boots to interact with elastic. I have a scenario as below: inserting a document like A inserting a document like B ( and this action takes 5m to complete) and I also insert oth… --- ## ["term" behave srangely in knn filter?](https://discuss.elastic.co/t/term-behave-srangely-in-knn-filter/357388)
**Author:** [@Yoann\_Buzenet](https://discuss.elastic.co/u/Yoann_Buzenet)\ **Replies:** 5\ **Last updated:** [April 16, 2024, 1:26pm UTC](https://discuss.elastic.co/t/term-behave-srangely-in-knn-filter/357388 "2024-04-16T13:26:17Z")
Hello, My range filters are working perfectly, but when I use a term that doesn't match anything, results are strange. For example, I'm trying to get boardgames by age. I use a range filters that does work. If I use a … --- ## [How can I install multiple admin console to enhance the availability?](https://discuss.elastic.co/t/how-can-i-install-multiple-admin-console-to-enhance-the-availability/357357)
**Author:** [@shorouqamin](https://discuss.elastic.co/u/shorouqamin)\ **Replies:** 5\ **Last updated:** [April 16, 2024, 10:07am UTC](https://discuss.elastic.co/t/how-can-i-install-multiple-admin-console-to-enhance-the-availability/357357 "2024-04-16T10:07:56Z")
we need to enhance prod availability, so we think about installing multiple admin console. Please any suggestion of how to apply this or if there is better way. Thanks --- ## [Any alternative solution to phrase query?](https://discuss.elastic.co/t/any-alternative-solution-to-phrase-query/357502)
**Author:** [@zouxiang1993](https://discuss.elastic.co/u/zouxiang1993)\ **Replies:** 0\ **Last updated:** [April 16, 2024, 9:59am UTC](https://discuss.elastic.co/t/any-alternative-solution-to-phrase-query/357502 "2024-04-16T09:59:22Z")
I use Elasticsearch to store large amount of log data, so I'm particularly concerned abount storage costs. This is a Lucene segment in my ES index: 1.5K \_3ee.fdm 2.4G \_3ee.fdt 172K \_3ee.fdx 3.4K \_3ee.fnm 172M … --- ## [ElasticSearch Watcher http request input is not getting any response](https://discuss.elastic.co/t/elasticsearch-watcher-http-request-input-is-not-getting-any-response/357489)
**Author:** [@JasonREC](https://discuss.elastic.co/u/JasonREC)\ **Replies:** 2\ **Last updated:** [April 16, 2024, 9:39am UTC](https://discuss.elastic.co/t/elasticsearch-watcher-http-request-input-is-not-getting-any-response/357489 "2024-04-16T09:39:54Z")
Hi, I am trying to use elastic watcher to fetch data from my api which hosted in the aws lambda with api gateway setup. Below is my input query but it just returned something which says "Validation Failed: 1: a watch e… --- ## [Elastic search document access based control and vector search](https://discuss.elastic.co/t/elastic-search-document-access-based-control-and-vector-search/357023)
**Author:** [@anuj99](https://discuss.elastic.co/u/anuj99)\ **Replies:** 12\ **Last updated:** [April 16, 2024, 9:33am UTC](https://discuss.elastic.co/t/elastic-search-document-access-based-control-and-vector-search/357023 "2024-04-16T09:33:29Z")
Following is my use case to store data in Elasticsearch for workspace search connecting different data sources. Text from file is chunked and stored in different document used to vector and keyword search chunk. Howeve… --- ## [Datehistogram on DayLightSaving time range produces wrong buckets](https://discuss.elastic.co/t/datehistogram-on-daylightsaving-time-range-produces-wrong-buckets/355902)
**Author:** [@Vishnu\_R](https://discuss.elastic.co/u/Vishnu_R)\ **Replies:** 1\ **Last updated:** [April 16, 2024, 8:49am UTC](https://discuss.elastic.co/t/datehistogram-on-daylightsaving-time-range-produces-wrong-buckets/355902 "2024-04-16T08:49:28Z")
Time Zone: America/Los\_Angeles Search Start Time - 10/03/2024 00:00 Search End Time - 10/03/2024 04:00 Note - On DST clock forwards one hour, after 10/03/2024 1:59 we will have 10/03/2024 3:00. Date histogram interva… --- ## [When do we need dedicated coordinating node?](https://discuss.elastic.co/t/when-do-we-need-dedicated-coordinating-node/357473)
**Author:** [@Dylan\_Juan](https://discuss.elastic.co/u/Dylan_Juan)\ **Replies:** 5\ **Last updated:** [April 16, 2024, 8:21am UTC](https://discuss.elastic.co/t/when-do-we-need-dedicated-coordinating-node/357473 "2024-04-16T08:21:24Z")
Hi everyone, we're currenty facing an issue when we want to deploy our elasticstack deployment. I'm just wondering when do we need dedicated coordinating node, because as i search across elasticsearch documentation ther… --- ## [Upgrade docker elk-stack from 7.14.X to 8.13.2](https://discuss.elastic.co/t/upgrade-docker-elk-stack-from-7-14-x-to-8-13-2/357487)
**Author:** [@Aviel\_Bashari](https://discuss.elastic.co/u/Aviel_Bashari)\ **Replies:** 1\ **Last updated:** [April 16, 2024, 8:18am UTC](https://discuss.elastic.co/t/upgrade-docker-elk-stack-from-7-14-x-to-8-13-2/357487 "2024-04-16T08:18:22Z")
Hi, I installed elk-stack using docker-compose with version 7.14.1 I want to upgrade my stack to 8.13.2. what are the steps that I need to do? is it enough to change the version in my compose file and rebuild the imag… --- ## [Reindex part of a datastream](https://discuss.elastic.co/t/reindex-part-of-a-datastream/357463)
**Author:** [@Russell\_Fulton](https://discuss.elastic.co/u/Russell_Fulton)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 9:19pm UTC](https://discuss.elastic.co/t/reindex-part-of-a-datastream/357463 "2024-04-15T21:19:23Z")
I January I added a field to a datastream. I sent the type to integer as it was a number (but not a count). I recently realised that searches on that field were slow as were visualisation. I then made the mistake of c… --- ## [How to upload watcher in docker elastic search/Kibana?](https://discuss.elastic.co/t/how-to-upload-watcher-in-docker-elastic-search-kibana/357459)
**Author:** [@Ankita\_Mehta](https://discuss.elastic.co/u/Ankita_Mehta)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 8:33pm UTC](https://discuss.elastic.co/t/how-to-upload-watcher-in-docker-elastic-search-kibana/357459 "2024-04-15T20:33:58Z")
I am uploading a custom watcher in Kibana. Now while using DevTools, its is acknowledging the json and everything is working fine: PUT \_watcher/watch/new\_test\_watcher { "trigger": { "schedule": { … --- ## [It is possible to use other stemmers for nonenglish languages?](https://discuss.elastic.co/t/it-is-possible-to-use-other-stemmers-for-nonenglish-languages/357456)
**Author:** [@udl](https://discuss.elastic.co/u/udl)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 8:13pm UTC](https://discuss.elastic.co/t/it-is-possible-to-use-other-stemmers-for-nonenglish-languages/357456 "2024-04-15T20:13:13Z")
Well, I am working in a proyect with Spanish text, summing up, none of the stemmers that I have seen in the documentation for Spanish give me good results (only 2, snowball and the normal one), to give an example. { "… --- ## [How to determine best practice to deploy ES cluster](https://discuss.elastic.co/t/how-to-determine-best-practice-to-deploy-es-cluster/356604)
**Author:** [@Dylan\_Juan](https://discuss.elastic.co/u/Dylan_Juan)\ **Replies:** 2\ **Last updated:** [April 15, 2024, 7:42pm UTC](https://discuss.elastic.co/t/how-to-determine-best-practice-to-deploy-es-cluster/356604 "2024-04-15T19:42:06Z")
Hi everyone we're currently running ES version 7.10. Currently we only has 2 VM for powering this deployment (Master and Data Nodes) and we're seperating our nodes by using different port number on each virtual node. We… --- ## [Incorrect behaviour of fuzzing parameters with completion suggester](https://discuss.elastic.co/t/incorrect-behaviour-of-fuzzing-parameters-with-completion-suggester/357455)
**Author:** [@pigeon\_gcc](https://discuss.elastic.co/u/pigeon_gcc)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 7:23pm UTC](https://discuss.elastic.co/t/incorrect-behaviour-of-fuzzing-parameters-with-completion-suggester/357455 "2024-04-15T19:23:08Z")
I use fuzzing in my quries to completion suggester. It seems like min\_length and fuzziness parameters of the query can't agree between each other. The parameters are described in the docs Example 1: "min\_length": 5, "f… --- ## [2 ESQL requests in one request](https://discuss.elastic.co/t/2-esql-requests-in-one-request/357453)
**Author:** [@Aleksei](https://discuss.elastic.co/u/Aleksei)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 6:52pm UTC](https://discuss.elastic.co/t/2-esql-requests-in-one-request/357453 "2024-04-15T18:52:05Z")
Hi all. Has anyone already dived into ES|QL? I'm interested in how to build two queries in one general query. To then calculate the % ratio based on the results of these queries. For example A/(B+A)\*100 A - is the … --- ## [Scheduler for reconciliation](https://discuss.elastic.co/t/scheduler-for-reconciliation/357451)
**Author:** [@ashish25](https://discuss.elastic.co/u/ashish25)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 6:04pm UTC](https://discuss.elastic.co/t/scheduler-for-reconciliation/357451 "2024-04-15T18:04:59Z")
Hi, I am having 2 indices transaction and event. transaction doc: POST transaction/\_doc/1234 { "status": "Initiate", "payload": "data", "correlationId": "1234" } event doc: POST event/\_doc/1 { "eventStatus": … --- ## [Forcemerge of index with vectors takes long, many hours or forever](https://discuss.elastic.co/t/forcemerge-of-index-with-vectors-takes-long-many-hours-or-forever/356818)
**Author:** [@Yolga.Ai](https://discuss.elastic.co/u/Yolga.Ai)\ **Replies:** 2\ **Last updated:** [April 15, 2024, 4:05pm UTC](https://discuss.elastic.co/t/forcemerge-of-index-with-vectors-takes-long-many-hours-or-forever/356818 "2024-04-15T16:05:42Z")
I have two big problems where we try to index \>100mln ob documents with vector field: big problems with forcemerge in indices with dense\_vector field inside it. Sometimes it takes to forcmerge from 15-20 segments to 5 … --- ## [Unable to install Elastic-search on SLES12 SP5 linux server](https://discuss.elastic.co/t/unable-to-install-elastic-search-on-sles12-sp5-linux-server/357444)
**Author:** [@sjothili](https://discuss.elastic.co/u/sjothili)\ **Replies:** 0\ **Last updated:** [April 15, 2024, 2:48pm UTC](https://discuss.elastic.co/t/unable-to-install-elastic-search-on-sles12-sp5-linux-server/357444 "2024-04-15T14:48:16Z")
Hi, I am trying to install Elastic search service on SLES12 SP5 server using zypper. I am following this link to create repo and run the 'zypper' cmd to install the elasticsearch service. But the installation fails as i… --- ## [Does anyone know if the doc \_id field has to follow a standard or pattern?](https://discuss.elastic.co/t/does-anyone-know-if-the-doc-id-field-has-to-follow-a-standard-or-pattern/357178)
**Author:** [@Diego\_Sanchez](https://discuss.elastic.co/u/Diego_Sanchez)\ **Replies:** 1\ **Last updated:** [April 15, 2024, 1:56pm UTC](https://discuss.elastic.co/t/does-anyone-know-if-the-doc-id-field-has-to-follow-a-standard-or-pattern/357178 "2024-04-15T13:56:00Z")
We have a system that uses the path of the URL as doc ID. Everything ran ok until this week when we received a couple of bad requests and transportation errors coming from URLs like this one ../../../example or .. We use… --- ## [Nested Vector Search -\> Retrieve k chunks](https://discuss.elastic.co/t/nested-vector-search-retrieve-k-chunks/357311)
**Author:** [@anuj99](https://discuss.elastic.co/u/anuj99)\ **Replies:** 1\ **Last updated:** [April 15, 2024, 1:52pm UTC](https://discuss.elastic.co/t/nested-vector-search-retrieve-k-chunks/357311 "2024-04-15T13:52:14Z")
Following is my use case to store data in Elasticsearch for workspace search connecting different data sources. Text from file is chunked and stored in different document used to vector and keyword search chunk. Howeve… --- ## [How can I save this aggregated results under a new index](https://discuss.elastic.co/t/how-can-i-save-this-aggregated-results-under-a-new-index/357299)
**Author:** [@Jingyi\_Wang](https://discuss.elastic.co/u/Jingyi_Wang)\ **Replies:** 6\ **Last updated:** [April 15, 2024, 1:36pm UTC](https://discuss.elastic.co/t/how-can-i-save-this-aggregated-results-under-a-new-index/357299 "2024-04-15T13:36:32Z")
I run the aggregation script in elastic dev tool: GET copper\_scan\_username\_index,fibre\_scan\_username\_index/\_search { "size": 0, "aggs": { "unique\_username": { "terms": { "field": "username", … --- ## [Get Cluster Indexing Rate/Second via Rest API](https://discuss.elastic.co/t/get-cluster-indexing-rate-second-via-rest-api/357296)
**Author:** [@jscheitel](https://discuss.elastic.co/u/jscheitel)\ **Replies:** 1\ **Last updated:** [April 15, 2024, 1:23pm UTC](https://discuss.elastic.co/t/get-cluster-indexing-rate-second-via-rest-api/357296 "2024-04-15T13:23:49Z")
Hello - we have cluster monitoring enabled, and can see the Search and Indexing Rates and Latencies graphs on the Cluster Overview page. We need to query some indication of indexing rate or ingestion rate for display in… --- ## [Search docs not return 0 hits](https://discuss.elastic.co/t/search-docs-not-return-0-hits/357309)
**Author:** [@JPXotox](https://discuss.elastic.co/u/JPXotox)\ **Replies:** 9\ **Last updated:** [April 15, 2024, 1:23pm UTC](https://discuss.elastic.co/t/search-docs-not-return-0-hits/357309 "2024-04-15T13:23:09Z")
Hi, I´m trying to search some docs, in Kibana using discover i have 2 hits with the following timestamp: @timestamp Apr 3, 2024 @ 03:27:23.000 and Apr 3, 2024 @ 03:26:56.000 for a doc with a field "sender": "TEED-NEC45… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=122) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=124)