or you could stop weewx for the hyperbackup period and resume when it is complete. weewx will then do 'catchup' from loggers and all should be tickety-boo .....
On Wednesday, 1 January 2020 10:21:16 UTC+2, Geni wrote: > > Hi, Thomas. > The hint that the error code 1927 comes from MariaDB, I knew immediately > where to look for it! > Now at this time a hyperbackup job is running on my synologe which also > contained the application MariaDB, I have removed it and this night no > error messages. > > Summary: > The backup stops the database service for a short moment and if that's > exactly when Weewx wants to access it, it won't work. > My suggestion would be if weewx doesn't get a database connection it will > wait for the next interval but without killing the process. > In my case this would be 1 or 2 intervals and then the missing records > would be read in and nobody would notice anything. > > Regards > Geni > > PS: This error occurred very rarely with the Raspberry PI2? > > > Am Dienstag, 31. Dezember 2019 11:01:10 UTC+1 schrieb Geni: >> >> Hello, >> Since I replaced the Raspberry PI 2 with a Raspberry PI 3+ this problem >> occurs every night, before only sporadically. >> In use: >> Raspberry 3+ mit Raspbian Buster Lite >> Externe SqlDB (MariaDB 10) >> David Vantage Pro2 Version: 3.83 >> Weewx 3.9.2-1 >> >> Every night at exactly 00:20, it stops. The report at 00:10 is still made >> debug-log: >> Dec 31 00:10:55 Wetter-Raspi weewx[889]: reportengine: Report 'RSYNC' not >> enabled. Skipping. >> Dec 31 00:17:15 Wetter-Raspi weewx[889]: vantage: Requesting 200 LOOP >> packets. >> Dec 31 00:17:15 Wetter-Raspi weewx[889]: vantage: Gentle wake up of >> console successful >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: engine: StdReport thread has >> been terminated >> Dec 31 07:44:10 Wetter-Raspi weewx[3001]: engine: Debug is 1 >> Dec 31 07:44:10 Wetter-Raspi weewx[3001]: engine: Initializing engine >> Dec 31 07:44:10 Wetter-Raspi weewx[3001]: vantage: Driver version is 3.1.1 >> Dec 31 07:44:10 Wetter-Raspi weewx[3001]: vantage: Opened up serial port >> /dev/ttyUSB0; baud 19200; timeout 4.00 >> Dec 31 07:44:10 Wetter-Raspi weewx[3001]: vantage: Gentle wake up of >> console successful >> Dec 31 07:44:10 Wetter-Raspi weewx[3001]: vantage: Hardware type is 16 >> Dec 31 07:44:11 Wetter-Raspi weewx[3001]: vantage: ISS ID is 1 >> Dec 31 07:44:11 Wetter-Raspi weewx[3001]: vantage: Hardware name: Vantage >> Pro2 >> >> syslog: >> Dec 31 00:17:01 Wetter-Raspi CRON[1919]: (root) CMD ( cd / && run-parts >> --report /etc/cron.hourly) >> Dec 31 00:17:15 Wetter-Raspi weewx[889]: vantage: Requesting 200 LOOP >> packets. >> Dec 31 00:17:15 Wetter-Raspi weewx[889]: vantage: Gentle wake up of >> console successful >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: engine: Main loop exiting. >> Shutting engine down. >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: engine: Shutting down StdReport >> thread >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: engine: StdReport thread has >> been terminated >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: engine: Caught unrecoverable >> exception in engine: >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** (1927, 'Connection was >> killed') >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** Traceback (most recent >> call last): >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/engine.py", line 894, in main >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** engine.run() >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/engine.py", line 191, in run >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** >> self.dispatchEvent(weewx.Event(weewx.NEW_LOOP_PACKET, packet=packet)) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/engine.py", line 224, in dispatchEvent >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** callback(event) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/wxservices.py", line 45, in new_loop_packet >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** >> self.calc.do_calculations(event.packet, 'loop') >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/wxservices.py", line 191, in do_calculations >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** getattr(self, >> 'calc_' + obs)(data_us, data_type) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/wxservices.py", line 228, in calc_pressure >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** data['dateTime'], >> interval) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/wxservices.py", line 404, in _get_temperature_12h >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** record = >> dbmanager.getRecord(ts12, max_delta=self.max_delta_12h) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weewx/manager.py", line 370, in getRecord >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** (time_start_ts, >> time_stop_ts, timestamp)) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** File >> "/usr/share/weewx/weedb/mysql.py", line 49, in guarded_fn >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** raise klass(e) >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** DatabaseError: (1927, >> 'Connection was killed') >> Dec 31 00:20:01 Wetter-Raspi weewx[889]: **** Exiting. >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: bits received from HRNG >> source: 320064 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: bits sent to kernel pool: >> 274848 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: entropy added to kernel >> pool: 274848 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2 successes: 16 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2 failures: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2(2001-10-10) >> Monobit: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2(2001-10-10) >> Poker: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2(2001-10-10) >> Runs: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2(2001-10-10) >> Long run: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS 140-2(2001-10-10) >> Continuous run: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: HRNG source speed: >> (min=742.464; avg=808.940; max=986.277)Kibits/s >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: FIPS tests speed: >> (min=6.539; avg=7.855; max=16.600)Mibits/s >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: Lowest ready-buffers >> level: 2 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: Entropy starvations: 0 >> Dec 31 00:22:34 Wetter-Raspi rngd[312]: stats: Time spent starving for >> entropy: (min=0; avg=0.000; max=0)us >> Dec 31 01:17:01 Wetter-Raspi CRON[2044]: (root) CMD ( cd / && run-parts >> --report /etc/cron.hourly) >> Dec 31 01:22:34 Wetter-Raspi rngd[312]: stats: bits received from HRNG >> source: 360064 >> Dec 31 01:22:34 Wetter-Raspi rngd[312]: stats: bits sent to kernel pool: >> 304608 >> >> >> One attempt is made every hour until the service is restarted. ( sudo >> /etc/init.d/weewx restart) >> CRON[2044]: (root) CMD ( cd / && run-parts --report >> /etc/cron.hourly)01:17:01 >> >> what's the problem there? >> >> Thanks, Geni >> >> > -- 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/8134339f-28ec-46ec-8de8-acd35083a2a3%40googlegroups.com.
