Have you tried browsing the data using https://sqlitebrowser.org/ or similar tool?
On Wed, Dec 25, 2024, 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/CAA1SM2325E3-1VaERQ4VBLM4dO2QAG9Ugf9L5VHZ%2BuT5q%3DhHFw%40mail.gmail.com.
