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
→ 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?
I localized the root cause for this behavior with version 8.x:
By setting Min time interval to default value the dashboards are again
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.
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?
I have the same issue with MySQL data source.
I’m using the below dashboard for MySQL DB
I have the same problem with Grafana 8.1.3 and Postgres datasource.
Error updating options: Query error: 400
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
This topic was automatically closed after 365 days. New replies are no longer allowed.