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.