[0.10.1] CQ missing data depending on time frame #6273
Comments
|
I'm experiencing the same behaviour: I verified that my data exists in the original measurement and in the downsampled measurement (generated with a CQ and with some manual backfilling). When I query the downsampled measurement with a time range longer than about 3.25 days, big chunks of data is missing from the results. I'm using 0.10.3. |
|
Interesting thing while I was collecting data. As we are putting more data into the system that exact same behavior is happening to non CQ data. Does anyone have any idea how I can trouble shoot this? |
|
I'm sorry this wasn't answered, but 0.10.3 is out of date and not maintained. Please try migrating your databases and upgrading to 1.0. If you still have issues with this after upgrading, comment and I'll reopen the issue. If you need help upgrading, you can ask questions on our mailing list. |
I am using CQ's to down sample by site to get location averages. All of this works correctly but I am seeing an odd issue. After some time of running I notice that data that is requested for long time frames (> 3h) don't have any current data. However, when I change the query to the last three hours the missing data shows up correctly. I checked using the following quires and the data is there for small times but not the long ones. I have tried restarting the influx service and it had no impact. Another thing to note is that this is also only happing on the CQ version of the data. The non downsampled data does not show this issue.
I was not able to find anything similar in the open bugs or on the google group page.
When running a Query for time > now() -4h the data is missing in alot of spots
When I run the same query with time > now() -3h the missing data from above is filled in.
When I look at the data that feeds the CQ it has the data. Below its working for time > now() -4h.
CQ:
siteRoleup CREATE CONTINUOUS QUERY siteRoleup ON serverPerf RESAMPLE EVERY 30s FOR 5m BEGIN SELECT mean(respTime) AS respTime INTO serverPerf.oneyear.site_perf FROM serverPerf.oneyear.respTime GROUP BY time(1m), serverGroup, site END
Influx Info:
name: build
Branch Build Time Commit Version
HEAD 2016-02-18T20:44:27.807242 df902a4 0.10.1
name: runtime
GOARCH GOMAXPROCS GOOS version
amd64 16 linux go1.4.3
Prebuild package
System Info:
Linux 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:52:48 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
Distributor ID: Ubuntu
Description: Ubuntu 12.04.2 LTS
Release: 12.04
Codename: precise
48Gb ram
2x Intel(R) Xeon(R) CPU E5620 @ 2.40GHz
6 drive spinning disk software raid (Raid 10)
Influx conf mostly default.
[data]
enabled = true
dir = "/data/influxdb/data"
engine = "tsm1"
max-wal-size = 26214400
wal-flush-interval = "3m0s"
wal-partition-flush-delay = "2s"
wal-dir = "/data/influxdb/wal"
wal-logging-enabled = true
wal-ready-series-size = 30720
wal-compaction-threshold = 0.5
wal-max-series-size = 1048576
wal-flush-cold-interval = "5s"
wal-partition-size-threshold = 52428800
query-log-enabled = true
cache-max-memory-size = 524288000
cache-snapshot-memory-size = 26214400
cache-snapshot-write-cold-duration = "1h0m0s"
compact-full-write-cold-duration = "24h0m0s"
max-points-per-block = 0
data-logging-enabled = true
Any ideas on how to debug this or point out something dumb I am doing would be a huge help.
The text was updated successfully, but these errors were encountered: