Solved! Thanks to everbody for pushing me in the right direction! But two more questions: " weectl database reconfigure ..." created a db weewx_new containing just a single table named "archive". Whereas the old db had 52 tables like:
archive archive_day_ET archive_day_UV archive_day__metadata archive_day_altimeter archive_day_barometer archive_day_consBatteryVoltage ... Does this mean all tables but archive are obsolete? "weectl database check --binding=wx_binding" returns: Using configuration file /home/weewx/weewx-data/weewx.conf Checking daily summary tables version... Daily summary tables are at version 4.0. Interval Weighting Fix is not required. I'd expected "... version 5.x". Zed schrieb am Donnerstag, 4. Dezember 2025 um 22:30:56 UTC+1: > Ops, "this conversation > <https://groups.google.com/g/weewx-user/c/y_qcJrAYFnU/m/a-bKnFgEAwAJ>". > > Zed schrieb am Donnerstag, 4. Dezember 2025 um 22:11:57 UTC+1: > >> Just found this conversion >> <https://groups.google.com/g/weewx-user/c/y_qcJrAYFnU/m/a-bKnFgEAwAJ>. >> Looks like the manager.py fixes this issue. >> Zed schrieb am Donnerstag, 4. Dezember 2025 um 21:50:40 UTC+1: >> >>> "weectl database reconfigure --binding=wx_binding -y" (without " >>> --dry-run") fails with the same message. >>> >>> Zed schrieb am Donnerstag, 4. Dezember 2025 um 21:48:39 UTC+1: >>> >>>> I guess "weectl database reconfigure --binding=wx_binding -y" will do >>>> this job. >>>> But "weectl database reconfigure --binding=wx_binding --dry-run -y" >>>> fails: >>>> >>>> Using configuration file /home/weewx/weewx-data/weewx.conf >>>> This is a dry run. Nothing will actually be done. >>>> Copying database 'weewx' to 'weewx_new' >>>> The new database will use the same unit system as the old ('METRICWX'). >>>> Traceback (most recent call last): >>>> File "/home/weewx/weewx-venv/bin/weectl", line 7, in <module> >>>> sys.exit(main()) >>>> ~~~~^^ >>>> File "/home/weewx/weewx-venv/lib/python3.13/site-packages/weectl.py", >>>> line 67, in main >>>> namespace.func(namespace) >>>> ~~~~~~~~~~~~~~^^^^^^^^^^^ >>>> File >>>> "/home/weewx/weewx-venv/lib/python3.13/site-packages/weectllib/__init__.py", >>>> >>>> line 90, in dispatch >>>> namespace.action_func(config_dict, namespace) >>>> ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^ >>>> File >>>> "/home/weewx/weewx-venv/lib/python3.13/site-packages/weectllib/database_cmd.py", >>>> >>>> line 371, in reconfigure_database >>>> weectllib.database_actions.reconfigure_database(config_dict, >>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^ >>>> >>>> db_binding=namespace.binding, >>>> >>>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> >>>> dry_run=namespace.dry_run, >>>> >>>> ^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> >>>> no_confirm=namespace.yes) >>>> >>>> ^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> File >>>> "/home/weewx/weewx-venv/lib/python3.13/site-packages/weectllib/database_actions.py", >>>> >>>> line 295, in reconfigure_database >>>> weewx.manager.reconfig(manager_dict['database_dict'], >>>> ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> new_database_dict, >>>> ^^^^^^^^^^^^^^^^^^ >>>> new_unit_system=target_unit_system, >>>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> new_schema=manager_dict['schema'], >>>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> dry_run=dry_run) >>>> ^^^^^^^^^^^^^^^^ >>>> File >>>> "/home/weewx/weewx-venv/lib/python3.13/site-packages/weewx/manager.py", >>>> line 711, in reconfig >>>> record_generator = >>>> weewx.units.GenWithConvert(old_archive.genBatchRecords(), >>>> ^^^^^ >>>> UnboundLocalError: cannot access local variable 'weewx' where it is not >>>> associated with a value >>>> Zed schrieb am Donnerstag, 4. Dezember 2025 um 18:47:09 UTC+1: >>>> >>>>> Thank you vince. That makes sense. >>>>> These are the columns of table archive? >>>>> Are you using mariadb/mysql? Could you please post the result of >>>>> "describe archive;" then. >>>>> >>>>> Could somebody please post a script to upgrade a mariadb from v4 to v5? >>>>> Is there a migration guide describing this step? >>>>> Is it sufficient to add these columns? >>>>> >>>>> vince schrieb am Donnerstag, 4. Dezember 2025 um 18:15:34 UTC+1: >>>>> >>>>>> If your weewx was fast with v4 and it is very slow with v5, you are >>>>>> very likely trying to display something in a skin that is calculated yet >>>>>> not an element in the db. This is a change that occurred in v5. >>>>>> >>>>>> The schema definition in the db only creates new columns if you are >>>>>> 'creating' a 'new' database, if I remember correctly. >>>>>> >>>>>> - Your database has 53 items in the archive record. That means >>>>>> you are using the old 'small' schema. >>>>>> - My db has 114 items in the archive record. That means I am >>>>>> using the newer wview-extended schema. >>>>>> >>>>>> Your db is missing the following elements that were added in the >>>>>> wview-extended schema. >>>>>> >>>>>> appTemp appTemp1 >>>>>> batteryStatus1 batteryStatus2 batteryStatus3 batteryStatus4 >>>>>> batteryStatus5 batteryStatus6 batteryStatus7 batteryStatus8 >>>>>> cloudbase >>>>>> co >>>>>> co2 >>>>>> dewpoint1 >>>>>> extraHumid3 extraHumid4 extraHumid5 extraHumid6 extraHumid7 >>>>>> extraHumid8 >>>>>> extraTemp4 extraTemp5 extraTemp6 extraTemp7 extraTemp8 >>>>>> forecast >>>>>> hailBatteryStatus >>>>>> heatindex1 >>>>>> humidex humidex1 >>>>>> illuminance >>>>>> inDewpoint >>>>>> lightning_distance lightning_disturber_count lightning_energy >>>>>> lightning_noise_count lightning_strike_count luminosity >>>>>> maxSolarRad >>>>>> nh3 >>>>>> no2 >>>>>> noise >>>>>> o3 >>>>>> pb >>>>>> pm1_0 pm10_0 pm2_5 >>>>>> signal1 signal2 signal3 signal4 signal5 signal6 signal7 signal8 >>>>>> snow snowBatteryStatus snowDepth snowMoisture snowRate >>>>>> so2 >>>>>> uvBatteryStatus >>>>>> windrun >>>>>> >>>>>> >>>>>> On Thursday, December 4, 2025 at 7:49:30 AM UTC-8 Zed wrote: >>>>>> >>>>>>> The differences in Seasons/skin.conf are: >>>>>>> >>>>>>> 8c8 >>>>>>> < SKIN_VERSION = 5.2.0 >>>>>>> --- >>>>>>> > SKIN_VERSION = 4.9.1 >>>>>>> 29c29 >>>>>>> < # If you have a Google Analytics GA4 tag, uncomment and edit >>>>>>> the next line, and >>>>>>> --- >>>>>>> > # If you have a Google Analytics ID, uncomment and edit the >>>>>>> next line, and >>>>>>> 31c31 >>>>>>> < #googleAnalyticsId = G-ABCDEFGHI >>>>>>> --- >>>>>>> > #googleAnalyticsId = UA-12345678-1 >>>>>>> 269c269 >>>>>>> < time_length = 27h >>>>>>> --- >>>>>>> > time_length = 97200 # 27 hours >>>>>>> 350c350 >>>>>>> < aggregate_interval = 1h >>>>>>> --- >>>>>>> > aggregate_interval = hour >>>>>>> 359c359 >>>>>>> < aggregate_interval = 1h >>>>>>> --- >>>>>>> > aggregate_interval = hour >>>>>>> 384c384 >>>>>>> < aggregate_interval = 1h >>>>>>> --- >>>>>>> > aggregate_interval = hour >>>>>>> 410c410 >>>>>>> < aggregate_interval = 1h >>>>>>> --- >>>>>>> > aggregate_interval = hour >>>>>>> 488c488 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 496c496 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 521c521 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 546c546 >>>>>>> < aggregate_interval = 3h >>>>>>> --- >>>>>>> > aggregate_interval = 10800 # 3 hours >>>>>>> 625c625 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 633c633 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 658c658 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 683c683 >>>>>>> < aggregate_interval = 1d >>>>>>> --- >>>>>>> > aggregate_interval = day >>>>>>> 762c762 >>>>>>> < aggregate_interval = 1w >>>>>>> --- >>>>>>> > aggregate_interval = week >>>>>>> 770c770 >>>>>>> < aggregate_interval = 1w >>>>>>> --- >>>>>>> > aggregate_interval = week >>>>>>> 795c795 >>>>>>> < aggregate_interval = 1w >>>>>>> --- >>>>>>> > aggregate_interval = week >>>>>>> >>>>>>> >>>>>>> Tom Keffer schrieb am Donnerstag, 4. Dezember 2025 um 16:35:39 UTC+1: >>>>>>> >>>>>>>> Yes, reports that use derived types can be slow if the type is not >>>>>>>> in the database. The Belchertown skin has this problem because of its >>>>>>>> use >>>>>>>> of type 'appTemp'. However, the Seasons skin does not do this. >>>>>>>> (Unless, of >>>>>>>> course, you extended it.) >>>>>>>> >>>>>>>> The declaration for schema >>>>>>>> >>>>>>>> schema = schemas.wview_extended.schema >>>>>>>> >>>>>>>> does not make any difference. It's only used when the database is >>>>>>>> created. >>>>>>>> >>>>>>>> What type of Raspberry Pi are you using? I've used everything from >>>>>>>> an RPi Zero on with no problem, but it will be slow. >>>>>>>> >>>>>>>> These performance problems can be difficult to diagnose. I >>>>>>>> would suggest commenting out the template declarations in >>>>>>>> Seasons/skin.conf >>>>>>>> one by one until you find the culprit. >>>>>>>> >>>>>>>> -tk >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Thu, Dec 4, 2025 at 6:28 AM Zed <[email protected]> wrote: >>>>>>>> >>>>>>>>> Is the report generation dependent from the database layout? >>>>>>>>> What makes you think, 3rd party templates are in use? >>>>>>>>> >>>>>>>>> There is a difference in "schema" in weewx.conf: >>>>>>>>> Before (v4.9.1): >>>>>>>>> >>>>>>>>> [DataBindings] >>>>>>>>> [[wx_binding]] >>>>>>>>> database = archive_mysql >>>>>>>>> table_name = archive >>>>>>>>> manager = weewx.manager.DaySummaryManager >>>>>>>>> schema = schemas.wview_extended.schema >>>>>>>>> >>>>>>>>> Now (v5.2.0): >>>>>>>>> >>>>>>>>> [DataBindings] >>>>>>>>> [[wx_binding]] >>>>>>>>> database = archive_mysql >>>>>>>>> table_name = archive >>>>>>>>> manager = weewx.manager.DaySummaryManager >>>>>>>>> schema = weewx.schemas.wview_extended.schema >>>>>>>>> >>>>>>>>> Could this cause this issue? >>>>>>>>> John Smith schrieb am Donnerstag, 4. Dezember 2025 um 14:51:36 >>>>>>>>> UTC+1: >>>>>>>>> >>>>>>>>>> On Fri, 5 Dec 2025 at 00:38, Zed <[email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> how can i check the columns? Attached please find the db-columns >>>>>>>>>>> currently defined. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> I have no direct experience with using 3rd party templates, but >>>>>>>>>> you'd have to look for things in the template(s) that have no >>>>>>>>>> corresponding >>>>>>>>>> columns in the DB, especially for things like monthly or yearly >>>>>>>>>> stats etc... >>>>>>>>>> >>>>>>>>>> When debugging things in general you should disable everything, >>>>>>>>>> and then turn features back on one by one until you hit the same >>>>>>>>>> behaviour. >>>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>> 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/4ad2d41d-1343-4daa-9443-4bf567c2435fn%40googlegroups.com >>>>>>>>> >>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/4ad2d41d-1343-4daa-9443-4bf567c2435fn%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/757b8a14-845f-416d-97cc-980531c5d3d8n%40googlegroups.com.
