go-graphite / carbon-clickhouse

Graphite metrics receiver with ClickHouse as storage
MIT License
186 stars 47 forks source link

Not able to `find` root metric names? #63

Closed mzealey closed 4 years ago

mzealey commented 4 years ago

Not sure if this is the correct repo to ask the question in, but I've set up clickhouse / carbon-clickhouse / graphite-clickhouse and carbonapi. However I cannot find any metrics. graphite-clickhouse logs:

[2020-06-28T14:05:54.175Z] INFO [query] query {"query": "SELECT Path FROM graphite_index WHERE (Level = 20001) AND (Path = '' OR Path = '.') AND (Date = '1970-02-12') GROUP BY Path", "request_id": "17afadc09d2bb5932d064937c32fa174", "time": 0.007886948}
[2020-06-28T14:05:54.175Z] INFO access {"request_id": "17afadc09d2bb5932d064937c32fa174", "time": 0.008105494, "method": "GET", "url": "/metrics/find/?format=carbonapi_v3_pb", "peer": "172.18.0.11:60050", "status": 200}

Looking in clickhouse:

clickhouse :) select Path from graphite_index where Level = 20001 AND (Date = '1970-02-12');

SELECT Path
FROM graphite_index
WHERE (Level = 20001) AND (Date = '1970-02-12')
...
┌─Path──────┐
│ carbon.   │
│ collectd. │
└───────────┘

So no '' or '.' entry listed to search for? Is carbon-clickhouse not inserting these correctly, or is graphite-clickhouse not doing the find correctly?

Running docker images: lomik/graphite-clickhouse:v0.11.1; lomik/carbon-clickhouse:v0.11.0 and latest rpm of carbonapi.

mzealey commented 4 years ago

Hm seems to be due to using carbonapi_v3_pb rathre than carbonapi_v2_pb ?