Page 1 of 1

SQL update after reboot / Cumulus not running

Posted: Tue 02 Jun 2020 9:18 pm
by vachah
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!

Re: SQL update after reboot / Cumulus not running

Posted: Wed 03 Jun 2020 12:07 am
by jlmr731
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 ?

Re: SQL update after reboot / Cumulus not running

Posted: Wed 03 Jun 2020 9:22 pm
by vachah
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?

Re: SQL update after reboot / Cumulus not running

Posted: Wed 03 Jun 2020 10:50 pm
by sfws
vachah wrote: Wed 03 Jun 2020 9:22 pm there is no possibility to configure this load during recovery. True?
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?

Re: SQL update after reboot / Cumulus not running

Posted: Wed 03 Jun 2020 10:58 pm
by jlmr731
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.