The log doesn't seem to tell anything special: [/share/homes/admin/weewxwftest] # cat /var/log/messages | grep wee_database Jul 9 08:23:30 qnap user.info wee_database[20528] INFO weewx.manager: Dropping daily summary tables from 'weewxwftest' ... Jul 9 08:23:30 qnap user.info wee_database[20528] INFO weewx.manager: Dropped daily summary tables from database 'weewxwftest' Jul 9 08:23:49 qnap user.info wee_database[21058] INFO __main__: All daily summaries will be rebuilt. Jul 9 08:23:56 qnap user.info wee_database[21058] INFO weewx.manager: Created daily summary tables Jul 9 08:23:56 qnap user.info wee_database[21058] INFO __main__: Rebuilding daily summaries in database 'weewxwftest' ... Jul 9 08:23:56 qnap user.info wee_database[21058] INFO weewx.manager: Starting backfill of daily summaries Jul 9 08:32:32 qnap user.info wee_database[21058] INFO weewx.manager: Processed 132119 records to backfill 208 day summaries in 515.43 seconds Jul 9 08:32:32 qnap user.info wee_database[21058] INFO __main__: Rebuild of daily summaries in database 'weewxwftest' complete
(I had to run it again as the log from yesterday had already been purged but I suppose the result is the same. I did watch the log and didn't notice anything interesting at the time) Thanks, Jan-Jaap On Friday, July 9, 2021 at 3:57:22 AM UTC+2 [email protected] wrote: > How about the log from when you tried dropping and rebuilding the database? > > On Thu, Jul 8, 2021 at 2:29 PM 'Jan-Jaap van der Geer' via weewx-user < > [email protected]> wrote: > >> I have the exact same errors as fpb: >> >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> Generate failed with exception '<class 'NameMapper.NotFound'>' >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** Ignoring template >> /share/homes/admin/weewxwf/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw' >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** Traceback (most recent call last): >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** File >> "/share/CACHEDEV1_DATA/homes/admin/weewxwf/bin/weewx/cheetahgenerator.py", >> line 326, in generate >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** unicode_string = compiled_template.respond() >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** File >> "_share_homes_admin_weewxwf_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", >> line 430, in respond >> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR weewx.cheetahgenerator: >> **** NotFound: cannot find 'raw' while searching for 'day.wind.count.raw' >> >> I don't really understand what this 'new schema' and 'old schema' is, but >> I tried: >> >> wee_database --drop-daily >> wee_database --rebuild-daily >> >> both without changing the binding in weewx.conf and after changing it. >> Right now I have >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_mysql >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.manager.DaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview_extended.schema >> >> but using: >> >> manager = weewx.wxmanager.WXDaySummaryManager >> >> and rebuilding still caused the errors. >> >> What should I do to fix this? >> >> Thanks, >> Jan-Jaap >> >> On Wednesday, December 16, 2020 at 2:26:19 PM UTC+1 [email protected] >> wrote: >> >>> You have the correct configuration, but remember, it only applies *when >>> the database is created*. Thereafter, the schema is read from the >>> database. >>> >>> You can try rebuilding the daily summaries using wee_database: >>> >>> *sudo wee_database --drop-daily* >>> *sudo wee_database --rebuild-daily* >>> >>> >>> The rebuild will use the configuration in weewx.conf. >>> >>> -tk >>> >>> On Tue, Dec 15, 2020 at 9:58 PM fpb <[email protected]> wrote: >>> >>>> @Tom, >>>> >>>> I'm having a similar issue but I'm trying to figure out what the >>>> correct schema (assuming that is the issue) but I can't find a >>>> combination. >>>> >>>> This is what I have; >>>> >>>> [DataBindings] >>>> >>>> [[wx_binding]] >>>> # The database must match one of the sections in [Databases]. >>>> # This is likely to be the only option you would want to change. >>>> database = archive_sqlite >>>> # The name of the table within the database >>>> table_name = archive >>>> # The manager handles aggregation of data for historical >>>> summaries >>>> manager = weewx.manager.DaySummaryManager >>>> # The schema defines the structure of the database. >>>> # It is *only* used when the database is created. >>>> schema = schemas.wview_extended.schema >>>> [[forecast_binding]] >>>> database = forecast_sqlite >>>> >>>> and below my log errors; >>>> >>>> ec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw' >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** Traceback (most recent call last): >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in >>>> generate >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** unicode_string = compiled_template.respond() >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line >>>> 430, in respond >>>> >>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator: >>>> **** NotFound: cannot find 'raw' while searching for 'day.wind.count.raw' >>>> Any help will be appreciate. >>>> >>>> On Thursday, June 4, 2020 at 6:01:51 PM UTC-4 [email protected] wrote: >>>> >>>>> That's probably what happened. >>>>> >>>>> You're not the first to get tripped up by this. Obviously, I need to >>>>> rethink how to manage the transition to the new way of specifying schemas. >>>>> >>>>> On Thu, Jun 4, 2020 at 11:20 AM Jacques Terrettaz <[email protected]> >>>>> wrote: >>>>> >>>>>> Forget my last message : I used a new Raspberry PI to install weewx >>>>>> V4, and then I transferred my "old" mysql database to the new >>>>>> installation... >>>>>> >>>>>> >>>>>> Le 4 juin 2020 à 20:01, Jacques Terrettaz <[email protected]> a >>>>>> écrit : >>>>>> >>>>>> Tom, >>>>>> >>>>>> One comment about the old and new database schema : I didn't change >>>>>> anything by myself in the [DataBinding] section of weewx.conf after the >>>>>> upgrade to V4.0, so I suspect that the manager = weewx.manager. >>>>>> DaySummaryManager line was automatically modified during the >>>>>> upgrade process. >>>>>> Is it right ? >>>>>> >>>>>> >>>>>> -- >>>>>> 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/ACB63400-3370-43DF-A186-A96D3BC23AA3%40gmail.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/weewx-user/ACB63400-3370-43DF-A186-A96D3BC23AA3%40gmail.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/d4d9e47e-ca30-4729-a81b-9d1cfd8dde76n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/d4d9e47e-ca30-4729-a81b-9d1cfd8dde76n%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 on the web visit >> https://groups.google.com/d/msgid/weewx-user/d4e7d688-fe41-4258-b7c9-6068c95012b3n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/d4e7d688-fe41-4258-b7c9-6068c95012b3n%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 on the web visit https://groups.google.com/d/msgid/weewx-user/17e8d219-f018-493f-aef4-6a5b323f4075n%40googlegroups.com.
