https://signoz.io logo
#support
Title
# support
k

Kshitij Gang

03/17/2023, 6:23 AM
I 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 AM
You probably have set up ClickHouse incorrectly. There needs to be a cluster named
cluster,
and the user needs access to databases
signoz_{distributed}_{traces,metrics,logs}
.
k

Kshitij Gang

03/17/2023, 7:29 AM
The user has access to all the databases..the migrations are run by the query server itself or do i have to do that manually
I can see the traces and metrics , but not logs and the service map
s

Srikanth Chekuri

03/17/2023, 7:50 AM
the migrations are run by the query server itself or do i have to do that manually
SigNoz 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 AM
I am running clickhouse server version 23.1, on ubuntu 22.04 lts , on an aws ec2 t2.small instance (amd64)
my 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 AM
Yes, the compatible versions can be found in our docker deployment (or charts).
k

Kshitij Gang

03/17/2023, 9:33 AM
ok..thank you
I 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
response from the api {"data":null,"total":0,"limit":0,"offset":0,"errors":[{"code":400,"msg":"Error in processing sql query"}]}
probable error in the query service
s

Srikanth Chekuri

03/20/2023, 6:48 AM
Ok, are you working with the same environment stated above with
clickhouse-server:22.8.8-alpine
?
k

Kshitij Gang

03/20/2023, 7:14 AM
I have an updated version of clickouse 23.1, then i will try to use the 22.8.8 version
9 Views