# The result of "metricbeat test modules sql" has timeout failure when the query does not have any output

**URL:** <https://discuss.elastic.co/t/the-result-of-metricbeat-test-modules-sql-has-timeout-failure-when-the-query-does-not-have-any-output/316874>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [October 18, 2022, 9:57am UTC](https://discuss.elastic.co/t/the-result-of-metricbeat-test-modules-sql-has-timeout-failure-when-the-query-does-not-have-any-output/316874 "2022-10-18T09:57:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![donald\_b90](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@donald\_b90](https://discuss.elastic.co/u/donald_b90)\
**Post date:** [October 18, 2022, 9:57am UTC](https://discuss.elastic.co/t/the-result-of-metricbeat-test-modules-sql-has-timeout-failure-when-the-query-does-not-have-any-output/316874/1 "2022-10-18T09:57:12Z")

</div>

Hi All,  
First of all, I appreciate your attention in advance.  
Since, I am new in using ELK Stack, I have one question. I have one simple query in my sql.yml file which returns no records (The sql module is enabled).  
// for example  
//select Col1, Col2 from table where 1=2

The above statement clearly will not return anything, but just suppose my query in some cases may return one record, and in some cases does not have any output.

Everything works well, when we have at least one record. but the "metricbeat test modules sql" command fails when we don't have any output, and the columns cannot be found in discover part, so we cannot put them into a dashboard.

Any comment is appreciated.

Many Thanks

---

<div class="post-metadata">

**Author:** ![donald\_b90](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@donald\_b90](https://discuss.elastic.co/u/donald_b90)\
**Post date:** [October 18, 2022, 3:01pm UTC](https://discuss.elastic.co/t/the-result-of-metricbeat-test-modules-sql-has-timeout-failure-when-the-query-does-not-have-any-output/316874/2 "2022-10-18T15:01:32Z")

</div>

I mean, do we have a parameter or something to make the query without output acceptable for "metricbeat test modules sql " command ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 15, 2022, 3:01pm UTC](https://discuss.elastic.co/t/the-result-of-metricbeat-test-modules-sql-has-timeout-failure-when-the-query-does-not-have-any-output/316874/3 "2022-11-15T15:01:49Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.