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.
