v4.9.0 seems broken with grafana 10.1.0

[vanja-p]

What happened:

Since 4.9.0 released yesterday, I haven't been able to query ClickHouse from Grafana. Any query, even just SHOW TABLES results in the error SQLDatasourceMaxOpenConnsDefault not set in config.

Screenshot:

The logs include lines like
logger=plugin.grafana-clickhouse-datasource t=2025-05-23T03:32:10.237184461Z level=error msg="Partial data response error" dsName=ClickHouse dsUid=clickhouse endpoint=queryData error="SQLDatasourceMaxOpenConnsDefault not set in config" uname= pluginId=grafana-clickhouse-datasource refID=0.322196045463234 status=500 statusSource=downstream

The same thing happens if I open the data source page, and click the "Test" button.

What you expected to happen:
Queries work as before

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

• Run grafana 10.1.0 with GF_INSTALL_PLUGINS=grafana-clickhouse-datasource
• Open grafana in chrome
• Open the developer console
• Open "Explore" and select the ClickHouse data source
• The last request in the developer console fails with the above error.
• Trying to do queries results in the same error.

Anything else we need to know?:

I can't easily upgrade the version of Grafana that we deploy. Also, since I'm using an older version, the GF_PLUGINS_PREINSTALL env variable isn't supported. That's unfortunate since it allows pinning a plugin to a specific version.

Instead, I need to use GF_INSTALL_PLUGINS, which makes Grafana fail to start with Plugin not found if I try to add the suffix @4.8.2.

Also, If I locally run a later version of Grafana, like 11.6.0, with the plugin version 4.9.0, I get a different error: error querying the database: code: 164, message: Cannot modify 'limit' setting in readonly mode. Screenshot:

This error goes away if I roll back to plugin version 4.8.2 using the env variable GF_PLUGINS_PREINSTALL=grafana-clickhouse-datasource@4.8.2.

Environment:

• Grafana version: 10.1.0
• Plugin version: 4.9.0
• OS Grafana is installed on: Ubuntu
• User OS & Browser: Ubuntu & Chrome
• Others:

[navinpai]

+1 seeing the same issue.

Grafana version: 10.4.0
Plugin version: 4.9.0

Also, if you install version 4.8.2 and then upgrade to 4.9.0 I think issue doesn't show up. Only comes up if you in initialize with 4.9.0

[madworx]

+1 same issue. Grafana 10.1.4, plugin 4.9.0.

[SpencerTorres]

Appreciate the feedback everyone, hopefully we can get this patched quick. Looks like a permission issue with applying the setting from #1215? Perhaps we can disable this if the permissions aren't available.

[ozlevka-work]

+1
Same issue.
At the moment we changed readonly profile to 2
But it is not all time suitable solution.
Pls fix the backward compatibility

[PixiBixi]

+1 have the same issue.

You can specify plugin version like this :

plugins:
  - grafana-clickhouse-datasource 4.8.2 # 4.9.0 is bugged

(syntax for helm chart)