Not work Grafana v8.0.6

[sonfire186]

Im used time series and graph(old) the error is the same

SELECT
    $timeSeries as t,
    countryISO,
    count()
FROM $table

WHERE $timeFilter

GROUP BY
    t,
    countryISO
ORDER BY t, countryISO

Error

Grafana v8.0.6
Vertamedia v2.3.1

[Slach]

could you open "Generated SQL" and try to run it from clickhouse-client?

could you share your connection settings?
look like grafana can't connect to your clickhouse-server
and don't depends on grafana version

[sonfire186]

could you open "Generated SQL" and try to run it from clickhouse-client?

It works
grafana is connected to clickhouse is 100%

[sonfire186]

with grafana 7.5 everything works

[Slach]

could you try to set up the GF_LOG_LEVEL=debug environment variable or setup level=debug in [log] section on grafana.ini file inside the grafana server and share grafana logs?

[sonfire186]

could you try to set up the GF_LOG_LEVEL=debug environment variable or setup level=debug in [log] section on grafana.ini file inside the grafana server and share grafana logs?

t=2021-07-15T10:43:37+0500 lvl=dbug msg="Received unknown frontend metric" logger=context userId=1 orgId=1 uname=admin metric=frontend_boot_first_contentful_paint_time_seconds
t=2021-07-15T10:43:37+0500 lvl=dbug msg="Found old rendered file to delete" logger=cleanup folder=/var/lib/grafana/png deleted=0 kept=0
t=2021-07-15T10:43:37+0500 lvl=dbug msg="Found old rendered file to delete" logger=cleanup folder=/var/lib/grafana/csv deleted=0 kept=0
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Deleted expired snapshots" logger=cleanup rows affected=0
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Deleted old/expired dashboard versions" logger=cleanup rows affected=0
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Deleted excess annotations" logger=cleanup annotations affected=0 annotation tags affected=0
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Expired user invites" logger=cleanup rows affected=0
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Deleted short urls" logger=cleanup rows affected=0
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Deleted expired login attempts" logger=cleanup rows affected=0
t=2021-07-15T10:43:38+0500 lvl=warn msg="Request Origin is not authorized" logger=live origin=http://mob-click-dev.taximaxim.local:3000 appUrl=http://localhost:3000/ allowedOrigins=
t=2021-07-15T10:43:38+0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/live/ws status=403 remote_addr=10.145.217.166 time_ms=1 size=10 referer=
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Checking for updates" logger=plugins
t=2021-07-15T10:43:38+0500 lvl=dbug msg="Scheduling update" logger=alerting.scheduler ruleCount=0
t=2021-07-15T10:43:48+0500 lvl=dbug msg="Scheduling update" logger=alerting.scheduler ruleCount=0
t=2021-07-15T10:43:51+0500 lvl=warn msg="Request Origin is not authorized" logger=live origin=http://mob-click-dev.taximaxim.local:3000 appUrl=http://localhost:3000/ allowedOrigins=
t=2021-07-15T10:43:51+0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/live/ws status=403 remote_addr=10.145.217.166 time_ms=1 size=10 referer=
t=2021-07-15T10:43:54+0500 lvl=warn msg="Request Origin is not authorized" logger=live origin=http://mob-click-dev.taximaxim.local:3000 appUrl=http://localhost:3000/ allowedOrigins=
t=2021-07-15T10:43:54+0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/live/ws status=403 remote_addr=10.145.217.166 time_ms=2 size=10 referer=
t=2021-07-15T10:43:58+0500 lvl=eror msg="Data proxy error" logger=data-proxy-log userId=1 orgId=1 uname=admin path=/api/datasources/proxy/1/ remote_addr=10.84.13.139 referer="http://mob-click-dev.taximaxim.local:3000/d/7V46gYinz/predlozhenie-zakazov?orgId=1" error="http: proxy error: net/http: timeout awaiting response headers"
t=2021-07-15T10:43:58+0500 lvl=eror msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/datasources/proxy/1/ status=502 remote_addr=10.84.13.139 time_ms=30031 size=0 referer="http://mob-click-dev.taximaxim.local:3000/d/7V46gYinz/predlozhenie-zakazov?orgId=1"
t=2021-07-15T10:43:58+0500 lvl=dbug msg="Scheduling update" logger=alerting.scheduler ruleCount=0

[Slach]

Hello @sonfire86, sorry for late response did you try 2.3.1 plugin with grafana 8.2?

[Slach]

origin=http://mob-click-dev.taximaxim.local:3000 appUrl=http://localhost:3000/ allowedOrigins=

look like do you use nginx + grafana instead of pure grafana?