I am getting an error while fetching logs in signo...
# supportk
Kshitij Gang
03/17/2023, 6:23 AMI am getting an error while fetching logs in signoz, I can see the logs in my clickhouse tables but I am getting the following error when the ui tries to fetch the logs
s
Srikanth Chekuri
03/17/2023, 6:38 AMYou probably have set up ClickHouse incorrectly. There needs to be a cluster named
cluster,signoz_{distributed}_{traces,metrics,logs}k
Kshitij Gang
03/17/2023, 7:29 AMThe user has access to all the databases..the migrations are run by the query server itself or do i have to do that manually
Kshitij Gang
03/17/2023, 7:30 AMI can see the traces and metrics , but not logs and the service map
s
Srikanth Chekuri
03/17/2023, 7:50 AMthe migrations are run by the query server itself or do i have to do that manuallySigNoz collector does it automatically when you start it up. The service map is a ClickHouse exception issue which I asked for env details here https://signoz-community.slack.com/archives/C01HWQ1R0BC/p1679035265278129?thread_ts=1678870098.544749&cid=C01HWQ1R0BC. The logs says it can’t find the DB and table. This could mean multiple things - Do distributed tables exist? Does the user have access to the DB and table?
k
Kshitij Gang
03/17/2023, 8:43 AMI am running clickhouse server version 23.1, on ubuntu 22.04 lts , on an aws ec2 t2.small instance (amd64)
Kshitij Gang
03/17/2023, 8:44 AMmy otel collector version is signoz/signoz-otel-collector:${OTELCOL_TAG:-0.66.4}, has there been a change after this which might have a different table name
s
Srikanth Chekuri
03/17/2023, 9:24 AMYes, the compatible versions can be found in our docker deployment (or charts).
k
Kshitij Gang
03/17/2023, 9:33 AMok..thank you
Kshitij Gang
03/20/2023, 5:36 AMI am now able to see the logs but when i update the version of otel collector but I am unable to see the service map....this is error shown in the console
Kshitij Gang
03/20/2023, 5:36 AMresponse from the api {"data":null,"total":0,"limit":0,"offset":0,"errors":[{"code":400,"msg":"Error in processing sql query"}]}
Kshitij Gang
03/20/2023, 5:42 AMprobable error in the query service
s
Srikanth Chekuri
03/20/2023, 6:48 AMOk, are you working with the same environment stated above with
clickhouse-server:22.8.8-alpinek
Kshitij Gang
03/20/2023, 7:14 AMI have an updated version of clickouse 23.1, then i will try to use the 22.8.8 version
9 Views