Using influxdb-1.4.2
Having database Persons with retention policies
- duration - 30d
- shard group duration - 7d
- replication - 1
Now, I am adding a countinuous query to this database for a measurement Students and another countinuous query to another measurement in same database named Teachers
I have 2 questions,
-
At some point my continuous queries stops working
-
I try to push the data manually by editing the continuous query statement between BEGIN to END with start and end time
I can able to add the no. of missing records from start to end date in the new measurement of continuous query
NOTE:
-
For both measurements I m getting,
- Written data = 23 records (no. of records in old measurements for 1 minute)
-
But, When I try to get the data from new measurements for 1 month,
-
Expectation
- I need to get only 1 minute of data for both measurment
-
Acutal
- I am getting 7 days of record for 1 measurement
- And, I am getting 1 day of record for another measurment
-
Expectation
3… After adding the new records,
- If my influxdb has been restarted (stopped and started after few seconds), I cannot get the newly inserted data which has been inserted using edited CQ
- All my record inserted using edited CQ has been gone