The first timestamp is Oct. 12 2020, here are the top rows of the query (the list is huge).
sqlite> select datetime(dateTime, 'unixepoch', 'localtime'), dateTime from archive where dateTime < 1602536552; *1970-01-01 01:01:00|60* 2020-10-12 16:05:00|1602511500 2020-10-12 16:06:00|1602511560 2020-10-12 16:07:00|1602511620 2020-10-12 16:08:00|1602511680 2020-10-12 16:09:00|1602511740 2020-10-12 16:10:00|1602511800 2020-10-12 16:11:00|1602511860 2020-10-12 16:12:00|1602511920 2020-10-12 16:13:00|1602511980 2020-10-12 16:14:00|1602512040 2020-10-12 16:15:00|1602512100 2020-10-12 16:16:00|1602512160 2020-10-12 16:17:00|1602512220 2020-10-12 16:18:00|1602512280 So I deleted that record in bold, dropped and rebuilt the daily summaries, and restarted weewx: monitored the log for a few minutes, no errors found. Now the question is: where did that record come from? :) Thanks for all the help Tom, greatly appreciated. Alessandro On Wednesday, October 28, 2020 at 9:15:25 PM UTC+1 Alessandro Del Prete wrote: > Tom, thanks a lot for the reply, I will try this and report back. > > Just one question: in the log I see the problem is on the Seasons skin, > not Belchertown. Am I missing something? > > On Wednesday, October 28, 2020 at 9:12:49 PM UTC+1 [email protected] wrote: > >> It looks like the Belchertown skin is asking for aggregations over dates >> back in 1978. Seeing as how WeeWX wasn't even invented until 2008, you >> probably have some bad data in there, which is likely causing the problem. >> >> What is the earliest timestamp you expect in your database? For purposes >> of illustration, let's assume it is 12-May 2018. Use a tool like the >> website epochconverter.com to figure out what this is in Unix epoch >> time. The answer for the example is 1589241600. >> >> Now use the sqlite3 tool to see what records predate that. >> >> *sqlite3 /var/lib/weewx/weewx.sdb* >> sqlite> *select datetime(dateTime, 'unixepoch', 'localtime'), dateTime >> from archive where dateTime < 1589241600;* >> >> If it's all garbage, then it's safe to delete these data: >> >> sqlite> *delete from archive where dateTime <1589241600;* >> >> Then drop and rebuild the daily summaries, just like you did before. >> >> Make a backup before you start. >> >> -tk >> >> On Wed, Oct 28, 2020 at 10:43 AM Alessandro Del Prete < >> [email protected]> wrote: >> >>> The full log is here: https://pastebin.com/f62DRnHL >>> >>> Luckily the reporting cycle started almost immediately, I noticed this " >>> Daily summary cannot be used." error : >>> >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.reportengine: Found >>> configuration file /etc/weewx/skins/Seasons/skin.conf for report >>> 'SeasonsReport' >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.cheetahgenerator: Using >>> search list ['weewx.cheetahgenerator.Almanac', >>> 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', >>> 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', >>> 'weewx.cheetahgenerator.Extras'] >>> Oct 28 18:17:27 ubuntu weewx[694317] INFO weewx.restx: Hubitat: >>> Published record 2020-10-28 18:17:17 CET (1603905437) >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.manager: Daily summary >>> version is 2.0 >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; >>> aggregate_type=count >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> timespan=[1972-10-01 00:00:00 CET (86742000) -> 1972-10-02 00:00:00 CET >>> (86828400)] >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 >>> 18:17:00 CET (1603905420) >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: *Daily summary >>> cannot be used.* >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> Reason: cannot find 'count' while searching for 'day.wind.count.raw' >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> Traceback (most recent call last): >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> unicode_string = compiled_template.respond() >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in >>> respond >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> NameMapper.NotFound: cannot find 'count' while searching for >>> 'day.wind.count.raw' >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; >>> aggregate_type=count >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> timespan=[1978-10-01 00:00:00 CET (276044400) -> 1978-10-02 00:00:00 CET >>> (276130800)] >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 >>> 18:17:00 CET (1603905420) >>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: *Daily summary >>> cannot be used.* >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> Reason: cannot find 'count' while searching for 'day.wind.count.raw' >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> Traceback (most recent call last): >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> unicode_string = compiled_template.respond() >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in >>> respond >>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** >>> NameMapper.NotFound: cannot find 'count' while searching for >>> 'day.wind.count.raw' >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; >>> aggregate_type=count >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> timespan=[2020-10-01 00:00:00 CEST (1601503200) -> 2020-10-02 00:00:00 CEST >>> (1601589600)] >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 >>> 18:17:00 CET (1603905420) >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: Daily summary >>> will be used. >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; >>> aggregate_type=count >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> timespan=[2020-10-02 00:00:00 CEST (1601589600) -> 2020-10-03 00:00:00 CEST >>> (1601676000)] >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 >>> 18:17:00 CET (1603905420) >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: Daily summary >>> will be used. >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; >>> aggregate_type=count >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> timespan=[2020-10-03 00:00:00 CEST (1601676000) -> 2020-10-04 00:00:00 CEST >>> (1601762400)] >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: >>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 >>> 18:17:00 CET (1603905420) >>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: Daily summary >>> will be used. >>> >>> On Wednesday, October 28, 2020 at 4:29:27 PM UTC+1 [email protected] >>> wrote: >>> >>>> The only other thing I can think of is that the Belchertown skin is >>>> making a query on something other than midnight-to-midnight. >>>> >>>> We can check that. Please replace your copy of xtypes.py (you should >>>> find it in /usr/share/weewx/weewx/xtypes.py) with the attached. It has >>>> been >>>> instrumented to log the aggregation interval. >>>> >>>> Run with debug=1 from startup through the first reporting cycle. Post >>>> the full log. It could be rather voluminous, so you may want to post the >>>> log as an attachment, or upload to a service such as pastebin.com. >>>> >>>> -tk >>>> >>>> On Wed, Oct 28, 2020 at 7:59 AM Alessandro Del Prete < >>>> [email protected]> wrote: >>>> >>>>> Done. And restarted weewx. >>>>> >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** Reason: cannot find 'count' while searching for 'day.wind.count.raw' >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** Traceback (most recent call last): >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>>>> generate >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** unicode_string = compiled_template.respond() >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line >>>>> 431, in respond >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** NameMapper.NotFound: cannot find 'count' while searching for >>>>> 'day.wind.count.raw' >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** Reason: cannot find 'count' while searching for 'day.wind.count.raw' >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** Traceback (most recent call last): >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>>>> generate >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** unicode_string = compiled_template.respond() >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line >>>>> 431, in respond >>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: >>>>> **** NameMapper.NotFound: cannot find 'count' while searching for >>>>> 'day.wind.count.raw' >>>>> >>>>> >>>>> On Wednesday, October 28, 2020 at 1:54:04 PM UTC+1 [email protected] >>>>> wrote: >>>>> >>>>>> 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/a80c017d-070d-4c90-b71b-8273d74cb5efn%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/a80c017d-070d-4c90-b71b-8273d74cb5efn%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/0c24713c-71a7-4d9d-986d-7bee1272c9e9n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/0c24713c-71a7-4d9d-986d-7bee1272c9e9n%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/fbf5e636-f72e-4e7b-9821-25e409e05bd3n%40googlegroups.com.
