"Error updating options: Query error: 400 Bad Request" after upgrade to 8.x

[pecs]

• What Grafana version and what operating system are you using?
  → Grafana 8.0.1 on Windows Server

• What are you trying to achieve?
  → Update system from 7.5.4 to 8.0.1

• How are you trying to achieve it?
  → Update based on Upgrade Grafana | Grafana documentation

• What happened?
  → MSSQL based Dashboard shows error
  → Dashboard variables can’t be initialized
  ("Error updating options: Query error: 400 Bad Request)
  → variable query looks like "select distinct project from work_items_pr ]

• What did you expect to happen?
  → no error like in version 7.5.4

• Can you copy/paste the configuration(s) that you are having problems with?
  ???

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  → yes: “Error updating options: Query error: 400 Bad Request”
  

  

• Did you follow any online instructions? If so, what is the URL?
  ???

[pecs]

I localized the root cause for this behavior with version 8.x:

By setting Min time interval to default value the dashboards are again

[mattabrams]

hi @pecs,

Glad you got this working. There are several patches that were released in 8.0.1 and 8.0.2 that dealt with SQL issues. If this returns, I’d try upgrading and testing again.

[shrakhimov]

Hi!

I have the same issue with a Postgres datasource.
The variables are failed with “Error updating options: Query error: 400 Bad Request”
In the datasource settings, the interval is set to default.
When I click “Save & Test” the datasource is happy.

Does anyone know what the issue could be?

[enggal17]

Hi,

I have the same issue with MySQL data source.

I’m using the below dashboard for MySQL DB

2MySQL Simple Dashboard | Grafana Labs

Thanks

[perttuh]

Hi,

I have the same problem with Grafana 8.1.3 and Postgres datasource.

Templating [variable]
Error updating options: Query error: 400

[ajithravindranathan]

if I am using a data source configuration file(yaml) to configure the default source what attribute represents Minimum time interval in the data source. Would it be “time interval” as defined here, Provisioning | Grafana Labs under the JsonData section

By the way I am using a docker container to run Grafana and volume mounts the configuration

apiVersion: 1

datasources:
  - name: PostgreSQL
    type: postgres
    url: 192.168.71.140:5432
    database: mydb 
    user: mydb
    secureJsonData:
      password: "xxxxxxxx"
    jsonData:
      sslmode: "disable" 
      postgresVersion: 1200
      timescaledb: true