-
Notifications
You must be signed in to change notification settings - Fork 52
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
empty output in CH because of different timezone in cluster and on carbon-clickhouse/graphite-clichouse/carbonapi node #184
Comments
Thank you for detailed report. I work for fix this issue. |
@Vlggg Can you run queries on your clickhouse ?
|
@Vlggg Can Your build and test graphite-clickhouse from https://github.com/msaf1980/graphite-clickhouse/tree/fix_daystart ? |
As I think, this issue fixed in last release as workaround. In new install, better way is switch to UTC-based scheme. |
Hi @msaf1980! |
Hello folks!
I've tried to update graphite-clickhouse from 0.12.0 to 0.13.2 and found interesting behavior.
graphite-clickhouse, carbon-clickhouse and carbonapi run on node A with timezone UTC, at the same time clickhouse cluster works on several nodes with timezone PDT(UTC-7)
and everything works fine but only for specific time ranges.
Example:
we have metrics in time period - from 1650776160 to 1650779759. Now if we run query as graphite-clickhouse do then
As you can see there is no rows in answer but if we set timezone from carbon-clikchouse node in PREWHERE part of query, we have correct response.
PREWHERE Date >= toDate(1650776160,'UTC') AND Date <= toDate(1650779759,'UTC')
example:
I made a hot fix for that but this works only for our env and itself not a good solution)
The text was updated successfully, but these errors were encountered: