Page 1 of 1
MySQL Timeouts
Posted: Wed 20 Jul 2022 8:28 am
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?
Re: MySQL Timeouts
Posted: Wed 20 Jul 2022 2:41 pm
by mcrossley
Were the interval inserts still working?
Re: MySQL Timeouts
Posted: Wed 20 Jul 2022 2:42 pm
by water01
Solved, ISP was having problems.
Re: MySQL Timeouts
Posted: Wed 20 Jul 2022 2:56 pm
by mcrossley
Re: MySQL Timeouts
Posted: Sat 23 Jul 2022 2:36 pm
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?
Re: MySQL Timeouts
Posted: Sat 23 Jul 2022 2:59 pm
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.
Re: MySQL Timeouts
Posted: Sat 23 Jul 2022 3:00 pm
by water01
OK thanks.
