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
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Day roll over completed after 18 hours
Moderator: mcrossley
-
- Posts: 38
- Joined: Sat 29 Jan 2011 7:08 pm
- Weather Station: Davis VP2 Plus
- Operating System: Rasbian on RPI
- Location: Durham, Co Durham
- Contact:
Day roll over completed after 18 hours
You do not have the required permissions to view the files attached to this post.
Stewart
www.stewartwlewis.com
www.stewartwlewis.com
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Day roll over completed after 18 hours
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.
The real time and period SQL updates will each use a new SQL session so they are all independent of each other.
-
- Posts: 38
- Joined: Sat 29 Jan 2011 7:08 pm
- Weather Station: Davis VP2 Plus
- Operating System: Rasbian on RPI
- Location: Durham, Co Durham
- Contact:
Re: Day roll over completed after 18 hours
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.
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.
Stewart
www.stewartwlewis.com
www.stewartwlewis.com