Hello together,
I went through forum, tried several searches but with no result so I'm trying with question.
When Cumulus is not running for some while and then it is started again, it starts with "Downloading Archive Data" (two times - in my case). But the question is - is there some possibility to send this (archive) data also to SQL DB? In my case the data are not pushed to SQL and I can't find the way how to do this.
Thanks for some hint!
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
SQL update after reboot / Cumulus not running
Moderator: mcrossley
-
- Posts: 225
- Joined: Sat 27 Aug 2016 12:11 am
- Weather Station: Davis vantage pro 2
- Operating System: Debian
- Location: Wickliffe, Ohio
- Contact:
Re: SQL update after reboot / Cumulus not running
The Downloading Archive Data" (two times - in my case) is normal, something about double checking that data has been downloaded properly.
As far as it updating the SQL database only Monthly, and dayfile (if time has elapsed past midnight or when you set roll over) the realtime does not get updated.
So if monthly is not being updated for you check your MXDIAG file (the latest one) to see if any errors or you can post a copy here and someone can examine to see whats going on.
also has this always been the case or since one of the latest versions ?
As far as it updating the SQL database only Monthly, and dayfile (if time has elapsed past midnight or when you set roll over) the realtime does not get updated.
So if monthly is not being updated for you check your MXDIAG file (the latest one) to see if any errors or you can post a copy here and someone can examine to see whats going on.
also has this always been the case or since one of the latest versions ?
Jeff
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
-
- Posts: 12
- Joined: Fri 17 Aug 2018 12:38 pm
- Weather Station: Davis VP2
- Operating System: Raspian
Re: SQL update after reboot / Cumulus not running
For me the two times reading data is no problem, I understand the reason.
What I'm trying to handle with is Realtime table update. During last days I've some troubles with stability on my RPI 3b. Now I'm running Cumulus build 3079. Last crash was today morning. And while I'm working with the values through Grafana I'd like to have all data in Realtime table in MySQL.
But if I'm right - there is no possibility to configure this load during recovery. True?
What I'm trying to handle with is Realtime table update. During last days I've some troubles with stability on my RPI 3b. Now I'm running Cumulus build 3079. Last crash was today morning. And while I'm working with the values through Grafana I'd like to have all data in Realtime table in MySQL.
But if I'm right - there is no possibility to configure this load during recovery. True?
-
- Posts: 1183
- Joined: Fri 27 Jul 2012 11:29 am
- Weather Station: Chas O, Maplin N96FY, N25FR
- Operating System: rPi 3B+ with Buster (full)
Re: SQL update after reboot / Cumulus not running
True.
Each set of Realtime data is generated from what is available at current time.
It is impossible to go back and work out what was current at times when your RPI device was not receiving the current time values. Where could you read that missing information from?
Last edited by sfws on Thu 04 Jun 2020 4:21 am, edited 1 time in total.
-
- Posts: 225
- Joined: Sat 27 Aug 2016 12:11 am
- Weather Station: Davis vantage pro 2
- Operating System: Debian
- Location: Wickliffe, Ohio
- Contact:
Re: SQL update after reboot / Cumulus not running
if your putting data in for grafana you might want to use the monthly table as that will be updated when you reload cumulus just a thought.
Jeff
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21