Page 1 of 1
MySQL tables stopped updating
Posted: Thu 04 Jun 2020 8:16 pm
by stefanbagnato
I upgraded to the latest Cumulus MX release on 5/29, and today I checked MySQL and the tables are not updating. However, if I view the data logs through Cumulus, the data still shows up to date. I am not sure what's going on, but I ran the update the same way as always...
Re: MySQL tables stopped updating
Posted: Thu 04 Jun 2020 8:23 pm
by sfws
Does your installation use SFTP?
Presumably you mean you updated to MX 3.6.5 (b. 3081)?
There was an alteration for that in 3.6.6 (b.3082) because of transfers failing.
The next release, whenever it happens, is expected to deal with further transfer problems.
Re: MySQL tables stopped updating
Posted: Thu 04 Jun 2020 8:26 pm
by stefanbagnato
Nope, everything is local, so I can just unzip into the working directory. It's odd because the Data Log links from within the browser are up to date. And I have meteotemplate tables which pull from Cumulus and they are all up to date too. I am running a restore of the entire Cumulus directory to just before the update and pointing it to a temp folder. "something" must not have updated correctly.
Correct, this update was on 5/29..so 3.6.6 wasn't out yet.
Re: MySQL tables stopped updating
Posted: Thu 04 Jun 2020 8:28 pm
by sfws
stefanbagnato wrote: ↑Thu 04 Jun 2020 8:26 pm
Nope, everything is local
I'm out of ideas then.
Re: MySQL tables stopped updating
Posted: Thu 04 Jun 2020 8:37 pm
by stefanbagnato
It's no problem. I reverted every file in the CumulusMX directory (no sub folders/files) besides realtime.txt and and wxnow.txt. Obviously "something" didn't update right, because now the db table is updating again. I'll monitor it for a while and then try another update when I have time to closely monitor and not leave it for 7 days again.