# Query SQL failed: Internal Server Error

**URL:** <https://discuss.elastic.co/t/query-sql-failed-internal-server-error/213124>\
**Category:** Kibana\
**Created:** [December 27, 2019, 3:37am UTC](https://discuss.elastic.co/t/query-sql-failed-internal-server-error/213124 "2019-12-27T03:37:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jun\_Zhang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jun_zhang/32/25863_2.png) [@Jun\_Zhang](https://discuss.elastic.co/u/Jun_Zhang)\
**Post date:** [December 27, 2019, 3:37am UTC](https://discuss.elastic.co/t/query-sql-failed-internal-server-error/213124/1 "2019-12-27T03:37:42Z")

</div>

Elasticsearch & Kibana Version: 7.5.1

Query SQL like:

```
POST /_sql?format=txt
{
    "query": """ 
     DESCRIBE "metricbeat-7.2.0-2019.12.26-000001"
    """
}

```

response:

```
{
  "statusCode": 500,
  "error": "Internal Server Error",
  "message": "An internal server error occurred"
}

```

Kibana logs:

> Debug: internal, implementation, error  
> Error: Cannot throw non-error object  
> at module.exports.internals.Manager.execute (/usr/share/kibana/node\_modules/hapi/lib/toolkit.js:42:33)  
> at process.\_tickCallback (internal/process/next\_tick.js:68:7)  
> {"type":"error","@timestamp":"2019-12-27T03:26:06Z","tags":,"pid":6,"level":"error","error":{"message":"Cannot throw non-error object","name":"Error","stack":"Error: Cannot thr  
> ow non-error object\n at module.exports.internals.Manager.execute (/usr/share/kibana/node\_modules/hapi/lib/toolkit.js:42:33)\n at process.\_tickCallback (internal/process/ne  
> xt\_tick.js:68:7)"},"url":{"protocol":null,"slashes":null,"auth":null,"host":null,"port":null,"hostname":null,"hash":null,"search":"?path=%2F\_sql%3Fformat%3Dtxt&method=POST","quer  
> y":{"path":"/\_sql?format=txt","method":"POST"},"pathname":"/api/console/proxy","path":"/api/console/proxy?path=%2F\_sql%3Fformat%3Dtxt&method=POST","href":"/api/console/proxy?path  
> =%2F\_sql%3Fformat%3Dtxt&method=POST"},"message":"Cannot throw non-error object"}  
> {"type":"response","@timestamp":"2019-12-27T03:26:06Z","tags":["access:console"],"pid":6,"method":"post","statusCode":500,"req":{"url":"/api/console/proxy?path=%2F\_sql%3Fformat%3  
> Dtxt&method=POST","method":"post","headers":{"host":"172.27.129.111:5601","connection":"keep-alive","content-length":"88","accept":"text/plain, _/_; q=0.01","origin":"[http://172](http://172).  
> 27.129.111:5601","kbn-version":"7.5.1","user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10\_15\_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36","co  
> ntent-type":"application/json","referer":"[http://172.27.129.111:5601/app/kibana","accept-encoding":"gzip](http://172.27.129.111:5601/app/kibana%22,%22accept-encoding%22:%22gzip), deflate","accept-language":"zh-CN,zh;q=0.9,en;q=0.8"},"remoteAddress":"1  
> 72.27.160.87","userAgent":"172.27.160.87","referer":"[http://172.27.129.111:5601/app/kibana"},"res":{"statusCode":500,"responseTime":121,"contentLength":9},"message":"POST](http://172.27.129.111:5601/app/kibana%22%7D,%22res%22:%7B%22statusCode%22:500,%22responseTime%22:121,%22contentLength%22:9%7D,%22message%22:%22POST) /api/co  
> nsole/proxy?path=%2F\_sql%3Fformat%3Dtxt&method=POST 500 121ms - 9.0B"}

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [December 27, 2019, 11:20am UTC](https://discuss.elastic.co/t/query-sql-failed-internal-server-error/213124/2 "2019-12-27T11:20:42Z")

</div>

@Jun_Zhang are there any error messages in Elasticsearch's own logs?  
Do you get the same error when not using Kibana?

---

<div class="post-metadata">

**Author:** ![kingsleyum](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@kingsleyum](https://discuss.elastic.co/u/kingsleyum)\
**Post date:** [January 2, 2020, 9:12pm UTC](https://discuss.elastic.co/t/query-sql-failed-internal-server-error/213124/3 "2020-01-02T21:12:51Z")

</div>

Had same Error.. turns out a member of my cluster was down.

---

<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:** [January 30, 2020, 9:12pm UTC](https://discuss.elastic.co/t/query-sql-failed-internal-server-error/213124/4 "2020-01-30T21:12:51Z")

</div>

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