search

influxdata / influxdb

Scalable datastore for metrics, events, and real-time analytics
https://influxdata.com
Apache License 2.0
28.78k stars 3.54k forks source link

Time zones do not work correctly in continuous queries #8601

Closed jsternberg closed 7 years ago

jsternberg commented 7 years ago

Bug report

System info: InfluxDB 1.3

Steps to reproduce:

  1. Create a continuous query using a time zone with GROUP BY time(1d)

Expected behavior: The time zone should influence when the CQ gets run so you get the data in the correct time zone.

Actual behavior: It sets the start and end time to be a day in UTC, but the query still properly accounts for the time zone so it only selects part of the day.

Additionally, the start and end time should accomodate when the time zone changes the same way that the query engine does.

jsternberg commented 7 years ago

This is similar to #8569. The symptoms are the same even if the reason is different.

jsternberg commented 7 years ago

Fixed via #8606.