# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1250 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1251 --- ## [Magento 2 reindexing output message](https://discuss.elastic.co/t/magento-2-reindexing-output-message/187404)
**Author:** [@scoops87](https://discuss.elastic.co/u/scoops87)\ **Replies:** 3\ **Last updated:** [June 26, 2019, 8:52am UTC](https://discuss.elastic.co/t/magento-2-reindexing-output-message/187404 "2019-06-26T08:52:39Z")
Hello, We have elastic Search for magento 2.2.2 and on reindexing using SSH we get this output: Catalog Search indexer process unknown error: {"error":{"root\_cause":\[{"type":"mapper\_parsing\_exception","reason":"No han… --- ## [PUT vs POST when adding documents in elastic search](https://discuss.elastic.co/t/put-vs-post-when-adding-documents-in-elastic-search/187486)
**Author:** [@Vishwajeet\_singh](https://discuss.elastic.co/u/Vishwajeet_singh)\ **Replies:** 3\ **Last updated:** [June 26, 2019, 8:51am UTC](https://discuss.elastic.co/t/put-vs-post-when-adding-documents-in-elastic-search/187486 "2019-06-26T08:51:44Z")
Hi, I am new to Elasticsearch and trying to add documents in elastic index. I have got confused between PUT and POST here as both are producing same results in below scenario: curl -H "Content-Type: application/json" … --- ## [Elasticsearch 7.0 SQL ACCESS request cache](https://discuss.elastic.co/t/elasticsearch-7-0-sql-access-request-cache/186467)
**Author:** [@c81b4c93b1f70af5398f](https://discuss.elastic.co/u/c81b4c93b1f70af5398f)\ **Replies:** 11\ **Last updated:** [June 26, 2019, 8:31am UTC](https://discuss.elastic.co/t/elasticsearch-7-0-sql-access-request-cache/186467 "2019-06-26T08:31:31Z")
Looks like SQL query is not cached, and equivalent dsl qeury is cached. Every single time this SQL query is executed, it takes over 3 seconds. (The number of documents is about 6,000,000) POST /\_sql?format=json … --- ## [Elasticsearch security related question](https://discuss.elastic.co/t/elasticsearch-security-related-question/187451)
**Author:** [@zozo6015](https://discuss.elastic.co/u/zozo6015)\ **Replies:** 4\ **Last updated:** [June 26, 2019, 8:27am UTC](https://discuss.elastic.co/t/elasticsearch-security-related-question/187451 "2019-06-26T08:27:49Z")
Hello, I am wondering if after enabling xpack security feature and generating the passwords can I start using the feature with those usernames/passwords without having to create any other users. Regards, --- ## [Delete the first 10000 document in an index](https://discuss.elastic.co/t/delete-the-first-10000-document-in-an-index/187368)
**Author:** [@Szilveszter](https://discuss.elastic.co/u/Szilveszter)\ **Replies:** 3\ **Last updated:** [June 26, 2019, 8:26am UTC](https://discuss.elastic.co/t/delete-the-first-10000-document-in-an-index/187368 "2019-06-26T08:26:46Z")
Hi, I have an annoying issue. I have to write a script, witch can do some logrotation. I have permission only for this script, I can not configure ES. The ES has a daily index. The version of ES is 7.1.1. The idea is … --- ## [Elasticsearch cause linux kernel crash](https://discuss.elastic.co/t/elasticsearch-cause-linux-kernel-crash/187461)
**Author:** [@john\_am](https://discuss.elastic.co/u/john_am)\ **Replies:** 8\ **Last updated:** [June 26, 2019, 8:09am UTC](https://discuss.elastic.co/t/elasticsearch-cause-linux-kernel-crash/187461 "2019-06-26T08:09:18Z")
Hi,guys, thanks for your reading my poor english. I got a situation that elasticsearch cause my linux kernel crash.However, what information i got from logs(linux messsage log) is Garbled. What's worse i found nothing … --- ## [Problem with jvm.options after update to 7.2](https://discuss.elastic.co/t/problem-with-jvm-options-after-update-to-7-2/187513)
**Author:** [@NashSLX](https://discuss.elastic.co/u/NashSLX)\ **Replies:** 0\ **Last updated:** [June 26, 2019, 8:02am UTC](https://discuss.elastic.co/t/problem-with-jvm-options-after-update-to-7-2/187513 "2019-06-26T08:02:02Z")
I updated to 7.2 with the windows installer today, and I've been getting an issue getting the JVM to even start after that. Our Elastic Search Nodes run on Windows Server 2016 Dataservers, and are using java version 12. … --- ## [Should i create daily index or weekly?](https://discuss.elastic.co/t/should-i-create-daily-index-or-weekly/187499)
**Author:** [@Jeetu19](https://discuss.elastic.co/u/Jeetu19)\ **Replies:** 1\ **Last updated:** [June 26, 2019, 7:32am UTC](https://discuss.elastic.co/t/should-i-create-daily-index-or-weekly/187499 "2019-06-26T07:32:40Z")
I have three node cluster(1 master node and two data node). currently i am creating weekly index with 3 shards and 1 replica.and size of weekly index is around 40-50 gb. and its working fine for us. but now we have anot… --- ## [Type: mapper\_parsing\_exception Reason: "failed to parse field \[GeoCode\] of type \[geo\_point\]" CausedBy: Type: illegal\_argument\_exception Reason: "illegal latitude value \[-100.491065\] for GeoCode](https://discuss.elastic.co/t/type-mapper-parsing-exception-reason-failed-to-parse-field-geocode-of-type-geo-point-causedby-type-illegal-argument-exception-reason-illegal-latitude-value-100-491065-for-geocode/187488)
**Author:** [@SudevPK](https://discuss.elastic.co/u/SudevPK)\ **Replies:** 2\ **Last updated:** [June 26, 2019, 7:26am UTC](https://discuss.elastic.co/t/type-mapper-parsing-exception-reason-failed-to-parse-field-geocode-of-type-geo-point-causedby-type-illegal-argument-exception-reason-illegal-latitude-value-100-491065-for-geocode/187488 "2019-06-26T07:26:40Z")
errors Invalid NEST response built from a successful low level call on POST: /\_bulk # Invalid Bulk items: operation\[509\]: update returned 400 \_index: property \_type: \_doc \_id: 6313260 \_version: 0 error: Type: mapper\_pa… --- ## [Search for an address](https://discuss.elastic.co/t/search-for-an-address/186720)
**Author:** [@rori1](https://discuss.elastic.co/u/rori1)\ **Replies:** 2\ **Last updated:** [June 26, 2019, 7:10am UTC](https://discuss.elastic.co/t/search-for-an-address/186720 "2019-06-26T07:10:22Z")
Hello, I have an address in a nested object where number, road name, postal code and city are each in a specific field. What is the best way to make search request from query like " 4 Brooklyn Rd Bromley" ? Thanks fo… --- ## [Bulk processor: Cannot find bulk threads while profiling](https://discuss.elastic.co/t/bulk-processor-cannot-find-bulk-threads-while-profiling/186188)
**Author:** [@pokaleshrey](https://discuss.elastic.co/u/pokaleshrey)\ **Replies:** 8\ **Last updated:** [June 26, 2019, 6:52am UTC](https://discuss.elastic.co/t/bulk-processor-cannot-find-bulk-threads-while-profiling/186188 "2019-06-26T06:52:33Z")
We are using BulkProcessor for indexing data. We have set the ConcurrentRequest parameter to 5. I am profiling my application and expect that i could see 5 bulk request threads in the live thread monitoring. But i cann… --- ## [ES with one node](https://discuss.elastic.co/t/es-with-one-node/187356)
**Author:** [@tandreja](https://discuss.elastic.co/u/tandreja)\ **Replies:** 2\ **Last updated:** [June 26, 2019, 6:35am UTC](https://discuss.elastic.co/t/es-with-one-node/187356 "2019-06-26T06:35:42Z")
Hello I'm in a situation with only one node on a big machine (2 CPU 12 core HT, 256 Go RAM, 40 To disk). With this, the CPUs are only used at 800% ( 8 vCPU) and I do not have great performances (2000 EPS). What can I … --- ## [Are allowed private SaaS and private package redistribution by the Elastic License?](https://discuss.elastic.co/t/are-allowed-private-saas-and-private-package-redistribution-by-the-elastic-license/187269)
**Author:** [@LeMic](https://discuss.elastic.co/u/LeMic)\ **Replies:** 2\ **Last updated:** [June 26, 2019, 6:17am UTC](https://discuss.elastic.co/t/are-allowed-private-saas-and-private-package-redistribution-by-the-elastic-license/187269 "2019-06-26T06:17:05Z")
Hi, We would like to offer an internal service (log analysis, metrics and APM) using the Elastic Stack and propose this service across multiple teams by providing a centralized shared installation on the one hand and a … --- ## [Error "type": "query\_shard\_exception" while running below query in dev tools](https://discuss.elastic.co/t/error-type-query-shard-exception-while-running-below-query-in-dev-tools/186666)
**Author:** [@pyerunka](https://discuss.elastic.co/u/pyerunka)\ **Replies:** 11\ **Last updated:** [June 26, 2019, 6:08am UTC](https://discuss.elastic.co/t/error-type-query-shard-exception-while-running-below-query-in-dev-tools/186666 "2019-06-26T06:08:00Z")
Hello, I am running below query: GET new\_master\_query/\_search { "query": { "multi\_match": { "query": "Geosolutions", "fields": \[ "contentid^4", "title^3","object\_summary^2","submitted\_for\_name"\] } } } and … --- ## [Template not working](https://discuss.elastic.co/t/template-not-working/187414)
**Author:** [@Mohit\_Ruke](https://discuss.elastic.co/u/Mohit_Ruke)\ **Replies:** 1\ **Last updated:** [June 26, 2019, 5:04am UTC](https://discuss.elastic.co/t/template-not-working/187414 "2019-06-26T05:04:40Z")
Hi Everyone , I have created a template for my indices with the intention that all indexes that fall under the index pattern will have same mapping. This is my template { "sqe\_template1": { "order": 0, "index\_patt… --- ## [How to disable security filter config when debug the source code?](https://discuss.elastic.co/t/how-to-disable-security-filter-config-when-debug-the-source-code/187469)
**Author:** [@Albert-Hugo](https://discuss.elastic.co/u/Albert-Hugo)\ **Replies:** 0\ **Last updated:** [June 26, 2019, 4:10am UTC](https://discuss.elastic.co/t/how-to-disable-security-filter-config-when-debug-the-source-code/187469 "2019-06-26T04:10:00Z")
Please help, I want to debug the source code,but do not know how to disable security filter config ? --- ## [Elasticsearch ILM stuck at forcemerge](https://discuss.elastic.co/t/elasticsearch-ilm-stuck-at-forcemerge/184506)
**Author:** [@NerdSec](https://discuss.elastic.co/u/NerdSec)\ **Replies:** 15\ **Last updated:** [June 26, 2019, 4:00am UTC](https://discuss.elastic.co/t/elasticsearch-ilm-stuck-at-forcemerge/184506 "2019-06-26T04:00:11Z")
Hi, I currently have an ILM policy that does the following: As mentioned here, after shrink I end up having a shard size of 40GB. I have then configured ILM to delete the indices after 7 days. However, the ILM pol… --- ## [How to download a old version of es?](https://discuss.elastic.co/t/how-to-download-a-old-version-of-es/187466)
**Author:** [@9527q](https://discuss.elastic.co/u/9527q)\ **Replies:** 4\ **Last updated:** [June 26, 2019, 3:53am UTC](https://discuss.elastic.co/t/how-to-download-a-old-version-of-es/187466 "2019-06-26T03:53:35Z")
I want to download a es6.7, but I can't find the download-url. There is only a lasted version (7.2) of es. Of course I also want to know the method to find the all verision of every plugin. I'm from China and my English… --- ## [Shard count does not match active mapping](https://discuss.elastic.co/t/shard-count-does-not-match-active-mapping/187411)
**Author:** [@o1o1o11o1](https://discuss.elastic.co/u/o1o1o11o1)\ **Replies:** 7\ **Last updated:** [June 26, 2019, 1:54am UTC](https://discuss.elastic.co/t/shard-count-does-not-match-active-mapping/187411 "2019-06-26T01:54:16Z")
I have 4 Elasticsearch 7.1 clusters using the same mapping template, that I can verify being in use: localhost:9200/\_template/mytemplate ... "settings": { "index": { ... "number\_of\_shards": "40", "ref… --- ## [CloudFront Logs into ES - Index Mapping Query with Updating to 7.1?](https://discuss.elastic.co/t/cloudfront-logs-into-es-index-mapping-query-with-updating-to-7-1/187446)
**Author:** [@ninjada](https://discuss.elastic.co/u/ninjada)\ **Replies:** 0\ **Last updated:** [June 26, 2019, 12:28am UTC](https://discuss.elastic.co/t/cloudfront-logs-into-es-index-mapping-query-with-updating-to-7-1/187446 "2019-06-26T00:28:54Z")
Okay, previously I've setup an AWS Lambda function to automatically collect AWS CloudFront logs from an S3 bucket and push them into an AWS ElasticSearch cluster. This was working fine with ES version 6. However, after a… --- ## [Curator removes kibana aliases even when filter is configured](https://discuss.elastic.co/t/curator-removes-kibana-aliases-even-when-filter-is-configured/187029)
**Author:** [@fragatina](https://discuss.elastic.co/u/fragatina)\ **Replies:** 3\ **Last updated:** [June 25, 2019, 11:27pm UTC](https://discuss.elastic.co/t/curator-removes-kibana-aliases-even-when-filter-is-configured/187029 "2019-06-25T23:27:02Z")
I'm using elasticsearch and kibana 7.1.1 and curator 5.7.5. Latest versions of elasticsearch (I think since 6.7 are using an alias .kibana which creates .kibana\_1, .kibana\_2,....) From this page it seems I thought that… --- ## [Effective way to pull a unique field value from Elasticsearch 2.4?](https://discuss.elastic.co/t/effective-way-to-pull-a-unique-field-value-from-elasticsearch-2-4/187261)
**Author:** [@Yashasvi\_Raj\_Pant](https://discuss.elastic.co/u/Yashasvi_Raj_Pant)\ **Replies:** 5\ **Last updated:** [June 25, 2019, 9:05pm UTC](https://discuss.elastic.co/t/effective-way-to-pull-a-unique-field-value-from-elasticsearch-2-4/187261 "2019-06-25T21:05:43Z")
I have a field called memberInfoId in Elasticsearch, whose value is unique in each document. I have thousands of documents in my Elasticsearch, so if I have to pull all the value of memberInfoId , terms aggregation seems… --- ## [How to go to offline mode](https://discuss.elastic.co/t/how-to-go-to-offline-mode/187163)
**Author:** [@zatom](https://discuss.elastic.co/u/zatom)\ **Replies:** 5\ **Last updated:** [June 25, 2019, 9:03pm UTC](https://discuss.elastic.co/t/how-to-go-to-offline-mode/187163 "2019-06-25T21:03:22Z")
I want to reindex my index in offline mode in elasticsearch(6x..) inorder to avoid any errors or timeout issues. How do I do that? I am new to online and offline terms. --- ## [How are numeric data types indexed?](https://discuss.elastic.co/t/how-are-numeric-data-types-indexed/187418)
**Author:** [@shekharshan](https://discuss.elastic.co/u/shekharshan)\ **Replies:** 2\ **Last updated:** [June 25, 2019, 8:23pm UTC](https://discuss.elastic.co/t/how-are-numeric-data-types-indexed/187418 "2019-06-25T20:23:55Z")
I wanted to understand how numeric data types such as integer and long are indexed. I think it should get indexed like keywords, without any analysis. Is there any need or benefit to also mapping a numeric type with a 'k… --- ## [Curator 5.6.0 deletes indices newer than unit\_count](https://discuss.elastic.co/t/curator-5-6-0-deletes-indices-newer-than-unit-count/187393)
**Author:** [@Ayush\_Mathur](https://discuss.elastic.co/u/Ayush_Mathur)\ **Replies:** 1\ **Last updated:** [June 25, 2019, 6:10pm UTC](https://discuss.elastic.co/t/curator-5-6-0-deletes-indices-newer-than-unit-count/187393 "2019-06-25T18:10:11Z")
Elastic Stack version: 6.2.3 Curator Version : 5.6.0 We have configured curator to delete the indices which are older than 14 days where indices are rolled on daily basis. The configuration looks like: action: de… --- ## [Use of Scroll with Composite Aggregation](https://discuss.elastic.co/t/use-of-scroll-with-composite-aggregation/187389)
**Author:** [@Shivendra\_Singh](https://discuss.elastic.co/u/Shivendra_Singh)\ **Replies:** 0\ **Last updated:** [June 25, 2019, 4:49pm UTC](https://discuss.elastic.co/t/use-of-scroll-with-composite-aggregation/187389 "2019-06-25T16:49:04Z")
Hi All, Can I use Scroll with Composite Aggregation or shall I use after key for iterating the result set? I have read the scroll documentation it suggests not to use scroll for real time purpose. I have also read that … --- ## [No living connections - Cannot start kibana](https://discuss.elastic.co/t/no-living-connections-cannot-start-kibana/187359)
**Author:** [@lucardo0](https://discuss.elastic.co/u/lucardo0)\ **Replies:** 4\ **Last updated:** [June 25, 2019, 4:26pm UTC](https://discuss.elastic.co/t/no-living-connections-cannot-start-kibana/187359 "2019-06-25T16:26:32Z")
I'm trying to run a docker-compose with kibana and elasticsearch. I tried with 4 different options that i found on the internet, but i keep having the same problem: Kibana server is not ready yet on localhost:5601. Thse… --- ## [Unable to reference geo\_point type field](https://discuss.elastic.co/t/unable-to-reference-geo-point-type-field/186775)
**Author:** [@JackFS4](https://discuss.elastic.co/u/JackFS4)\ **Replies:** 4\ **Last updated:** [June 25, 2019, 3:13pm UTC](https://discuss.elastic.co/t/unable-to-reference-geo-point-type-field/186775 "2019-06-25T15:13:40Z")
I know I'm missing something simple, I have an index built from my firewall log events and in Kibana/Discover I have a SourceIPGeo.location.lat and SourceIPGeo.location.lon but when I try to make a map visualization I ge… --- ## [Error when installing a template in ES](https://discuss.elastic.co/t/error-when-installing-a-template-in-es/187210)
**Author:** [@kumar4](https://discuss.elastic.co/u/kumar4)\ **Replies:** 6\ **Last updated:** [June 25, 2019, 2:32pm UTC](https://discuss.elastic.co/t/error-when-installing-a-template-in-es/187210 "2019-06-25T14:32:39Z")
when i run the flowwing command: curl -XPUT localhost:9200/\_template/blueliv -d @template.json it give me an error is there any oher command to instal template in ES 6 --- ## [Problem while reading date from ES index in hive](https://discuss.elastic.co/t/problem-while-reading-date-from-es-index-in-hive/187365)
**Author:** [@sudhithra](https://discuss.elastic.co/u/sudhithra)\ **Replies:** 0\ **Last updated:** [June 25, 2019, 2:21pm UTC](https://discuss.elastic.co/t/problem-while-reading-date-from-es-index-in-hive/187365 "2019-06-25T14:21:49Z")
Hi, I face a problem while reading date fields in HIVE using ES connector. I use es.mapping/rich.date as false. But still i get a parsing error while selecting the field from the hive table CREATE EXTERNAL TABLE al3( … [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1249) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1251)