Closed Mrzzzzz closed 3 months ago
Mrzzzzz
commented
4 months ago
An unexpected error happened
详情
Error: Minified React error #31; visit https://reactjs.org/docs/error-decoder.html?invariant=31&args[]=object%20with%20keys%20%7Bcode%2C%20message%7D for the full message or use the non-minified dev environment for full errors and additional helpful warnings.
Mrzzzzz
commented
4 months ago grafana version 10.0.3 Altinity plugin for ClickHouse 3.0.0
Mrzzzzz
commented
4 months ago 
Slach
commented
4 months ago According to shared screenshots everything should be ok.
Could you try with latest pre-release? You need download https://github.com/Altinity/clickhouse-grafana/releases/download/v3.0.3/vertamedia-clickhouse-datasource-3.0.3.zip into /var/lib/grafana/plugins/vertamedia-clickhouse-datasource/ and restart grafana-server
something like that
wget https://github.com/Altinity/clickhouse-grafana/releases/download/v3.0.3/vertamedia-clickhouse-datasource-3.0.3.zip -q -O - | sudo unzip -d /var/lib/grafana/plugins/vertamedia-clickhouse-datasource/ -q
sudo chown grafana -R /var/lib/grafana/plugins/vertamedia-clickhouse-datasource
systemctl restart grafana-serveror using grafana cli interface
grafana cli --pluginUrl https://github.com/Altinity/clickhouse-grafana/releases/download/v3.0.3/vertamedia-clickhouse-datasource-3.0.3.zip plugins install vertamedia-clickhouse-datasourceAccording to shared screenshots everything should be ok.
Could you try with latest pre-release? You need download https://github.com/Altinity/clickhouse-grafana/releases/download/v3.0.3/vertamedia-clickhouse-datasource-3.0.3.zip into /var/lib/grafana/plugins/vertamedia-clickhouse-datasource/ and restart grafana-server
something like that
wget https://github.com/Altinity/clickhouse-grafana/releases/download/v3.0.3/vertamedia-clickhouse-datasource-3.0.3.zip -q -O - | sudo unzip -d /var/lib/grafana/plugins/vertamedia-clickhouse-datasource/ -q sudo chown grafana -R /var/lib/grafana/plugins/vertamedia-clickhouse-datasource systemctl restart grafana-serveror using grafana cli interface
grafana cli --pluginUrl https://github.com/Altinity/clickhouse-grafana/releases/download/v3.0.3/vertamedia-clickhouse-datasource-3.0.3.zip plugins install vertamedia-clickhouse-datasource
Upgraded or the same error
Mrzzzzz
commented
4 months ago Does it not support databend database queries
Slach
commented
4 months ago Are you use clickhouse compatible https://github.com/datafuselabs/databend ?
Is databend support HTTP protocol for queries?
Mrzzzzz
commented
4 months ago 您是否使用与 clickhouse 兼容的https://github.com/datafuselabs/databend？
是否
databend支持HTTP协议查询？
Yes, you can already search for the outbound list in the picture, but clicking on the query results in an error
Slach
commented
4 months ago Could you press CTRL+SHIFT+I -> Network tab and try to find request and response from grafana to grafana backend dataproxy is return 200 code with properly result?
moreover, could you share
curl -vvv "http://databend:your-password@databend-query:8124/?query=SELECT version()"databend-query:8124
{"error":{"code":"400","message":"UnknownFunction. Code: 1008, Text = error: \n --> SQL:1:16\n |\n1 | SELECT (intDiv(toUInt32(undefined), 2) 2) 1000 as t, count() FROM default.employee_data WHERE undefined >= toDateTime(1713424120) AND undefined <= toDateTime(1713427720) GROUP BY t ORDER BY t FORMAT JSON\n | ^^^^^^^^^^^^^^^^^^^ no function matches the given name: 'touint32', do you mean 'to_uint32', 'to_int32', 'to_uint8', 'try_to_uint32', 'to_uint16', 'to_uint64', 'to_int8'?\n\n."}}
Mrzzzzz
commented
4 months ago curl -vvv "http://databend:your-password@databend-query:8124/?query=SELECT version()"
Slach
commented
4 months ago no function matches the given name: 'touint32', do you mean 'to_uint32', 'to_int32', 'to_uint8', 'try_to_uint32', 'to_uint16', 'to_uint64', 'to_int8'?
It means databend doesn't support standard clickhouse functions like toUInt32 and have different SQL dialect, and can't be used as source server for ClickHouse plugin execution
check
curl -vvv "http://databend:your-password@databend-query:8124/?query=SELECT+toUInt32(1)"and better create issue in https://github.com/datafuselabs/databend/issues in this case
I will try to reproduce it later
Mrzzzzz
commented
4 months ago no function matches the given name: 'touint32', do you mean 'to_uint32', 'to_int32', 'to_uint8', 'try_to_uint32', 'to_uint16', 'to_uint64', 'to_int8'?
It means
databenddoesn't support standard clickhouse functions liketoUInt32and have different SQL dialect, and can't be used as source server for ClickHouse plugin executioncheck
curl -vvv "http://databend:your-password@databend-query:8124/?query=SELECT+toUInt32(1)"and better create issue in https://github.com/datafuselabs/databend/issues in this case
I will try to reproduce it later
ok thank