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]> 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]. > 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/CAPq0zED8y0h6O28x%2BTb3G43Cb7QOjr05XOwdM-6Fc1DdDWtG9g%40mail.gmail.com.
