With the changes, WeeWX will wait 60 seconds, then restart from the top. If
your backup takes 10 minutes, then it will keep retrying 10 times until it
succeeds.

On Wed, Jan 1, 2020 at 2:28 AM Geni <[email protected]> wrote:

> Hyperbackup runs on my synology and weewx on a Raspberry, so Hyperbackup
> can't stop and start weewx!
> I think it's better if weewx is fault tolerant, Snology is rebooted
> occasionally during updates, then there is no database connection, the
> HTML_ROOT is offline and the FTP path is not found.
>
> Am Mittwoch, 1. Januar 2020 09:29:50 UTC+1 schrieb Andrew Milner:
>>
>> 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/ae91000b-1d50-4318-b288-6f487ef6b4ec%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/ae91000b-1d50-4318-b288-6f487ef6b4ec%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/CAPq0zEAsFwPbotq5c4FiJ4H2jETkF3x_y%3Dko3DS-S%2B-2DrdkCg%40mail.gmail.com.

Reply via email to