Page 1 of 1

Day roll over completed after 18 hours

Posted: Sun 28 Jun 2020 10:42 pm
by stewartwlewis
Hi
Have been looking at last weeks data and the daily rollover that should happen at midnight on 22 June 2020 started at midnight but didn't actually do much until 18:31:24 on the 23 June 2020 when it completed. The dayfile.txt numbers are correct but monthly and realtime counters for wind run and sun hours didn't reset until 18:31.
There is a message in the logs to say that the SQL operation was interrupted but CumulusMX was writing to the Monthly and Realtime SQL tables throughout between midnight and 18:31 so don't think that can be the cause.
Has anybody else seen this and is it something I need to worry about or just accept as a glitch.

Log for 22 June 2020 midnight and part up to 18:31 23 June attached.

running CumulusMX build 3081 on rpi.

Thanks

Re: Day roll over completed after 18 hours

Posted: Tue 30 Jun 2020 8:08 pm
by mcrossley
I'd recommend updating to the latest build, it makes the EOD SQL operation asynchronous with the rest of the EOD processing. So if the update hangs for some reason, MX will carry on.

The real time and period SQL updates will each use a new SQL session so they are all independent of each other.

Re: Day roll over completed after 18 hours

Posted: Tue 30 Jun 2020 8:25 pm
by stewartwlewis
Thanks Mark

Will do.
Thought it must be a SQL operation locking things but didn't notice the line in the lates update that decouples the sql operations. Fixed before I encountered the problem.

Impressive.