[Bug] error while performing the infinity query. unable to parse response body as JSON. unexpected end of JSON input

[ricoroodenburg]

Describe the bug

error while performing the infinity query. unable to parse response body as JSON. unexpected end of JSON input

Steps to reproduce

Send a request to an API endpoint with some queries which returns nothing.

Note: bugs will be fixed only if enough information provided to reproduce the issue

Screenshots

Version Details:

• Grafana version : v11.5.1 (c6c701cf5b)
• Plugin version : 3.0.0-beta.1

[yesoreyeram]

Did it work before? Or never worked?

Seems like an issue with the url. Use query inspector to see what the outgoing URL looks like.. probably you need fix in either authentication or the url. You can also use health check section in the config to debug the issue.

If nothing works, send us a reproduction steps.

[ricoroodenburg]

It's definitely not an URL and authentication issue. This issue only occurs when receiving a 204 (no content) status code.
I don't have a public API which I can share with you unfortunately. Have you ever seen this before with an 204?

[ricoroodenburg]

@yesoreyeram can you help me further with this?

[Severus157]

I have a similar problem, with Version 2.12.2 and Grafana 10.4.2.
The plugin shows a similar error message:
Status: 500. Message: error while performing the infinity query. unexpected EOF
When I use the same curl copied from the Query Inspector from my terminal, it works.

$ curl -X 'GET' -H 'Accept: application/json;q=0.9,text/plain' 'http://[Internal_URL]/v1/core_usage' {"data": [{"hotcores": 11, "id": "ID", "misccores": 3}, {"hotcores": 3, "id": "ID", "misccores": 1}, {"hotcores": 9, "id": "ID", "misccores": 3}, {"hotcores": 2, "id": "ID", "misccores": 1}, {"hotcores": 15, "id": "ID", "misccores": 3}, {"hotcores": 2, "id": "ID", "misccores": 1}, {"hotcores": 3, "id": "ID", "misccores": 1}, {"hotcores": 10, "id": "ID", "misccores": 3}, {"hotcores": 2, "id": "ID", "misccores": 1}, {"hotcores": 8, "id": "ID", "misccores": 3}], "success": true, "error": ""}

From my testing, it looks like it cannot see, that the json ends there without a newline. Which is missing on some of these internal URLs. The ones which include a newline in the end, seems to work, but without one not.
Unfortunately we cannot change the internal URL currently to add a newline.

Is there any way to manipulate that it still works for the ones which provide json without a newline at the end?

[cbonami]

Same problem here.

Infinity Datasource v3.3.0
Grafana v12.0.2

Performing a PUT request. I'm using volkovlabs Business Form, but I think the problem is coming from Infinity datasource.

This is what the network tab in the browser tells me after the request is made:

{
    "results": {
        "": {
            "error": "error while performing the infinity query. unable to parse response body as JSON. unexpected end of JSON input",
            "errorSource": "downstream",
            "status": 500,
            "frames": [
                {
                    "schema": {
                        "name": "response",
                        "meta": {
                            "typeVersion": [
                                0,
                                0
                            ],
                            "custom": {
                                "data": null,
                                "duration": 25816530,
                                "error": "unable to parse response body as JSON. unexpected end of JSON input",
                                "query": {
                                    "alias": "",
                                    "columns": [],
                                    "computed_columns": [],
                                    "csv_options": {
                                        "columns": "",
                                        "comment": "",
                                        "delimiter": "",
                                        "relax_column_count": false,
                                        "skip_empty_lines": false,
                                        "skip_lines_with_error": false
                                    },
                                    "data": "",
                                    "dataOverrides": null,
                                    "expression": "",
                                    "filterExpression": "",
                                    "filters": [],
                                    "format": "table",
                                    "global_query_id": "",
                                    "groq": "",
                                    "json_options": {
                                        "columnar": false,
                                        "root_is_not_array": false
                                    },
                                    "parser": "backend",
                                    "query_mode": "",
                                    "refId": "",
                                    "root_selector": "",
                                    "seriesCount": 0,
                                    "source": "url",
                                    "summarizeAlias": "",
                                    "summarizeBy": "",
                                    "summarizeExpression": "",
                                    "type": "json",
                                    "uql": "",
                                    "url": "https://systst-everesst-acl.apps.okd4-dev.everesst.cegeka.com/v1/dead-letter-table",
                                    "url_options": {
                                        "body_content_type": "application/json",
                                        "body_form": null,
                                        "body_graphql_query": "",
                                        "body_graphql_variables": "",
                                        "body_type": "raw",
                                        "data": "{\"messageKey\": \"56464\", \"streamKey\": \"COMPANY\"}",
                                        "headers": [
                                            {
                                                "key": "Content-Type",
                                                "value": "application/json"
                                            },
                                            {
                                                "key": "accept",
                                                "value": "*/*"
                                            }
                                        ],
                                        "method": "PUT",
                                        "params": null
                                    }
                                },
                                "responseCodeFromServer": 200
                            },
                            "executedQueryString": "###############\n## URL\n###############\n\nhttps://systst-everesst-acl.apps.okd4-dev.everesst.cegeka.com/v1/dead-letter-table\n\n###############\n## Curl Command\n###############\n\ncurl -X 'PUT' -d '{\"messageKey\": \"56464\", \"streamKey\": \"COMPANY\"}' -H 'Accept: xxxxxxxx' -H 'Accept-Encoding: gzip' -H 'Content-Type: xxxxxxxx' 'https://systst-everesst-acl.apps.okd4-dev.everesst.cegeka.com/v1/dead-letter-table'\n###############\n\u003e Authentication steps not included for OAuth authentication"
                        },
                        "fields": []
                    },
                    "data": {
                        "values": []
                    }
                }
            ]
        }
    }
}

The requestr in the network tab is this:

{
  "queries": [
    {
      "columns": [],
      "filters": [],
      "format": "as-is",
      "global_query_id": "",
      "parser": "uql",
      "refId": "",
      "root_selector": "",
      "source": "url",
      "type": "json",
      "url": "https://systst-everesst-acl.apps.okd4-dev.everesst.cegeka.com/v1/dead-letter-table",
      "url_options": {
        "body_content_type": "application/json",
        "body_type": "raw",
        "data": "{\"messageKey\": \"465454\",\"streamKey\": \"COMPANY\"}",
        "headers": [
          {
            "key": "Content-Type",
            "value": "application/json"
          },
          {
            "key": "accept",
            "value": "*/*"
          }
        ],
        "method": "PUT",
        "body_form": [],
        "body_graphql_query": "",
        "body_graphql_variables": ""
      },
      "uql": "",
      "datasource": {
        "type": "yesoreyeram-infinity-datasource",
        "uid": "inf_everesst_systst"
      },
      "datasourceId": 1
    }
  ]
}

The headers that I'm passing with the PUT-request:

• Content-Type: application/json
• accept: /

This request should perfectly work, as it works from Swagger client:

The Infinity datasource uses OAuth2, but I guess that's not the problem, as a simple GET-call works elsewhere in the dashboard:

[cbonami]

Aha ... the content-length of the response is 0. So there's indeed no JSON returning. Still the Infinity datasource expects JSON in the response and wants to parse it.

So we have to find a way to tell to Infinity to NOT parse the response.

[yesoreyeram]

Infinity older versions doesn't support PUT. Only the latest version support that but behind the config flag. Check change log for more details