I noticed some erroneous "Total hours of sunshine" and "High solar rad" on my Interface graphs from the end of June and early July - I don't have any solar sensors so rarely look at this graph. I used the Interface dayfile editor to remove the readings. On each save I noticed a MySql error occuring - I didn't make a note of the precise error text, but wasn't too fussed as I can always manually delete the entries in the database table. I did this about 11:10 UTC today and moved onto doing other stuff (company tax return!). I didn't think anything was amiss (as I was still seeing data on the MX dashboard) until I got an email notification from WeatherCloud saying that my device had been offline since 11:10 UTC. Looking in the MXdiags file I could see repeated SQL errors since 11:10 UTC - referring to the CustomSqlSecs realtime statements, but containing queries from the regular realtime updates (i.e. NOT the custom ones that I have defined). No errors from WeatherCloud - just no WeatherCloud update log statements after 11:10 UTC. Similar for WOW, APRS, Windy, PWS, etc. Even generation of twitter.txt stopped (I wrote my own tweeting utility but fortunately included in it a check to see if twitter.txt has updated before actually tweeting).
I restarted MX once I noticed the errors in the MXdiags file, and all has returned to normal.
I can only think that the MySQL errors I saw during my use of the Interface dayfile editor triggered all sorts of problems for timed threads! Attached below is the MXdiags file.
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
Problems noticed after using Interface dayfile editor
Moderator: mcrossley
-
- Posts: 2474
- Joined: Wed 08 Jun 2011 11:19 am
- Weather Station: Davis Vantage Pro 2 + Ecowitt
- Operating System: GNU/Linux Ubuntu 22.04 LXC
- Location: Alcaston, Shropshire, UK
- Contact:
Problems noticed after using Interface dayfile editor
You do not have the required permissions to view the files attached to this post.
- 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: Problems noticed after using Interface dayfile editor
Thanks, I'll get the day file editor SQL statement format fixed tonight, then take a look at why it was affecting the other uploads...