Hi Thomas, thank you for your answer. No, the MySQL database is not on the pi, it is externally hosted.
Am Mittwoch, 18. März 2020 12:16:20 UTC+1 schrieb Thomas Keffer: > > I take it you are running MySQL on a Raspberry Pi? Could be that the SD > card is failing. > > On Wed, Mar 18, 2020 at 12:23 AM Luftfahrtverein Grünstadt < > [email protected] <javascript:>> wrote: > >> Hi all, >> >> after updating our raspberry pi (apt-get update & upgrade) I experience >> very bad performance of weewx resulting in an endless loop of retrying. >> Here is an excerpt of the log: >> Mar 18 08:10:18 raspberrypi weewx[467]: manager: Added record 2020-03-18 >> 08:10:00 CET (1584515400) to database 'd0222d5f' >> Mar 18 08:10:21 raspberrypi weewx[467]: manager: Added record 2020-03-18 >> 08:10:00 CET (1584515400) to daily summary in 'd0222d5f' >> Mar 18 08:11:00 raspberrypi weewx[467]: cheetahgenerator: Generated 8 >> files for report SeasonsReport in 39.21 seconds >> ^[[AMar 18 08:14:36 raspberrypi weewx[467]: imagegenerator: Generated 42 >> images for SeasonsReport in 215.72 seconds >> Mar 18 08:14:36 raspberrypi weewx[467]: copygenerator: copied 5 files to >> /var/www/html/weewx >> Mar 18 08:14:40 raspberrypi weewx[467]: GaugeGenerator: Generated 7 >> images for HTMLPages in 3.42 seconds >> Mar 18 08:14:40 raspberrypi weewx[467]: translategenerator.pyc: Language >> is german >> Mar 18 08:14:48 raspberrypi weewx[467]: historygenerator.pyc: Generated 6 >> tables in 7.08 seconds >> Mar 18 08:15:02 raspberrypi weewx[467]: engine: Main loop exiting. >> Shutting engine down. >> Mar 18 08:15:02 raspberrypi weewx[467]: engine: Shutting down StdReport >> thread >> Mar 18 08:15:14 raspberrypi weewx[467]: cheetahgenerator: Generated 10 >> files for report HTMLPages in 33.72 seconds >> Mar 18 08:15:14 raspberrypi weewx[467]: copygenerator: copied 3 files to >> /var/www/html/weewx/Bootstrap >> Mar 18 08:15:14 raspberrypi weewx[467]: translategenerator.pyc: Language >> is german >> Mar 18 08:15:22 raspberrypi weewx[467]: engine: Unable to shut down >> StdReport thread >> Mar 18 08:15:22 raspberrypi weewx[467]: engine: Database connection >> exception: (2013, 'Lost connection to MySQL server during query') >> Mar 18 08:15:22 raspberrypi weewx[467]: **** Waiting 2 minutes then >> retrying... >> >> >> As you can see generating images / files took very very long (e.g. 215 >> seconds for seasonsreport). I successfully run weewx for 4 years now and It >> was never that slow. >> A few weeks ago I moved from sqlite to mysql without any issues and it >> worked well, so I do not hink this has any relation to the problem. >> >> In addition to the bad performance (i think it is a folllow-up problem) I >> got database connection exceptions (2013, lost connection during query), >> but adding records to the database work fine. Is there a way to set a >> higher connection timeout value? >> >> I tried already rebuilding the daily values several times, setting the >> archive interval to 5 min (before it was 1 min) but nothing helps. >> >> Any help is really appreciated! What do you need to know? >> >> Thank you so much! >> >> Sebastian >> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/570b85ea-14ce-4dd0-b5c7-354d72e7b7d1%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/570b85ea-14ce-4dd0-b5c7-354d72e7b7d1%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/fd6846ee-f9ba-458d-ba3a-252e630718b2%40googlegroups.com.
