This is the dump: https://we.tl/t-X3r6gbimBx
sreda, 25. december 2024 ob 22:48:59 UTC+1 je oseba mihec napisala: > I replaced the original manager.py with attached one. That file is in the > /usr/share/weewx/weewx/ directory. > I will prepare the dump of the database. > > username@hostname:~$ sudo weectl database rebuild-daily > > Using configuration file /etc/weewx/weewx.conf > All daily summaries will be rebuilt. > Rebuild the daily summaries in the database 'weewx.sdb' (y/n)? y > Rebuilding daily summaries in database 'weewx.sdb' ... > Daily summaries at V2.0. Patching to V4.0 > Traceback (most recent call last):0:00 CEST (1628719200) > File "/usr/share/weewx/weedb/sqlite.py", line 38, in guarded_fn > return fn(*args, **kwargs) > File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute > return sqlite3.Cursor.execute(self, *args, **kwargs) > sqlite3.OperationalError: no such column: inf > > During handling of the above exception, another exception occurred: > > Traceback (most recent call last): > File "/usr/share/weewx/weectl.py", line 75, in <module> > main() > File "/usr/share/weewx/weectl.py", line 67, in main > namespace.func(namespace) > File "/usr/share/weewx/weectllib/__init__.py", line 90, in dispatch > namespace.action_func(config_dict, namespace) > File "/usr/share/weewx/weectllib/database_cmd.py", line 329, in > rebuild_daily > weectllib.database_actions.rebuild_daily(config_dict, > File "/usr/share/weewx/weectllib/database_actions.py", line 134, in > rebuild_daily > with weewx.manager.open_manager(manager_dict, initialize=True) as dbm: > File "/usr/share/weewx/weewx/manager.py", line 924, in open_manager > return manager_cls.open_with_create(manager_dict['database_dict'], > File "/usr/share/weewx/weewx/manager.py", line 244, in open_with_create > dbmanager = cls(connection, table_name=table_name, schema=schema) > File "/usr/share/weewx/weewx/manager.py", line 1076, in __init__ > self.patch_sums() > File "/usr/share/weewx/weewx/manager.py", line 1537, in patch_sums > > self.recalculate_weights(start_d=datetime.date(2020, 6, 1)) > File "/usr/share/weewx/weewx/manager.py", line 1451, in > recalculate_weights > self._do_tranche(mark_d, end_of_tranche_d, weight_fn, progress_fn) > File "/usr/share/weewx/weewx/manager.py", line 1490, in _do_tranche > self._set_day_sums(day_accum, cursor) > File "/usr/share/weewx/weewx/manager.py", line 1516, in _set_day_sums > > cursor.execute(update_sql, (day_accum.timespan.start,)) > File "/usr/share/weewx/weedb/sqlite.py", line 50, in guarded_fn > raise weedb.NoColumnError(e) > weedb.NoColumnError: no such column: inf > > > sreda, 25. december 2024 ob 21:13:17 UTC+1 je oseba Tom Keffer napisala: > >> Thanks. That tells me what I needed to know to create a useful >> instrumented version of manager.py. Replace the one you have with the >> attached version. It will give more information about exactly what created >> the error. Post the log. >> >> -tk >> >> On Wed, Dec 25, 2024 at 9:29 AM mihec <[email protected]> wrote: >> >>> Hi, first I want to wish you Merry Christmas and Happy Holidays! >>> >>> This is the output of the "weectl database rebuild-daily". Please note >>> that I've copied the weewx.sdb database file to a desktop PC to make it run >>> much faster. I've replaced the real username and hostname with something >>> generic. The weewx's version is same as in RPi. >>> >>> When executed, the 'rebuild' process starts around June 2020 and goes on >>> normally until it fails on August 12, 2021 (epoch 1628719200). In the >>> output below, you only see the status when it fails already. I can provide >>> with a screenshot if that helps. >>> The thing is that any command on the database (update, check or rebuild) >>> fails on the same date (record?). >>> >>> username@host:~$ ls -la weewx.sdb >>> -rwxrwxr-x 1 username username 682086400 dec 25 18:18 weewx.sdb >>> username@host:~$ weewxd -v >>> 5.1.0 >>> username@host:~$ weectl -v >>> weectl 5.1.0 >>> username@host:~$ sudo weectl database rebuild-daily >>> [sudo] password for username: >>> Using configuration file /etc/weewx/weewx.conf >>> All daily summaries will be rebuilt. >>> Rebuild the daily summaries in the database 'weewx.sdb' (y/n)? y >>> Rebuilding daily summaries in database 'weewx.sdb' ... >>> Daily summaries at V2.0. Patching to V4.0 >>> Traceback (most recent call last):0:00 CEST (1628719200) >>> File "/usr/share/weewx/weedb/sqlite.py", line 38, in guarded_fn >>> return fn(*args, **kwargs) >>> File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute >>> return sqlite3.Cursor.execute(self, *args, **kwargs) >>> sqlite3.OperationalError: no such column: inf >>> >>> During handling of the above exception, another exception occurred: >>> >>> Traceback (most recent call last): >>> File "/usr/share/weewx/weectl.py", line 75, in <module> >>> main() >>> File "/usr/share/weewx/weectl.py", line 67, in main >>> namespace.func(namespace) >>> File "/usr/share/weewx/weectllib/__init__.py", line 90, in dispatch >>> namespace.action_func(config_dict, namespace) >>> File "/usr/share/weewx/weectllib/database_cmd.py", line 329, in >>> rebuild_daily >>> weectllib.database_actions.rebuild_daily(config_dict, >>> File "/usr/share/weewx/weectllib/database_actions.py", line 134, in >>> rebuild_daily >>> with weewx.manager.open_manager(manager_dict, initialize=True) as >>> dbm: >>> File "/usr/share/weewx/weewx/manager.py", line 924, in open_manager >>> return manager_cls.open_with_create(manager_dict['database_dict'], >>> File "/usr/share/weewx/weewx/manager.py", line 244, in open_with_create >>> dbmanager = cls(connection, table_name=table_name, schema=schema) >>> File "/usr/share/weewx/weewx/manager.py", line 1076, in __init__ >>> self.patch_sums() >>> File "/usr/share/weewx/weewx/manager.py", line 1531, in patch_sums >>> self.recalculate_weights(start_d=datetime.date(2020, 6, 1)) >>> File "/usr/share/weewx/weewx/manager.py", line 1451, in >>> recalculate_weights >>> self._do_tranche(mark_d, end_of_tranche_d, weight_fn, progress_fn) >>> File "/usr/share/weewx/weewx/manager.py", line 1490, in _do_tranche >>> self._set_day_sums(day_accum, cursor) >>> File "/usr/share/weewx/weewx/manager.py", line 1515, in _set_day_sums >>> cursor.execute(update_sql, (day_accum.timespan.start,)) >>> File "/usr/share/weewx/weedb/sqlite.py", line 50, in guarded_fn >>> raise weedb.NoColumnError(e) >>> weedb.NoColumnError: no such column: inf >>> username@host:~$ >>> >>> torek, 24. december 2024 ob 15:15:16 UTC+1 je oseba Tom Keffer napisala: >>> >>>> Let's put aside the database update and just focus on rebuilding the >>>> daily summaries. >>>> >>>> Could you please include the stack trace when doing "weectl database >>>> rebuild-daily"? Once I see where it fails, I can send you an instrumented >>>> version of the database code so we can see exactly what is happening. >>>> >>>> -tk >>>> >>>> On Tue, Dec 24, 2024 at 3:39 AM mihec <[email protected]> wrote: >>>> >>>>> Well, I've checked also the weectl database check which fails at the >>>>> same point as the update. >>>>> >>>>> >>>>> torek, 24. december 2024 ob 12:31:36 UTC+1 je oseba Auchtermuchty >>>>> Weather napisala: >>>>> >>>>>> That's not what it does now. >>>>>> >>>>>> " Databases created earlier than 3.7.0 (released 11-March-2017) have >>>>>> a flaw that prevents them from being used with archive intervals that >>>>>> change with time. This utility check whether your database is affected." >>>>>> >>>>>> $ weectl database check >>>>>> Using configuration file /etc/weewx/weewx.conf >>>>>> Checking daily summary tables version... >>>>>> Daily summary tables are at version 4.0. >>>>>> Interval Weighting Fix is not required. >>>>>> $ >>>>>> >>>>>> On Tuesday, 24 December 2024 at 11:13:48 UTC Graham Eddy wrote: >>>>>> >>>>>>> weewx used to include a tool for picking up things like a string >>>>>>> where a number should be. maybe `weectl database check’ still does this >>>>>>> *⊣GE⊢* >>>>>>> >>>>>>> On 24 Dec 2024, at 4:17 pm, mihec <[email protected]> wrote: >>>>>>> >>>>>>> I think there must be an invalid entry in my database (Aug 12, >>>>>>> 2021). My SQLite database management knowledge is basically zero, so >>>>>>> I'm >>>>>>> looking for advice >>>>>>> >>>>>>> >>>>>>> -- >>>>> 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 visit >>>>> https://groups.google.com/d/msgid/weewx-user/e60483cc-3910-45f8-aff4-7b4e95939cd9n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/e60483cc-3910-45f8-aff4-7b4e95939cd9n%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 visit >>> https://groups.google.com/d/msgid/weewx-user/e92cf44c-d06f-4de1-ba04-440bceed755fn%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/e92cf44c-d06f-4de1-ba04-440bceed755fn%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 visit https://groups.google.com/d/msgid/weewx-user/0bb2b958-5a83-473f-89e9-b12b1709d49fn%40googlegroups.com.
