Well, there is something wrong on the external server or, possibly, the connection between.
In general, installations that use MySQL are less reliable than those using SQLite. See the Wiki article *SQLite vs MySQL <https://github.com/weewx/weewx/wiki/SQLite-vs-MySQL>*. -tk On Wed, Mar 18, 2020 at 5:02 AM Luftfahrtverein Grünstadt < [email protected]> wrote: > 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]> 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/fd6846ee-f9ba-458d-ba3a-252e630718b2%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/fd6846ee-f9ba-458d-ba3a-252e630718b2%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/CAPq0zEBFZbome%3DK%3D0u1C28PyWZEYnutxRqm9XaDHkRFsPkcVZw%40mail.gmail.com.
