Query SQL failed: Internal Server Error

Elastic Stack Kibana
1

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.
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, 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 /api/co
nsole/proxy?path=%2F_sql%3Fformat%3Dtxt&method=POST 500 121ms - 9.0B"}

2

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

3

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

4

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