This error could happen if a query was made for aggregation periods that do not run midnight-to-midnight, but I don't know why the Belchertown skin would do that.
One thing to try: rebuilding the daily summaries. *wee_database --drop-daily* *wee_database --rebuild-daily* -tk On Wed, Oct 28, 2020 at 12:22 AM Alessandro Del Prete < [email protected]> wrote: > The table exists. Could it be corrupted in some way? That would explain > why the problem came up only recently. > > SQLite version 3.31.1 2020-01-27 19:55:54 > Enter ".help" for usage hints. > sqlite> SELECT tbl_name FROM sqlite_master WHERE type='table'; > archive > archive_day_altimeter > archive_day_appTemp > archive_day_appTemp1 > archive_day_barometer > archive_day_batteryStatus1 > archive_day_batteryStatus2 > archive_day_batteryStatus3 > archive_day_batteryStatus4 > archive_day_batteryStatus5 > archive_day_batteryStatus6 > archive_day_batteryStatus7 > archive_day_batteryStatus8 > archive_day_cloudbase > archive_day_co > archive_day_co2 > archive_day_consBatteryVoltage > archive_day_dewpoint > archive_day_dewpoint1 > archive_day_ET > archive_day_extraHumid1 > archive_day_extraHumid2 > archive_day_extraHumid3 > archive_day_extraHumid4 > archive_day_extraHumid5 > archive_day_extraHumid6 > archive_day_extraHumid7 > archive_day_extraHumid8 > archive_day_extraTemp1 > archive_day_extraTemp2 > archive_day_extraTemp3 > archive_day_extraTemp4 > archive_day_extraTemp5 > archive_day_extraTemp6 > archive_day_extraTemp7 > archive_day_extraTemp8 > archive_day_forecast > archive_day_hail > archive_day_hailBatteryStatus > archive_day_hailRate > archive_day_heatindex > archive_day_heatindex1 > archive_day_heatingTemp > archive_day_heatingVoltage > archive_day_humidex > archive_day_humidex1 > archive_day_inDewpoint > archive_day_inHumidity > archive_day_inTemp > archive_day_inTempBatteryStatus > archive_day_leafTemp1 > archive_day_leafTemp2 > archive_day_leafWet1 > archive_day_leafWet2 > archive_day_lightning_distance > archive_day_lightning_disturber_count > archive_day_lightning_energy > archive_day_lightning_noise_count > archive_day_lightning_strike_count > archive_day_luminosity > archive_day_maxSolarRad > archive_day_nh3 > archive_day_no2 > archive_day_noise > archive_day_o3 > archive_day_outHumidity > archive_day_outTemp > archive_day_outTempBatteryStatus > archive_day_pb > archive_day_pm10_0 > archive_day_pm1_0 > archive_day_pm2_5 > archive_day_pressure > archive_day_radiation > archive_day_rain > archive_day_rainBatteryStatus > archive_day_rainRate > archive_day_referenceVoltage > archive_day_rxCheckPercent > archive_day_signal1 > archive_day_signal2 > archive_day_signal3 > archive_day_signal4 > archive_day_signal5 > archive_day_signal6 > archive_day_signal7 > archive_day_signal8 > archive_day_snow > archive_day_snowBatteryStatus > archive_day_snowDepth > archive_day_snowMoisture > archive_day_snowRate > archive_day_so2 > archive_day_soilMoist1 > archive_day_soilMoist2 > archive_day_soilMoist3 > archive_day_soilMoist4 > archive_day_soilTemp1 > archive_day_soilTemp2 > archive_day_soilTemp3 > archive_day_soilTemp4 > archive_day_supplyVoltage > archive_day_txBatteryStatus > archive_day_UV > archive_day_uvBatteryStatus > archive_day_windBatteryStatus > archive_day_windchill > archive_day_windDir > archive_day_windGust > archive_day_windGustDir > archive_day_windrun > archive_day_windSpeed > *archive_day_wind* > archive_day__metadata > sqlite> > > > On Wednesday, October 28, 2020 at 12:11:38 AM UTC+1 [email protected] > wrote: > >> Can you take a look inside your database? What is the result of: >> >> *sqlite3 /var/lib/weewx/weewx.sdb* >> sqlite> *SELECT tbl_name FROM sqlite_master WHERE type='table';* >> sqlite> *.quit* >> >> This will tell us whether the table archive_day_wind exists in your >> database. >> >> -tk >> >> >> >> On Tue, Oct 27, 2020 at 2:20 PM Alessandro Del Prete < >> [email protected]> wrote: >> >>> Hi, >>> >>> I have the same issue, it's a brand new installation of weewx 4.1.1, >>> working since a month with a belchertown skin and a weatherflow tempest. >>> >>> Today I was checking weewx.log and I noticed this: >>> >>> Oct 27 21:39:24 ubuntu weewx[59297] DEBUG weewx.manager: Daily summary >>> version is 2.0 >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> Reason: cannot find 'count' while searching for 'day.wind.count.raw' >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> Traceback (most recent call last): >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> unicode_string = compiled_template.respond() >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in >>> respond >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> NameMapper.NotFound: cannot find 'count' while searching for >>> 'day.wind.count.raw' >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> Reason: cannot find 'count' while searching for 'day.wind.count.raw' >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> Traceback (most recent call last): >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> unicode_string = compiled_template.respond() >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in >>> respond >>> Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** >>> NameMapper.NotFound: cannot find 'count' while searching for >>> 'day.wind.count.raw' >>> >>> Then I found your reply to solve the problem. I checked the DataBindings >>> section, and everything's like you suggested, no mixing (it was a new >>> installation), so I don't know why the issue came up only after some time. >>> >>> Is it possible to solve the problem without deleting the database? >>> >>> Thanks for any advice on this. >>> >>> Alessandro >>> >>> On Thursday, September 17, 2020 at 8:20:48 PM UTC+2 [email protected] >>> wrote: >>> >>>> The reason why this can occur is a rather technical one, but has to do >>>> with mixing the older, V3.x, way of specifying a schema, and the newer, >>>> V4.x way. >>>> >>>> 1. Stop weewx >>>> >>>> 2. Assuming there is nothing valuable in it, delete the archive >>>> /var/lib/weewx/weewx.sdb >>>> >>>> 3. Make sure your [DataBindings] section looks like this. Pay attention >>>> to the highlighted areas. >>>> >>>> [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 >>>> >>>> 4. Restart weewx. >>>> >>>> -tk >>>> >>>> >>>> >>>> On Thu, Sep 17, 2020 at 11:00 AM '[email protected]' via >>>> weewx-user <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> After two tries with cheaper Weather Stations which failed due to >>>>> Quality I bought now a Davis Vantage Pro2 Wireless with a Weatherlink Live >>>>> Adapter >>>>> >>>>> I have setup now a new Weewx Installation and had it running for some >>>>> days with "simulator" without any issues. >>>>> >>>>> Now I got my davis and I have configured it immediatly. >>>>> >>>>> But unfortunatley I am getting now the following error: >>>>> >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> Generate failed with exception '<class 'NameMapper.NotFound'>'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Reason: cannot find 'count' while searching for 'day.wind.count.raw'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Traceback (most recent call last):* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>>>> generate* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** unicode_string = compiled_template.respond()* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line >>>>> 431, in respond* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** NameMapper.NotFound: cannot find 'count' while searching for >>>>> 'day.wind.count.raw'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> Generate failed with exception '<class 'NameMapper.NotFound'>'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y.txt.tmpl* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Reason: cannot find 'count' while searching for >>>>> 'month.wind.count.raw'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Traceback (most recent call last):* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>>>> generate* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** unicode_string = compiled_template.respond()* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y_txt_tmpl.py", line >>>>> 862, >>>>> in respond* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** NameMapper.NotFound: cannot find 'count' while searching for >>>>> 'month.wind.count.raw'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> Generate failed with exception '<class 'NameMapper.NotFound'>'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Ignoring template /etc/weewx/skins/Seasons/rss.xml.tmpl* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Reason: cannot find 'max' while searching for 'day.wind.max'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** Traceback (most recent call last):* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>>>> generate* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** unicode_string = compiled_template.respond()* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** File "_etc_weewx_skins_Seasons_rss_xml_tmpl.py", line 268, in >>>>> respond* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>>>> **** NameMapper.NotFound: cannot find 'max' while searching for >>>>> 'day.wind.max'* >>>>> *Sep 17 19:55:17 weewx-test weewx[23751] INFO weewx.cheetahgenerator: >>>>> Generated 5 files for report SeasonsReport in 0.66 seconds* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> Caught unrecoverable exception in generator >>>>> 'weewx.imagegenerator.ImageGenerator'* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** no such table: archive_day_wind* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** Traceback (most recent call last):* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weedb/sqlite.py", line 29, in >>>>> guarded_fn* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** return fn(*args, **kwargs)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weedb/sqlite.py", line 211, in >>>>> execute* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** return sqlite3.Cursor.execute(self, *args, **kwargs)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** sqlite3.OperationalError: no such table: archive_day_wind* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> ***** >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** During handling of the above exception, another exception >>>>> occurred:* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> ***** >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** Traceback (most recent call last):* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/reportengine.py", line 197, in >>>>> run* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** obj.start()* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/reportengine.py", line 280, in >>>>> start* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** self.run()* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 41, in >>>>> run* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** self.genImages(self.gen_ts)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 180, in >>>>> genImages* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** aggregate_interval=aggregate_interval)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 86, in >>>>> get_series* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** aggregate_interval)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 628, in >>>>> get_series* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** aggregate_interval)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 140, in >>>>> get_series* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** agg_vt = get_aggregate(obs_type, stamp, do_aggregate, >>>>> db_manager)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 102, in >>>>> get_aggregate* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** **option_dict)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 796, in >>>>> get_aggregate* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** row = db_manager.getSql(sql, timespan)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/manager.py", line 426, in >>>>> getSql* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** _cursor.execute(sql, sqlargs)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weedb/sqlite.py", line 37, in >>>>> guarded_fn* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** raise weedb.NoTableError(e)* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** weedb.NoTableError: no such table: archive_day_wind* >>>>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>>>> **** Generator terminated* >>>>> >>>>> Any ideas? >>>>> >>>>> -- >>>>> 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/8cddf9c5-ac26-4bbf-bc3b-e21d0bc5e513n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/weewx-user/8cddf9c5-ac26-4bbf-bc3b-e21d0bc5e513n%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/9653844c-9165-4cac-a075-e1117984736en%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/9653844c-9165-4cac-a075-e1117984736en%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/c8a13b8e-c377-47dd-9477-21372e4b0261n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/c8a13b8e-c377-47dd-9477-21372e4b0261n%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/CAPq0zEDEB%3DEZXnH55ZQeR1nn2fExTn_wuz%2BbAieH0X%3D8%3DVxi-w%40mail.gmail.com.
