Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 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

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

MySQL Timeouts

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:
Contact water01

MySQL Timeouts

Post by water01 »

Everything has been working fine with Build 3194 but all of a sudden late last night started getting

Code: Select all

2022-07-20 09:24:16.923 Realtime[32]: Error encountered during MySQL operation = Connect Timeout expired.
Anyone got any idea what to check as to why this is happening as I have run out of things to check?
David
Image
Top
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:
Contact mcrossley

Re: MySQL Timeouts

Post by mcrossley »

Were the interval inserts still working?
Top
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:
Contact water01

Re: MySQL Timeouts

Post by water01 »

Solved, ISP was having problems.
David
Image
Top
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:
Contact mcrossley

Re: MySQL Timeouts

Post by mcrossley »

:)
Top
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:
Contact water01

Re: MySQL Timeouts

Post by water01 »

Actually it wasn't solved but it is now, for some unknown reason my IP address got blocked by their firewall even though the Remote MySQL access had the right IP address in it.

OK now up and running and the update of the failed MySQL updates worked perfectly from the log.

However, I am missing some data from the Monthly table from the 19th to today. If I upload the Jul22log.txt to my server and run ImportCumulusFile.php using that file will it work by overwriting all July's data and not cause a problem?
David
Image
Top
sfws
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: MySQL Timeouts

Post by sfws »

water01 wrote: ↑Sat 23 Jul 2022 2:36 pm However, I am missing some data from the Monthly table from the 19th to today.
Use the MX utility that is designed exactly for that purpose.
Top
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:
Contact water01

Re: MySQL Timeouts

Post by water01 »

OK thanks.
David
Image
Top
Post Reply

Return to “Cumulus MX version 3 (since build 3043)”