# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1167 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1168 --- ## [JDBC connection not working](https://discuss.elastic.co/t/jdbc-connection-not-working/198175)
**Author:** [@zbawio](https://discuss.elastic.co/u/zbawio)\ **Replies:** 10\ **Last updated:** [September 5, 2019, 3:21pm UTC](https://discuss.elastic.co/t/jdbc-connection-not-working/198175 "2019-09-05T15:21:59Z")
Hi all, I have a database on my MSSQL 2012 server and i am trying to get my database to elasticsearch with logstash. I did I installed jdk 8 I installed sqljdbc 4.2 I Added the java and jdbc to Environment path Iam… --- ## [How to back monthly indices with curator day to day?](https://discuss.elastic.co/t/how-to-back-monthly-indices-with-curator-day-to-day/197367)
**Author:** [@javadevmtl](https://discuss.elastic.co/u/javadevmtl)\ **Replies:** 3\ **Last updated:** [September 5, 2019, 3:16pm UTC](https://discuss.elastic.co/t/how-to-back-monthly-indices-with-curator-day-to-day/197367 "2019-09-05T15:16:30Z")
Hi running Curator 5.1 and Elasticsearch 6.4.2 I have the following Curator action... Which works. My concern is how do I catch the last day of the month? So on September 1st I would need to make sure the last bit of A… --- ## [After new install "Can not run elasticsearch as root"](https://discuss.elastic.co/t/after-new-install-can-not-run-elasticsearch-as-root/196796)
**Author:** [@Hortiks](https://discuss.elastic.co/u/Hortiks)\ **Replies:** 12\ **Last updated:** [September 5, 2019, 3:02pm UTC](https://discuss.elastic.co/t/after-new-install-can-not-run-elasticsearch-as-root/196796 "2019-09-05T15:02:43Z")
Hello, after the installation of elasticsearch\_7.3.1, i've got the message "can not run elasticsearch as root". I had a functionnal 1.7.3 with some changes : -/etc/default/elasticsearch =\> uncommented lines START\_DAEM… --- ## [Elasticsearch latest version support for win 2019](https://discuss.elastic.co/t/elasticsearch-latest-version-support-for-win-2019/198240)
**Author:** [@elitzur\_e](https://discuss.elastic.co/u/elitzur_e)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 2:11pm UTC](https://discuss.elastic.co/t/elasticsearch-latest-version-support-for-win-2019/198240 "2019-09-05T14:11:09Z")
Hi i have seen other (locked) post about this with no official answer. is there any known issue running es or kibana on windows server 2019? (its not on support matix) thanks --- ## [Inserting and Indexing Raw HTML into Elastic Search](https://discuss.elastic.co/t/inserting-and-indexing-raw-html-into-elastic-search/198268)
**Author:** [@hotelalpha](https://discuss.elastic.co/u/hotelalpha)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 2:01pm UTC](https://discuss.elastic.co/t/inserting-and-indexing-raw-html-into-elastic-search/198268 "2019-09-05T14:01:18Z")
I have to index about 42 million raw html files and the end objective is to search through these html. Search is suppose to be from HTML tags and content. E.g. Insert following HTML \ \ **Author:** [@ran\_n](https://discuss.elastic.co/u/ran_n)\ **Replies:** 12\ **Last updated:** [September 5, 2019, 12:36pm UTC](https://discuss.elastic.co/t/cluster-hangs-for-20-seconds-on-a-single-node-crush/198191 "2019-09-05T12:36:05Z") Hi, I have a simple setup, with test data of 10 documents. I have 3 nodes, 2 data 1 only master I have 5 shards with 1 replica. I run a search query every second via small simulator I then disable the network card o… --- ## [Elastic Search Startup Warnings](https://discuss.elastic.co/t/elastic-search-startup-warnings/198237)
**Author:** [@Artiiz](https://discuss.elastic.co/u/Artiiz)\ **Replies:** 2\ **Last updated:** [September 5, 2019, 11:59am UTC](https://discuss.elastic.co/t/elastic-search-startup-warnings/198237 "2019-09-05T11:59:15Z")
Hi there all, We are running into a massive number of Warnings when starting up ElasticSearch, these are all in elasticsearch.log and are very strange as they seem to no inhibit start up at all. \[2019-09-05T13:12:18,79… --- ## [Data frame transforms](https://discuss.elastic.co/t/data-frame-transforms/198231)
**Author:** [@Vladpov](https://discuss.elastic.co/u/Vladpov)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 11:30am UTC](https://discuss.elastic.co/t/data-frame-transforms/198231 "2019-09-05T11:30:26Z")
Hi guys, is there any option to have access to Data frame transforms in basic open-source Elastic Stack solution? I've heard that it is free and part of the default Elastic build. When I try easy sample to transform d… --- ## [ELK 7 Latest stable Version for production deployment](https://discuss.elastic.co/t/elk-7-latest-stable-version-for-production-deployment/198222)
**Author:** [@vivektsb](https://discuss.elastic.co/u/vivektsb)\ **Replies:** 6\ **Last updated:** [September 5, 2019, 11:17am UTC](https://discuss.elastic.co/t/elk-7-latest-stable-version-for-production-deployment/198222 "2019-09-05T11:17:00Z")
Hi , Could you please let us know the latest stable version of ELK for production deployment? Regards, Vivek --- ## [Sort grouped search result by formula](https://discuss.elastic.co/t/sort-grouped-search-result-by-formula/198223)
**Author:** [@yuriiH](https://discuss.elastic.co/u/yuriiH)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 10:31am UTC](https://discuss.elastic.co/t/sort-grouped-search-result-by-formula/198223 "2019-09-05T10:31:17Z")
Hello. I am trying to implement query which will sort results by the formula. For example, we have the next entities: { "price":"1000", "zip":"77777", "field1":"1", "field2":"5" }, { "price":"2222", "zip":"777… --- ## [ElasticSearch container is not being created using Docker compose](https://discuss.elastic.co/t/elasticsearch-container-is-not-being-created-using-docker-compose/198214)
**Author:** [@kishore\_royal](https://discuss.elastic.co/u/kishore_royal)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 9:46am UTC](https://discuss.elastic.co/t/elasticsearch-container-is-not-being-created-using-docker-compose/198214 "2019-09-05T09:46:00Z")
Hi , I am trying to run ELK stack with filebeat on VM installed on windows machine. When I run the docker-compose up command , filebeat and kibana containers are getting created while elasticsearch container not being … --- ## [Elasticsearch HTTPS](https://discuss.elastic.co/t/elasticsearch-https/197347)
**Author:** [@Dev-Flo](https://discuss.elastic.co/u/Dev-Flo)\ **Replies:** 17\ **Last updated:** [September 5, 2019, 9:39am UTC](https://discuss.elastic.co/t/elasticsearch-https/197347 "2019-09-05T09:39:01Z")
Hey, I enabled encrypted HTTP client connections via TLS, following this guide: https://www.elastic.co/guide/en/elasticsearch/reference/current/configuring-tls.html#tls-http. However, now I cannot connect to the Elast… --- ## [Monitoring not showing all nodes](https://discuss.elastic.co/t/monitoring-not-showing-all-nodes/197673)
**Author:** [@coudenysj](https://discuss.elastic.co/u/coudenysj)\ **Replies:** 2\ **Last updated:** [September 5, 2019, 9:37am UTC](https://discuss.elastic.co/t/monitoring-not-showing-all-nodes/197673 "2019-09-05T09:37:47Z")
Hi, This is a followup question for Monitoring -\> Elasticsearch -\> Nodes - no data nodes(. I have 15 nodes in my cluster, but the Monitoring -\> Elasticsearch -\> Nodes is only showing master nodes. The strange thing is… --- ## [\[Resolved\]\[ES7.0.1\] Exception \[o.e.d.SeedHostsResolver \] \[node-1\] failed to resolve host \[node-1\] when starting es](https://discuss.elastic.co/t/resolved-es7-0-1-exception-o-e-d-seedhostsresolver-node-1-failed-to-resolve-host-node-1-when-starting-es/197960)
**Author:** [@cheriemilk](https://discuss.elastic.co/u/cheriemilk)\ **Replies:** 6\ **Last updated:** [September 5, 2019, 8:51am UTC](https://discuss.elastic.co/t/resolved-es7-0-1-exception-o-e-d-seedhostsresolver-node-1-failed-to-resolve-host-node-1-when-starting-es/197960 "2019-09-05T08:51:56Z")
Hi team, I got below error when starting es7.0.1, how to correct the yml configuration file to resolve it? \[2019-09-04T08:40:22,339\]\[INFO \]\[o.e.h.AbstractHttpServerTransport\] \[node-1\] publish\_address {10.59.181.210:9… --- ## [Possible to run with EBS instead of instance store?](https://discuss.elastic.co/t/possible-to-run-with-ebs-instead-of-instance-store/196569)
**Author:** [@VBDave](https://discuss.elastic.co/u/VBDave)\ **Replies:** 2\ **Last updated:** [September 5, 2019, 8:31am UTC](https://discuss.elastic.co/t/possible-to-run-with-ebs-instead-of-instance-store/196569 "2019-09-05T08:31:57Z")
Hi there, We're currently running an elastic cluster for an ELK backend, on i3.2xlarge EC2 instances in AWS and using the local Instance Store to store the data partition on, which is generally what is recommended in th… --- ## [Bin/elasticsearch](https://discuss.elastic.co/t/bin-elasticsearch/198194)
**Author:** [@tonic\_Zun](https://discuss.elastic.co/u/tonic_Zun)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 8:27am UTC](https://discuss.elastic.co/t/bin-elasticsearch/198194 "2019-09-05T08:27:44Z")
The installation method used by the existing 6.x version cannot be installed with the latest 7.3.1. OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in… --- ## [How to set the value of "total\_fields" by using curl?](https://discuss.elastic.co/t/how-to-set-the-value-of-total-fields-by-using-curl/198196)
**Author:** [@terrymu](https://discuss.elastic.co/u/terrymu)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 8:26am UTC](https://discuss.elastic.co/t/how-to-set-the-value-of-total-fields-by-using-curl/198196 "2019-09-05T08:26:02Z")
Hi Experts, I'm parsing my source logs then meeting an issue such like this: \[2019-09-05T15:56:34,215\]\[WARN \]\[logstash.outputs.elasticsearch\] Could not index event to Elasticsearch. {:status=\>400, :action=\>\["index", {… --- ## [Identifying Pipeline Bottlenecks (Lost Events)](https://discuss.elastic.co/t/identifying-pipeline-bottlenecks-lost-events/198036)
**Author:** [@tobydickinson](https://discuss.elastic.co/u/tobydickinson)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 8:18am UTC](https://discuss.elastic.co/t/identifying-pipeline-bottlenecks-lost-events/198036 "2019-09-05T08:18:51Z")
First time poster, long time lurker. I am using the Elastic stack to process and analyze XML documents which are sent to me over the HTTP protocol. I currently have the following pipeline set up to realise this behaviou… --- ## [Is there a way to delete unassigned replica and recover using primary shard for a index?](https://discuss.elastic.co/t/is-there-a-way-to-delete-unassigned-replica-and-recover-using-primary-shard-for-a-index/198160)
**Author:** [@senthilp](https://discuss.elastic.co/u/senthilp)\ **Replies:** 2\ **Last updated:** [September 5, 2019, 8:15am UTC](https://discuss.elastic.co/t/is-there-a-way-to-delete-unassigned-replica-and-recover-using-primary-shard-for-a-index/198160 "2019-09-05T08:15:00Z")
One of my replica is failed to recover due to file system issue and Primary shard is fine. Is there a way we can delete only the failed replica for that shard and recover using the Primary shard. --- ## [Some problems on elasticsearch\_6.3.1 docker](https://discuss.elastic.co/t/some-problems-on-elasticsearch-6-3-1-docker/198147)
**Author:** [@kiddingl](https://discuss.elastic.co/u/kiddingl)\ **Replies:** 8\ **Last updated:** [September 5, 2019, 8:07am UTC](https://discuss.elastic.co/t/some-problems-on-elasticsearch-6-3-1-docker/198147 "2019-09-05T08:07:24Z")
I have installed repository-s3 and modify elasticsearh.yml, But I don't want to restart container I can't find any way --- ## [Explanation for index.force\_memory\_term\_dictionary](https://discuss.elastic.co/t/explanation-for-index-force-memory-term-dictionary/198193)
**Author:** [@internet-media](https://discuss.elastic.co/u/internet-media)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 8:05am UTC](https://discuss.elastic.co/t/explanation-for-index-force-memory-term-dictionary/198193 "2019-09-05T08:05:25Z")
Hi there Elastic Support Team and Community, I'm wondering what the index setting "force\_memory\_term\_dictionary" ist doing. I can't find an explanation in the documentation. What I found was an in-code comment that exp… --- ## [MUST\_NOT query not working](https://discuss.elastic.co/t/must-not-query-not-working/198189)
**Author:** [@rajneesh](https://discuss.elastic.co/u/rajneesh)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 7:47am UTC](https://discuss.elastic.co/t/must-not-query-not-working/198189 "2019-09-05T07:47:36Z")
Hi, I have a query in which i want add a must\_not clause to discard all records that have blank data for a particular field. I tried so many ways to do it but none worked. when i issue the same query with few other fiel… --- ## [Bulk Update with ScriptedUpsert run scripts twice](https://discuss.elastic.co/t/bulk-update-with-scriptedupsert-run-scripts-twice/198185)
**Author:** [@dbakti7](https://discuss.elastic.co/u/dbakti7)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 7:36am UTC](https://discuss.elastic.co/t/bulk-update-with-scriptedupsert-run-scripts-twice/198185 "2019-09-05T07:36:07Z")
I'm trying to use scripted upsert to handle array of nested field. Basically on each insert/update, we need to append new version into the nested field. The following is the script: if (ctx.\_source\[params.version\_name\] … --- ## [Custom Plugin To Call An External API End Point](https://discuss.elastic.co/t/custom-plugin-to-call-an-external-api-end-point/198173)
**Author:** [@Pritish\_Mohapatra](https://discuss.elastic.co/u/Pritish_Mohapatra)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 6:54am UTC](https://discuss.elastic.co/t/custom-plugin-to-call-an-external-api-end-point/198173 "2019-09-05T06:54:13Z")
Hi, I have developed a dashboard in Kibana which displays all the errors logged from my application via elastic search. For all the failed records I want to create a button and on the click of it I want to reprocess the… --- ## [Question about Throughput Sizing](https://discuss.elastic.co/t/question-about-throughput-sizing/198137)
**Author:** [@zidane28](https://discuss.elastic.co/u/zidane28)\ **Replies:** 4\ **Last updated:** [September 5, 2019, 6:15am UTC](https://discuss.elastic.co/t/question-about-throughput-sizing/198137 "2019-09-05T06:15:07Z")
I found out that one of the method for cluster planning is though Throughput Sizing , in which it uses number of search per second, search response time, physical cores etc etc. to calculate how many nodes needed. Below… --- ## [Best approach to creating mapping in elasticsearch/logstash](https://discuss.elastic.co/t/best-approach-to-creating-mapping-in-elasticsearch-logstash/198156)
**Author:** [@mdhl](https://discuss.elastic.co/u/mdhl)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 5:58am UTC](https://discuss.elastic.co/t/best-approach-to-creating-mapping-in-elasticsearch-logstash/198156 "2019-09-05T05:58:08Z")
Hello everyone, I am new to ELK stack. Currently in the processing of deploying POC for migrating our small splunk deployment to ELK. One of the problem I am having is trying to create mapping in elasticsearch. Current… --- ## [Does ES support to add a new item into the nested field of existing document?](https://discuss.elastic.co/t/does-es-support-to-add-a-new-item-into-the-nested-field-of-existing-document/198154)
**Author:** [@yash.tandon](https://discuss.elastic.co/u/yash.tandon)\ **Replies:** 0\ **Last updated:** [September 5, 2019, 5:49am UTC](https://discuss.elastic.co/t/does-es-support-to-add-a-new-item-into-the-nested-field-of-existing-document/198154 "2019-09-05T05:49:13Z")
--- ## [I don't want to restart elasticsearcch](https://discuss.elastic.co/t/i-dont-want-to-restart-elasticsearcch/198141)
**Author:** [@kiddingl](https://discuss.elastic.co/u/kiddingl)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 5:02am UTC](https://discuss.elastic.co/t/i-dont-want-to-restart-elasticsearcch/198141 "2019-09-05T05:02:34Z")
I don't want to restart elasticsearch after installing plugin repository-s3 and midifying elasticsearch.yml on docker Do you have any good ideas or tools? --- ## [Limit search result by user](https://discuss.elastic.co/t/limit-search-result-by-user/198031)
**Author:** [@Ingram\_Gultom](https://discuss.elastic.co/u/Ingram_Gultom)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 3:21am UTC](https://discuss.elastic.co/t/limit-search-result-by-user/198031 "2019-09-05T03:21:13Z")
Hello, Can elasticsearch limit search result by user? for example user "testing" can only view search result only for 1 week or 1000 docs. --- ## [Elasticsearch update by query using NEST](https://discuss.elastic.co/t/elasticsearch-update-by-query-using-nest/198083)
**Author:** [@kartheek91](https://discuss.elastic.co/u/kartheek91)\ **Replies:** 1\ **Last updated:** [September 5, 2019, 2:25am UTC](https://discuss.elastic.co/t/elasticsearch-update-by-query-using-nest/198083 "2019-09-05T02:25:09Z")
Can anyone help how to pass paramter dynamically in update by query using nest c# . var test= highLevelClient.UpdateByQuery(u =\> u .Index("test") .Type("doc") .Query(q =\> q .Term("\_id", id) ) .Script(("ctx.\_sourc… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1166) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=1168)