https://signoz.io logo
Join Slack
Powered by
Hello Team, i am seeing some error ```2024.11.04 0...
# support
k
Hello Team, i am seeing some error
Copy code
2024.11.04 09:06:46.728048 [ 866 ] {200cd42c-0aa1-4d53-af64-1e29ef93819a} <Error> TCPHandler: Code: 81. DB::Exception: Database signoz_analytics does not exist. Maybe you meant signoz_metrics?. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
is that newly introduced in signoz 0.55.0. Do we need to update otel config and exporter things to point to signoz_metrics instead of analytics or from which component its coming from any idea
p
cc @Srikanth Chekuri
k
any findings?
@Srikanth Chekuri
Copy code
> grep -nr signoz_analytics
pkg/query-service/app/clickhouseReader/reader.go:59:	signozHistoryDBName       = "signoz_analytics"
pkg/query-service/migrate/migate.go:61:	database := "CREATE DATABASE IF NOT EXISTS signoz_analytics ON CLUSTER %s"
pkg/query-service/migrate/migate.go:63:	localTable := `CREATE TABLE IF NOT EXISTS signoz_analytics.rule_state_history_v0 ON CLUSTER %s
pkg/query-service/migrate/migate.go:83:	distributedTable := `CREATE TABLE IF NOT EXISTS signoz_analytics.distributed_rule_state_history_v0 ON CLUSTER %s
pkg/query-service/migrate/migate.go:96:ENGINE = Distributed(%s, signoz_analytics, rule_state_history_v0, cityHash64(rule_id, rule_name, fingerprint))`
pkg/query-service/migrate/migate.go:99:	dbExists := `SELECT count(*) FROM system.databases WHERE name = 'signoz_analytics'`
pkg/query-service/migrate/migate.go:114:	tableExists := `SELECT count(*) FROM system.tables WHERE name = 'rule_state_history_v0' AND database = 'signoz_analytics'`
pkg/query-service/migrate/migate.go:129:	distributedTableExists := `SELECT count(*) FROM system.tables WHERE name = 'distributed_rule_state_history_v0' AND database = 'signoz_analytics'`
Copy code
ClickHouseUrl= "<tcp://clickhouse:9000>"
      ALERTMANAGER_API_PREFIX = "<http://alertmanager:9093/api/>"
      SIGNOZ_LOCAL_DB_PATH = "/var/lib/signoz/signoz.db"
      DASHBOARDS_PATH = "/root/config/dashboards"
      STORAGE = "clickhouse"
      GODEBUG = "netdns=go"
      TELEMETRY_ENABLED = "true"
      DEPLOYMENT_TYPE = "docker-standalone-amd"
      SPAN_RENDER_LIMIT = 5000
      MAX_SPANS_IN_TRACE = 10000
do we need to update any environment variable for query service
or this is known issue
?
5 Views
Open in Slack
PreviousNext
Powered by