# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1815 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1816 --- ## [X-Pack attempts to load ca-bundle.crt and ca-bundle.trust.crt despite not being configured to do so](https://discuss.elastic.co/t/x-pack-attempts-to-load-ca-bundle-crt-and-ca-bundle-trust-crt-despite-not-being-configured-to-do-so/116939)
**Author:** [@Michael\_Ihde](https://discuss.elastic.co/u/Michael_Ihde)\ **Replies:** 2\ **Last updated:** [January 25, 2018, 3:07pm UTC](https://discuss.elastic.co/t/x-pack-attempts-to-load-ca-bundle-crt-and-ca-bundle-trust-crt-despite-not-being-configured-to-do-so/116939 "2018-01-25T15:07:08Z")
I'm using ElasticSearch 5.5.2 within Docker (from the official images) and trying to setup the SSL configuration. I've set: xpack.ssl.key=/usr/share/elasticsearch/config/tls/private/server.key xpack.ssl.certificate… --- ## [Watcher migration Invalid Address Error](https://discuss.elastic.co/t/watcher-migration-invalid-address-error/116716)
**Author:** [@AbdulH](https://discuss.elastic.co/u/AbdulH)\ **Replies:** 13\ **Last updated:** [January 25, 2018, 2:00pm UTC](https://discuss.elastic.co/t/watcher-migration-invalid-address-error/116716 "2018-01-25T14:00:50Z")
I have managed to configure a one node cluster to send out email alerts, with the same configuration on a three node cluster I get the following error: "type": "messaging\_exception", "reason": "failed to send email with… --- ## [\_script index](https://discuss.elastic.co/t/script-index/117050)
**Author:** [@Steve\_Stevens](https://discuss.elastic.co/u/Steve_Stevens)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 2:00pm UTC](https://discuss.elastic.co/t/script-index/117050 "2018-01-25T14:00:20Z")
I can POST to /\_scripts/{name} and I can GET /\_scripts/{name}, but I can't seem to find an API to listing all stored scripts, or searching for them. Is there one? --- ## [Elastic search depreciated classes](https://discuss.elastic.co/t/elastic-search-depreciated-classes/116232)
**Author:** [@Master](https://discuss.elastic.co/u/Master)\ **Replies:** 18\ **Last updated:** [January 25, 2018, 1:01pm UTC](https://discuss.elastic.co/t/elastic-search-depreciated-classes/116232 "2018-01-25T13:01:14Z")
i want to migrate elastic search from 2.x to 6.x. In this process created new indexed and loaded data from DB to ES 6.x but in service layer(java) facing some issue like below orQueryBuilder.add(QueryBuilders.termQuery… --- ## [Elastic Seach - NEST - filter top N documents by score and then sort by field](https://discuss.elastic.co/t/elastic-seach-nest-filter-top-n-documents-by-score-and-then-sort-by-field/117045)
**Author:** [@flavioguterres](https://discuss.elastic.co/u/flavioguterres)\ **Replies:** 0\ **Last updated:** [January 25, 2018, 12:53pm UTC](https://discuss.elastic.co/t/elastic-seach-nest-filter-top-n-documents-by-score-and-then-sort-by-field/117045 "2018-01-25T12:53:37Z")
I'm using Elastic Search with Nest 5.6, I would like to filter only 100 documents with the highest Score and then sort by any other field. The problem is that sorting is done together between the score and the field, but… --- ## [Very fast search, but cache doesnt exist \[Elastic 5.5\]](https://discuss.elastic.co/t/very-fast-search-but-cache-doesnt-exist-elastic-5-5/116909)
**Author:** [@KGarcia](https://discuss.elastic.co/u/KGarcia)\ **Replies:** 2\ **Last updated:** [January 25, 2018, 11:39am UTC](https://discuss.elastic.co/t/very-fast-search-but-cache-doesnt-exist-elastic-5-5/116909 "2018-01-25T11:39:45Z")
Hello Elastic community. We have a small cluster and we would like to known if the time for a search query, without the cache, is correct. You see, we have 1TB, more than 100 Million documents, and the first search take… --- ## [RAM Usage](https://discuss.elastic.co/t/ram-usage/116972)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 5\ **Last updated:** [January 25, 2018, 11:28am UTC](https://discuss.elastic.co/t/ram-usage/116972 "2018-01-25T11:28:48Z")
Hi Is there any command or way to know about the total RAM usage by elastic client? Thanks Aneesh --- ## [ElasticSearch(Java) - searching with the help of location(GeoPoint](https://discuss.elastic.co/t/elasticsearch-java-searching-with-the-help-of-location-geopoint/116866)
**Author:** [@Nikita\_Krasnov](https://discuss.elastic.co/u/Nikita_Krasnov)\ **Replies:** 12\ **Last updated:** [January 25, 2018, 11:20am UTC](https://discuss.elastic.co/t/elasticsearch-java-searching-with-the-help-of-location-geopoint/116866 "2018-01-25T11:20:45Z")
Hello to everyone. I try to search by geoShapeQuery: @PostMapping("/findLogsByValues") @Transactional public ResponseEntity findLogsByValues(@RequestBody ElasticSearchLogRequest esLogRequest) { if (esLogReques… --- ## [Deleted documents in Elastic Search for Magento](https://discuss.elastic.co/t/deleted-documents-in-elastic-search-for-magento/117030)
**Author:** [@SC123456](https://discuss.elastic.co/u/SC123456)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 11:19am UTC](https://discuss.elastic.co/t/deleted-documents-in-elastic-search-for-magento/117030 "2018-01-25T11:19:13Z")
I'm using Elastic Search with Magento 2.1.7 and frequently I encounter missing (deleted) documents after the index is completed; has anyone encountered this before ? --- ## [Cluster for elasticsearch](https://discuss.elastic.co/t/cluster-for-elasticsearch/116968)
**Author:** [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Replies:** 3\ **Last updated:** [January 25, 2018, 10:03am UTC](https://discuss.elastic.co/t/cluster-for-elasticsearch/116968 "2018-01-25T10:03:21Z")
Hello , I have more than 100 servers than how to create cluster for elasticsearch and how to define the no of mater nodes and data nodes and client nodes . can anyone tell me difference between all the three? a help wo… --- ## [Listing all backup in ES and ultimately restoring from snapshot](https://discuss.elastic.co/t/listing-all-backup-in-es-and-ultimately-restoring-from-snapshot/116983)
**Author:** [@joker](https://discuss.elastic.co/u/joker)\ **Replies:** 3\ **Last updated:** [January 25, 2018, 9:38am UTC](https://discuss.elastic.co/t/listing-all-backup-in-es-and-ultimately-restoring-from-snapshot/116983 "2018-01-25T09:38:03Z")
How to list all backup names in ES ? I am new to this and couldn't find a command after googling and all. ALERT(little long) : I am an Intern in a company and this guy who setup all ES stuff left, and now it's my work t… --- ## [Why delete document by id not support index wildcard](https://discuss.elastic.co/t/why-delete-document-by-id-not-support-index-wildcard/117010)
**Author:** [@Zt\_Zeng](https://discuss.elastic.co/u/Zt_Zeng)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 9:31am UTC](https://discuss.elastic.co/t/why-delete-document-by-id-not-support-index-wildcard/117010 "2018-01-25T09:31:51Z")
Recently, I found that the delete document by id have to through delete by query. POST /blog-\*/messages/\_delete\_by\_query?pretty { "query": { "match": { "\_id": "N1H$K4Xtsra" } } } Is there any plan to … --- ## [Merging of indices](https://discuss.elastic.co/t/merging-of-indices/116958)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 9:24am UTC](https://discuss.elastic.co/t/merging-of-indices/116958 "2018-01-25T09:24:24Z")
Hi Student ======= { "StudentId":1, "StudentName":"abc" } Subject ======= { "SubjectId":101, "SubjectName":"English" }, { "SubjectId":102, "SubjectName":"Science" } SubjectAssigned =============== { "SubjectId… --- ## [Merge data fer two indices with foreign key](https://discuss.elastic.co/t/merge-data-fer-two-indices-with-foreign-key/116863)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 3\ **Last updated:** [January 25, 2018, 9:23am UTC](https://discuss.elastic.co/t/merge-data-fer-two-indices-with-foreign-key/116863 "2018-01-25T09:23:18Z")
Hi, Can I get the merged data from two different indices? For example: Index1 : Name, Id , Type Index2: Type, TypeData1 Type, TypeData2 I want data to be returned in single query like Name,Id,Type:\[TypeData1,TypeDat… --- ## [Elastic Search Developer from Prague wanted](https://discuss.elastic.co/t/elastic-search-developer-from-prague-wanted/116889)
**Author:** [@RichardSouta](https://discuss.elastic.co/u/RichardSouta)\ **Replies:** 0\ **Last updated:** [January 24, 2018, 3:55pm UTC](https://discuss.elastic.co/t/elastic-search-developer-from-prague-wanted/116889 "2018-01-24T15:55:30Z")
Hi, is there any Elastic Search Developer from Prague? I would like to cooperate with you on big SW project. --- ## [Max number of records in an Index](https://discuss.elastic.co/t/max-number-of-records-in-an-index/116984)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 9:12am UTC](https://discuss.elastic.co/t/max-number-of-records-in-an-index/116984 "2018-01-25T09:12:55Z")
Hi Is there any max limit of records(rows) in an index? Crores of data rows can I add to an index? Thanks Aneesh --- ## [Number of Shards increase/decrease](https://discuss.elastic.co/t/number-of-shards-increase-decrease/116986)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 9:09am UTC](https://discuss.elastic.co/t/number-of-shards-increase-decrease/116986 "2018-01-25T09:09:47Z")
Hi What will be causes with increase/decrease of number of shards? Thanks Aneesh --- ## [Creating snapshot for a particular period. ( ex: 1-1-2017 to 31-12-2017)](https://discuss.elastic.co/t/creating-snapshot-for-a-particular-period-ex-1-1-2017-to-31-12-2017/116837)
**Author:** [@sanjayap\_sanju](https://discuss.elastic.co/u/sanjayap_sanju)\ **Replies:** 3\ **Last updated:** [January 25, 2018, 9:08am UTC](https://discuss.elastic.co/t/creating-snapshot-for-a-particular-period-ex-1-1-2017-to-31-12-2017/116837 "2018-01-25T09:08:23Z")
Hi i am new to elasticsearch, was working on snapshot and restore of index. I was able to successfully take a snapshot and restore the entire index using the below query PUT \_snapshot/testindex\_backup/16jan18 { "indi… --- ## [EsRejectedExecutionException when just refresh kibana](https://discuss.elastic.co/t/esrejectedexecutionexception-when-just-refresh-kibana/116166)
**Author:** [@Zt\_Zeng](https://discuss.elastic.co/u/Zt_Zeng)\ **Replies:** 5\ **Last updated:** [January 25, 2018, 9:05am UTC](https://discuss.elastic.co/t/esrejectedexecutionexception-when-just-refresh-kibana/116166 "2018-01-25T09:05:22Z")
Recently the Kibana fail to show any content. It just show empty or give us the error. Check the log of Elasticsearch, we found the very long EsRejectedExecutionException for search queue: rejected execution of org.elas… --- ## [How to aggregate on the same field:value which are specified in query in elasticsearch](https://discuss.elastic.co/t/how-to-aggregate-on-the-same-field-value-which-are-specified-in-query-in-elasticsearch/117007)
**Author:** [@glady](https://discuss.elastic.co/u/glady)\ **Replies:** 0\ **Last updated:** [January 25, 2018, 9:01am UTC](https://discuss.elastic.co/t/how-to-aggregate-on-the-same-field-value-which-are-specified-in-query-in-elasticsearch/117007 "2018-01-25T09:01:36Z")
So my data in elasticsearch looks like this one whole dict with one person id is equal to one doc and it contains list of objects like {"dummy\_name": "abc","dummy\_id": "44850642"}which is shown below ,the thing is I am q… --- ## [6.x.x can't run on HTTP POST](https://discuss.elastic.co/t/6-x-x-cant-run-on-http-post/116956)
**Author:** [@f26227279](https://discuss.elastic.co/u/f26227279)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 8:34am UTC](https://discuss.elastic.co/t/6-x-x-cant-run-on-http-post/116956 "2018-01-25T08:34:42Z")
I installed 6.1.1 version Elasticsearch, and when I want to POST from ES I found it can't run and show me the pass format is wrong,but if I degrade the version to 5.x.x then it can return ES data successfully. how is it… --- ## [Reindexing in Kibana or other ELK stack product](https://discuss.elastic.co/t/reindexing-in-kibana-or-other-elk-stack-product/116477)
**Author:** [@Fatalityap](https://discuss.elastic.co/u/Fatalityap)\ **Replies:** 6\ **Last updated:** [January 25, 2018, 8:12am UTC](https://discuss.elastic.co/t/reindexing-in-kibana-or-other-elk-stack-product/116477 "2018-01-25T08:12:51Z")
Hi. I know that there is Reindex ( https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-reindex.html ) feature in Elasticsearch and for zero downtime Elasticsearch team recommends to use index alias. But… --- ## [Grouping Term Sub Aggregation](https://discuss.elastic.co/t/grouping-term-sub-aggregation/116744)
**Author:** [@premier](https://discuss.elastic.co/u/premier)\ **Replies:** 3\ **Last updated:** [January 25, 2018, 6:21am UTC](https://discuss.elastic.co/t/grouping-term-sub-aggregation/116744 "2018-01-25T06:21:01Z")
I'm trying to group term aggregations. My \_search payload: { "size": 25, "query": { "bool": { "must": \[ { "query\_string": { "query": "\*" } }, { … --- ## [Memory in dat folder](https://discuss.elastic.co/t/memory-in-dat-folder/116864)
**Author:** [@aneesh](https://discuss.elastic.co/u/aneesh)\ **Replies:** 2\ **Last updated:** [January 25, 2018, 6:11am UTC](https://discuss.elastic.co/t/memory-in-dat-folder/116864 "2018-01-25T06:11:43Z")
Hi If I have data of 1GB and added to an index, How much memory it will take in Elastic search data folder. Thanks Aneesh --- ## [Forced awareness + replica count](https://discuss.elastic.co/t/forced-awareness-replica-count/115351)
**Author:** [@priteshkp](https://discuss.elastic.co/u/priteshkp)\ **Replies:** 2\ **Last updated:** [January 25, 2018, 6:04am UTC](https://discuss.elastic.co/t/forced-awareness-replica-count/115351 "2018-01-25T06:04:06Z")
Using ES 6.1.0. I'm trying to understand what might be happening (either I'm doing something wrong or I'm misreading the documentation). I have a cluster where I have 2 physical machines. On each physical machine I la… --- ## [Sum two int variable in REST](https://discuss.elastic.co/t/sum-two-int-variable-in-rest/116967)
**Author:** [@f26227279](https://discuss.elastic.co/u/f26227279)\ **Replies:** 0\ **Last updated:** [January 25, 2018, 5:08am UTC](https://discuss.elastic.co/t/sum-two-int-variable-in-rest/116967 "2018-01-25T05:08:04Z")
Hi everyone, I want to sum two integer variable in REST API such like below: "aggs": { "download1" : { "filter" : { "term": { "IPV4\_DST\_ADDR":"120.127.160.91"} }, "aggs" : { … --- ## [Kernel Update on Ubuntu 17.10 causes Elasticsearch to panic](https://discuss.elastic.co/t/kernel-update-on-ubuntu-17-10-causes-elasticsearch-to-panic/116865)
**Author:** [@Dominik\_Stadler](https://discuss.elastic.co/u/Dominik_Stadler)\ **Replies:** 6\ **Last updated:** [January 25, 2018, 3:24am UTC](https://discuss.elastic.co/t/kernel-update-on-ubuntu-17-10-causes-elasticsearch-to-panic/116865 "2018-01-25T03:24:30Z")
Hi, anybody else seeing this? When we run Elasticsearch 5.3.3 on Ubuntu 17.10 after the most recent kernel update from 4.13.0-25-generic to 4.13.0-31-generic we see kernel oopses, any remedy except downgrading the kerne… --- ## [Rollover information for alias](https://discuss.elastic.co/t/rollover-information-for-alias/116778)
**Author:** [@Karthik\_Ramachandran](https://discuss.elastic.co/u/Karthik_Ramachandran)\ **Replies:** 1\ **Last updated:** [January 25, 2018, 2:09am UTC](https://discuss.elastic.co/t/rollover-information-for-alias/116778 "2018-01-25T02:09:49Z")
Hi All, Once rollover is set against a alias, how do I see what is set? Should I have to refer to the codebase always? Is there any API that can tell me what rollover strategy is applied to an alias. Regards Karrthik … --- ## [Es 6.x not support multi types in index, but elasticsearch-hadoop docs not update](https://discuss.elastic.co/t/es-6-x-not-support-multi-types-in-index-but-elasticsearch-hadoop-docs-not-update/116842)
**Author:** [@oldcodeoberyn](https://discuss.elastic.co/u/oldcodeoberyn)\ **Replies:** 3\ **Last updated:** [January 25, 2018, 12:58am UTC](https://discuss.elastic.co/t/es-6-x-not-support-multi-types-in-index-but-elasticsearch-hadoop-docs-not-update/116842 "2018-01-25T00:58:46Z")
in this guide: https://www.elastic.co/guide/en/elasticsearch/hadoop/current/spark.html it recommend user to use es 6.x version which not support multi type, but still guide user to set multi-type in one index val game… --- ## [Using a different date range format than what is defined on Elasticsearch cluster](https://discuss.elastic.co/t/using-a-different-date-range-format-than-what-is-defined-on-elasticsearch-cluster/116905)
**Author:** [@elasticdude](https://discuss.elastic.co/u/elasticdude)\ **Replies:** 0\ **Last updated:** [January 24, 2018, 5:22pm UTC](https://discuss.elastic.co/t/using-a-different-date-range-format-than-what-is-defined-on-elasticsearch-cluster/116905 "2018-01-24T17:22:30Z")
I came across the post in which it is mentioned that reducing the time range matching to seconds precision would result in improvement in query latency. In my table date format is "yyyy-mm-dd hh:mm:ss.NNN". When I'm tr… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1814) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1816)