Continuous Query only runs once


#1

Created the following CQ, but it seems to only run once in so much as when I query the database I can see the data for the first write.

The logs, however indicate that it is running continuously but no further data is added.

name: database
name    query
----    -----
cq_5min CREATE CONTINUOUS QUERY cq_5min ON database BEGIN SELECT mean(*) INTO database."rp1".:MEASUREMENT FROM database."std"./.*/ GROUP BY time(5m), * END

influxd: ts=2018-07-12T16:20:00.813300Z lvl=info msg="Continuous query execution (start)" log_id=09FosTHW000 service=continuous_querier trace_id=09FpWjgG000 op_name=continuous_querier_execute op_event=start

 

influxd: ts=2018-07-12T16:20:00.813332Z lvl=info msg="Executing continuous query" log_id=09FosTHW000 service=continuous_querier trace_id=09FpWjgG000 op_name=continuous_querier_execute name=cq_5min db_instance=database start=2018-07-12T16:15:00.000000Z end=2018-07-12T16:20:00.000000Z

 

influxd: ts=2018-07-12T16:20:56.929804Z lvl=info msg="Finished continuous query" log_id=09FosTHW000 service=continuous_querier trace_id=09FpWjgG000 op_name=continuous_querier_execute name=cq_5min db_instance=database written=3161 start=2018-07-12T16:15:00.000000Z end=2018-07-12T16:20:00.000000Z duration=56116ms

 

influxd: ts=2018-07-12T16:20:56.929877Z lvl=info msg="Continuous query execution (end)" log_id=09FosTHW000 service=continuous_querier trace_id=09FpWjgG000 op_name=continuous_querier_execute op_event=end op_elapsed=56116.588ms

 

influxd: ts=2018-07-12T16:25:00.028062Z lvl=info msg="Continuous query execution (start)" log_id=09FosTHW000 service=continuous_querier trace_id=09Fpn~V0000 op_name=continuous_querier_execute op_event=start

influxd: ts=2018-07-12T16:25:00.028133Z lvl=info msg="Executing continuous query" log_id=09FosTHW000 service=continuous_querier trace_id=09Fpn~V0000 op_name=continuous_querier_execute name=cq_5min db_instance=database start=2018-07-12T16:20:00.000000Z end=2018-07-12T16:25:00.000000Z

influxd: ts=2018-07-12T16:25:56.208576Z lvl=info msg="Finished continuous query" log_id=09FosTHW000 service=continuous_querier trace_id=09Fpn~V0000 op_name=continuous_querier_execute name=cq_5min db_instance=database written=3156 start=2018-07-12T16:20:00.000000Z end=2018-07-12T16:25:00.000000Z duration=56180ms

influxd: ts=2018-07-12T16:25:56.208627Z lvl=info msg="Continuous query execution (end)" log_id=09FosTHW000 service=continuous_querier trace_id=09Fpn~V0000 op_name=continuous_querier_execute op_event=end op_elapsed=56180.575ms

Any pointers greatly appreciated.


#2

I didn’t realise field names are appended with “mean_”. The continuous query does appear to be working.