Continuous Queries Stopped Working For 2 Days

I have a time series database with 10+ CQ’s running on it. I noticed that on the 29th of Janurary at 23:30 and until the 1st of Janurary at 01:00 all of my continuous queries stopped running. New data did get added to the timeseries for the continuous queries to run on. Is there any reason for all CQ’s to stop running at the same time and then start 3 days later?

  • Make sure your server was on power
  • Make sure your influxdb process is running and not on vacation.
  • Make sure your monitor software is running

If you are not on the influxcloud, how do you expect anyone to seriously reply to this? I would start looking in your syslog server for errors related to influx, maybe process oom?

You did see he wrote “New data did get added to the timeseries” right? How would that be possible if the server was without power?

I just had the same happen to me. Everything kept on working normally, all kind of data was added, but at least one of my continuous queries stopped working for three days. Some CQs kept on working normally.