Welcome to the Cumulus Support forum.

Latest Cumulus MX release 3.28.5 (build 3282) - 23 February 2024

Legacy Cumulus 1 release v1.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

MX not talking to console

General news concerning announcements of new releases, forum outages etc.
Post Reply
UncleBuck
Posts: 43
Joined: Sat 29 Dec 2012 10:27 pm
Weather Station: Davis VP2+
Operating System: MAC Mini - OSX El Capitan
Location: Victoria, Australia

MX not talking to console

Post by UncleBuck »

I have been doing quite a bit of work getting data out of MySQL and today MX decided it could not get the data from the console.

Restarting MX fixed that problem (what caused it I don't know) BUT, during the time MX could not get the data from the console, it kept sending the same data to MySQL every minute and kept sending an updated (but incorrect) realtime file to the server.

I stopped MX again, restored the files from a backup just prior to when the error started and started MX again. This fixed all the dayfile etc, but I noticed that MySQL was still showing the erroneous data. I thought MX "updated" the entries in MySQL but it appears this is not the case.

What I had to do was stop MX, restore the files, remove the erroneous entries from MySQL and then finally restart MX.

So now a request for a future update to MX:
When MX cannot get the data from the console, MySQL not be updated.

I hope all of the above makes sense.
Regards,
User avatar
steve
Cumulus Author
Posts: 26702
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: MX not talking to console

Post by steve »

UncleBuck wrote:I thought MX "updated" the entries in MySQL but it appears this is not the case.
It does "INSERT IGNORE". I could change it to "INSERT ... ON DUPLICATE KEY UPDATE" if it's generally thought that's a good idea, and no-one can think of any problems with doing it.
So now a request for a future update to MX:
When MX cannot get the data from the console, MySQL not be updated.
This would be covered by the existing request(s) to stop updating things in general if there is no new data, if/when I ever get around to doing it.
Steve
Post Reply