Plugin health check failed on create datasource

[silentsokolov]

What happened:
We cannot create datasource, after click "Save & Test" get error "Plugin health check failed"

What you expected to happen:
Datasource created

How to reproduce it (as minimally and precisely as possible):

Grafana helm values:

plugins:
  - grafana-clickhouse-datasource
  # - https://grafana.com/api/plugins/grafana-clickhouse-datasource/versions/4.0.0-beta/download;grafana-clickhouse-datasource

grafana.ini:
  paths:
    data: /var/lib/grafana/
    logs: /var/log/grafana
    plugins: /var/lib/grafana/plugins
    provisioning: /etc/grafana/provisioning
  log:
    mode: console
  dataproxy:
    timeout: 6000
    keep_alive_seconds: 300

Connect creds:

github.demo.trial.altinity.cloud:8443
demo:demo

We also used our creds ... the same error

Screenshots

Environment:

• Grafana version: Grafana v10.3.1 (00a22ff8b2)
• Plugin version: stable & 4.0.0-beta
• OS Grafana is installed on: -
• User OS & Browser: firefox / chrome

[SpencerTorres]

Hello! Thank you for submitting a detailed issue, I was able to easily reproduce this.

It's unfortunate that the UI error isn't as detailed, this is something I want to change in a future update. However, it does appear the underlying error gets returned to the browser in the network log. I also verified this to be the error in the plugin logs:

health check failed:
rpc error: code = Unknown desc = clickhouse
[execute]:: 500 code: Code: 452.
DB::Exception: Setting max_execution_time should not be changed. (SETTING_CONSTRAINT_VIOLATION)
(version 23.12.2.59 (official build))

It appears the query timeout is being set to a number that violates the setting constraint. Setting the "query timeout" to 0 seems to fix it. I was also able to get it to work by setting it to 1 (I assume the demo server wants to prevent queries that run longer than 1 second)

Let me know if this fixes your issue. I'll make note about enhancing the error feedback. Thanks!

[silentsokolov]

Yep, this setting fixes the error.

[Habeeb556]

Hello! Thank you for submitting a detailed issue, I was able to easily reproduce this.

It's unfortunate that the UI error isn't as detailed, this is something I want to change in a future update. However, it does appear the underlying error gets returned to the browser in the network log. I also verified this to be the error in the plugin logs:

health check failed:
rpc error: code = Unknown desc = clickhouse
[execute]:: 500 code: Code: 452.
DB::Exception: Setting max_execution_time should not be changed. (SETTING_CONSTRAINT_VIOLATION)
(version 23.12.2.59 (official build))

It appears the query timeout is being set to a number that violates the setting constraint. Setting the "query timeout" to 0 seems to fix it. I was also able to get it to work by setting it to 1 (I assume the demo server wants to prevent queries that run longer than 1 second)

Let me know if this fixes your issue. I'll make note about enhancing the error feedback. Thanks!

Same issue here, and this setting resolved the error.

[shqnayaz]

@Habeeb556 @SpencerTorres , I have a same problem, I am unable to locate where is the query timeout settings in grafana,
please advice.

[Habeeb556]

@shqnayaz open the "Additional settings" in the data source.