Tom, my weewx.sdb is in /var/lib/weewx/. When I run squlite3 I get this.
pi@raspberrypi:/var/lib/weewx $ sqlite3 /var/lib/weewx/weedwx.sdb SQLite version 3.27.2 2019-02-25 16:06:06 Enter ".help" for usage hints. sqlite> select dateTime, datetime(dateTime, 'unixepoch', 'localtime'), interval from archive where interval<=0; Error: no such table: archive sqlite> On Wednesday, January 6, 2021 at 1:37:35 PM UTC-5 tke...@gmail.com wrote: > 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 <sanph...@gmail.com> > 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 <tke...@gmail.com> 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 <sanph...@gmail.com> >>> 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 weewx-user+...@googlegroups.com. >>>> 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 >>> weewx-user+...@googlegroups.com. >>> 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 weewx-user+...@googlegroups.com. >> > 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/70b4bce2-0678-4471-b4e4-595082def8a3n%40googlegroups.com.
