# Elastic Stack

**URL:** https://discuss.elastic.co/c/elastic-stack/81.md?page=1407

[Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md)

**Page:** 1408

---

## [Range-Query not working l](https://discuss.elastic.co/t/range-query-not-working-l/273496)

<div class="topic-metadata">

**Author:** [@Rammi22](https://discuss.elastic.co/u/Rammi22)\
**Replies:** 3\
**Last updated:** [May 20, 2021, 9:49am UTC](https://discuss.elastic.co/t/range-query-not-working-l/273496 "2021-05-20T09:49:42Z")

</div>

Hello, I use: Elasticsearch-PHP ElasticsearchDSL Configurated search query: array(2) { \["index"\]=\> string(19) "my\_index\_\*" \["body"\]=\> array(4) { \["query"\]=\> array(1) { \["range"\]=\> array(…

---

## [Elasticsearch - added LDAP authentication, node won't start](https://discuss.elastic.co/t/elasticsearch-added-ldap-authentication-node-wont-start/273499)

<div class="topic-metadata">

**Author:** [@d.silwon](https://discuss.elastic.co/u/d.silwon)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 9:44am UTC](https://discuss.elastic.co/t/elasticsearch-added-ldap-authentication-node-wont-start/273499 "2021-05-20T09:44:13Z")

</div>

Dears, ELK 7.7.0 With bellow configuration my node won't start: cluster.name: elkcluster node.name: elkcluster01 path.data: /var/lib/elasticsearch path.logs: /var/log/elasticsearch network.host: 10.10.10.1 http.port: …

---

## [Uptime smtp connector?](https://discuss.elastic.co/t/uptime-smtp-connector/272897)

<div class="topic-metadata">

**Author:** [@hilt86](https://discuss.elastic.co/u/hilt86)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 9:26am UTC](https://discuss.elastic.co/t/uptime-smtp-connector/272897 "2021-05-20T09:26:29Z")

</div>

In Kibana Alerts and Actions there is a SMTP connector however for some reason you can't add a SMTP to Uptime?

---

## [GROK: help with pattern](https://discuss.elastic.co/t/grok-help-with-pattern/273396)

<div class="topic-metadata">

**Author:** [@Guillermo\_Valles\_Cas](https://discuss.elastic.co/u/Guillermo_Valles_Cas)\
**Replies:** 3\
**Last updated:** [May 20, 2021, 9:18am UTC](https://discuss.elastic.co/t/grok-help-with-pattern/273396 "2021-05-20T09:18:38Z")

</div>

Hello!! I'm trying to get the pattern of a file in Logstash with GROK, but I do not know how to make it. The line I want to GROK is: {"type":"log","@timestamp":"2021-05-19T08:45:42+02:00","tags":\["info","plugins","actio…

---

## [How to predict N days using data frame regression model and streaming data?](https://discuss.elastic.co/t/how-to-predict-n-days-using-data-frame-regression-model-and-streaming-data/272666)

<div class="topic-metadata">

**Author:** [@inhinyera16](https://discuss.elastic.co/u/inhinyera16)\
**Replies:** 5\
**Last updated:** [May 20, 2021, 9:11am UTC](https://discuss.elastic.co/t/how-to-predict-n-days-using-data-frame-regression-model-and-streaming-data/272666 "2021-05-20T09:11:51Z")

</div>

We have given system metrics dataset and the requirement is to predict when do we need to upgrade our servers. Basically what were trying to do is capacity planning using regression analysis. Were done with creating the …

---

## [Logstash unparsed events exceptions](https://discuss.elastic.co/t/logstash-unparsed-events-exceptions/273495)

<div class="topic-metadata">

**Author:** [@ima](https://discuss.elastic.co/u/ima)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 8:55am UTC](https://discuss.elastic.co/t/logstash-unparsed-events-exceptions/273495 "2021-05-20T08:55:10Z")

</div>

Hello, is there anybody who knows where I can find logstash events exceptions and what other healthchecks should I do for logstash

---

## [Kubernetes Module of Metricbeat does not get metrics \[7.9.2 with Kubernetes 1.21.1\]](https://discuss.elastic.co/t/kubernetes-module-of-metricbeat-does-not-get-metrics-7-9-2-with-kubernetes-1-21-1/272996)

<div class="topic-metadata">

**Author:** [@RdrgPorto](https://discuss.elastic.co/u/RdrgPorto)\
**Replies:** 0\
**Last updated:** [May 14, 2021, 8:45am UTC](https://discuss.elastic.co/t/kubernetes-module-of-metricbeat-does-not-get-metrics-7-9-2-with-kubernetes-1-21-1/272996 "2021-05-14T08:45:28Z")

</div>

Hi, everyone I have been testing with a new version of Kubernetes, in this case, 1.21.1. I use Metricbeat in order to get metrics of containers, pods and nodes. Here you are my config: apiVersion: v1 kind: ConfigMap m…

---

## [Changing the score of the results based on a field's value \[Java\]](https://discuss.elastic.co/t/changing-the-score-of-the-results-based-on-a-fields-value-java/273490)

<div class="topic-metadata">

**Author:** [@oasis\_agano](https://discuss.elastic.co/u/oasis_agano)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 8:11am UTC](https://discuss.elastic.co/t/changing-the-score-of-the-results-based-on-a-fields-value-java/273490 "2021-05-20T08:11:13Z")

</div>

I am trying to change the order of the results based on a keyword field. something similar to this but with the java client. { "query": { "function\_score": { "functions": \[ { …

---

## [Filebeat not able to send all logs](https://discuss.elastic.co/t/filebeat-not-able-to-send-all-logs/273488)

<div class="topic-metadata">

**Author:** [@msjsitl](https://discuss.elastic.co/u/msjsitl)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 8:10am UTC](https://discuss.elastic.co/t/filebeat-not-able-to-send-all-logs/273488 "2021-05-20T08:10:26Z")

</div>

Hello all, I am using filebeat 7.9.3. Recently we did load testing on our server almost 4 hours. During load testing almost 1 and GB files created every hour. File rotation policy is after every 1 hour. Before load tes…

---

## [Want to find all document in elastic search in Node JS using aggregation](https://discuss.elastic.co/t/want-to-find-all-document-in-elastic-search-in-node-js-using-aggregation/273281)

<div class="topic-metadata">

**Author:** [@Anjali\_Gupta](https://discuss.elastic.co/u/Anjali_Gupta)\
**Replies:** 5\
**Last updated:** [May 20, 2021, 7:53am UTC](https://discuss.elastic.co/t/want-to-find-all-document-in-elastic-search-in-node-js-using-aggregation/273281 "2021-05-20T07:53:37Z")

</div>

Here is my code, i have lakhs of document in transactions\_development index and in below code I am getting only 10 hits inside body but I want to fetch lakhs of hits const totalDebited = await esClient.search({ index: …

---

## [How to access term\_vectors (payloads) from painless script](https://discuss.elastic.co/t/how-to-access-term-vectors-payloads-from-painless-script/273481)

<div class="topic-metadata">

**Author:** [@JF2018](https://discuss.elastic.co/u/JF2018)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 7:30am UTC](https://discuss.elastic.co/t/how-to-access-term-vectors-payloads-from-painless-script/273481 "2021-05-20T07:30:35Z")

</div>

Hi I am using elastic 7.5.2. I have seen multiple examples on how to access term\_vectors (payloads) via groovy scripts. I though only have painless scripting available, so any help on how to access term\_vectors (payload…

---

## [Kibana Container Please run next command \`npm update caniuse-lite browserslist](https://discuss.elastic.co/t/kibana-container-please-run-next-command-npm-update-caniuse-lite-browserslist/273387)

<div class="topic-metadata">

**Author:** [@MdRashid](https://discuss.elastic.co/u/MdRashid)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 7:02am UTC](https://discuss.elastic.co/t/kibana-container-please-run-next-command-npm-update-caniuse-lite-browserslist/273387 "2021-05-20T07:02:14Z")

</div>

Hi All, i have issue with kibana container here is the logs of kibana mohd@master-node:~$ docker container logs fe5fe4f19954 {"type":"log","@timestamp":"2021-05-19T05:48:05Z","tags":\["info","optimize"\],"pid":1,"message…

---

## [Cpu utilization 100 percent - Elasticsearch](https://discuss.elastic.co/t/cpu-utilization-100-percent-elasticsearch/273291)

<div class="topic-metadata">

**Author:** [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)\
**Replies:** 4\
**Last updated:** [May 20, 2021, 7:23am UTC](https://discuss.elastic.co/t/cpu-utilization-100-percent-elasticsearch/273291 "2021-05-20T07:23:10Z")

</div>

My monitoring cluster is showing 99 percent Cpu usage during writes. Is it normal? If it's a 4 cpu node, does it mean that max is 400 percent?

---

## [Event based data pushing](https://discuss.elastic.co/t/event-based-data-pushing/273478)

<div class="topic-metadata">

**Author:** [@Abhishek\_Chauhan](https://discuss.elastic.co/u/Abhishek_Chauhan)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 7:22am UTC](https://discuss.elastic.co/t/event-based-data-pushing/273478 "2021-05-20T07:22:14Z")

</div>

Hello guys, I have deployed logstash to push data from postgres to elasticsearch but as the quantity of data has increased, pushing thousands of rows(all data in that db) every 60 seconds just for a small change or addi…

---

## [Load more than 1 million row from SQL Server to ES with Logstash JDBC](https://discuss.elastic.co/t/load-more-than-1-million-row-from-sql-server-to-es-with-logstash-jdbc/273476)

<div class="topic-metadata">

**Author:** [@Dai\_Thai\_Hoa\_Vo](https://discuss.elastic.co/u/Dai_Thai_Hoa_Vo)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 7:06am UTC](https://discuss.elastic.co/t/load-more-than-1-million-row-from-sql-server-to-es-with-logstash-jdbc/273476 "2021-05-20T07:06:36Z")

</div>

Hi every onne. I have a trouble when load the tables SalesTrans has more than 1 million rows. I used logstash to load them into ES. It works fine but very slow. Please any one support to me. Thank you.

---

## [Grok make log missing](https://discuss.elastic.co/t/grok-make-log-missing/273255)

<div class="topic-metadata">

**Author:** [@DawitCh](https://discuss.elastic.co/u/DawitCh)\
**Replies:** 4\
**Last updated:** [May 20, 2021, 6:53am UTC](https://discuss.elastic.co/t/grok-make-log-missing/273255 "2021-05-20T06:53:07Z")

</div>

Here is my example log \<134\>May 24 17:15:52 asdsgag.com 1,yyyy/mm/dd 17:15:52,001801056715,TRAFFIC,end,1,yyyy/mm/dd 17:15:52,xxx.xxx.xxx.xxx,xxx.xxx.xxx.xxx,0.0.0.0,0.0.0.0,TEST,,,incomplete,local1,wifi,office,cd5.32,rt…

---

## [Index Patterns containing frozen indices](https://discuss.elastic.co/t/index-patterns-containing-frozen-indices/273471)

<div class="topic-metadata">

**Author:** [@leemase004](https://discuss.elastic.co/u/leemase004)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 5:52am UTC](https://discuss.elastic.co/t/index-patterns-containing-frozen-indices/273471 "2021-05-20T05:52:58Z")

</div>

We have noticed on our system that our search\_throttled thread pool has an extremely high number of rejected request. Each node has about ~4k-6k. To my understanding, the search\_throttled thread pool is reserved specifi…

---

## [How to link HunSpell files \`.dic\` and \`.aff\` separately to stemmer config?](https://discuss.elastic.co/t/how-to-link-hunspell-files-dic-and-aff-separately-to-stemmer-config/273329)

<div class="topic-metadata">

**Author:** [@GokulNC](https://discuss.elastic.co/u/GokulNC)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 5:45am UTC](https://discuss.elastic.co/t/how-to-link-hunspell-files-dic-and-aff-separately-to-stemmer-config/273329 "2021-05-20T05:45:08Z")

</div>

Question: In HunSpell Token-Filter Analyzer (for Dictionary-based Stemming), while configuring its parameters, is it possible to specify separate full-paths for .dic and .aff files instead of having to set a common dire…

---

## [Why does Logstash's https communication work without OpenSSL?](https://discuss.elastic.co/t/why-does-logstashs-https-communication-work-without-openssl/273460)

<div class="topic-metadata">

**Author:** [@TakaSeki](https://discuss.elastic.co/u/TakaSeki)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 5:25am UTC](https://discuss.elastic.co/t/why-does-logstashs-https-communication-work-without-openssl/273460 "2021-05-20T05:25:19Z")

</div>

I'm running logstash using docker on CentOS7. Openssl is not installed on CentOS 7 and docker containers. However, logstash input https communication is working. Why is this? Does logstash include openssl functionali…

---

## [Display piechart](https://discuss.elastic.co/t/display-piechart/273463)

<div class="topic-metadata">

**Author:** [@gregory7](https://discuss.elastic.co/u/gregory7)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 4:21am UTC](https://discuss.elastic.co/t/display-piechart/273463 "2021-05-20T04:21:41Z")

</div>

Hi, I'm trying to display pie chart, but little guide for me, so I'm asking your help. I built up elasticsearch index as follows {id:1,group:fruit,item:apple,sold:Y,yymm:202105} {id:2,group:fruit,item:banana,sold:Y,y…

---

## [Azure App Services to ELK](https://discuss.elastic.co/t/azure-app-services-to-elk/273327)

<div class="topic-metadata">

**Author:** [@madmunki](https://discuss.elastic.co/u/madmunki)\
**Replies:** 15\
**Last updated:** [May 20, 2021, 4:31am UTC](https://discuss.elastic.co/t/azure-app-services-to-elk/273327 "2021-05-20T04:31:49Z")

</div>

I currently manage more than 50 Azure App Services and looking for a solution to collect the logs and put them where devs can look at the logs and troubleshoot issues. If I go into the App Log Stream, it displays what I …

---

## [Help with http http\_poller input plugin](https://discuss.elastic.co/t/help-with-http-http-poller-input-plugin/273226)

<div class="topic-metadata">

**Author:** [@jeromeat](https://discuss.elastic.co/u/jeromeat)\
**Replies:** 2\
**Last updated:** [May 20, 2021, 3:28am UTC](https://discuss.elastic.co/t/help-with-http-http-poller-input-plugin/273226 "2021-05-20T03:28:11Z")

</div>

I can pull json data using the following curl command successfully: curl -H "Api-Token: xxxxxxxxxx" -H "Api-Secret: xxxxxxxxxxxxxxx" https://site.cyz10.local:443/api/v1/tags?page=1&page\_size=10&type=ip Below is the con…

---

## [Elasticsearch slow query log pattern too big](https://discuss.elastic.co/t/elasticsearch-slow-query-log-pattern-too-big/273462)

<div class="topic-metadata">

**Author:** [@Izek](https://discuss.elastic.co/u/Izek)\
**Replies:** 0\
**Last updated:** [May 20, 2021, 2:15am UTC](https://discuss.elastic.co/t/elasticsearch-slow-query-log-pattern-too-big/273462 "2021-05-20T02:15:55Z")

</div>

I try to debug on the slow query but found out that all the slow query logs pattern are corrupt and cannot be parse by filebeat. Is there any way to increase the pattern size Below is the example, I cut most of the det…

---

## [The problems of memory of ES7.12](https://discuss.elastic.co/t/the-problems-of-memory-of-es7-12/273461)

<div class="topic-metadata">

**Author:** [@lichuandev](https://discuss.elastic.co/u/lichuandev)\
**Replies:** 1\
**Last updated:** [May 20, 2021, 2:10am UTC](https://discuss.elastic.co/t/the-problems-of-memory-of-es7-12/273461 "2021-05-20T02:10:04Z")

</div>

I use ES to store files, and the size of each file is within 100kb. The following two problems encountered in the use process have not been solved: 1.We set the requests cache: false, and the memory will still slowly re…

---

## [Error 403 Forbidden when connect to Microsoft Defender API](https://discuss.elastic.co/t/error-403-forbidden-when-connect-to-microsoft-defender-api/273232)

<div class="topic-metadata">

**Author:** [@ismyhairnice](https://discuss.elastic.co/u/ismyhairnice)\
**Replies:** 0\
**Last updated:** [May 18, 2021, 6:00am UTC](https://discuss.elastic.co/t/error-403-forbidden-when-connect-to-microsoft-defender-api/273232 "2021-05-18T06:00:29Z")

</div>

Hi all I am trying to connect to Microsoft Defender API using Elastic Filebeat. I followed the instructions here https://docs.microsoft.com/en-us/microsoft-365/security/defender-endpoint/exposed-apis-create-app-webapp?v…

---

## [Best practices/recommendations for structuring log indices for a lot of apps](https://discuss.elastic.co/t/best-practices-recommendations-for-structuring-log-indices-for-a-lot-of-apps/273254)

<div class="topic-metadata">

**Author:** [@lancer\_enkor](https://discuss.elastic.co/u/lancer_enkor)\
**Replies:** 1\
**Last updated:** [May 20, 2021, 1:52am UTC](https://discuss.elastic.co/t/best-practices-recommendations-for-structuring-log-indices-for-a-lot-of-apps/273254 "2021-05-20T01:52:32Z")

</div>

Hi, I'm building an ES cluster for application logs. The problem is that we have a lot of apps and a lot of environments. Every app and every env can have different retention times, so I can have let say over 100 apps t…

---

## [Using Keystores - not working (v6.6.0)](https://discuss.elastic.co/t/using-keystores-not-working-v6-6-0/273362)

<div class="topic-metadata">

**Author:** [@anaconda2196](https://discuss.elastic.co/u/anaconda2196)\
**Replies:** 1\
**Last updated:** [May 20, 2021, 1:49am UTC](https://discuss.elastic.co/t/using-keystores-not-working-v6-6-0/273362 "2021-05-20T01:49:58Z")

</div>

Hello, I'm trying to use a keystore value in my metricbeatbeat configuration and I can't seem to get it working... I have created initContainer in that I am just creating keystore and add my elasticsearch password in E…

---

## [How to perform nested aggregation in child parent relationship](https://discuss.elastic.co/t/how-to-perform-nested-aggregation-in-child-parent-relationship/273372)

<div class="topic-metadata">

**Author:** [@Waseem\_Farooqui](https://discuss.elastic.co/u/Waseem_Farooqui)\
**Replies:** 0\
**Last updated:** [May 19, 2021, 8:02am UTC](https://discuss.elastic.co/t/how-to-perform-nested-aggregation-in-child-parent-relationship/273372 "2021-05-19T08:02:52Z")

</div>

Hi, I am using elasticsearch 7.11 and have implemented parent child relation on of the base reason was my updates were very frequent and time a new child could be added under 1 parent, My project is something managing …

---

## [Getting error while setting up alters system in kibana](https://discuss.elastic.co/t/getting-error-while-setting-up-alters-system-in-kibana/273449)

<div class="topic-metadata">

**Author:** [@Umesh\_Kumar\_Sah](https://discuss.elastic.co/u/Umesh_Kumar_Sah)\
**Replies:** 1\
**Last updated:** [May 19, 2021, 11:08pm UTC](https://discuss.elastic.co/t/getting-error-while-setting-up-alters-system-in-kibana/273449 "2021-05-19T23:08:47Z")

</div>

Can anyone plz help me out this issue? May 20 02:41:18 devopsengineering systemd\[1\]: kibana.service: Scheduled restart job, restart counter is at 1. May 20 02:41:18 devopsengineering systemd\[1\]: Stopped Kibana. May 20…

---

## [SSL certificate in email output plugin logstash](https://discuss.elastic.co/t/ssl-certificate-in-email-output-plugin-logstash/273450)

<div class="topic-metadata">

**Author:** [@jrojasp95](https://discuss.elastic.co/u/jrojasp95)\
**Replies:** 4\
**Last updated:** [May 19, 2021, 10:20pm UTC](https://discuss.elastic.co/t/ssl-certificate-in-email-output-plugin-logstash/273450 "2021-05-19T22:20:38Z")

</div>

Hi I am trying to use the email output plugin in logstash but I can't get it to work on the server with docker, on localhost it works with port 587 but on the server I get an OpenSSL hostname not match with ssl certifica…

[Previous page](https://discuss.elastic.co/c/elastic-stack/81.md?page=1406)

[Next page](https://discuss.elastic.co/c/elastic-stack/81.md?page=1408)
