Hi, I've noticed recently that at least one of my continuous queries doesn't contain all of the data that the raw series contains. See http://imgur.com/a/R76G6 for an example comparison of the raw data vs. the continuous query data. The continuous query is defined as follows:
CREATE CONTINUOUS QUERY router_rpm_1m_sum ON ac54edda_6a34_4b8b_99d3_a949fb3c8994 BEGIN SELECT sum(value) INTO ac54edda_6a34_4b8b_99d3_a949fb3c8994.retention_4w."router.rpm.1m.sum" FROM ac54edda_6a34_4b8b_99d3_a949fb3c8994.retention_1d."router.rpm" GROUP BY time(1m) END This wasn't always the case - up until several weeks ago it was recording the correct data. I noticed a dip in our traffic graph, and assumed that traffic had decreased, but recently checking the raw (non-continuous) data I discovered that this was not the case. Unfortunately the correct data has been deleted due to the retention policy, so I can no longer compare it. Server load seems low (load average 0.09, CPU ~2%, 28% memory used, 13% disk space used), and restarting InfluxDB hasn't helped. I'm running v0.13.0 on Ubuntu Ubuntu 14.04.4 LTS (https://s3.amazonaws.com/dl.influxdata.com/influxdb/releases/influxdb_0.13.0_amd64.deb). Any idea what is going on here, or what my next steps might be to diagnose and fix the issue? Thanks -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/05b7f64d-c812-4ee1-9a31-b211b574b653%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
