Anything new on this?
On Fri, Jul 9, 2021 at 5:35 AM Tom Keffer <[email protected]> wrote: > Three things: > > 1. Let's see what's actually in your database. > > *show tables in weewxwftest;* > > > 2. Can we see the output of > > *wee_debug --info* > > > Double check that the utility obfuscated any passwords you might have in > weewx.conf. > > 3. Just to double check: you only have one weewx.conf file, right? > > > > On Thu, Jul 8, 2021 at 11:38 PM 'Jan-Jaap van der Geer' via weewx-user < > [email protected]> wrote: > >> 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 >> <https://groups.google.com/d/msgid/weewx-user/17e8d219-f018-493f-aef4-6a5b323f4075n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- -tk -- 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/CAPq0zEBArXCB0nEMfowbAMPtTufzV39kpmLHvKgCuUncYHs4VQ%40mail.gmail.com.
