# Elasticsearch **URL:** https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=487 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 488 --- ## [Database Management](https://discuss.elastic.co/t/database-management/298060)
**Author:** [@John\_Dever\_Rusiana](https://discuss.elastic.co/u/John_Dever_Rusiana)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 4:49pm UTC](https://discuss.elastic.co/t/database-management/298060 "2022-02-23T16:49:57Z")
Hi All, good day! I just want to ask from someone who have experienced in Database Management. As a database designer or manager, which would you prefer doing, normalization or denormalization of database? Why? Any ide… --- ## [Shard Siem cause cluster red V2](https://discuss.elastic.co/t/shard-siem-cause-cluster-red-v2/296575)
**Author:** [@labate](https://discuss.elastic.co/u/labate)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 4:14pm UTC](https://discuss.elastic.co/t/shard-siem-cause-cluster-red-v2/296575 "2022-02-23T16:14:43Z")
Hello everyone, I have a problem with my .siem-signals-default index. The shard goes to red status and I can't reallocate the shard to another node. Because the shard seems to not be in my cluster and I can't get it bac… --- ## [Watcher error when force executing](https://discuss.elastic.co/t/watcher-error-when-force-executing/297648)
**Author:** [@vee](https://discuss.elastic.co/u/vee)\ **Replies:** 2\ **Last updated:** [February 23, 2022, 3:46pm UTC](https://discuss.elastic.co/t/watcher-error-when-force-executing/297648 "2022-02-23T15:46:54Z")
Hi - I noticed this error when attempting to force execute a watcher that triggers out the alert to our monitoring tool - Nagios. could not parse \[webhook\] action \[inlined/notify-nagios\]. failed parsing http request te… --- ## [What's the disk watermark actually applied while specified in both node configuration file and cluster settings?](https://discuss.elastic.co/t/whats-the-disk-watermark-actually-applied-while-specified-in-both-node-configuration-file-and-cluster-settings/297966)
**Author:** [@Hao\_Yellow](https://discuss.elastic.co/u/Hao_Yellow)\ **Replies:** 13\ **Last updated:** [February 23, 2022, 3:21pm UTC](https://discuss.elastic.co/t/whats-the-disk-watermark-actually-applied-while-specified-in-both-node-configuration-file-and-cluster-settings/297966 "2022-02-23T15:21:44Z")
Hello, I have a cluster of several nodes, where each node has the following configuration about the disk watermark: cluster.routing.allocation.disk.watermark.low=60gb cluster.routing.allocation.disk.watermark.high=50gb … --- ## [Exists query problem](https://discuss.elastic.co/t/exists-query-problem/298037)
**Author:** [@Busra\_Duygu](https://discuss.elastic.co/u/Busra_Duygu)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 2:45pm UTC](https://discuss.elastic.co/t/exists-query-problem/298037 "2022-02-23T14:45:37Z")
Hello friends, I need your help on a subject. There is a field with a nested type in an index and another field with a string type in this field. Any record has this field, but I would be very happy if you could help me … --- ## [No\_viable\_alt\_exception in painless script field](https://discuss.elastic.co/t/no-viable-alt-exception-in-painless-script-field/298018)
**Author:** [@niveditakathal](https://discuss.elastic.co/u/niveditakathal)\ **Replies:** 2\ **Last updated:** [February 23, 2022, 12:18pm UTC](https://discuss.elastic.co/t/no-viable-alt-exception-in-painless-script-field/298018 "2022-02-23T12:18:03Z")
Hi All, I want to calculate a substring of a string field (starting from 0 till either a fixed position or till - symbol ) under kibana index pattern . However when I am trying to create a scripted field I am getting "S… --- ## [Assigning Shards in ElasticSearch Cluster](https://discuss.elastic.co/t/assigning-shards-in-elasticsearch-cluster/298021)
**Author:** [@subham](https://discuss.elastic.co/u/subham)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 11:59am UTC](https://discuss.elastic.co/t/assigning-shards-in-elasticsearch-cluster/298021 "2022-02-23T11:59:49Z")
Hi All, I have 8 nodes in my ES cluster. I want to de-provision 2 of the servers. When i stop the Elasticsearch process in 2 of my nodes, the 430 shards which are assigned to these 2 nodes gets unassigned. Is there any … --- ## [Regression: Client 7.16.x IndicesClient.exists indicesOptions are not present in request anymore](https://discuss.elastic.co/t/regression-client-7-16-x-indicesclient-exists-indicesoptions-are-not-present-in-request-anymore/298017)
**Author:** [@Sebastian\_Bathke](https://discuss.elastic.co/u/Sebastian_Bathke)\ **Replies:** 0\ **Last updated:** [February 23, 2022, 11:25am UTC](https://discuss.elastic.co/t/regression-client-7-16-x-indicesclient-exists-indicesoptions-are-not-present-in-request-anymore/298017 "2022-02-23T11:25:56Z")
Hey folks, we encountered a regression when updating to the latest 7.16.3 Java client, still making use of the RestHighLevelClient. The main cause for the issue is that actually the GetIndexRequest.DEFAULT\_INDICES\_OPTI… --- ## [Real minimal hardware requirements](https://discuss.elastic.co/t/real-minimal-hardware-requirements/298008)
**Author:** [@jfs1](https://discuss.elastic.co/u/jfs1)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 10:49am UTC](https://discuss.elastic.co/t/real-minimal-hardware-requirements/298008 "2022-02-23T10:49:53Z")
What are the real minimal requirements for a lab Elastic stack deployment ? I mean : no production data. Only functionnal testing in the lab. So how much RAM/CPU/Disk to run Elastic + Kibana + Logstash on a single node… --- ## [Elasticsearch javascript](https://discuss.elastic.co/t/elasticsearch-javascript/298013)
**Author:** [@Achraf\_MENSI](https://discuss.elastic.co/u/Achraf_MENSI)\ **Replies:** 0\ **Last updated:** [February 23, 2022, 10:48am UTC](https://discuss.elastic.co/t/elasticsearch-javascript/298013 "2022-02-23T10:48:24Z")
Hello have anyone tried to create web interface to manupliate ILM policy via javascript? i want to know it's possible or not , because i tried and i find just just how to manage index with js. Thanks --- ## [Multiple VPC Private Link Endpoints in one ES Deployment](https://discuss.elastic.co/t/multiple-vpc-private-link-endpoints-in-one-es-deployment/286555)
**Author:** [@Daniel.X](https://discuss.elastic.co/u/Daniel.X)\ **Replies:** 5\ **Last updated:** [February 23, 2022, 10:05am UTC](https://discuss.elastic.co/t/multiple-vpc-private-link-endpoints-in-one-es-deployment/286555 "2022-02-23T10:05:07Z")
Hi there, We currently have a vpc per environment in our AWS e.g. beta, pre, staging, and production. I've followed the instructions here to setup the AWS Private Link/Traffic Filtering for our vpc: AWS Privatelink traf… --- ## [Watcher not automatically sending any emails](https://discuss.elastic.co/t/watcher-not-automatically-sending-any-emails/297509)
**Author:** [@Angad\_Panesar1](https://discuss.elastic.co/u/Angad_Panesar1)\ **Replies:** 4\ **Last updated:** [February 23, 2022, 9:48am UTC](https://discuss.elastic.co/t/watcher-not-automatically-sending-any-emails/297509 "2022-02-23T09:48:30Z")
I am trying to get the report below automatically sent to me every hour but unfortunately I got several errors. Is there any way to fix them? Did I do the code wrong? Please let me know. Thank you. Dev Tools Coding for … --- ## [ELK Docker TLS Encryption and Set up](https://discuss.elastic.co/t/elk-docker-tls-encryption-and-set-up/297959)
**Author:** [@userR](https://discuss.elastic.co/u/userR)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 8:59am UTC](https://discuss.elastic.co/t/elk-docker-tls-encryption-and-set-up/297959 "2022-02-23T08:59:08Z")
Below is my set up: Machine 1: Elasticsearch (1 node) and Kibana containers using Docker-Compose Machine 2: Logstash container using Docker-Compose, forwarding parsed logs to Machine1 Machine 3: Filebeat install… --- ## [Error during bulk import while inserting around 200K documents from SQL Server](https://discuss.elastic.co/t/error-during-bulk-import-while-inserting-around-200k-documents-from-sql-server/297942)
**Author:** [@girishraghu](https://discuss.elastic.co/u/girishraghu)\ **Replies:** 2\ **Last updated:** [February 23, 2022, 8:55am UTC](https://discuss.elastic.co/t/error-during-bulk-import-while-inserting-around-200k-documents-from-sql-server/297942 "2022-02-23T08:55:21Z")
Hi team, I am relatively new to the ELK world. I am writing a simple Python script to fetch around 200K records from a local instance of SQL Server and index them in my local ELK instance running on my laptop. The scrip… --- ## [Can't able to connect s3 through repository-s3 using service account role](https://discuss.elastic.co/t/cant-able-to-connect-s3-through-repository-s3-using-service-account-role/297986)
**Author:** [@Preti](https://discuss.elastic.co/u/Preti)\ **Replies:** 0\ **Last updated:** [February 23, 2022, 8:40am UTC](https://discuss.elastic.co/t/cant-able-to-connect-s3-through-repository-s3-using-service-account-role/297986 "2022-02-23T08:40:40Z")
Hi Team, Can't able to connect s3 through repository-s3 using service account role. PUT /\_snapshot/xxxxxxx { "type": "s3", "settings": { "bucket": "xxxxxxx", "allow\_insecure\_settings": "false","protocol": "https", "e… --- ## [Index alias](https://discuss.elastic.co/t/index-alias/297921)
**Author:** [@Eran\_Hadad](https://discuss.elastic.co/u/Eran_Hadad)\ **Replies:** 3\ **Last updated:** [February 23, 2022, 8:27am UTC](https://discuss.elastic.co/t/index-alias/297921 "2022-02-23T08:27:00Z")
Hi all, I am a beginner in elastic and I've inherited an environment in elastic cloud. I have an index that ends with a dash, let's call it indexname- Developers wrote code to insert records to this index name. There… --- ## [Why curl command is not showing o/p in proxy server](https://discuss.elastic.co/t/why-curl-command-is-not-showing-o-p-in-proxy-server/297854)
**Author:** [@Bhanuji\_paluri](https://discuss.elastic.co/u/Bhanuji_paluri)\ **Replies:** 21\ **Last updated:** [February 23, 2022, 8:25am UTC](https://discuss.elastic.co/t/why-curl-command-is-not-showing-o-p-in-proxy-server/297854 "2022-02-23T08:25:13Z")
curl os not responding in proxy side, i have restarted ES nodes and then start working fine but again stopped from first response , but get the output in devtools. kindly let me know what all steps need to perform for… --- ## [Elasticsearch explicit field mappings in template not taken when data is logged from filebeat through ingest pipeline](https://discuss.elastic.co/t/elasticsearch-explicit-field-mappings-in-template-not-taken-when-data-is-logged-from-filebeat-through-ingest-pipeline/297946)
**Author:** [@shi](https://discuss.elastic.co/u/shi)\ **Replies:** 2\ **Last updated:** [February 23, 2022, 6:28am UTC](https://discuss.elastic.co/t/elasticsearch-explicit-field-mappings-in-template-not-taken-when-data-is-logged-from-filebeat-through-ingest-pipeline/297946 "2022-02-23T06:28:43Z")
sir, I have created an index life cycle policy with name lp\_ilp\_fgnew1 Created index template lp\_templateforotherfgutmwaf7 as follows PUT \_index\_template/lp\_templateforotherfgutmwaf7 { "index\_patterns": \["lp\_inde… --- ## [How are interger numbers treated in ElasticSearch?](https://discuss.elastic.co/t/how-are-interger-numbers-treated-in-elasticsearch/297745)
**Author:** [@jordane95](https://discuss.elastic.co/u/jordane95)\ **Replies:** 3\ **Last updated:** [February 23, 2022, 6:07am UTC](https://discuss.elastic.co/t/how-are-interger-numbers-treated-in-elasticsearch/297745 "2022-02-23T06:07:07Z")
Hey, I'm new to this. I have some questions about Elasticsearch. How are interger numbers treated in this lib? For example, year, age, month...etc. Can I build the index with BERT-tokenizer tokenized documents where ea… --- ## [Elasticsearch 5.6 scroll query takes longer](https://discuss.elastic.co/t/elasticsearch-5-6-scroll-query-takes-longer/297971)
**Author:** [@mario12](https://discuss.elastic.co/u/mario12)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 5:47am UTC](https://discuss.elastic.co/t/elasticsearch-5-6-scroll-query-takes-longer/297971 "2022-02-23T05:47:50Z")
We are using a scroll query to load all the documents from ES 2.4. It took less than 2 minutes to load 3 million documents. We recently upgrade to ES 5.6 and it takes 10-12 minutes on average. We are using \_doc for sort … --- ## [Error calling webhook \[DEPTH\_ZERO\_SELF\_SIGNED\_CERT\]](https://discuss.elastic.co/t/error-calling-webhook-depth-zero-self-signed-cert/297065)
**Author:** [@angelolol](https://discuss.elastic.co/u/angelolol)\ **Replies:** 3\ **Last updated:** [February 23, 2022, 3:05am UTC](https://discuss.elastic.co/t/error-calling-webhook-depth-zero-self-signed-cert/297065 "2022-02-23T03:05:15Z")
Hi, I´m working with webhook action where I´m trying to send a request to Jira but I get this error "error calling webhook \[DEPTH\_ZERO\_SELF\_SIGNED\_CERT\]", I change "xpack.actions.ssl.verificationMode : none" in the kiba… --- ## [Profile time cost stat differ profile detail](https://discuss.elastic.co/t/profile-time-cost-stat-differ-profile-detail/297961)
**Author:** [@mxq-151](https://discuss.elastic.co/u/mxq-151)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 2:43am UTC](https://discuss.elastic.co/t/profile-time-cost-stat-differ-profile-detail/297961 "2022-02-23T02:43:26Z")
{ "took" : 7510, "timed\_out" : false, "\_shards" : { "total" : 5, "successful" : 5, "skipped" : 0, "failed" : 0 }, "hits" : { "total" : { "value" : 1545576, "relation" : "eq" … --- ## [EQL increase the eql\_sequence memory limit](https://discuss.elastic.co/t/eql-increase-the-eql-sequence-memory-limit/297926)
**Author:** [@lusynda](https://discuss.elastic.co/u/lusynda)\ **Replies:** 1\ **Last updated:** [February 23, 2022, 2:48am UTC](https://discuss.elastic.co/t/eql-increase-the-eql-sequence-memory-limit/297926 "2022-02-23T02:48:28Z")
Hi all How can i increase the limit of the eql\_sequence in the elastic breaker settings. I constantly got this error while using sequence in eql { "error" : { "root\_cause" : \[ { "type" : "circuit\_b… --- ## [Creating snapshot every six months](https://discuss.elastic.co/t/creating-snapshot-every-six-months/297870)
**Author:** [@mangeshs](https://discuss.elastic.co/u/mangeshs)\ **Replies:** 1\ **Last updated:** [February 22, 2022, 11:05pm UTC](https://discuss.elastic.co/t/creating-snapshot-every-six-months/297870 "2022-02-22T23:05:56Z")
Hi, I have lot of records in only one index so I want to create snapshots backup of index every six months and point those to different index pattern so that I can have different dashboards for every six months and one … --- ## [Hostname/IP does not match certificate's altnames](https://discuss.elastic.co/t/hostname-ip-does-not-match-certificates-altnames/297928)
**Author:** [@Emile\_Plas](https://discuss.elastic.co/u/Emile_Plas)\ **Replies:** 1\ **Last updated:** [February 22, 2022, 7:33pm UTC](https://discuss.elastic.co/t/hostname-ip-does-not-match-certificates-altnames/297928 "2022-02-22T19:33:40Z")
I am trying to set up Elasticsearch and kibana 8 on a new machine. For one or another reason kibana gives me the following error: Hostname/IP does not match certificate's altnames. IP: ... is not in the certificate's al… --- ## [Unable to log in after installation](https://discuss.elastic.co/t/unable-to-log-in-after-installation/297933)
**Author:** [@Nestoter](https://discuss.elastic.co/u/Nestoter)\ **Replies:** 1\ **Last updated:** [February 22, 2022, 7:02pm UTC](https://discuss.elastic.co/t/unable-to-log-in-after-installation/297933 "2022-02-22T19:02:27Z")
Hi, I'm installing Elastic following this: https://www.elastic.co/guide/en/elasticsearch/reference/8.0/deb.html Step 1. wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-8.0.0-amd64.deb Step 2. s… --- ## [How to enable security APi](https://discuss.elastic.co/t/how-to-enable-security-api/297259)
**Author:** [@Bhanuji\_paluri](https://discuss.elastic.co/u/Bhanuji_paluri)\ **Replies:** 7\ **Last updated:** [February 22, 2022, 6:31pm UTC](https://discuss.elastic.co/t/how-to-enable-security-api/297259 "2022-02-22T18:31:25Z")
how to enable security APi , please guide with steps --- ## [ILM, creation\_date and reindexing](https://discuss.elastic.co/t/ilm-creation-date-and-reindexing/297469)
**Author:** [@nisow95612](https://discuss.elastic.co/u/nisow95612)\ **Replies:** 4\ **Last updated:** [February 22, 2022, 6:19pm UTC](https://discuss.elastic.co/t/ilm-creation-date-and-reindexing/297469 "2022-02-22T18:19:15Z")
Hello Elastic people, this is a follow-up to Is it possible change creation\_date on reindexed Indexes to get Life cycle Management to work on old indexes My usecase - so to say - is learning to use ES while trying to b… --- ## [Payload scoring in elasticsearch?](https://discuss.elastic.co/t/payload-scoring-in-elasticsearch/297878)
**Author:** [@pauloamed](https://discuss.elastic.co/u/pauloamed)\ **Replies:** 1\ **Last updated:** [February 22, 2022, 4:48pm UTC](https://discuss.elastic.co/t/payload-scoring-in-elasticsearch/297878 "2022-02-22T16:48:06Z")
Hey! I've been trying to write a custom text scoring function in Elasticsearch and I can't find a way to do it. I want to weight the score of each query term with a payload passed inside the query. How can I do it using… --- ## [Elasticsearch 8.0 RPM Install Security autoconfiguration issues](https://discuss.elastic.co/t/elasticsearch-8-0-rpm-install-security-autoconfiguration-issues/297907)
**Author:** [@apjkelly](https://discuss.elastic.co/u/apjkelly)\ **Replies:** 5\ **Last updated:** [February 22, 2022, 4:33pm UTC](https://discuss.elastic.co/t/elasticsearch-8-0-rpm-install-security-autoconfiguration-issues/297907 "2022-02-22T16:33:53Z")
I'm in the process of attempting to install Elasticsearch on a group of CentOS 7 servers. I am installing using the rpm provided in the Elasticsearch repo. However there appears to be an issue with the automated security… [Previous page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=486) [Next page](https://discuss.elastic.co/c/elastic-stack/elasticsearch/6.md?page=488)