Do it from a terminal. For now, just do the very first select statement so we can see where we stand:
*sqlite3 /var/weewx/weedwx.sdb* sqlite> *select dateTime, datetime(dateTime, 'unixepoch', 'localtime'), interval from archive where interval<=0;* sqlite> *.quit* On Wed, Jan 6, 2021 at 10:33 AM Michael Sanphillipo <[email protected]> wrote: > Tom, do I do this in terminal and do I enter it exactly as you have it > listed above? > > On Wed, Jan 6, 2021 at 1:19 PM Tom Keffer <[email protected]> wrote: > >> The software is a little more hard-nosed about demanding valid values for >> the field 'interval'. Somewhere in your database, you have a value of zero >> for the archive interval length. To find them: >> >> *sqlite3 /var/weewx/weedwx.sdb* >> sqlite> *select dateTime, datetime(dateTime, 'unixepoch', 'localtime'), >> interval from archive where interval<=0;* >> >> To delete them: >> >> sqlite> *delete from archive where interval<=0;* >> >> Alternatively, if you're confident you know what the correct value should >> be (let's say it's 5 minutes); >> >> sqlite> *update archive set interval=5 where interval<=0;* >> >> -tk >> >> On Wed, Jan 6, 2021 at 9:49 AM Michael Sanphillipo <[email protected]> >> wrote: >> >>> I upgraded today and received the following errors in my Syslog. Any >>> help would be greatly appreciated. >>> >>> Jan 6 12:44:46 raspberrypi weewx[1063] INFO __main__: Initializing >>> weewx version 4.3.0 >>> Jan 6 12:44:46 raspberrypi weewx[1063] INFO __main__: Using Python >>> 3.7.3 (default, Jul 25 2020, 13:03:44) #012[GCC 8.3.0] >>> Jan 6 12:44:46 raspberrypi weewx[1063] INFO __main__: Platform >>> Linux-5.4.79-v7+-armv7l-with-debian-10.7 >>> Jan 6 12:44:46 raspberrypi weewx[1063] INFO __main__: Locale is >>> 'en_US.UTF-8' >>> Jan 6 12:44:46 raspberrypi weewx[1063] INFO __main__: PID file is >>> /var/run/weewx.pid >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO __main__: Using >>> configuration file /etc/weewx/weewx.conf >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO __main__: Debug is 0 >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO weewx.engine: Loading >>> station type AcuRite (weewx.drivers.acurite) >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO weewx.drivers.acurite: >>> driver version is 0.4 >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO weewx.engine: StdConvert >>> target unit is 0x1 >>> Jan 6 12:44:46 raspberrypi weewx[1051]: Starting weewx weather system: >>> weewx. >>> Jan 6 12:44:46 raspberrypi systemd[1]: Started LSB: weewx weather >>> system. >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO weewx.manager: Daily >>> summaries at V2.0. Patching to V3.0 >>> Jan 6 12:44:46 raspberrypi weewx[1067] INFO weewx.manager: >>> recalculate_weights: Using database 'weewx.sdb' >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: Caught >>> unrecoverable exception: >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> Non-positive value for record field 'interval': 0 >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> Traceback (most recent call last): >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewxd", line 148, in main >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> engine = weewx.engine.StdEngine(config_dict) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/engine.py", line 93, in __init__ >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> self.loadServices(config_dict) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/engine.py", line 161, in loadServices >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> obj = weeutil.weeutil.get_object(svc)(self, config_dict) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/wxservices.py", line 38, in __init__ >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> self.db_manager = engine.db_binder.get_manager(data_binding=data_binding, >>> initialize=True) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 534, in get_manager >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> self.manager_cache[data_binding] = open_manager(manager_dict, initialize) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 684, in open_manager >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> manager_dict['schema']) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 164, in open_with_create >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> dbmanager = cls(connection, table_name=table_name, schema=schema) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 831, in __init__ >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> self.patch_sums() >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 1255, in patch_sums >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> self.recalculate_weights(start_d=datetime.date(2020,6,1)) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 1182, in recalculate_weights >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> self._do_tranche(mark_d, end_of_tranche_d, weight_fn, progress_fn) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 1215, in _do_tranche >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> weight = weight_fn(self, rec) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> File "/usr/share/weewx/weewx/manager.py", line 1366, in _calc_weight >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> "Non-positive value for record field 'interval': %s" % >>> (record['interval'],)) >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> weewx.manager.IntervalError: Non-positive value for record field >>> 'interval': 0 >>> Jan 6 12:44:52 raspberrypi weewx[1067] CRITICAL __main__: **** >>> Exiting. >>> >>> -- >>> 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/45226679-4c2b-431b-9ee7-94ffe7b0b724n%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/45226679-4c2b-431b-9ee7-94ffe7b0b724n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/cPTRWVE2lBE/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/CAPq0zEDgh-emK1xpZpxNEgrvtTSEEt1GkRAQbur%2BApOoMf6Qiw%40mail.gmail.com >> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEDgh-emK1xpZpxNEgrvtTSEEt1GkRAQbur%2BApOoMf6Qiw%40mail.gmail.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/CAAsGudo5T7TQv%3DRCuu22-jt5LWSDD_VSzAqgeGgUR28GPyAWvw%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAAsGudo5T7TQv%3DRCuu22-jt5LWSDD_VSzAqgeGgUR28GPyAWvw%40mail.gmail.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/CAPq0zEAnF1Yt4bPewYb9Z%3DeR_F7M3Gi4Po%3DPrZ4KDEeQih715g%40mail.gmail.com.
